N1MEDS_ROT_USERPREF_GRID SAP (Medication: Grid Output Fields) Structure details
Description: Medication: Grid Output Fields
Related tables to N1MEDS_ROT_USERPREF_GRID
Access table N1MEDS_ROT_USERPREF_GRID
Structure field list including key, data, relationships and ABAP select examples
N1MEDS_ROT_USERPREF_GRID is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Medication: Grid Output Fields" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_N1MEDS_ROT_USERPREF_GRID TYPE N1MEDS_ROT_USERPREF_GRID.
The N1MEDS_ROT_USERPREF_GRID table consists of various fields, each holding specific information or linking keys about Medication: Grid Output Fields data available in SAP. These include ROW_ID (IS-H: 5-Digit Number Field), USR (User Name in User Master Record), DS00 (Medication: Phonetic Search as Default), DS00_1 (i.s.h.med: Name Search Algorithm).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP N1MEDS_ROT_USERPREF_GRID structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
ROW_ID | IS-H: 5-Digit Number Field | N_NUMC5 | NUMC | 5 | NUMC5 | ||||
USR | User Name in User Master Record | XUBNAME | CHAR | 12 | Assigned to domain | XUBNAME | XUS | ||
DS00 | Medication: Phonetic Search as Default | N1MEDS_DS00 | CHAR | 1 | ISH_ON_OFF | ||||
DS00_1 | i.s.h.med: Name Search Algorithm | N1SRCALGNAME | CHAR | 60 | TEXT60 | ||||
DS02 | Medication: Shortcut Indicator | N1MEDS_DS02D | CHAR | 1 | N1MEDS_DS02D | ||||
DS03 | Medication: Automatically Assign Wild Card to Search String | N1MEDS_DS03D | CHAR | 1 | XFELD | ||||
DS03_1 | Medication: Lower-Level Classification Codes | N1MEDS_DS03_1D | CHAR | 1 | N1MEDS_DS03_1D | ||||
DS03_2 | Medication: Lower-Level Diagnosis Codes | N1MEDS_DS03_2D | CHAR | 1 | N1MEDS_DS03_2D | ||||
DS03_3 | Medication: Lower-Level Health Problem Codes | N1MEDS_DS03_3D | CHAR | 1 | N1MEDS_DS03_3D | ||||
DS03_4 | Medication: Activate External Search via Generic Name | N1MEDS_DS03_4D | CHAR | 1 | ISH_ON_OFF | ||||
DS04 | Medication: Automatic Selection of Single Result | N1MEDS_DS04D | CHAR | 1 | XFELD | ||||
DS05 | Medication: Search Scope | N1MEDS_DS05D | CHAR | 40 | CHAR40 | ||||
DS06 | Medication: Included Drug Categories | N1MEDS_DS06D | CHAR | 40 | CHAR40 | ||||
DS06_6 | Medication: Drug Kit | N1MEDS_DS066D | CHAR | 1 | XFELD | ||||
DS07 | Medication: Search Criteria | N1MEDS_DS07D | CHAR | 65 | CHAR65 | ||||
DS08 | Medication: Search Using Template Group Name | N1MEDS_DS08 | CHAR | 1 | ISH_ON_OFF | ||||
DS09 | Medication: Therapeutical Classification System | N1MEDS_DS09D | CHAR | 15 | Assigned to domain | N1MEDS_DS09D | |||
DS09_1 | Medication: Classification System | N1ME_CLASSDESCS | CHAR | 15 | |||||
DS10 | Medication: Search Criteria Off | N1MEDS_DS10D | CHAR | 1 | XFELD | ||||
DS11 | Medication: Double-Click Behavior | N1MEDS_DS11D | CHAR | 60 | N1MEDS_DS11D | ||||
DS12 | Medication: First Level Grouping | N1MEDS_DS12FLG | CHAR | 20 | N1MEDS_DS12L | ||||
DS13 | Medication: Second Level Grouping | N1MEDS_DS12SLG | CHAR | 20 | N1MEDS_DS12L | ||||
DS14 | Medication: Template Grouping | N1MEDS_DS14D | CHAR | 20 | N1MEDS_DS14D | ||||
DS15 | Medication: Templates in Favorites | N1MEDS_DS15D | CHAR | 1 | XFELD | ||||
DS16 | Medication: Apply Grouping to Favorites | N1MEDS_DS16D | CHAR | 1 | XFELD | ||||
DS16_1 | Medication: Apply Sorting Behavior to Favorites | N1MEDS_DS16_1D | CHAR | 1 | XFELD | ||||
DS17 | Medication: Maximum Number of Selected Entries | N1MEDS_DS17D | INT4 | 10 | INT4 | ||||
DS18 | Medication: Load Therapeutic Class Nodes | N1MEDS_DS18D | CHAR | 1 | XFELD | ||||
DS19 | Medication: 1st Level Sorting for Search Results | N1MEDS_DS19D | CHAR | 30 | N1MEDS_DS19D | ||||
DS20 | Medication: 2nd Level Sorting for Search Results | N1MEDS_DS20D | CHAR | 30 | N1MEDS_DS20D | ||||
DS21 | Medication: Order Templates - Open Node Level | N1MEDS_DS21D | CHAR | 60 | N1MEDS_DS21D | ||||
DS22 | Medication: Drug Catalog - Open Node Level | N1MEDS_DS22D | CHAR | 60 | N1MEDS_DS22D | ||||
DS23 | Medication: Automatic Invoking of Drug Search | N1MEDS_DS23D | CHAR | 15 | N1MEDS_DS23D | ||||
DS23_1 | Medication: Automatice Display of Favorites at Search Call | N1MEDS_DS23_1D | CHAR | 1 | ISH_ON_OFF | ||||
DS24 | Medication: Include Templates in Therapeutic Classes | N1MEDS_DS24D | CHAR | 1 | XFELD | ||||
DS25 | Medication: Check Drugs of Medication Orders | N1MEDS_DS25D | CHAR | 60 | N1MEDS_DS25D | ||||
DS26 | Medication: Sort Order for 1st Level Sorting | N1MEDS_ICON | CHAR | 46 | TV_IMAGE | ||||
DS27 | Medication: Sort Order for 2nd Level Sorting | N1MEDS_ICON2 | CHAR | 46 | TV_IMAGE | ||||
DS28 | Medication: Display Description Instead of Drug Name | N1MEDS_DS28D | CHAR | 1 | ISH_ON_OFF | ||||
DS30 | Medication: Diagnosis Catalog Presetting | N1MEDS_DS30D | CHAR | 1 | N1MEDS_DS30D | ||||
DS30_1 | Short Description of Catalog | KATKB | CHAR | 10 | TEXT10 | ||||
DS31 | Health Problems Catalog | SYMPTKAT | CHAR | 40 | CHAR40 | ||||
DS40 | Medication: Display Behavior for Kit Drugs | N1MEDS_DS40D | CHAR | 1 | N1MEDS_DS40D | ||||
DS40A | Medication: Kit Drug in Drug Kit | N1MEDS_DS40AD | CHAR | 1 | XFELD | ||||
DS40B | Medication: Kit Drug in Hierarchy | N1MEDS_DS40BD | CHAR | 1 | XFELD | ||||
DS41 | Medication: Grouping by Hierarchy | N1MEDS_DS41D | CHAR | 1 | N1MEDS_DS41D | ||||
DS41_1 | Medication: Grouping by Favorites Hierarchy | N1MEDS_DS41_1D | CHAR | 1 | N1MEDS_DS41_1D | ||||
DS42 | Medication: Display Additional Drugs | N1MEDS_DS42D | CHAR | 1 | N1MEDS_DS42D | ||||
DS43 | Medication: Display Price | N1MEDS_DS43D | CHAR | 1 | N1MEDS_DS43D | ||||
DS43_1 | Medication: Price Type | N1ME_MD_PRICETYPEDESC | CHAR | 40 | N1ME_TEXT_40 | ||||
DS50 | Medication: Clinical/Organizational Criterion | N1MEDS_DS50D | CHAR | 1 | N1MEDS_DS50D | ||||
DS60_1 | Medication: Export Indications | N1MEDS_DS60_1D | CHAR | 1 | N1MEDS_DS60_1D | ||||
DS60_2 | Medication: Export Diagnoses | N1MEDS_DS60_2D | CHAR | 1 | N1MEDS_DS60_2D | ||||
DS60_3 | Medication: Export Health Problems | N1MEDS_DS60_3D | CHAR | 1 | N1MEDS_DS60_3D | ||||
DS61 | Medication: Auto. User Assignment for New Group | N1MEDS_DS61D | CHAR | 1 | CHAR1 | ||||
FA01 | Medication: Period in Days | N1MEDSFA01D | DEC | 3 | N1MEDSFA01D | ||||
FA02 | Maximum Number of Selected Entries | TBMAXSEL | INT4 | 10 | SYST_LONG | ||||
OV_OBJ | IS-H: Object Reference of the Type IF_ISH_IDENTIFY_OBJECT | NFVOBJECT | REF | 0 | IF_ISH_IDENTIFY_OBJECT | ||||
OM01 | Medication: Presetting - Order Start Time | N1ME_OM01_EXT | CHAR | 20 | N1ME_OM01_EXT | ||||
OM02 | Medication: Order Duration Setting | N1ME_OM02_EXT | CHAR | 20 | N1ME_OM02_EXT | ||||
OM03 | Medication: Configuration (Stand Alone) | N1ME_OM03 | CHAR | 32 | SYSUUID_C | ||||
OM04 | Medication: Reason for Ending Order | N1ME_OM04 | CHAR | 10 | |||||
OM05 | Medication: Reason for Renewed Order | N1ME_OM05 | CHAR | 10 | |||||
OM06 | Medication: Order Drug from Drug Kit | N1ME_OM06_EXT | CHAR | 30 | N1ME_OM06_EXT | ||||
OM07 | Medication: Unit for Dispensing Quantity | N1ME_OM07_EXT | CHAR | 25 | N1ME_OM07_EXT | ||||
OM08 | Medication: Behavior in Case of Dose Change | N1ME_OM08_EXT | CHAR | 40 | N1ME_OM08_EXT | ||||
OM09 | Medication: Behavior on Percentage Change (Mixed Drugs) | N1ME_OM09_EXT | CHAR | 50 | N1ME_OM09_EXT | ||||
OM10 | Medication: Dose Definition (Fraction/Decimal) | N1ME_OM10 | CHAR | 1 | XFELD | ||||
OM11 | Medication: Display OU Times on Chart | N1ME_OM11 | CHAR | 1 | XFELD | ||||
OM12 | Medication: Display Messages in Chart | N1ME_OM12 | CHAR | 1 | XFELD | ||||
OM13 | Medication: Skip Alternative Dialog | N1ME_OM13 | CHAR | 1 | XFELD | ||||
OM14 | Medication: Handling of Check Condition | N1ME_OM14_EXT | CHAR | 40 | N1ME_OM14_EXT | ||||
OM15 | Medication: Calculation of Volume Using Duration/Flow Rate | N1ME_OM15_EXT | CHAR | 40 | N1ME_OM15_EXT | ||||
OM16 | Medication: Reason for Ending Emergency Order | N1ME_OM16 | CHAR | 10 | |||||
NU01 | Nursing: Configuration | N1_NRS_NU01 | CHAR | 32 | SYSUUID_C | ||||
NU02 | Nursing: Performance/Release Time | N1_NRS_NU02_EXT | CHAR | 30 | N1_SRV_NU02_EXT | ||||
NU04 | Nursing Plan: Display Terminated Entries | N1NRS_PS_NU04 | CHAR | 1 | XFELD | ||||
NU05 | Nursing Plan: Display Canceled Entries | N1NRS_PS_NU05 | CHAR | 1 | XFELD | ||||
NU06 | Nursing Plan: Hide Properties | N1NRS_PS_NU06 | CHAR | 1 | XFELD | ||||
NU07 | Nursing Plan: Hide Links | N1NRS_PS_NU07 | CHAR | 1 | XFELD | ||||
NU08 | Nursing Plan: Expansion Level | N1NRS_PS_NU08 | NUMC | 1 | NUM1 | ||||
NU09 | Nursing: Display Favorites | N1_NRS_NU09 | CHAR | 1 | N1_NRS_NU09 | ||||
NU10 | Nursing: Display Nursing Plans | N1_NRS_NU10 | CHAR | 1 | N1_NRS_NU10 | ||||
NU11 | Nursing: Dialog for Perform/Release | N1_NRS_NU11 | CHAR | 1 | N1_NRS_NU11 | ||||
NU12 | Nursing: Coloring for Processed Service | N1_NRS_NU12 | CHAR | 4 | N1_NRS_NU12 | ||||
NU13 | Nursing Plan: Hide Invalid Entries | N1NRS_PS_NU13 | CHAR | 1 | XFELD | ||||
NU14 | Nursing: Coloring of Invalid Nursing Plan Entries | N1NRS_PS_NU14 | CHAR | 2 | N1NRS_PS_NU14 | ||||
NU15 | Nursing Plan: Expanded Levels Basic Catalog | N1NRS_PS_NU15 | NUMC | 1 | NUM1 | ||||
NU16 | Nursing Plan: Expansion Level Standard Nursing Plan | N1NRS_PS_NU16 | NUMC | 1 | NUM1 | ||||
NU17 | Nursing Plan: Automatic Planned Evaluation | N1NRS_PS_NU17 | CHAR | 1 | XFELD | ||||
NU18 | Nursing Plan: Number of Days for Planned Evaluation | N1NRS_PS_NU18 | NUMC | 2 | NUMC2 | ||||
NU19 | Nursing Plan: Time of Actual Evaluation | N1NRS_PS_NU19 | CHAR | 1 | N1NRS_PS_NU19 | ||||
NU20 | Nursing Plan Settings: Standalone Configuration | N1NRS_PS_NU20 | CHAR | 32 | SYSUUID_C | ||||
NU21 | Nursing Plan Settings: Configuration | N1NRS_PS_NU21 | CHAR | 32 | SYSUUID_C | ||||
NU22 | Nursing Plan: Display Folder for Properties | N1NRS_PS_NU22 | CHAR | 1 | XFELD | ||||
NU23 | Nursing Plan: Display Folder for Links | N1NRS_PS_NU23 | CHAR | 1 | XFELD | ||||
NU24 | Nursing: Expansion Level for Nursing Plan Selection | N1_NRS_NU24 | NUMC | 1 | NUM1 | ||||
NU25 | Nursing: Coloring of Nursing Plan Blocks | N1NRS_PS_NU25 | CHAR | 2 | N1NRS_PS_NU25 | ||||
CELLSTYLE | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure N1MEDS_ROT_USERPREF_GRID using ABAP code?
As N1MEDS_ROT_USERPREF_GRID is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on N1MEDS_ROT_USERPREF_GRID as there is no data to select.How to access SAP table N1MEDS_ROT_USERPREF_GRID
Within an ECC or HANA version of SAP you can also view further information about N1MEDS_ROT_USERPREF_GRID and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects