SAP ABAP View ENT5109 (Purchase order history-goods receipt-blocked stock)

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	ENT5109
Short Description	Purchase order history-goods receipt-blocked stock
Root table	EKBE	History per Purchasing Document

Entity Type	DM02L
Short text	Purchase order history - goods receipt - blocked stock

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EKBE	EKBE
2	EKKO
3	EKPO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EKKO	MANDT	JL	EQ		1		0	0
2	EKBE	MANDT	JR	EQ		1	AND	0	0
3	EKKO	EBELN	JL	EQ		1		0	0
4	EKBE	EBELN	JR	EQ		1	AND	0	0
5	EKKO	MANDT	JL	EQ		1		0	0
6	EKPO	MANDT	JR	EQ		1	AND	0	0
7	EKKO	EBELN	JL	EQ		1		0	0
8	EKPO	EBELN	JR	EQ		1	AND	0	0
9	EKBE	VGABE		EQ	'1'	1		0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EKBE	MANDT	2	☑	MANDT	☐	Client
2	GJAHR	EKBE	GJAHR	2	☑	MJAHR	☐	Year of material document
3	BUDAT	EKBE	BUDAT	2	☑	BUDAT	☐	Posting Date in the Document
4	EBELP	EKPO	EBELP	2	☑	EBELP	☐	Item Number of Purchasing Document
5	BEDAT	EKKO	BEDAT	2	☑	EBDAT	☐	Purchasing Document Date
6	VGABE	EKBE	VGABE	2	☑	VGABE	☐	Transaction/event type, purchase order history
7	BEWTP	EKBE	BEWTP	2	☑	BEWTP	☐	Purchase Order History Category
8	DMBTR	EKBE	DMBTR	2	☑	DMBTR	☐	Amount in local currency
9	WRBTR	EKBE	WRBTR	2	☑	WRBTR	☐	Amount in document currency
10	SHKZG	EKBE	SHKZG	2	☑	SHKZG	☐	Debit/Credit Indicator
11	XBLNR	EKBE	XBLNR	2	☑	XBLNR1	☐	Reference Document Number
12	EBELN	EKBE	EBELN	2	☑	EBELN	☐	Purchasing Document Number
13	ZEKKN	EKBE	ZEKKN	2	☑	DZEKKN	☐	Sequential Number of Account Assignment
14	BELNR	EKBE	BELNR	2	☑	MBLNR	☐	Number of Material Document
15	BUZEI	EKBE	BUZEI	2	☑	MBLPO	☐	Item in material document
16	MENGE	EKBE	MENGE	1	☑	MENGE_D	☐	Quantity
17	BPMNG	EKBE	BPMNG	1	☑	MENGE_BPR	☐	Quantity in purchase order price unit
18	WAERS	EKBE	WAERS	1	☑	WAERS	☐	Currency Key
19	ELIKZ	EKBE	ELIKZ	1	☑	ELIKZ	☐	"Delivery Completed" Indicator
20	BWART	EKBE	BWART	1	☑	BWART	☐	Movement type (inventory management)
21	LFGJA	EKBE	LFGJA	1	☑	LFBJA	☐	Fiscal Year of a Reference Document
22	LFBNR	EKBE	LFBNR	1	☑	LFBNR	☐	Document number of a reference document
23	LFPOS	EKBE	LFPOS	1	☑	LFPOS	☐	Item of a reference document
24	WESBS	EKBE	WESBS		☐	WESBS	☐	Goods receipt blocked stock in order unit
25	BPWES	EKBE	BPWES		☐	BPWES	☐	Quantity in GR blocked stock in order price unit

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	20140121
SAP Release Created in