EKPO_DISTR

Transparent Table Application Table
81 Fields 7 CDS Views

Purchasing Document Item Distribution

EKPO_DISTR is an SAP database table in S/4HANA. Purchasing Document Item Distribution. It contains 81 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
P_CntrlPurContrAggrDistrSts view union_all BASIC
P_CntrlPurContrDistribution view from BASIC
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 (81)

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
dummy_ekpodistr_incl_eew_ps EKPODISTR_INCL_EEW Ext. Include
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
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
procmthubsubcontractor EMLIF Supplier
procmthubsuplrissubcontractor LBLKZ SC Supplier
referencedeliveryaddressid ADRN2 Address
formofaddress AD_TITLE Title Key
formofaddressname AD_TITLETX Title
procmthubbusinesspartnername1 AD_NAME1 Name
procmthubbusinesspartnername2 AD_NAME2 Name 2
procmthubbusinesspartnername3 AD_NAME3 Name 3
procmthubbusinesspartnername4 AD_NAME4 Name 4
procmthubstreetname AD_STREET Street
procmthubhousenumber AD_HSNM1 House Number
procmthubpostalcode AD_PSTCD1 Postal Code
procmthubcityname AD_CITY1 City
procmthubcountry LAND1 Country/Reg.
procmthubregion REGIO Region
procmthubprdcssrdocuuid MMPUR_PRDCSSRDOC_UUID Predecessor Doc UUID
procmthubprdcssrdocitemuuid MMPUR_PRDCSSRDOC_ITEM_UUID Prdcssr DocItem UUID
procmthubprdcssrdocobjtype BO_OBJECT_TYPE BO Object Type
procmthubprdcssrdocobjnodetype BO_NODE_TYPE SAP Business Object Node Type

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]
    DUMMY_EKPODISTR_INCL_EEW_PS,     -- Ext. Include [EKPODISTR_INCL_EEW]
    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]
    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]
    PROCMTHUBSUBCONTRACTOR,          -- Supplier [EMLIF]
    PROCMTHUBSUPLRISSUBCONTRACTOR,   -- SC Supplier [LBLKZ]
    REFERENCEDELIVERYADDRESSID,      -- Address [ADRN2]
    FORMOFADDRESS,                   -- Title Key [AD_TITLE]
    FORMOFADDRESSNAME,               -- Title [AD_TITLETX]
    PROCMTHUBBUSINESSPARTNERNAME1,   -- Name [AD_NAME1]
    PROCMTHUBBUSINESSPARTNERNAME2,   -- Name 2 [AD_NAME2]
    PROCMTHUBBUSINESSPARTNERNAME3,   -- Name 3 [AD_NAME3]
    PROCMTHUBBUSINESSPARTNERNAME4,   -- Name 4 [AD_NAME4]
    PROCMTHUBSTREETNAME,             -- Street [AD_STREET]
    PROCMTHUBHOUSENUMBER,            -- House Number [AD_HSNM1]
    PROCMTHUBPOSTALCODE,             -- Postal Code [AD_PSTCD1]
    PROCMTHUBCITYNAME,               -- City [AD_CITY1]
    PROCMTHUBCOUNTRY,                -- Country/Reg. [LAND1]
    PROCMTHUBREGION,                 -- Region [REGIO]
    PROCMTHUBPRDCSSRDOCUUID,         -- Predecessor Doc UUID [MMPUR_PRDCSSRDOC_UUID]
    PROCMTHUBPRDCSSRDOCITEMUUID,     -- Prdcssr DocItem UUID [MMPUR_PRDCSSRDOC_ITEM_UUID]
    PROCMTHUBPRDCSSRDOCOBJTYPE,      -- BO Object Type [BO_OBJECT_TYPE]
    PROCMTHUBPRDCSSRDOCOBJNODETYPE,  -- SAP Business Object Node Type [BO_NODE_TYPE]
    PRIMARY KEY (MANDT, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, DISTRIBUTIONNUMBER)
);

Learn More