SAP ABAP Table ENT5006 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT5006	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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	BADAT	☑	BADAT	DATUM	DATS	8	0	Requisition (request) date
4	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
5	MEINS	☑	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	T006
6	MENGE	☑	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
7	LIFNR	☑	WLIEF	LIFNR	CHAR	10	0	Desired vendor	LFA1
8	WERKS	☑	EWERK	WERKS	CHAR	4	0	Plant	T001W
9	TXZ01	☑	TXZ01	TEXT40	CHAR	40	0	Short Text
10	BSART	☑	BBSRT	BSART	CHAR	4	0	Purchase Requisition Document Type
11	BVDAT	☑	BVDAT	DATUM	DATS	8	0	Date of last resubmission
12	BVDRK	☑	BVDRK	ZAEHL	DEC	7	0	Number of resubmissions
13	AFNAM	☑	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
14	BATOL	☑	BATOL	BATOL	DEC	3	0	Resubmission interval of purchase requisition
15	BEDNR	☑	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
16	FRGDT	☑	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
17	DISPO	☑	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
18	ESTKZ	☑	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
19	EKGRP	☑	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
20	EMATN	☑	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
21	PSTYP	☑	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
22	FRGKZ	☑	FRGKZ	FRGKZ	CHAR	1	0	Release Indicator	T161S
23	LOEKZ	☑	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
24	BANFN	☑	BANFN	BANFN	CHAR	10	0	Purchase requisition number
25	STATU	☑	BANST	BANST	CHAR	1	0	Processing status of purchase requisition
26	FRGZU	☑	FRGZU	FRGZU	CHAR	8	0	Release status
27	FRGST	☑	FRGST	FRGST	CHAR	2	0	Release strategy in the purchase requisition
28	ERNAM	☑	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
29	ERDAT	☑	AEDAT	DATUM	DATS	8	0	Last Changed On
30	BNFPO	☑	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition
31	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
32	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
33	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
34	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
35	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
36	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number
37	BUMNG	☐	BUMNG	MENG13	QUAN	13	3	Shortage (stock undercoverage) quantity
38	LFDAT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
39	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
40	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
41	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
42	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
43	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
44	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
45	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
46	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
47	EBELP	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number	EKPO

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT5006	DISPO	T024D	DISPO	REF	1	N
2	ENT5006	EBELN	EKKO	EBELN	REF	1	N
3	ENT5006	EBELP	EKPO	EBELP	REF	1	N
4	ENT5006	EKGRP	T024	EKGRP	REF	1	N
5	ENT5006	EKORG	T024E	EKORG	REF	1	N
6	ENT5006	EMATN	MARA	MATNR	REF	1	N
7	ENT5006	FLIEF	LFA1	LIFNR	REF	1	N
8	ENT5006	FRGKZ	T161S	FRGKZ	REF	1	CN
9	ENT5006	KNTTP	T163K	KNTTP	REF	1	N
10	ENT5006	LGORT	T001L	LGORT	REF	1	N
11	ENT5006	LIFNR	LFA1	LIFNR	REF	1	N
12	ENT5006	MANDT	T000	MANDT	KEY	1	N
13	ENT5006	MATKL	T023	MATKL	REF	1	N
14	ENT5006	MATNR	MARA	MATNR	REF	1	N
15	ENT5006	MEINS	T006	MSEHI	REF	1	N
16	ENT5006	PSTYP	T163	PSTYP	REF	1	N
17	ENT5006	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in