1. Home
  2. Resources
  3. SAP Tables
  4. N1DC - IS-H*MED: Table of Formularies

SAP Table N1DC

IS-H*MED: Table of Formularies

N1DC (IS-H*MED: Table of Formularies) 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 N1DC to other SAP tables.

N1DC table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
CATID Medication: ID of a Drug Catalog N1ME_CATIDDC CHAR 3 0
CATTYPE Medication: Category of Drug Catalog N1ME_CATTYPE NUMC 1 0
1 External Catalog
2 Formulary
3 External
VERSEXT Medication: External Version Number N1ME_VERSEXT CHAR 15 0
VERSDATE Medication: Date and Time of Version N1ME_VERSDATE NUMC 14 0
MMACTIVE Medication: MM Active Indicator N1ME_MD_MMACTIVE CHAR 1 0
X On
NULL Off
AGCAT Medication: ID of Agent Catalog - OBSOLETE N1ME_MD_AGCATID CHAR 3 0
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
FORMTY Medication: Drug Type Maintained N1ME_N1FORMTY CHAR 1 0
X Yes
NULL No
DELIVERERID i.s.h.med: Medication; Deliverer ID N1ME_MD_DELIVID CHAR 32 0

N1DC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
N1DC MANDT N1DC MANDT T000 Clients MANDT