EKBZ_MA

Transparent Table Application Table

Delivery Costs at Account Assignment Level

EKBZ_MA is an SAP database table in S/4HANA. Delivery Costs at Account Assignment Level. It contains 38 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
M_V_POH_EKBZ_MA view from CDS View for PO History Del. Costs - MAA
MMPURORDHISTDELCOST_SDM view from SDM View for EKBZ_MA
MMPURORDHISTDELCOST_SDM view union SDM View for EKBZ_MA
MMPURORDHISTDELCOSTLEDGER view inner Delivery Costs in MAA PO History on Ledger/CURTP Level

Fields (38)

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
KEY zekkn DZEKKN Account Assgmt No.
share_f SHARE_F Qty Share AA
xunpl XUNPL UAcctAssignment
shkzg SHKZG Debit/Credit
menge_f MENGE_F Qty (FP Number)
bpmng_f MENGE_F Qty (FP Number)
menge MENGE_D Quantity
bpmng MENGE_BPR Qty. in OPUn
dmbtr DMBTR_CS Amount in LC
arewr AREWR GR/IR clr.value
reewr REEWR Invoice Value
wrbtr WRBTR_CS Amount
areww AREWW GR/IR clr.value
refwr REFWR Inv.Value in FC
arewb AREWB GR/IR clr.value
rewrb REWRB FC invoice amnt
kudif KUDIF Exch.Rate Diff.
curtp2 CURTP Crcy type/val.
waers2 WAERS Currency
dmbt2 DMBT2 Amount 1st ML Curr.
arew2 AREW2 GR/IR Clrg Val. MLC1
kudif2 KUDIF Exch.Rate Diff.
curtp3 CURTP Crcy type/val.
waers3 WAERS Currency
dmbt3 DMBT3 Amount 2nd ML Curr.
arew3 AREW3 GR/IR Clrg Val. MLC2
kudif3 KUDIF Exch.Rate Diff.
_dataaging DATA_TEMPERATURE Data Aging
sdm_version FINS_ML_SDM_VERSION SDM Versioning

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.

-- Delivery Costs at Account Assignment Level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKBZ_MA (
    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]
    ZEKKN,        -- Account Assgmt No. [DZEKKN]
    SHARE_F,      -- Qty Share AA [SHARE_F]
    XUNPL,        -- UAcctAssignment [XUNPL]
    SHKZG,        -- Debit/Credit [SHKZG]
    MENGE_F,      -- Qty (FP Number) [MENGE_F]
    BPMNG_F,      -- Qty (FP Number) [MENGE_F]
    MENGE,        -- Quantity [MENGE_D]
    BPMNG,        -- Qty. in OPUn [MENGE_BPR]
    DMBTR,        -- Amount in LC [DMBTR_CS]
    AREWR,        -- GR/IR clr.value [AREWR]
    REEWR,        -- Invoice Value [REEWR]
    WRBTR,        -- Amount [WRBTR_CS]
    AREWW,        -- GR/IR clr.value [AREWW]
    REFWR,        -- Inv.Value in FC [REFWR]
    AREWB,        -- GR/IR clr.value [AREWB]
    REWRB,        -- FC invoice amnt [REWRB]
    KUDIF,        -- Exch.Rate Diff. [KUDIF]
    CURTP2,       -- Crcy type/val. [CURTP]
    WAERS2,       -- Currency [WAERS]
    DMBT2,        -- Amount 1st ML Curr. [DMBT2]
    AREW2,        -- GR/IR Clrg Val. MLC1 [AREW2]
    KUDIF2,       -- Exch.Rate Diff. [KUDIF]
    CURTP3,       -- Crcy type/val. [CURTP]
    WAERS3,       -- Currency [WAERS]
    DMBT3,        -- Amount 2nd ML Curr. [DMBT3]
    AREW3,        -- GR/IR Clrg Val. MLC2 [AREW3]
    KUDIF3,       -- Exch.Rate Diff. [KUDIF]
    _DATAAGING,   -- Data Aging [DATA_TEMPERATURE]
    SDM_VERSION,  -- SDM Versioning [FINS_ML_SDM_VERSION]
    PRIMARY KEY (MANDT, EBELN, EBELP, STUNR, ZAEHK, VGABE, GJAHR, BELNR, BUZEI, ZEKKN)
);