SAP ABAP Table N1STFTYP (IS-H*MED: Substance Types)

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	N1STFTYP	Table Relationship Diagram
Short Description	IS-H*MED: Substance Types

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

History

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