SAP Table TN1OTYPE

IS-H*MED: Medication, Type of Order

TN1OTYPE (IS-H*MED: Medication, Type of Order) 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 TN1OTYPE to other SAP tables.

TN1OTYPE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
MOTYPID Medication: Type of Order N1ME_MOTYP NUMC 2 0
PRESCM Medication: Order Profile is Mandatory N1ME_PRESCM CHAR 1 0
X Yes
NULL No
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERTIM IS-H: Time Record Created RI_ERTIM TIMS 6 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 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
ANAMNESIS Medication, Anamnesis Order Type N1ME_ANAMNESIS CHAR 1 0
NULL No
X Yes

TN1OTYPE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TN1OTYPE EINRI TN1OTYPE EINRI TN01 IS-H: Institutions EINRI
TN1OTYPE EINRI TN1OTYPE MANDT TN01 IS-H: Institutions MANDT
TN1OTYPE MANDT TN1OTYPE MANDT T000 Clients MANDT