SAP ABAP Table ENT5005 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT5005	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	PREIS	☐	BAPRE	WERT11	CURR	11	2	Price in Purchase Requisition
39	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	TPRG
40	LFDAT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
41	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
42	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
43	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
44	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
45	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
46	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
47	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
48	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
49	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
50	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
51	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
52	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
53	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
54	EBELP	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number	EKPO
55	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
56	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
57	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT5005	BWTAR	T149D	BWTAR	REF	1	N
2	ENT5005	DISPO	T024D	DISPO	REF	1	N
3	ENT5005	EBELN	EKKO	EBELN	REF	1	N
4	ENT5005	EBELP	EKPO	EBELP	REF	1	N
5	ENT5005	EKGRP	T024	EKGRP	REF	1	N
6	ENT5005	EKORG	T024E	EKORG	REF	1	N
7	ENT5005	EMATN	MARA	MATNR	REF	1	N
8	ENT5005	FLIEF	LFA1	LIFNR	REF	1	N
9	ENT5005	FRGKZ	T161S	FRGKZ	REF	1	CN
10	ENT5005	INFNR	EINA	INFNR	REF	1	N
11	ENT5005	KNTTP	T163K	KNTTP	REF	1	N
12	ENT5005	KONNR	EKKO	EBELN	REF	1	N
13	ENT5005	KTPNR	EKPO	EBELP	REF	1	N
14	ENT5005	LGORT	T001L	LGORT	REF	1	N
15	ENT5005	LIFNR	LFA1	LIFNR	REF	1	N
16	ENT5005	LPEIN	TPRG	PRGBZ	REF	1	N
17	ENT5005	MANDT	T000	MANDT	KEY	1	N
18	ENT5005	MATKL	T023	MATKL	REF	1	N
19	ENT5005	MATNR	MARA	MATNR	REF	1	N
20	ENT5005	MEINS	T006	MSEHI	REF	1	N
21	ENT5005	PSTYP	T163	PSTYP	REF	1	N
22	ENT5005	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in