SAP ABAP Table VN1MEORDER (IS-H*MED: Verordnung (Medikation) - Verbuchungsstruktur)
Hierarchy
☛
IS-H (Software Component) SAP Healthcare
⤷ IS-HMED (Application Component) Clinical System
⤷ NMED_ME (Package) IS-H*MED: Medication
⤷ IS-HMED (Application Component) Clinical System
⤷ NMED_ME (Package) IS-H*MED: Medication
Basic Data
Table Category | INTTAB | Structure |
Structure | VN1MEORDER | Table Relationship Diagram |
Short Description | IS-H*MED: Verordnung (Medikation) - Verbuchungsstruktur |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | IS-H*MED: Medication, Drug Order | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | MEORDID | N1ME_MEORDID | N1ME_MEORDID | NUMC | 10 | 0 | Medication: Order - Order Number | ||
4 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | TN01 | |
5 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | NPAT | |
6 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | NFAL | |
7 | MOTX | N1ME_MOTX | N1ME_MOTX | CHAR | 60 | 0 | Medication: Description of Order | ||
8 | MOSTX | N1ME_MOSTX | N1ME_TEXT_80 | CHAR | 80 | 0 | Medication: Order - Comment | ||
9 | MOLTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
10 | ORGFA | N1ME_ORGFA | ORGID | CHAR | 8 | 0 | Medication: Ordering Departmental Org. Unit | NORG | |
11 | ORGPF | N1ME_ORGPF | ORGID | CHAR | 8 | 0 | Medication: Order - Ordering Organizational Unit | NORG | |
12 | MOTYPID | N1ME_MOTYP | N1ME_MOTYP | NUMC | 2 | 0 | Medication: Type of Order | TN1OTYPE | |
13 | MOSID | N1ME_MOSID | N1ME_MOSID | NUMC | 3 | 0 | Status ID for Status of Drug Order | TN1OSTATUS | |
14 | APDEV | N1ME_APDEVID | CHAR | 3 | 0 | Medication: Administration Device ID | TN1DEVICE | ||
15 | PHFORM | N1ME_PHFORMID | CHAR | 3 | 0 | Medication: ID Dosage Form | * | ||
16 | APROU | N1ME_ROUTEID | CHAR | 3 | 0 | Medication: ID Administration Route | TN1ROUTE | ||
17 | MOVDF | N1ME_MOVDF | DATS | DATS | 8 | 0 | Medication: Order - Valid From Date | ||
18 | MOVTF | N1ME_MOVTF | N1ME_MOVTF | TIMS | 6 | 0 | Medication: Validity Time From | ||
19 | MOVDT | N1ME_MOVDT | DATS | DATS | 8 | 0 | Medication: Order - Valid To Date | ||
20 | MOVTT | N1ME_MOVTT | N1ME_MOVTT | TIMS | 6 | 0 | Medication: Order - Validity Time To | ||
21 | ORDUR | N1ME_ORDUR | N1ME_ORDUR | QUAN | 12 | 3 | Medication: Order - Order Duration | ||
22 | ORDURU | N1ME_ORDURU | N1ME_ORDURU | UNIT | 3 | 0 | Medication: Order Duration Unit | ||
23 | EXTD | N1ME_EXTEND | XFELD | CHAR | 1 | 0 | Medication: Change in MO Validity | ||
24 | MEDGRPID | N1ME_MEDGRPID | CHAR | 3 | 0 | Medication: Drug Category Key | |||
25 | MOSUBTY | N1ME_MOSUBTY | N1ME_MOSUBTY | NUMC | 2 | 0 | Medication: Order - Subscreen Type | ||
26 | MORESP1 | N1ME_MORESP1 | RI_KUNNR | CHAR | 10 | 0 | Medication: Order - Employee Responsible | NGPA | |
27 | MORESP2 | N1ME_MORESP2 | RI_KUNNR | CHAR | 10 | 0 | Medication: Order - Consulting EmR | * | |
28 | MOCONSOU | N1ME_MOCONSOU | ORGID | CHAR | 8 | 0 | Medication: Order - Consulting OU | * | |
29 | INSTX | N1ME_INSTX | N1ME_TEXT_80 | CHAR | 80 | 0 | Medication: Order - Preparation Directions | ||
30 | INLTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
31 | ABSG | N1ABSG | CHAR10 | CHAR | 10 | 0 | Termination Reason | ||
32 | MOPRINT | N1ME_MOPRINT | N1ME_MOPRINT | NUMC | 3 | 0 | Medication: Order - Internal Priority | N1MEOPRI | |
33 | MEOEXT | N1ME_MEOEXT | N1ME_MEOEXT | CHAR | 1 | 0 | Medication: Order - External Medication | ||
34 | MEOEXTCC | N1ME_MEOEXTCC | N1ME_MEOEXTCC | CHAR | 1 | 0 | Medication: Relevant for Clinical Checking | ||
35 | EXT_DRUGID | N1ME_EXT_DRUGID | SYSUUID_C | CHAR | 32 | 0 | Medication: External Drug ID | N1BDCC | |
36 | MPRESNR | N1ME_MPRESNR | N1ME_MPRESNR | NUMC | 10 | 0 | Medication - Order Profile ID | ||
37 | MEPSNR | N1ME_MEPSNR | N1ME_MEPSNR | NUMC | 3 | 0 | Medication: Sequence Number Order Profile | ||
38 | MEPSSTX | N1ME_MEPSEQ | N1ME_MEPSEQ | CHAR | 80 | 0 | Medication: Sequence Text Order Profile | ||
39 | MEPSLTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
40 | ORIGIN | N1ME_ORIGIN | N1ME_MEORDID | NUMC | 10 | 0 | Medication: Order - Original Order ID | ||
41 | MOPRN | N1ME_PRN | N1ME_PRN | CHAR | 1 | 0 | Medication: Order - PRN Indicator | ||
42 | PRNCSTX | N1ME_PRNCOND | N1ME_PRNCOND | CHAR | 80 | 0 | Medication: Order - Check Condition | ||
43 | PRNCLTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
44 | OLDIS | N1ME_OLDIS | N1ME_OLDIS | CHAR | 1 | 0 | Medication: Order - Take Home Medication | ||
45 | SLDOSE | N1ME_SLDOSE | N1ME_SLDOSE | CHAR | 1 | 0 | Medication: Orders - Sliding Dose | ||
46 | IVTYPE | N1ME_IVTYPE | N1ME_IVTYPE | CHAR | 1 | 0 | Medication: Order - Infusion Type | ||
47 | RECUP | N1ME_RECUP | XFELD | CHAR | 1 | 0 | Medication: Order - Flag: Recipe Updated | ||
48 | STRGTHDOS | N1ME_STRGTHDOS | N1ME_STRGTHDOS | CHAR | 1 | 0 | Medication: Order - Dose Type | ||
49 | SELTYP | N1ME_SELTYP | N1ME_SELTYP | CHAR | 1 | 0 | Medication: Order - Selection Type | ||
50 | PATWGT | N1ME_PATWGT | N1ME_PATWGT | QUAN | 12 | 3 | Medication: Order - Patient Weight | ||
51 | PATWGTU | N1ME_PATWGTU | N1ME_UNIT | UNIT | 3 | 0 | Medication: Order - Patient Weight Unit | ||
52 | PATHGT | N1ME_PATHGT | N1ME_PATHGT | QUAN | 12 | 3 | Medication: Order - Patient Height | ||
53 | PATHGTU | N1ME_PATHGTU | N1ME_UNIT | UNIT | 3 | 0 | Medication: Order - Patient Height Unit | ||
54 | CALCUD | N1ME_CALCUD | N1ME_CALCUD | CHAR | 1 | 0 | Medication: Order - Calculation Method | ||
55 | PCALOCK | N1ME_PCALOCK | N1ME_QUAN123 | QUAN | 12 | 3 | Medication: PCA Lock Duration | ||
56 | PCALOCKU | N1ME_PCALOCU | N1ME_UNIT | UNIT | 3 | 0 | Medication: Order - PCA Lock Duration Unit | ||
57 | PCAMAX | N1ME_PCAMAX | INT1 | 3 | 0 | Medication: PCA Number of Boli | |||
58 | PCAPER | N1ME_PCAPER | N1ME_QUAN123 | QUAN | 12 | 3 | Medication: Time Number of Boli | ||
59 | PCAPERU | N1ME_PCAPERU | N1ME_UNIT | UNIT | 3 | 0 | Medication: Time Unit Number of Boli | ||
60 | COMPDOS | N1ME_COMPDOS | N1ME_COMPDOS | CHAR | 1 | 0 | Medication: Dose Type for Compound | ||
61 | AL | N1ME_LOCID | NUMC | 4 | 0 | ID Localization for Medication | |||
62 | CHDVER | N1ME_CHDVER | XFELD | CHAR | 1 | 0 | Medication: Order - Change Attribute Check | ||
63 | RCUSE | N1ME_RCUSE | CHAR | 5 | 0 | Order: Medication - Reason for Usage | |||
64 | DC_USED | N1ME_DC_USED | XFELD | CHAR | 1 | 0 | Medication: Order - Dose Calculator Used | ||
65 | VFCOIND | N1ME_VFCOIND | XFELD | CHAR | 1 | 0 | Check Condition Indicator | ||
66 | ADOUTPAT | N1ME_ADOUTPAT | XFELD | CHAR | 1 | 0 | Medication: Administration in IP/OC | ||
67 | OUPREP | N1ME_OUPREP | N1ME_OUPREP | CHAR | 1 | 0 | Medication: Preparation Fill Source Indicator | ||
68 | FIXQUAN | N1ME_FIXQUAN | N1ME_FIXQUAN | CHAR | 1 | 0 | Medication: Order Ind. for Fixed Recipe Qty for Compounds | ||
69 | MEFALAR | FALLART | FALLART | CHAR | 1 | 0 | IS-H: Case Type | ||
70 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
71 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
72 | ERTIM | RI_ERTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time Record Created | ||
73 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
74 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
75 | UPTIM | RI_UPTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time of Last Change | ||
76 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
77 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
78 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
79 | STOID | N1STOID | N1STOID | CHAR | 3 | 0 | Reason for Canceling Medical Object | * | |
80 | NMRF | N1ME_NMRF | N1ME_NMRF | NUMC | 4 | 0 | Medication: Number of Repeats | ||
81 | INPAT_ALLOWED | N1ME_INPAT_ALLOWED | N1ME_ALLOWED_CASETYPE | CHAR | 1 | 0 | Medication: Inpatient Case Type Allowed | ||
82 | DAYPAT_ALLOWED | N1ME_DAYPAT_ALLOWED | N1ME_ALLOWED_CASETYPE | CHAR | 1 | 0 | Medication: Day Patient Case Type Allowed | ||
83 | OUTPAT_ALLOWED | N1ME_OUTPAT_ALLOWED | N1ME_ALLOWED_CASETYPE | CHAR | 1 | 0 | Medication: Outpatient Case Type Allowed | ||
84 | IMDOSE | N1ME_IMDOSE | XFELD | CHAR | 1 | 0 | Medication: Order - Immediate Dose | ||
85 | PURPOSE | N1ME_ORD_PURPOSE | N1ME_ORD_PURPOSE | CHAR | 1 | 0 | Medication: Purpose of Order | ||
86 | DISPQUAN | N1ME_DISPQUAN | N1ME_QUAN123 | QUAN | 12 | 3 | Medication: Drug Dispensing Quantity | ||
87 | DISPQUANU | N1ME_DISPQUANU | N1ME_UNIT | UNIT | 3 | 0 | Medication: Dispensing Quantity Unit | ||
88 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
89 | KZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VN1MEORDER | APDEV | TN1DEVICE | APDEVID | |||
2 | VN1MEORDER | APROU | TN1ROUTE | APROUID | |||
3 | VN1MEORDER | EINRI | TN01 | EINRI | KEY | 1 | CN |
4 | VN1MEORDER | EXT_DRUGID | N1BDCC | DRUGIDBDC | |||
5 | VN1MEORDER | FALNR | NFAL | FALNR | REF | C | CN |
6 | VN1MEORDER | MANDT | T000 | MANDT | KEY | 1 | CN |
7 | VN1MEORDER | MOPRINT | N1MEOPRI | MOPRINT | REF | C | CN |
8 | VN1MEORDER | MORESP1 | NGPA | GPART | REF | C | CN |
9 | VN1MEORDER | MOSID | TN1OSTATUS | MOSID | REF | 1 | CN |
10 | VN1MEORDER | MOTYPID | TN1OTYPE | MOTYPID | REF | C | CN |
11 | VN1MEORDER | ORGFA | NORG | ORGID | REF | C | CN |
12 | VN1MEORDER | ORGPF | NORG | ORGID | REF | C | CN |
13 | VN1MEORDER | PATNR | NPAT | PATNR | REF | C | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 472 |