SAP ABAP Table V_TN1ESTATUS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TN1ESTATUS	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	EINRI	☑	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
3	MESID	☑	N1ME_MESID	N1ME_MESID	NUMC	3	0	Status ID for Status of Drug Event
4	INTST	☐	N1ME_MEISTA	N1ME_MEISTA	NUMC	2	0	Internal Status of Drug Event
5	ESTSEQ	☐	N1ME_MESTAS	N1ME_MESTAS	NUMC	2	0	Status Sequence Drug Event Status
6	EMAR	☐	N1ME_ESTAT_EMAR	N1ME_ESTAT_EMAR	CHAR	1	0	Medication: Event Status Flag "Administration"
7	DISP	☐	N1ME_ESTAT_DISP	N1ME_ESTAT_DISP	CHAR	1	0	Medication: Event Status Flag "Dispensing"
8	PPRINT	☐	N1ME_ESTAT_PRINT	N1ME_ESTAT_PRINT	CHAR	1	0	Medikation: Event Status Flag "Prescription Print"
9	USERST	☐	N1ME_MESTA	N1ME_MESTA	CHAR	3	0	Customer-Specific Status of Drug Event
10	DESCR	☐	N1ME_MESTAD	N1ME_MESTAD	CHAR	15	0	Status for Drug Event - Description
11	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
12	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
13	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
14	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
15	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
16	LOEKZ	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
17	LOUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
18	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	V_TN1ESTATUS	EINRI	TN01	EINRI	KEY	1	CN
2	V_TN1ESTATUS	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in