1. Home
  2. Resources
  3. SAP Tables
  4. TN1FORMLEVEL - i.s.h.med: Medication, Drug Levels

SAP Table TN1FORMLEVEL

i.s.h.med: Medication, Drug Levels

TN1FORMLEVEL (i.s.h.med: Medication, Drug Levels) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TN1FORMLEVEL to other SAP tables.

TN1FORMLEVEL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FORMLVL Medication: Internal Key of Drug Level N1ME_MD_FORMLVL NUMC 1 0
1 Highest Level
2 Middle Level
3 Lowest Level
CATID Medication: ID of a Drug Catalog N1ME_CATIDDC N1DC CHAR 3 0
LVLTYP Medication: Drug Level Type N1ME_MD_LVLTYP CHAR 1 0
1 Generic Drug
2 Generic Drug with Package Information
3 Brand Drug
4 Brand Drug with Package Information
EMAR Medication: "Administration" Purpose N1ME_MD_EMAR CHAR 1 0
NULL Not Used
1 Used
2 Search Only
DISP Medication: "Dispensing" Purpose N1ME_MD_DISP CHAR 1 0
NULL Not Used
1 Used
2 Search Only
PPRINT Medication: "Print Prescription" Purpose N1ME_MD_PPRINT CHAR 1 0
NULL Not Used
1 Used
2 Search Only
DLEMAR Medication: Default Level for "Administration" Purpose N1ME_MD_DLEMAR CHAR 1 0
X Yes
NULL No
DLDISP Medication: Default Level for "Dispensing" Purpose N1ME_MD_DLDISP CHAR 1 0
X Yes
NULL No
DLPPRINT Medication: Default Level for"Prescription Printout" Purpose N1ME_MD_DLPPRINT CHAR 1 0
X Yes
NULL No
MMACT Medication: MM Active for Drug Level N1ME_MD_MMACT CHAR 1 0
X On
NULL Off
DOCLVL Medication: Documentation Level N1ME_MD_DOCLVL CHAR 1 0
X On
NULL Off
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERTIM IS-H: Time Record Created RI_ERTIM TIMS 6 0
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
UPTIM IS-H: Time of Last Change RI_UPTIM TIMS 6 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
LOEKZ Deletion Flag/Indicator RI_LOEKZ CHAR 1 0
X Yes
NULL No
LOUSR User Who Deleted Record RI_LOUSR CHAR 12 0
LODAT Date of Deletion RI_LODAT DATS 8 0
LOTIM Deletion Time RI_LOTIM TIMS 6 0
DLANAMN Medication: Standard Level for "Anamnesis" Purpose N1ME_MD_DLANAMN CHAR 1 0
X Yes
NULL No

TN1FORMLEVEL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TN1FORMLEVEL CATID TN1FORMLEVEL MANDT N1DC IS-H*MED: Table of Formularies MANDT
TN1FORMLEVEL CATID TN1FORMLEVEL CATID N1DC IS-H*MED: Table of Formularies CATID
TN1FORMLEVEL MANDT TN1FORMLEVEL MANDT T000 Clients MANDT