EKPO_DISTR

Transparent Table Application Table
62 Fields 7 CDS Views

Purchasing Document Item Distribution

EKPO_DISTR is an SAP database table in S/4HANA. Purchasing Document Item Distribution. It contains 62 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
E_CntrlPurContrDistribution view from EXTENSION Extesnion View for Central Contract Distribution
P_CntrlPurContrAggrDistrSts view from BASIC Aggreate Overall Distribution Status of CCTR in Hub
P_CntrlPurContrAggrDistrSts view union BASIC Aggreate Overall Distribution Status of CCTR in Hub
P_CntrlPurContrDistribution view from BASIC Basic View for Central Contract Distribution
R_CentralRFQItemDistribution view from BASIC Restricted View for Central RFQ Item Distribution
R_CntrlPurContrDistribution view from BASIC Central Purchase Contract Distriution
R_CntrlSuplrQuotationItemDistr view from BASIC Central Supplier Qtan Item Distribution

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchasingdocument ebeln Purchasing Doc.
KEY purchasingdocumentitem ebelp Item
KEY distributionnumber mm_purgdoc_distr_num Distr. Number
referencedhdrdistrnumber mm_purgdoc_distr_num Distr. Number
purchasingdocumentcategory bstyp Doc. Category
purchasingdocumenttype esart Document Type
purchasingorganization ekorg Purchasing Org.
companycode bukrs Company Code
plant ewerk Plant
logicalsystem logsystem Logical System
documentcurrency waers Currency
purchasinggroup bkgrp Purch. Group
storagelocation lgort_d Location
paymentterms farp_dzterm Payment Terms
cashdiscount1days dzbd1t Days 1
cashdiscount2days dzbd2t Days 2
netpaymentdays dzbd3t Days Net
cashdiscount1percent dzbd1p CD Percentage 1
cashdiscount2percent dzbd2p CD Percentage 2
material matnr Material
materialgroup matkl Material Group
purchasingdocumentdistrpct mm_purgdoc_distr_pct Distribution %
targetquantity ktmng Target Quantity
targetvalue ktwrt Target Value
extcontractforpurg mm_pur_hub_konnr Contract
extcontractitemforpurg mm_pur_hub_ktpnr Contract Item
extcontractitemdistrforpurg mm_purgdoc_distr_num Distr. Number
extcontractitemdistrstatus me_distribution_status Distribution Status
responsemessageguid guid16 GUID
isdeleted mmpur_itemdistr_deleted Deltn Indicator
orderquantityunit bstme Order Unit
distributiontype mm_pur_cctr_itm_dist_type Distribution Type
resp_recd_at mmpur_utc Timestamp
itemdistributionisrelevant mmpur_itemdistr_relevant Is Relevant
isitemdistributionblocked mmpur_itemdistr_blocked Block Item Distr
manualdeliveryaddressid ad_addrnum Address Number
deliveryaddresstype mm_purgdoc_deliv_addr_type Delivery Addr. Type
distributionlevel mm_purgdoc_distr_node_type Distr. Level
procurementhubsourcesystem mmpur_d_source_sys Connected System ID
externalreferencedocument vgbel_ex Ext. Ref. Document
externalreferencedocumentitem vgpos_ex Ext. Ref. Doc. Item
externalrefdoccategory vgtyp_ex Category
purchasinginforecordupdatecode spinf InfoUpdate
procmthubpredecessordocument mm_pur_hub_ebeln Prdcssr Doc Num
procmthubpredecessordocitem mm_pur_hub_ebelp Prdcssr Doc Itm
procmthubpredecessordoccat mm_pur_hub_ebstyp Prdcssr Doc Categ
procmthubpurchaserequisition banfn Purchase Req.
procmthubpurrequisitionitem bnfpo Requisn. item
purreqnreleasestatus banpr Proc.state
sourcelistisupdated mmpur_sourcelistisupdated Sourcelist Updated
sourcelistrestriction srcelistrstrcn SrcListRstrcn
mrpsourcingcontrol autet MRP
srcelistresponsemsguuid guid16 GUID
sourcelistchangeconfstatus srcelistchangestatus Src. Lst Change Sta.
procmthubcompanycodegroupingid mmpur_d_cc_grouping_id Grouping ID
outlineagrmtitmisblocked mmpur_oa_blocked OA Blocked Ind
purgdocitmblkrsncode mmpur_blk_rsn_code Block Reason Code
incotermsclassification inco1 Incoterms
incotermslocation1 inco2_l Inco. Location1
shippinginstruction evers Shipping Instr.
cntrlpurcontrdistrtrggrdtetime mmpur_cctr_dstr_trg_dtetme Distr Trggr Time

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 Distribution
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKPO_DISTR (
    MANDT,                           -- Client [mandt]
    PURCHASINGDOCUMENT,              -- Purchasing Doc. [ebeln]
    PURCHASINGDOCUMENTITEM,          -- Item [ebelp]
    DISTRIBUTIONNUMBER,              -- Distr. Number [mm_purgdoc_distr_num]
    REFERENCEDHDRDISTRNUMBER,        -- Distr. Number [mm_purgdoc_distr_num]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [bstyp]
    PURCHASINGDOCUMENTTYPE,          -- Document Type [esart]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    COMPANYCODE,                     -- Company Code [bukrs]
    PLANT,                           -- Plant [ewerk]
    LOGICALSYSTEM,                   -- Logical System [logsystem]
    DOCUMENTCURRENCY,                -- Currency [waers]
    PURCHASINGGROUP,                 -- Purch. Group [bkgrp]
    STORAGELOCATION,                 -- Location [lgort_d]
    PAYMENTTERMS,                    -- Payment Terms [farp_dzterm]
    CASHDISCOUNT1DAYS,               -- Days 1 [dzbd1t]
    CASHDISCOUNT2DAYS,               -- Days 2 [dzbd2t]
    NETPAYMENTDAYS,                  -- Days Net [dzbd3t]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [dzbd1p]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [dzbd2p]
    MATERIAL,                        -- Material [matnr]
    MATERIALGROUP,                   -- Material Group [matkl]
    PURCHASINGDOCUMENTDISTRPCT,      -- Distribution % [mm_purgdoc_distr_pct]
    TARGETQUANTITY,                  -- Target Quantity [ktmng]
    TARGETVALUE,                     -- Target Value [ktwrt]
    EXTCONTRACTFORPURG,              -- Contract [mm_pur_hub_konnr]
    EXTCONTRACTITEMFORPURG,          -- Contract Item [mm_pur_hub_ktpnr]
    EXTCONTRACTITEMDISTRFORPURG,     -- Distr. Number [mm_purgdoc_distr_num]
    EXTCONTRACTITEMDISTRSTATUS,      -- Distribution Status [me_distribution_status]
    RESPONSEMESSAGEGUID,             -- GUID [guid16]
    ISDELETED,                       -- Deltn Indicator [mmpur_itemdistr_deleted]
    ORDERQUANTITYUNIT,               -- Order Unit [bstme]
    DISTRIBUTIONTYPE,                -- Distribution Type [mm_pur_cctr_itm_dist_type]
    RESP_RECD_AT,                    -- Timestamp [mmpur_utc]
    ITEMDISTRIBUTIONISRELEVANT,      -- Is Relevant [mmpur_itemdistr_relevant]
    ISITEMDISTRIBUTIONBLOCKED,       -- Block Item Distr [mmpur_itemdistr_blocked]
    MANUALDELIVERYADDRESSID,         -- Address Number [ad_addrnum]
    DELIVERYADDRESSTYPE,             -- Delivery Addr. Type [mm_purgdoc_deliv_addr_type]
    DISTRIBUTIONLEVEL,               -- Distr. Level [mm_purgdoc_distr_node_type]
    PROCUREMENTHUBSOURCESYSTEM,      -- Connected System ID [mmpur_d_source_sys]
    EXTERNALREFERENCEDOCUMENT,       -- Ext. Ref. Document [vgbel_ex]
    EXTERNALREFERENCEDOCUMENTITEM,   -- Ext. Ref. Doc. Item [vgpos_ex]
    EXTERNALREFDOCCATEGORY,          -- Category [vgtyp_ex]
    PURCHASINGINFORECORDUPDATECODE,  -- InfoUpdate [spinf]
    PROCMTHUBPREDECESSORDOCUMENT,    -- Prdcssr Doc Num [mm_pur_hub_ebeln]
    PROCMTHUBPREDECESSORDOCITEM,     -- Prdcssr Doc Itm [mm_pur_hub_ebelp]
    PROCMTHUBPREDECESSORDOCCAT,      -- Prdcssr Doc Categ [mm_pur_hub_ebstyp]
    PROCMTHUBPURCHASEREQUISITION,    -- Purchase Req. [banfn]
    PROCMTHUBPURREQUISITIONITEM,     -- Requisn. item [bnfpo]
    PURREQNRELEASESTATUS,            -- Proc.state [banpr]
    SOURCELISTISUPDATED,             -- Sourcelist Updated [mmpur_sourcelistisupdated]
    SOURCELISTRESTRICTION,           -- SrcListRstrcn [srcelistrstrcn]
    MRPSOURCINGCONTROL,              -- MRP [autet]
    SRCELISTRESPONSEMSGUUID,         -- GUID [guid16]
    SOURCELISTCHANGECONFSTATUS,      -- Src. Lst Change Sta. [srcelistchangestatus]
    PROCMTHUBCOMPANYCODEGROUPINGID,  -- Grouping ID [mmpur_d_cc_grouping_id]
    OUTLINEAGRMTITMISBLOCKED,        -- OA Blocked Ind [mmpur_oa_blocked]
    PURGDOCITMBLKRSNCODE,            -- Block Reason Code [mmpur_blk_rsn_code]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    INCOTERMSLOCATION1,              -- Inco. Location1 [inco2_l]
    SHIPPINGINSTRUCTION,             -- Shipping Instr. [evers]
    CNTRLPURCONTRDISTRTRGGRDTETIME,  -- Distr Trggr Time [mmpur_cctr_dstr_trg_dtetme]
    PRIMARY KEY (MANDT, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, DISTRIBUTIONNUMBER)
);

Learn More