1. Home
  2. Resources
  3. SAP Tables
  4. TN1ESTATUS - IS-H*MED: Status for Drug Event

SAP Table TN1ESTATUS

IS-H*MED: Status for Drug Event

TN1ESTATUS (IS-H*MED: Status for Drug Event) 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 TN1ESTATUS to other SAP tables.

TN1ESTATUS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
MESID Medication: Status ID for Status of Drug Event N1ME_MESID NUMC 3 0
INTST Medication: Internal Status of Drug Event N1ME_MEISTA NUMC 2 0
01 Saved
02 Confirmed
03 In Processing
04 Administered
05 Canceled
06 Completed
ESTSEQ Medication: Status Sequence Drug Event Status N1ME_MESTAS NUMC 2 0
EMAR Medication: Event Status Flag "Administration" N1ME_ESTAT_EMAR CHAR 1 0
NULL Not Applicable
X Status for Administration
DISP Medication: Event Status Flag "Dispensing" N1ME_ESTAT_DISP CHAR 1 0
NULL Not Applicable
X Status for Take Home
PPRINT Medikation: Event Status Flag "Prescription Print" N1ME_ESTAT_PRINT CHAR 1 0
NULL Not Applicable
X Status of Event Printing
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

TN1ESTATUS foreign key relationships

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