| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | FORMLVL | Medication: Internal Key of Drug Level | char | 1 | 0 | NUMC | (N'0') | No | | N1ME_MD_FORMLVL | Allow NULL? |
| 3 | CATID | Medication: ID of a Drug Catalog | nvarchar | 3 | 0 | CHAR | (N' ') | No | N1DC | N1ME_CATIDDC | Allow NULL? |
| 4 | LVLTYP | Medication: Drug Level Type | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_LVLTYP | Allow NULL? |
| 5 | EMAR | Medication: "Administration" Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_EMAR | Allow NULL? |
| 6 | DISP | Medication: "Dispensing" Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_DISP | Allow NULL? |
| 7 | PPRINT | Medication: "Print Prescription" Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_PPRINT | Allow NULL? |
| 8 | DLEMAR | Medication: Default Level for "Administration" Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_DLEMAR | Allow NULL? |
| 9 | DLDISP | Medication: Default Level for "Dispensing" Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_DLDISP | Allow NULL? |
| 10 | DLPPRINT | Medication: Default Level for"Prescription Printout" Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_DLPPRINT | Allow NULL? |
| 11 | MMACT | Medication: MM Active for Drug Level | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_MMACT | Allow NULL? |
| 12 | DOCLVL | Medication: Documentation Level | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_DOCLVL | Allow NULL? |
| 13 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 14 | ERTIM | IS-H: Time Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_ERTIM | Allow NULL? |
| 15 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 16 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 17 | UPTIM | IS-H: Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_UPTIM | Allow NULL? |
| 18 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 19 | LOEKZ | Deletion Flag/Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LOEKZ | Allow NULL? |
| 20 | LOUSR | User Who Deleted Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_LOUSR | Allow NULL? |
| 21 | LODAT | Date of Deletion | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_LODAT | Allow NULL? |
| 22 | LOTIM | Deletion Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_LOTIM | Allow NULL? |
| 23 | DLANAMN | Medication: Standard Level for "Anamnesis" Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ME_MD_DLANAMN | Allow NULL? |
