EKPO

Transparent Table Application Table
6 Fields 118 CDS Views

Purchasing Document Item

EKPO is an SAP database table in S/4HANA. Purchasing Document Item. It contains 6 fields. 118 CDS views read from this table.

CDS Views using this table (118)

ViewTypeJoinVDMDescription
Arun_Conf_Lines view inner Supply Assignment confirmations
arun_i_sl_sto_sel view inner STO selection at Date level
Arun_I_Sto_1 view from STO Item level Data selection
arun_i_sto_item view from STO Item level Data selection
Arun_Purchord_Aggr view inner Supply Assignment PO aggregate
Arun_Reqsrt_Mm view inner Requirement sorting - MM
ARUN_SCH_LINES view from Purchase Order Schedule Line Data
Arun_Spo_Reqmt view from Subcontracting PO Requirement
Arun_Sto_Req1 view from STO Requirement - Initial join
ARUN_STO_REQMT_SL view inner STO selection at Date level
ARun_ValAddedSrvcSTOItmBsc view inner P_ARunValAddedSrvcSTOItmBsc
ARUNI_CONF_LINE view inner Confirmations selection at date level
aruni_po_line view inner PO selection at date level
aruni_sto_line view inner PO selection at date level
ARUNI_STO_LINE_STK view inner STO as stock
Atpc_Cds_Eket_1 view left_outer Helper CDS View on EKET Table for ATP
ATPC_CDS_PREDECESSOR view inner Predecessor documents
Atpc_Cds_Sto_10 view left_outer Helper CDS view for STOs in ATP BOP
c_purdoclistflndocbase view from CONSUMPTION Follow on Document Base
c_purdoclistfollowonindicator view from CONSUMPTION Follow-on Document for Purchasing Documents
C_PurOrdItemQty view_entity from Purchase Order Item Quantity
e_mrp_purchase_docs view inner Fiori MRP App Purchase Documents CDS View
e_mrp_stocktransfer_demands view inner Fiori MRP App Stock Transfer Demands CDS View
E_PurchaseContractItem view from EXTENSION Extension for Purchase Contract Item
E_PurchasingDocumentItem view from EXTENSION Extension view for Purchasing Document Item
FAC_PURCHASE_ORDER view inner Purchase Order
Fclm_Mm_Ekpo view from Purchasing Document Item
Fclm_Mmdelta_Ekpo view from EKPO related to Delta table
Fclm_Mmekpo_Pre1 view from Preselection on EKPO
FINOC_RT_POI_MONTHS view from Orgl Chg: Purchg Doc Chg Dt Plus Months
fsh_ddl_tpo_1 view from TPO Level 1
I_AlignPurchaseOrderItem view from BASIC Fashion fields in Purchase Order
I_ARunMntrItemSTO view from BASIC Basic View for Stock Transport Orders in ARun Monitor Runs
I_ARunOvwSTOItem view from BASIC Basic View for Stock Transport Order Item
I_ARunPrioritySTOBasic view from BASIC Base View for ARun Priority in STOs
I_ARunSTOItem view inner BASIC ARun relevant Stock Transport Item
I_ChgImpactPurDocAcctAssign view inner BASIC Purchase Order acccount assignment details
I_DemandDrivenPurDocItem view from BASIC Demand Driven Purchasing Document Item
I_DigitalVehPurOrdConfign view_entity from BASIC Digital Vehicle Purchase Order
I_ExcessRqmtQtySTOMainItm view from BASIC Stock Transport Order Main(Non Value Added Service) Items
I_FldLogsPurchasingDocItem view from BASIC Field Logistics Purchase Orders
I_FldLogsRefPurchasingDoc view inner BASIC FL - Ref Purchasing Doc value help
I_MRPOutlineAgreement view inner BASIC Basic Outline Agreement SOS
I_PurchasingDocItemRqmtSgmt view from BASIC Purchasing Document Item Requirement Segment for VH
I_PurchasingDocumentItem view from BASIC Purchasing Document Item
I_PurchasingDocumentItemSgmt view from BASIC Purchasing Document Item Segment for VH
I_ScheduleAgreementExists view inner BASIC View for MRPCov to check if SchedAgmnt for a Material exists
I_SupDmndAllDocConfBsc view inner BASIC Basic View for Supplier Confirmations
I_SupDmndAllDocPOBsc view inner BASIC Basic View for Purchase Order
I_SupDmndAllDocPurgContr view inner BASIC View for Purchasing Contract
I_SupDmndAllDocRetsSup view inner BASIC View for Returns from PO/STO
I_SupDmndAllDocSTOItmBsc view inner BASIC Basic View for Stock Transport Order
I_SupDmndOvwItemPO view inner BASIC Basic View for Purchase Orders
I_SupDmndOvwItemSTO view inner BASIC Basic View for STO Item
m_v_ct_itm_status view from CDS View for Pur.Contract Item Status
m_v_m2s_pd_fd view from CDS View for follow on indicator
m_v_m2s_pd_fd_b view from CDS View for follow on indicator - base
m_v_m2s_pd_h_c view from CDS for calc. fields of Pur.Doc.Header
m_v_m2s_pd_i_c view from ME2STAR: CDS View for calculated fields of Pur. Doc. Item
m_v_m2s_pd_itm view from View for Purchasing Document Item
m_v_m2s_pd_qm_b2 view inner ME2STAR: CDS View for quantity mismatch
m_v_m2s_poiv_vm view from CDS View for EKBE to EKPO value mismatch
m_v_outline_agreement_sos view inner MM-PUR: CDS View for SOS
M_V_Outline_Agreement_Sos_B view inner MM-PUR: Basic CDS View for SOS
m_v_pd_itm_status view from CDS View for Pur. Document Item Status
M_V_PHL_EKBE view inner CDS View for PO History Light
m_v_po_itm_status view from CDS View for Purchase Order Item Status
M_V_POH_EKBE_MA view inner CDS View for PO History Multi Accounting
M_V_POH_EKBZ view right_outer CDS View for PO History Delivery Costs
M_V_POH_EKBZ_MA view inner CDS View for PO History Del. Costs - MAA
m_v_sa_itm_status view from CDS View for Sched. Agr. Item Status
mmpurpo_ctr_itm_from_limit view_entity inner CtrItms as ref.for POItms type enh lmt
P_CmmdtyPrcFixationExerPurg view inner BASIC Basic View Price Fixation Exercises Purchasing
P_CmmdtyPrcFixationExerPurgNew view_entity inner COMPOSITE Private View Price Fixation Exercise (sCPE) Purchasing
P_CmmdtyPrcFixationOptionPurg view inner BASIC Basic View Price Fixation Option Purchasing
P_CmmdtyPrcFixationOptnPurgNew view_entity inner COMPOSITE Private View Price Fixation Option (sCPE) Purchasing
P_MLCtrProposalPOItem view from BASIC Purchase Order Items for Contract Proposal ML
P_MLCtrProposalPurCtrItem view from BASIC Purchase Contract Items for Contract Proposal ML
P_PrcFixationOptionBsHndlgPurg view inner BASIC Basic View Price Fixation Option Basis Handling Purchasing
P_PrcFixationOptionCnvrsnPurg view inner BASIC Basic View Price Fixation Option Conversion Purchasing
P_PrcFixationOptnCnvrsnPurgNew view_entity inner COMPOSITE Price Fixation Option Conversion (sCPE) Purchasing
P_PrcSttgMethExecutionAnalysis view left_outer BASIC Price Setting Method Execution Analysis
P_PrFixationOptnBsHndlgPurgNew view_entity inner COMPOSITE Price Fixation Option Basis Handling (sCPE) Purchasing
P_PurchasingDocumentItem view from COMPOSITE Purchasing Document Item
P_PurOrdMaintainItemActAddr view from CONSUMPTION PO Maintenance: Purchase Order Item Address (Active)
P_RFQBidderProposal view inner BASIC RFQ Bidder Proposal
P_SupDmndAllDocMatlDocSDBsc view inner BASIC Basic View for Material Documents with Sales Order
P_SupDmndAllDocSTODate view inner BASIC View for Stock Transport Order Date/Quantity Calculation
P_SupDmndOvwSTODateBasic view inner BASIC SD Item For Supply Demand Overview
P_VarConfignPurchasingDocItem view from BASIC Simulation - Purchasing Document Item private view
pph_e_Mdbs_1 view from read MDBS
PPH_E_MDBS_SL view from read MDBS zero schedule lines
pph_e_Mdla_1 view from read MDLA
PPH_E_MDRELA_1 view inner read MDRELA
PPH_E_MDUB_0 view inner read MDUB
pph_e_Mdub_1 view inner read MDUB
pph_mrp_purch_doc_basic view inner Basic View für Purchasing Documents
PRODCMPLNCLICRLVTPURGDOC view from License Relevant Purchase Order Items
PurgDocItem view from Proxy for Purchasig Document Item (EKPO)
R_PurchasingDocumentItem view_entity from BASIC Purchasing Document Item
rfm_mm_seasons_basic_view view inner RFM Stock Transport Seasons Basic View
rfm_psst_sto_assign view inner Assignment Monitor STO view
rfm_scc_sto_sea_assign view from RFM Season Complete Check STO Assignment
rfm_scc_stocktransfer_basic_V view inner Get Stock Transfer order details
rrp_e_GiPo view inner RRP: Select Purchase Orders as Goods Issues
rrp_e_GrOc view inner RRP: Retrieve Open Order Confirmation Quantities
rrp_e_GrPo view inner RRP: Select Purchase Orders as Goods Receipts
SHSM_EKPO view from CDS View for EKPO search help
V_Mmim_Ddl_Om_Or_Grmail view inner Output Management GR Mail
V_WB2_EKKO_EKPO_1 view inner Business Volume from Purchase Order
V_WB2_EKKO_EKPO_2 view inner Business Volume Purchase Orders - EKKN
V_WB2_MKPF_MSEG_1 view inner Business Volume from Goods Receipt
V_WB2_MKPF_MSEG_2 view inner Business Volume from Goods Receipt -EKKN
V_WB2_RBKP_RSEG_1 view inner Business Volume from Supplier Invoice
V_WB2_RBKP_RSEG_2 view inner Business Volume from Supplier Invoice (online and batch)
V_WB2_RBKP_RSEG_3 view inner Business Volume Supplier Invoice -RBCO
view_PO_items_p view from Item Related Data of a Purchase Order
view_po_lts view from Supplier Subrange of a Purchase Order Item

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ebeln ebeln Purchasing Doc.
KEY ebelp ebelp Item
uniqueid purchasingdocumentitemuniqueid Document Item
refsite wrefsite Purchasing Ref. Site
pfmtransdatafootprintuuid pfmtransdatafootprintuuid Transaction Data Footprint

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Purchasing Document Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKPO (
    MANDT,                      -- Client [mandt]
    EBELN,                      -- Purchasing Doc. [ebeln]
    EBELP,                      -- Item [ebelp]
    UNIQUEID,                   -- Document Item [purchasingdocumentitemuniqueid]
    REFSITE,                    -- Purchasing Ref. Site [wrefsite]
    PFMTRANSDATAFOOTPRINTUUID,  -- Transaction Data Footprint [pfmtransdatafootprintuuid]
    PRIMARY KEY (MANDT, EBELN, EBELP)
);

Learn More