SAP ABAP View V_EKKO_EKPO (Usage Only in MM-SRV; for MM-PUR Note 313648 Applies)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

View Type	D	Database View
Database View	V_EKKO_EKPO
Short Description	Usage Only in MM-SRV; for MM-PUR Note 313648 Applies
Root table	EKKO	Purchasing Document Header

Table

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

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EKKO	MANDT		☐	MANDT	☐	Client
2	EBELN	EKKO	EBELN		☐	EBELN	☐	Purchasing Document Number
3	EBELP	EKPO	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
4	BUKRS_K	EKKO	BUKRS		☐	BUKRS	☐	Company Code
5	BSTYP_K	EKKO	BSTYP		☐	EBSTYP	☐	Purchasing Document Category
6	BSART	EKKO	BSART		☐	ESART	☐	Purchasing Document Type
7	BSAKZ	EKKO	BSAKZ		☐	BSAKZ	☐	Control indicator for purchasing document type
8	LOEKZ_K	EKKO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
9	STATU_K	EKKO	STATU		☐	ESTAK	☐	Status of Purchasing Document
10	AEDAT_K	EKKO	AEDAT		☐	ERDAT	☐	Date on which the record was created
11	ERNAM	EKKO	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
12	LIFNR	EKKO	LIFNR		☐	ELIFN	☐	Vendor's account number
13	EKORG	EKKO	EKORG		☐	EKORG	☐	Purchasing organization
14	EKGRP	EKKO	EKGRP		☐	BKGRP	☐	Purchasing Group
15	WAERS	EKKO	WAERS		☐	WAERS	☐	Currency Key
16	BEDAT	EKKO	BEDAT		☐	EBDAT	☐	Purchasing Document Date
17	KDATB	EKKO	KDATB		☐	KDATB	☐	Start of Validity Period
18	KDATE	EKKO	KDATE		☐	KDATE	☐	End of Validity Period
19	ADRNR_K	EKKO	ADRNR		☐	AD_ADDRNUM	☐	Address number
20	KTWRT	EKKO	KTWRT		☐	KTWRT	☐	Target Value for Header Area per Distribution
21	KUFIX	EKKO	KUFIX		☐	KUFIX	☐	Indicator: Fixing of Exchange Rate
22	FRGRL	EKKO	FRGRL		☐	FRGRL	☐	Release Not Yet Completely Effected
23	MEMORY	EKKO	FRGRL		☐	FRGRL	☐	Release Not Yet Completely Effected
24	LOEKZ	EKPO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
25	STATU	EKPO	STATU		☐	ASTAT	☐	RFQ status
26	AEDAT	EKPO	AEDAT		☐	PAEDT	☐	Purchasing Document Item Change Date
27	TXZ01	EKPO	TXZ01		☐	TXZ01	☐	Short Text
28	BUKRS	EKPO	BUKRS		☐	BUKRS	☐	Company Code
29	WERKS	EKPO	WERKS		☐	EWERK	☐	Plant
30	LGORT	EKPO	LGORT		☐	LGORT_D	☐	Storage location
31	BEDNR	EKPO	BEDNR		☐	BEDNR	☐	Requirement Tracking Number
32	MATKL	EKPO	MATKL		☐	MATKL	☐	Material Group
33	MENGE	EKPO	MENGE		☐	BSTMG	☐	Purchase Order Quantity
34	MEINS	EKPO	MEINS		☐	BSTME	☐	Order unit
35	BPRME	EKPO	BPRME		☐	BBPRM	☐	Order Price Unit (purchasing)
36	BPUMZ	EKPO	BPUMZ		☐	BPUMZ	☐	Numerator for Conversion of Order Price Unit into Order Unit
37	BPUMN	EKPO	BPUMN		☐	BPUMN	☐	Denominator for Conv. of Order Price Unit into Order Unit
38	UMREZ	EKPO	UMREZ		☐	UMBSZ	☐	Numerator for Conversion of Order Unit to Base Unit
39	UMREN	EKPO	UMREN		☐	UMBSN	☐	Denominator for Conversion of Order Unit to Base Unit
40	NETPR	EKPO	NETPR		☐	BPREI	☐	Net Price in Purchasing Document (in Document Currency)
41	PEINH	EKPO	PEINH		☐	EPEIN	☐	Price unit
42	NETWR	EKPO	NETWR		☐	BWERT	☐	Net Order Value in PO Currency
43	BRTWR	EKPO	BRTWR		☐	BBWERT	☐	Gross order value in PO currency
44	EREKZ	EKPO	EREKZ		☐	EREKZ	☐	Final Invoice Indicator
45	PSTYP	EKPO	PSTYP		☐	PSTYP	☐	Item category in purchasing document
46	KNTTP	EKPO	KNTTP		☐	KNTTP	☐	Account assignment category
47	LMEIN	EKPO	LMEIN		☐	LAGME	☐	Base Unit of Measure
48	ZWERT	EKPO	ZWERT		☐	DZWERT	☐	Target value for outline agreement in document currency
49	PRDAT	EKPO	PRDAT		☐	PREDT	☐	Date of Price Determination
50	BSTYP	EKPO	BSTYP		☐	BSTYP	☐	Purchasing document category
51	PACKNO	EKPO	PACKNO		☐	PACKNO	☐	Package number
52	ANFNR	EKPO	ANFNR		☐	ANFNR	☐	RFQ Number
53	ANFPS	EKPO	ANFPS		☐	ANFPS	☐	Item Number of RFQ
54	BANFN	EKPO	BANFN		☐	BANFN	☐	Purchase requisition number
55	BNFPO	EKPO	BNFPO		☐	BNFPO	☐	Item number of purchase requisition
56	AFNAM	EKPO	AFNAM		☐	AFNAM	☐	Name of requisitioner/requester
57	LEBRE	EKPO	LEBRE		☐	LEBRE	☐	Indicator for Service-Based Invoice Verification
58	ADRNR	EKPO	ADRNR		☐	ADRNR_MM	☐	Manual address number in purchasing document item
59	SPRAS	EKKO	SPRAS		☐	SPRAS	☐	Language Key
60	KZVBR	EKPO	KZVBR		☐	KZVBR	☐	Consumption posting
61	WEBRE	EKPO	KZVBR		☐	KZVBR	☐	Consumption posting
62	ELIKZ	EKPO	ELIKZ		☐	ELIKZ	☐	"Delivery Completed" Indicator
63	WEPOS	EKPO	WEPOS		☐	WEPOS	☐	Goods Receipt 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	20140121
SAP Release Created in