SAP ABAP Table N1MEPSTFZ (IS-H*MED: Medication - Substance Assignment)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NORD (Package) R/3MED: Services processing EDV-G
Basic Data
Table Category TRANSP    Transparent table 
Transparent table N1MEPSTFZ   Table Relationship Diagram
Short Description IS-H*MED: Medication - Substance Assignment    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
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 EINRI EINRI EINRI CHAR 4   0   IS-H: Institution TN01
3 MEPID N1MEPID N1MEPID CHAR 20   0   Identification of a Drug N1MEP
4 STFID N1STFID N1STFID NUMC 8   0   Identification of a Substance N1STF
5 KATID N1KATID N1KATID CHAR 10   0   Identification of a Medication Catalog N1MEK
6 STFTYPID N1STFTYPID N1STFTYPID CHAR 5   0   Identification of a Substance Type N1STFTYP
7 WIRK N1WIRK N1WIRK DEC 10   3   Effective Strength  
8 EINH MSEHI MEINS UNIT 3   0   Unit of Measurement T006
9 ERDAT RI_ERDAT RI_DATUM DATS 8   0   IS-H: Date when Record Created  
10 ERUSR RI_ERNAM USNAM CHAR 12   0   IS-H: Name of Employee who Created Record  
11 UPDAT RI_UPDAT RI_DATUM DATS 8   0   IS-H: Date of Last Change  
12 UPUSR RI_UPNAM USNAM CHAR 12   0   IS-H: Name of Person who Last Changed Data  
13 LIDAT N1LIDAT RI_DATUM DATS 8   0   Date of Last Import - External Catalog Type  
14 LIUSR N1LIUSR USNAM CHAR 12   0   User of Last Import  
15 LOEKZ RI_LOEKZ XFELD CHAR 1   0   Deletion Flag/Indicator  
16 LOUSR RI_LOUSR USNAM CHAR 12   0   IS-H: User who Deleted Record  
17 LODAT RI_LODAT RI_DATUM DATS 8   0   IS-H: Date of Deletion  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 N1MEPSTFZ EINH T006 MSEHI REF 1 CN
2 N1MEPSTFZ EINRI TN01 EINRI KEY 1 CN
3 N1MEPSTFZ KATID N1MEK KATID KEY 1 CN
4 N1MEPSTFZ MANDT T000 MANDT KEY 1 CN
5 N1MEPSTFZ MEPID N1MEP MEPID KEY 1 CN
6 N1MEPSTFZ STFID N1STF STFID KEY 1 CN
7 N1MEPSTFZ STFTYPID N1STFTYP STFTYPID REF 1 CN
History
Last changed by/on SAP  20050224 
SAP Release Created in 463