SAP ABAP View ENT5005 (Purchase requisition item - third party delivery)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ UUDM (Package) EDM: Data Modeler (General)

Basic Data

View Type	D	Database View
Database View	ENT5005
Short Description	Purchase requisition item - third party delivery
Root table	EBAN	Purchase Requisition

Entity Type	DM02L
Short text	Purchase requisition item - third party delivery

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EBAN	EBAN

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EBAN	MANDT	1	☑	MANDT	☐	Client
2	MATNR	EBAN	MATNR	1	☑	MATNR	☐	Material Number
3	BADAT	EBAN	BADAT	1	☑	BADAT	☐	Requisition (request) date
4	MATKL	EBAN	MATKL	1	☑	MATKL	☐	Material Group
5	MEINS	EBAN	MEINS	1	☑	BAMEI	☐	Purchase requisition unit of measure
6	MENGE	EBAN	MENGE	1	☑	BAMNG	☐	Purchase requisition quantity
7	LIFNR	EBAN	LIFNR	1	☑	WLIEF	☐	Desired vendor
8	WERKS	EBAN	WERKS	1	☑	EWERK	☐	Plant
9	TXZ01	EBAN	TXZ01	1	☑	TXZ01	☐	Short Text
10	BSART	EBAN	BSART	1	☑	BBSRT	☐	Purchase Requisition Document Type
11	BVDAT	EBAN	BVDAT	1	☑	BVDAT	☐	Date of last resubmission
12	BVDRK	EBAN	BVDRK	1	☑	BVDRK	☐	Number of resubmissions
13	AFNAM	EBAN	AFNAM	1	☑	AFNAM	☐	Name of requisitioner/requester
14	BATOL	EBAN	BATOL	1	☑	BATOL	☐	Resubmission interval of purchase requisition
15	BEDNR	EBAN	BEDNR	1	☑	BEDNR	☐	Requirement Tracking Number
16	FRGDT	EBAN	FRGDT	1	☑	FRGDT	☐	Purchase Requisition Release Date
17	DISPO	EBAN	DISPO	1	☑	DISPO	☐	MRP controller
18	ESTKZ	EBAN	ESTKZ	1	☑	ESTKZ	☐	Creation indicator (purchase requisition/schedule lines)
19	EKGRP	EBAN	EKGRP	1	☑	EKGRP	☐	Purchasing group
20	EMATN	EBAN	EMATN	1	☑	EMATN	☐	Material number corresponding to manufacturer part number
21	PSTYP	EBAN	PSTYP	1	☑	PSTYP	☐	Item category in purchasing document
22	FRGKZ	EBAN	FRGKZ	1	☑	FRGKZ	☐	Release Indicator
23	LOEKZ	EBAN	LOEKZ	1	☑	ELOEK	☐	Deletion indicator in purchasing document
24	BANFN	EBAN	BANFN	1	☑	BANFN	☐	Purchase requisition number
25	STATU	EBAN	STATU	1	☑	BANST	☐	Processing status of purchase requisition
26	FRGZU	EBAN	FRGZU	1	☑	FRGZU	☐	Release status
27	FRGST	EBAN	FRGST	1	☑	FRGST	☐	Release strategy in the purchase requisition
28	ERNAM	EBAN	ERNAM	1	☑	ERNAM	☐	Name of Person who Created the Object
29	ERDAT	EBAN	ERDAT	1	☑	AEDAT	☐	Last Changed On
30	BNFPO	EBAN	BNFPO	1	☑	BNFPO	☐	Item number of purchase requisition
31	LGORT	EBAN	LGORT	1	☑	LGORT_D	☐	Storage location
32	FLIEF	EBAN	FLIEF	1	☑	FLIEF	☐	Fixed vendor
33	EKORG	EBAN	EKORG	1	☑	EKORG	☐	Purchasing organization
34	QUNUM	EBAN	QUNUM	1	☑	QUNUM	☐	Number of quota arrangement
35	QUPOS	EBAN	QUPOS	1	☑	QUPOS	☐	Quota arrangement item
36	SERNR	EBAN	SERNR	1	☑	SERNR	☐	BOM explosion number
37	BUMNG	EBAN	BUMNG		☐	BUMNG	☐	Shortage (stock undercoverage) quantity
38	PREIS	EBAN	PREIS		☐	BAPRE	☐	Price in Purchase Requisition
39	LPEIN	EBAN	LPEIN		☐	LPEIN	☐	Category of delivery date
40	LFDAT	EBAN	LFDAT		☐	EINDT	☐	Item delivery date
41	WEBAZ	EBAN	WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
42	PEINH	EBAN	PEINH		☐	EPEIN	☐	Price unit
43	KNTTP	EBAN	KNTTP		☐	KNTTP	☐	Account assignment category
44	KZVBR	EBAN	KZVBR		☐	KZVBR	☐	Consumption posting
45	WEPOS	EBAN	WEPOS		☐	WEPOS	☐	Goods Receipt Indicator
46	WEUNB	EBAN	WEUNB		☐	WEUNB	☐	Goods Receipt, Non-Valuated
47	REPOS	EBAN	REPOS		☐	REPOS	☐	Invoice receipt indicator
48	BEDAT	EBAN	BEDAT		☐	BEDAT	☐	Purchase Order Date
49	BSMNG	EBAN	BSMNG		☐	BSMNG	☐	Quantity ordered against this purchase requisition
50	KONNR	EBAN	KONNR		☐	KONNR	☐	Number of principal purchase agreement
51	KTPNR	EBAN	KTPNR		☐	KTPNR	☐	Item number of principal purchase agreement
52	INFNR	EBAN	INFNR		☐	INFNR	☐	Number of purchasing info record
53	EBELN	EBAN	EBELN		☐	BSTNR	☐	Purchase order number
54	EBELP	EBAN	EBELP		☐	BSTPO	☐	Purchase order item number
55	BWTAR	EBAN	BWTAR		☐	BWTAR_D	☐	Valuation type
56	VRTKZ	EBAN	VRTKZ		☐	VRTKZ	☐	Distribution indicator for multiple account assignment
57	TWRKZ	EBAN	TWRKZ		☐	TWRKZ	☐	Partial invoice indicator

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in