SAP ABAP Table TNSTA0 (IS-H: Used Profiles Status Med. Basic Documentation)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPVS (Package) Application development patient management system

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TNSTA0	Table Relationship Diagram
Short Description	IS-H: Used Profiles Status Med. Basic Documentation

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	ENDDT	☑	RI_ENDDT	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Record
4	BEGDT	☐	RI_BEGDT	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Record
5	S_STSMA	☐	ISH_MD_S_STSMA	J_STSMA	CHAR	8	0	IS-H: Status Profile Med. Basic Doc. for Inpatient Cases	TJ20
6	T_STSMA	☐	ISH_MD_T_STSMA	J_STSMA	CHAR	8	0	IS-H: Status Profile Med. Basic Doc. for Day Patient Cases	TJ20
7	A_STSMA	☐	ISH_MD_A_STSMA	J_STSMA	CHAR	8	0	IS-H: Status Profile Med. Basic Doc. for Outpatient Cases	TJ20
8	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
9	ERTIM	☐	ISH_ERTIM	UHRZT	TIMS	6	0	IS-H: Time when Data 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	UPTIM	☐	ISH_UPTIM	UHRZT	TIMS	6	0	IS-H: Time Data Record was Last Changed
13	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	TNSTA0	A_STSMA	TJ20	STSMA	KEY	1	CN
2	TNSTA0	EINRI	TN01	EINRI
3	TNSTA0	MANDT	T000	MANDT
4	TNSTA0	S_STSMA	TJ20	STSMA	KEY	1	CN
5	TNSTA0	T_STSMA	TJ20	STSMA	KEY	1	CN

History

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