SAP ABAP Table N1FOFOA (IS-H*MED: Ingredient - Composite Drug Assignment)
Hierarchy
IS-H (Software Component) SAP Healthcare
   IS-HMED (Application Component) Clinical System
     NMED_ME (Package) IS-H*MED: Medication
Basic Data
Table Category TRANSP    Transparent table 
Transparent table N1FOFOA   Table Relationship Diagram
Short Description IS-H*MED: Ingredient - Composite Drug Assignment    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 GROUPDRUG N1ME_GROUPDRUG SYSUUID_C CHAR 32   0   Mnemonic of Composite Drug N1FORMULARY
3 INGDRUG N1ME_INGDRUG SYSUUID_C CHAR 32   0   Medication: Ingredient N1FORMULARY
4 DRUGTYP N1ME_MDRUGTYP N1ME_MDRUGTYP CHAR 1   0   Type of Ingredient in Medication Group  
5 UNIT N1ME_UNIT MEINS UNIT 3   0   Drug Base Unit T006
6 QUANT N1ME_QUANT N1ME_QUAN123 QUAN 12   3   Quantity of Assigned Agent or Drug  
7 STUNIT N1ME_STRGTHU MEINS UNIT 3   0   Strength Unit T006
8 STRGTH N1ME_STRGTH N1ME_QUAN123 QUAN 12   3   Drug Strength  
9 CALCUD N1ME_CALCUD N1ME_CALCUD CHAR 1   0   Medication: Order - Calculation Method  
10 CALCUDU N1ME_CMU MEINS UNIT 3   0   Medication: Order - Calculation Method Unit *
11 ERDAT RI_ERDAT RI_DATUM DATS 8   0   IS-H: Date when Record Created  
12 ERTIM RI_ERTIM UHRZT TIMS 6   0   IS-H: Time Record Created  
13 ERUSR RI_ERNAM USNAM CHAR 12   0   IS-H: Name of Employee who Created Record  
14 UPDAT RI_UPDAT RI_DATUM DATS 8   0   IS-H: Date of Last Change  
15 UPTIM RI_UPTIM UHRZT TIMS 6   0   IS-H: Time of Last Change  
16 UPUSR RI_UPNAM USNAM CHAR 12   0   IS-H: Name of Person who Last Changed Data  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 N1FOFOA GROUPDRUG N1FORMULARY DRUGID    
2 N1FOFOA INGDRUG N1FORMULARY DRUGID    
3 N1FOFOA MANDT T000 MANDT    
4 N1FOFOA STUNIT T006 MSEHI    
5 N1FOFOA UNIT T006 MSEHI    
History
Last changed by/on SAP  20050224 
SAP Release Created in 472