1. Home
  2. Resources
  3. SAP Tables
  4. TN1RCODE - IS-H*MED: Reason Code

SAP Table TN1RCODE

IS-H*MED: Reason Code

TN1RCODE (IS-H*MED: Reason Code) 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 TN1RCODE to other SAP tables.

TN1RCODE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
RCODEID Medication: Reason ID N1ME_RCODEID CHAR 5 0
DEACT Medication: Deactivation in Formulary Indicator N1ME_DEACT CHAR 1 0
X Yes
NULL No
DOSE Medication: Reason for Dose Difference Indicator N1ME_DOSEX CHAR 1 0
X Yes
NULL No
TIME Medication: Reason for Time Difference Indicator N1ME_TIMEX CHAR 1 0
X Yes
NULL No
OUSAGE Medication: Reason for Medication Order Indicator N1ME_OUSAGE CHAR 1 0
X Yes
NULL No
OENDING Medication: Indicator - End Reason for Order N1ME_ENDING CHAR 1 0
X Yes
NULL No
DISCARD Medication: Reason for Termination Indicator N1ME_DISCARD CHAR 1 0
X Yes
NULL No
DUPPRINT Medication: Reason for Duplicate Print Indicator N1ME_DUPPRINT CHAR 1 0
NULL Not Permitted for Multiple Printing
X Permitted for Multiple Printing
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
CCOVERRULED Medication: Medication Message Confirmed Indicator N1ME_OVERR CHAR 1 0
X Yes
NULL No

TN1RCODE foreign key relationships

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