SAP ABAP Table ENT5769 (Generated Table for View ENT5769)

Basic Data

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

Delivery and Maintenance

Pool/cluster	QDQL
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	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	MATNR	☑	QMATNRQL	MATNR	CHAR	18	0	Material Number	MARA
4	PLNTY	☑	QPLNTYQL	PLNTY	CHAR	1	0	Task List Type	TCA01
5	PLNNR	☑	QPLNNRQL	PLNNR	CHAR	8	0	Key for Task List Group	PLKO
6	PLNAL	☑	QPLNALQL	ALTNR	CHAR	2	0	Group Counter
7	PLNFL	☑	QPLNFLQL	PLNFOLGE	CHAR	6	0	Sequence of Operations Within a Plan
8	PLNKN	☑	QPLNKNQL	KNTNR	NUMC	8	0	Number of Task List Node
9	ZAEHLERQL	☑	QZAEHLERQL	QDYNANZ4	INT4	10	0	Sequential Counter for Different Quality Levels
10	LIFNR	☐	QELIFNQL	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
11	KUNNR	☐	QEKUNNQL	KUNNR	CHAR	10	0	Customer Account Number	KNA1
12	VORNR	☐	QVORNRD	VORNR	CHAR	4	0	Operation Number in the Quality Level
13	MERKNR	☐	QMERKNRD	QMERKNRP	NUMC	4	0	Characteristic Number in the Quality Level
14	VPLTY	☐	VPLNTY	PLNTY	CHAR	1	0	Type of the referenced task list	TCA01
15	VPLNR	☐	VPLNNR	PLNNR	CHAR	8	0	Group of the referenced task list
16	VPLAL	☐	VPLNAL	ALTNR	CHAR	2	0	Group counter of the referenced task list
17	VPLFL	☐	VPLBFL	PLNFOLGE	CHAR	6	0	Referenced sequence in routing
18	VPLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
19	AENDLOSA	☐	QAENDLOSA	QAENDERER	CHAR	12	0	User who Last Changed the Quality Level
20	AENDLOSM	☐	QAENDLOSM	QAENDERER	CHAR	12	0	User who Manually Changed the Quality Level
21	AEDATLOSA	☐	QAEDATLOSA	DATUM	DATS	8	0	Change Date of the Quality Level
22	AEDATLOSM	☐	QAEDATLOSM	DATUM	DATS	8	0	Change Date (Manual) of the Quality Level
23	PRUEFLOS	☐	QPLOSQL	NUMC12	NUMC	12	0	Number of the Last Inspection Lot with Usage Decision
24	BWLOS	☐	QBWLOS	QBEWERTUNG	CHAR	1	0	Valuation (Usage Decision) of the Last Inspection Lot
25	BWLOSDYN	☐	QBWLOSDYN	QBEWERTUNG	CHAR	1	0	Dynamic Modification Valuation of the Last Inspection Lot
26	DYNREGEL	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	QDDR
27	PRSTUFENAE	☐	QPRSTNAE	QPRSTUFE	NUMC	4	0	Inspection Stage for Next Inspection	QDPS
28	ANZLOSEOVE	☐	QANZLOSOVE	QDYNANZ2	INT2	5	0	Number of Inspection Lots Without Usage Decision
29	ANZPRAEN	☐	QANZPRAEN	QDYNANZ2	INT2	5	0	Number of Inspections Since Inspection Stage Change
30	ANZNIOAEN	☐	QANZNIOAEN	QDYNANZ2	INT2	5	0	Number of Not-OK Inspections (Rejections) Since Stage Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT5769	DYNREGEL	QDDR	DYNREGEL	REF	1	CN
2	ENT5769	KUNNR	KNA1	KUNNR	REF	C	CN
3	ENT5769	LIFNR	LFA1	LIFNR	REF	C	CN
4	ENT5769	MANDT	T000	MANDT	KEY	1	CN
5	ENT5769	MATNR	MARA	MATNR	KEY	1	CN
6	ENT5769	PLNNR	PLKO	PLNNR	KEY	C	CN
7	ENT5769	PLNTY	TCA01	PLNTY	KEY	1	CN
8	ENT5769	PRSTUFENAE	QDPS	PRSTUFE	REF	1	CN
9	ENT5769	VPLTY	TCA01	PLNTY	KEY	1	CN
10	ENT5769	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20040719
SAP Release Created in