EKBZ

Transparent Table Application Table
44 Fields 7 CDS Views

History per Purchasing Document: Delivery Costs

EKBZ is an SAP database table in S/4HANA. History per Purchasing Document: Delivery Costs. It contains 44 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
Fclm_Mm_Pohistdcost view from Purchasing Document Delivery Cost
FMLV_EKBEBZ_UCT_UNION view union_all History per Purchasing Document w. External CURTP
M_V_POH_EKBZ view from CDS View for PO History Delivery Costs
MMPURORDHISTDELCOST_SDM view inner SDM View for EKBZ_MA
P_EKBZ view from BASIC
P_PurOrdHistoryDeliveryCost1 view from BASIC
R_PurgDocHistDeliveryCostBsc view from BASIC History per Purchasing Delivery Cost

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY stunr STUNR Step Number
KEY zaehk DZAEHK Counter
KEY vgabe VGABE Trans./ev. type
KEY gjahr GJAHR Fiscal Year
KEY belnr BELNR_D Document Number
KEY buzei MBLPO Mat. Doc.Item
bewtp BEWTP PO History Cat.
budat BUDAT Posting Date
menge MENGE_D Quantity
dmbtr DMBTR_CS Amount in LC
wrbtr WRBTR_CS Amount
waers WAERS Currency
arewr AREWR GR/IR clr.value
shkzg SHKZG Debit/Credit
xblnr XBLNR1 Reference
frbnr FRBNR1 Bill of Lading
lifnr LIFNR Supplier
cpudt CPUDT Entered On
cputm CPUTM Entered at
reewr REEWR Invoice Value
refwr REFWR Inv.Value in FC
bwtar BWTAR_D Valuation Type
kschl KSCHL Condition Type
bpmng BPMNG Qty in OPUn
areww AREWW GR/IR clr.value
hswae HSWAE Local currency
vnetw VNETWR Net value
ernam ERNAM Created By
shkko SHKZG Debit/Credit
arewb AREWB GR/IR clr.value
rewrb REWRB FC invoice amnt
saprl SAPRL SAP Release
menge_pop MENGE_D Quantity
dmbtr_pop DMBTR_CS Amount in LC
wrbtr_pop WRBTR_CS Amount
bpmng_pop BPMNG Qty in OPUn
arewr_pop AREWR GR/IR clr.value
kudif KUDIF Exch.Rate Diff.
xmacc XMACC Multi Acct Assgt
wkurs WKURS Exchange Rate
_dataaging DATA_TEMPERATURE Data Aging

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.

-- History per Purchasing Document: Delivery Costs
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKBZ (
    MANDT,       -- Client [MANDT]
    EBELN,       -- Purchasing Doc. [EBELN]
    EBELP,       -- Item [EBELP]
    STUNR,       -- Step Number [STUNR]
    ZAEHK,       -- Counter [DZAEHK]
    VGABE,       -- Trans./ev. type [VGABE]
    GJAHR,       -- Fiscal Year [GJAHR]
    BELNR,       -- Document Number [BELNR_D]
    BUZEI,       -- Mat. Doc.Item [MBLPO]
    BEWTP,       -- PO History Cat. [BEWTP]
    BUDAT,       -- Posting Date [BUDAT]
    MENGE,       -- Quantity [MENGE_D]
    DMBTR,       -- Amount in LC [DMBTR_CS]
    WRBTR,       -- Amount [WRBTR_CS]
    WAERS,       -- Currency [WAERS]
    AREWR,       -- GR/IR clr.value [AREWR]
    SHKZG,       -- Debit/Credit [SHKZG]
    XBLNR,       -- Reference [XBLNR1]
    FRBNR,       -- Bill of Lading [FRBNR1]
    LIFNR,       -- Supplier [LIFNR]
    CPUDT,       -- Entered On [CPUDT]
    CPUTM,       -- Entered at [CPUTM]
    REEWR,       -- Invoice Value [REEWR]
    REFWR,       -- Inv.Value in FC [REFWR]
    BWTAR,       -- Valuation Type [BWTAR_D]
    KSCHL,       -- Condition Type [KSCHL]
    BPMNG,       -- Qty in OPUn [BPMNG]
    AREWW,       -- GR/IR clr.value [AREWW]
    HSWAE,       -- Local currency [HSWAE]
    VNETW,       -- Net value [VNETWR]
    ERNAM,       -- Created By [ERNAM]
    SHKKO,       -- Debit/Credit [SHKZG]
    AREWB,       -- GR/IR clr.value [AREWB]
    REWRB,       -- FC invoice amnt [REWRB]
    SAPRL,       -- SAP Release [SAPRL]
    MENGE_POP,   -- Quantity [MENGE_D]
    DMBTR_POP,   -- Amount in LC [DMBTR_CS]
    WRBTR_POP,   -- Amount [WRBTR_CS]
    BPMNG_POP,   -- Qty in OPUn [BPMNG]
    AREWR_POP,   -- GR/IR clr.value [AREWR]
    KUDIF,       -- Exch.Rate Diff. [KUDIF]
    XMACC,       -- Multi Acct Assgt [XMACC]
    WKURS,       -- Exchange Rate [WKURS]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, EBELN, EBELP, STUNR, ZAEHK, VGABE, GJAHR, BELNR, BUZEI)
);

Learn More