1. Home
  2. Resources
  3. SAP Tables
  4. NAGENT - IS-H*MED: Agents of Drugs

SAP Table NAGENT

IS-H*MED: Agents of Drugs

NAGENT (IS-H*MED: Agents of Drugs) 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 NAGENT to other SAP tables.

NAGENT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AGENTID Medication: Agent ID N1ME_AGENTID CHAR 32 0
CATIDBDC Medication: ID of External Drug Catalog - OBSOLETE N1ME_CATIDBC_O CHAR 3 0
EXTKEY Medication: ID in Base Drug Catalog - OBSOLETE N1ME_EXTKEY_O CHAR 40 0
VERSDATE Medciation: Date and Time of Version - OBSOLETE N1ME_VERSDATE_O NUMC 14 0
EXTDCODECAT Medication: ID of Identification System - OBSOLETE N1ME_EXTDCODECAT CHAR 3 0
EXTDINGCODE Medication:Code of Agent in Identification System - OBSOLETE N1ME_EXTDINGCODE CHAR 40 0
AGTYPE Medication: Agent Type N1ME_AGTYPE CHAR 3 0
001 Agent
002 Anion
003 Cation
004 Protein
005 Fat
006 Carbohydrate
007 Calorie
008 Auxiliary Agent
009 Others
EXTCATID Medication: ID of Agent Catalog - OBSOLETE N1ME_MD_AGCATID CHAR 3 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
UPTIM IS-H: Time of Last Change RI_UPTIM TIMS 6 0
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
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

NAGENT foreign key relationships

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