SAP ABAP Table ESD_ESTRI (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster
Delivery Class
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	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
3	ACTN	☑	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
4	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
5	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
6	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
7	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
8	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
9	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
10	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
11	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
12	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
13	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
14	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider
15	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
16	IDTYPE	☐	ESEIDTYPE	ESDIDTYPE	CHAR	10	0	Identification Category	TCG21
17	IDCAT	☐	ESEIDCAT	ESDIDCAT	CHAR	10	0	Identification Type	TCG23
18	LANGU	☐	ESELANGU	SPRAS	LANG	1	0	Language	T002
19	IDENT	☐	ESEIDENT	TEXT132	CHAR	132	0	Identifier
20	IDENTNM	☐	ESEIDENTNM	CHAR132	CHAR	132	0	Normed identification (upper case, no special characters)
21	LTXTFLG	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
22	ORD	☐	ESEORD	NUMC4	NUMC	4	0	Sort Sequence
23	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
24	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	ESD_DRAW
25	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version	ESD_DRAW
26	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ESD_ESTRI	AENNR	AENR	AENNR
2	ESD_ESTRI	DOKAR	TDWA	DOKAR
3	ESD_ESTRI	DOKNR	ESD_DRAW	DOKNR	KEY	1	CN
4	ESD_ESTRI	DOKVR	ESD_DRAW	DOKVR
5	ESD_ESTRI	IDCAT	TCG23	IDCAT		1	CN
6	ESD_ESTRI	IDTYPE	TCG21	IDTYPE	REF	1	CN
7	ESD_ESTRI	LANGU	T002	SPRAS	REF	C	CN
8	ESD_ESTRI	MANDT	T000	MANDT
9	ESD_ESTRI	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in