SAP ABAP Table N1STF (IS-H*MED: Master Data of Medication Substances)

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	N1STF	Table Relationship Diagram
Short Description	IS-H*MED: Master Data of Medication Substances

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	STFID	☑	N1STFID	N1STFID	NUMC	8	0	Identification of a Substance
4	KATID	☐	N1KATID	N1KATID	CHAR	10	0	Identification of a Medication Catalog	N1MEK
5	STFBEZ	☐	N1STFBEZ	N1STFBEZ	CHAR	100	0	Substance Description
6	EXTID	☐	N1EXTID	N1EXTID	CHAR	30	0	External Dispensing Form ID
7	EINH	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	T006
8	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
9	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
10	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
11	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
12	LIDAT	☐	N1LIDAT	RI_DATUM	DATS	8	0	Date of Last Import - External Catalog Type
13	LIUSR	☐	N1LIUSR	USNAM	CHAR	12	0	User of Last Import
14	LOEKZ	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
15	LOUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
16	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	N1STF	EINH	T006	MSEHI	REF	1	CN
2	N1STF	EINRI	TN01	EINRI	KEY	1	CN
3	N1STF	KATID	N1MEK	KATID	REF	1	CN
4	N1STF	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in	463