SAP ABAP Table ENT5809 (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	PLPO
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	PLNTY	☑	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
3	PLNNR	☑	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
4	PLNKN	☑	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
5	ZAEHL	☑	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
6	DATUV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
7	ANDAT	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
8	ANNAM	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
9	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
12	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
13	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
14	RSTRA	☐	RSTRA	RSTRA	CHAR	2	0	Reduction strategy per operation/activity
15	MLSTN	☐	MILESTONE	MILESTONE	CHAR	5	0	Usage	T433
16	PPRIO	☐	PRIORITAET	PRIORITAET	CHAR	2	0	Priority
17	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	TCN00
18	USR00	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
19	USR01	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
20	USR02	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
21	USR03	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
22	USR04	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
23	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
24	USR05	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
25	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
26	USR06	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
27	USE06	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
28	USR07	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
29	USE07	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
30	USR08	☐	USRDATE	USRDATE	DATS	8	0	User field for date
31	USR09	☐	USRDATE	USRDATE	DATS	8	0	User field for date
32	USR10	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
33	USR11	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
34	FRSP	☐	FRSP	FRSP	CHAR	1	0	Earliest possible activity / Latest possible activity
35	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
36	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
37	UMREN	☐	CP_UMREN	UMBSN	DEC	5	0	Denominator for converting rtg and op units of measure
38	UMREZ	☐	CP_UMREZ	UMBSZ	DEC	5	0	Numerator for converting task list and oper. un. of measure
39	BMSCH	☐	BMSCH	BMSCH	QUAN	13	3	Base Quantity
40	SORTL	☐	SORTI	CHAR10	CHAR	10	0	Sort Term for Non-Stock Info Records
41	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
42	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
43	PREIS	☐	IPREI	WERT11	CURR	11	2	Net Price in Purchasing Info Record
44	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
45	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
46	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
47	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
48	ESOKZ	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
49	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
50	EKGRP	☐	VG_EKGRP	EKGRP	CHAR	3	0	Purchasing group for external processing	T024
51	KZLGF	☐	KZLGF	XFELD	CHAR	1	0	Indicator: fixed lot external processing
52	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
53	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
54	BMEIH	☐	BMEIH	MEINS	UNIT	3	0	Operation order quantity unit	T006
55	BMVRG	☐	BMVRG	MENG13	QUAN	13	3	Purchase order quantity operation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT5809	BMEIH	T006	MSEHI	REF	1	CN
2	ENT5809	BUKRS	T001	BUKRS	REF	1	CN
3	ENT5809	EKGRP	T024	EKGRP	REF	1	CN
4	ENT5809	EKORG	T024E	EKORG	REF	1	CN
5	ENT5809	INFNR	EINA	INFNR	REF	1	CN
6	ENT5809	LIFNR	LFA1	LIFNR	REF	1	CN
7	ENT5809	MANDT	T000	MANDT	KEY	1	CN
8	ENT5809	MATKL	T023	MATKL	REF	1	CN
9	ENT5809	MEINH	T006	MSEHI	REF	1	CN
10	ENT5809	MLSTN	T433	MLSTN	REF	1	CN
11	ENT5809	PLNTY	TCA01	PLNTY	KEY	1	CN
12	ENT5809	SAKTO	CSKA	KSTAR	REF	1	CN
13	ENT5809	SLWID	TCN00	SLWID	REF	C	CN
14	ENT5809	STEUS	T430	STEUS	REF	1	CN
15	ENT5809	TXTSP	T002	SPRAS	REF	1	CN
16	ENT5809	USE04	T006	MSEHI	REF	1	CN
17	ENT5809	USE05	T006	MSEHI	REF	1	CN
18	ENT5809	USE06	TCURC	WAERS	REF	1	CN
19	ENT5809	USE07	TCURC	WAERS	REF	1	CN
20	ENT5809	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in