EKPO_WEIGHTS

Transparent Table Application Table
14 Fields 1 CDS Views

Purchasing Document Weights

EKPO_WEIGHTS is an SAP database table in S/4HANA. Purchasing Document Weights. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CntrlPurContrItmCmmdtyQty view from BASIC Cntrl Purg Contract Item Commodity Qty

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchasingdocument EBELN Purchasing Doc.
KEY purchasingdocumentitem EBELP Item
KEY commodityquantityseqnumber MMPUR_CMDTYQUAN_SEQNO Cmdty Quantity Seq N
commoditycode MMPUR_CMDTY_CODE Commodity Code
validityenddate KDATE Validity End
validityfromdate KDATB Validity Start
purchasingdocumentcategory BSTYP Doc. Category
commodityquantity MMPUR_CMDTY_QUANTITY Commodity Quantity
commodityquantityunit BSTME Order Unit
peritemquantity EPEIN Price Unit
peritemunit BSTME Order Unit
purgdoccmmdtyupdatecycle MMPUR_CMDT_UPD_CYC_IND Cycle Indicator
commodity TBA_STOEFFCHEN Commodity

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 Weights
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKPO_WEIGHTS (
    MANDT,                       -- Client [MANDT]
    PURCHASINGDOCUMENT,          -- Purchasing Doc. [EBELN]
    PURCHASINGDOCUMENTITEM,      -- Item [EBELP]
    COMMODITYQUANTITYSEQNUMBER,  -- Cmdty Quantity Seq N [MMPUR_CMDTYQUAN_SEQNO]
    COMMODITYCODE,               -- Commodity Code [MMPUR_CMDTY_CODE]
    VALIDITYENDDATE,             -- Validity End [KDATE]
    VALIDITYFROMDATE,            -- Validity Start [KDATB]
    PURCHASINGDOCUMENTCATEGORY,  -- Doc. Category [BSTYP]
    COMMODITYQUANTITY,           -- Commodity Quantity [MMPUR_CMDTY_QUANTITY]
    COMMODITYQUANTITYUNIT,       -- Order Unit [BSTME]
    PERITEMQUANTITY,             -- Price Unit [EPEIN]
    PERITEMUNIT,                 -- Order Unit [BSTME]
    PURGDOCCMMDTYUPDATECYCLE,    -- Cycle Indicator [MMPUR_CMDT_UPD_CYC_IND]
    COMMODITY,                   -- Commodity [TBA_STOEFFCHEN]
    PRIMARY KEY (MANDT, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, COMMODITYQUANTITYSEQNUMBER)
);

Learn More