SAP table V_EKKO_EKPO (Generated Table for View)

SAP table V_EKKO_EKPO has 3 primary key fields being MANDT,EBELN,EBELP.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
BUKRS_K Company Code CHAR 4 0 T001 BUKRS
BSTYP_K Purchasing Document Category CHAR 1 0 EBSTYP
A Request for Quotation
C Central Contract
F Purchase Order
K Contract
L Scheduling Agreement
N Central Request for Quotation
O Quotation
P Central Purchsae Order
R RFQ
T Central Supplier Quotation
BSART Purchasing Document Type CHAR 4 0 T161 ESART
BSAKZ Control indicator for purchasing document type CHAR 1 0 BSAKZ
C Subordinate Document
H Hierarchy
R Purchase requisition for outline agreement
T Transport
LOEKZ_K Deletion Indicator in Purchasing Document CHAR 1 0 ELOEK
STATU_K Status of Purchasing Document CHAR 1 0 ESTAK
1 Purchase Order from APO
2 Third-Party Order from CRM
3 Returns Order from Incorrect Delivery
4 Subsequent Stock Transport Order for Additional Item
5 Incorrect Item Returns from Stock Transport Orders
9 Enjoy Purchase Order
A RFQ with Quotation
B Purchase Order from Automatic Conversion of Requisitions
C Purchase Order from Goods Receipt
D Purchase Order from Data Transfer
E Purchase Order from Allocation Table
F Purchase Order from Kanban
G Purchase Order from Store Order
H Purchase Order from DRP
I Purchase Order from BAPI
J Purchase Order from ALE Scenario
K Purchase Order from BBP
L Scheduling Agreement from CRM
M Purchasing Document from E-Sourcing
N Purchase Document from external Network / System
R S4CRM Service Order
S Collective Purchase Order
T Purchase Order from Transportation Management
W Purchase Order Ignored for Collective Delivery Run
X Purchase Order Created via Function Module
AEDAT_K Creation Date of Purchasing Document DATS 8 0 MMPUR_ERDAT
ERNAM User of person who created a purchasing document CHAR 12 0 MMPUR_ERNAM
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 BKGRP
WAERS Currency Key CUKY 5 0 TCURC WAERS
BEDAT Purchasing Document Date DATS 8 0 EBDAT
KDATB Start of Validity Period DATS 8 0 KDATB
KDATE End of Validity Period DATS 8 0 KDATE
ADRNR_K Address Number CHAR 10 0 AD_ADDRNUM
KTWRT Target Value for Header Area per Distribution CURR 15 2 KTWRT
KUFIX Indicator for Fixed Exchange Rate CHAR 1 0 KUFIX
FRGRL Release Not Yet Completely Effected CHAR 1 0 FRGRL
MEMORY Release Not Yet Completely Effected CHAR 1 0 FRGRL
LOEKZ Deletion Indicator in Purchasing Document CHAR 1 0 ELOEK
STATU Origin of a Purchasing Document Item CHAR 1 0 ASTAT
No Quotation Exists/Not Created via Sales
A Quotation Exists in Case of RFQ Item
F Created via Production Order
V Created via Sales document
W Created via Allocation Table
AEDAT Purchasing Document Item Change Date DATS 8 0 PAEDT
TXZ01 Short Text CHAR 40 0 TXZ01
BUKRS Company Code CHAR 4 0 T001 BUKRS
WERKS Plant CHAR 4 0 T001W EWERK
LGORT Storage location CHAR 4 0 T001L LGORT_D
BEDNR Requirement Tracking Number CHAR 10 0 BEDNR
MATKL Material Group CHAR 9 0 T023 MATKL
MENGE Purchase Order Quantity QUAN 13 3 BSTMG
MEINS Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
BPRME Order Price Unit (Purchasing) UNIT 3 0 T006 BBPRM
BPUMZ Numerator for Conversion of Order Price Unit into Order Unit DEC 5 0 BPUMZ
BPUMN Denominator for Conv. of Order Price Unit into Order Unit DEC 5 0 BPUMN
UMREZ Numerator for Conversion of Order Unit to Base Unit DEC 5 0 UMBSZ
UMREN Denominator for Conversion of Order Unit to Base Unit DEC 5 0 UMBSN
NETPR Net Price in Purchasing Document (in Document Currency) CURR 11 2 BPREI
PEINH Price unit DEC 5 0 EPEIN
NETWR Net Order Value in PO Currency CURR 13 2 BWERT
BRTWR Gross order value in PO currency CURR 13 2 BBWERT
EREKZ Final Invoice Indicator CHAR 1 0 EREKZ
PSTYP Item category in purchasing document CHAR 1 0 T163 PSTYP
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
LMEIN Base Unit of Measure UNIT 3 0 T006 LAGME
ZWERT Target Value for Outline Agreement in Document Currency CURR 13 2 DZWERT
PRDAT Date of Price Determination DATS 8 0 PREDT
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
PACKNO Package number NUMC 10 0 ESLH PACKNO
ANFNR RFQ Number CHAR 10 0 EKKO ANFNR
ANFPS Item Number of RFQ NUMC 5 0 EKPO ANFPS
BANFN Purchase Requisition Number CHAR 10 0 BANFN
BNFPO Item number of purchase requisition NUMC 5 0 EBAN BNFPO
AFNAM Name of requisitioner/requester CHAR 12 0 AFNAM
LEBRE Indicator for Service-Based Invoice Verification CHAR 1 0 LEBRE
ADRNR Manual address number in purchasing document item CHAR 10 0 ADRC ADRNR_MM
SPRAS Language Key LANG 1 0 T002 SPRAS
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
WEBRE Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
WEPOS Goods Receipt Indicator CHAR 1 0 WEPOS

V_EKKO_EKPO foreign key relationships

Table Field Check Table Check Field
0 V_EKKO_EKPO ADRNR ADRC Addresses (Business Address Services) DATE_FROM
0 V_EKKO_EKPO ADRNR ADRC Addresses (Business Address Services) NATION
1 V_EKKO_EKPO ANFNR EKKO Purchasing Document Header MANDT
1 V_EKKO_EKPO ANFNR EKKO Purchasing Document Header EBELN
0 V_EKKO_EKPO ANFPS EKPO Purchasing Document Item MANDT
0 V_EKKO_EKPO ANFPS EKPO Purchasing Document Item EBELN
1 V_EKKO_EKPO BNFPO EBAN Purchase Requisition BANFN
1 V_EKKO_EKPO BNFPO EBAN Purchase Requisition BNFPO
0 V_EKKO_EKPO BPRME T006 Units of Measurement MANDT
1 V_EKKO_EKPO BSART T161 Purchasing Document Types MANDT
0 V_EKKO_EKPO BUKRS T001 Company Codes BUKRS
1 V_EKKO_EKPO BUKRS_K T001 Company Codes BUKRS
0 V_EKKO_EKPO EKGRP T024 Purchasing Groups EKGRP
1 V_EKKO_EKPO EKORG T024E Purchasing Organizations EKORG
0 V_EKKO_EKPO KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
0 V_EKKO_EKPO KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
1 V_EKKO_EKPO LGORT T001L Storage Locations MANDT
1 V_EKKO_EKPO LGORT T001L Storage Locations WERKS
0 V_EKKO_EKPO LIFNR LFA1 Supplier Master (General Section) MANDT
0 V_EKKO_EKPO LIFNR LFA1 Supplier Master (General Section) LIFNR
1 V_EKKO_EKPO LMEIN T006 Units of Measurement MANDT
1 V_EKKO_EKPO LMEIN T006 Units of Measurement MSEHI
0 V_EKKO_EKPO MANDT T000 Clients MANDT
1 V_EKKO_EKPO MATKL T023 Material Groups MATKL
0 V_EKKO_EKPO MEINS T006 Units of Measurement MANDT
0 V_EKKO_EKPO MEINS T006 Units of Measurement MSEHI
1 V_EKKO_EKPO PACKNO ESLH Service Package Header Data PACKNO
0 V_EKKO_EKPO PSTYP T163 Item Categories in Purchasing Document MANDT
0 V_EKKO_EKPO PSTYP T163 Item Categories in Purchasing Document PSTYP
1 V_EKKO_EKPO SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 V_EKKO_EKPO WAERS TCURC Currency Codes MANDT
0 V_EKKO_EKPO WAERS TCURC Currency Codes WAERS
1 V_EKKO_EKPO WERKS T001W Plants/Branches WERKS