EKBE_MA

Transparent Table Application Table
42 Fields 6 CDS Views

History of Purchasing Document at Account Assignment Level

EKBE_MA is an SAP database table in S/4HANA. History of Purchasing Document at Account Assignment Level. It contains 42 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
M_V_POH_EKBE_MA view from CDS View for PO History Multi Accounting
MMPURORDHISTMATCOST_SDM view from SDM View for EKBE_MA
MMPURORDHISTMATCOST_SDM view union SDM View for EKBE_MA
MMPURORDHISTMATCOSTCURTP view inner Material Costs in MAA PO History on unique CURTP Level
MMPURORDHISTMATCOSTLEDGER view inner Material Costs in MAA PO History on Ledger/CURTP Level
WB2_V_CCS_EKBE_MA_EKKN view from Account Assignment Data for Material Doc

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY zekkn DZEKKN Account Assgmt No.
KEY vgabe VGABE Trans./ev. type
KEY gjahr MJAHR Mat. Doc. Year
KEY belnr MBLNR Material Doc.
KEY buzei MBLPO Mat. Doc.Item
lfgja LFGJA Year Cur.Period
lfbnr LFBNR Reference Doc.
lfpos LFPOS Ref. Doc. Item
packno PACKNO_EKBE Package Number
introw INTROW_EKBE Service line
shkzg SHKZG Debit/Credit
share_f SHARE_F Qty Share AA
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
wrbtr WRBTR_CS Amount
dmbt2 DMBT2 Amount 1st ML Curr.
dmbt3 DMBT3 Amount 2nd ML Curr.
arewr AREWR GR/IR clr.value
areww AREWW GR/IR clr.value
arewb AREWB GR/IR clr.value
arew2 AREW2 GR/IR Clrg Val. MLC1
arew3 AREW3 GR/IR Clrg Val. MLC2
reewr REEWR Invoice Value
refwr REFWR Inv.Value in FC
rewrb REWRB FC invoice amnt
kudif KUDIF Exch.Rate Diff.
kudif2 KUDIF Exch.Rate Diff.
kudif3 KUDIF Exch.Rate Diff.
curtp2 CURTP Crcy type/val.
curtp3 CURTP Crcy type/val.
mwskz MWSKZ Tax Code
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
xunpl XUNPL UAcctAssignment
bekkn BEKKN SeqNo.PO AccAss
_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.

-- History of Purchasing Document at Account Assignment Level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKBE_MA (
    MANDT,        -- Client [MANDT]
    EBELN,        -- Purchasing Doc. [EBELN]
    EBELP,        -- Item [EBELP]
    ZEKKN,        -- Account Assgmt No. [DZEKKN]
    VGABE,        -- Trans./ev. type [VGABE]
    GJAHR,        -- Mat. Doc. Year [MJAHR]
    BELNR,        -- Material Doc. [MBLNR]
    BUZEI,        -- Mat. Doc.Item [MBLPO]
    LFGJA,        -- Year Cur.Period [LFGJA]
    LFBNR,        -- Reference Doc. [LFBNR]
    LFPOS,        -- Ref. Doc. Item [LFPOS]
    PACKNO,       -- Package Number [PACKNO_EKBE]
    INTROW,       -- Service line [INTROW_EKBE]
    SHKZG,        -- Debit/Credit [SHKZG]
    SHARE_F,      -- Qty Share AA [SHARE_F]
    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]
    WRBTR,        -- Amount [WRBTR_CS]
    DMBT2,        -- Amount 1st ML Curr. [DMBT2]
    DMBT3,        -- Amount 2nd ML Curr. [DMBT3]
    AREWR,        -- GR/IR clr.value [AREWR]
    AREWW,        -- GR/IR clr.value [AREWW]
    AREWB,        -- GR/IR clr.value [AREWB]
    AREW2,        -- GR/IR Clrg Val. MLC1 [AREW2]
    AREW3,        -- GR/IR Clrg Val. MLC2 [AREW3]
    REEWR,        -- Invoice Value [REEWR]
    REFWR,        -- Inv.Value in FC [REFWR]
    REWRB,        -- FC invoice amnt [REWRB]
    KUDIF,        -- Exch.Rate Diff. [KUDIF]
    KUDIF2,       -- Exch.Rate Diff. [KUDIF]
    KUDIF3,       -- Exch.Rate Diff. [KUDIF]
    CURTP2,       -- Crcy type/val. [CURTP]
    CURTP3,       -- Crcy type/val. [CURTP]
    MWSKZ,        -- Tax Code [MWSKZ]
    TAX_COUNTRY,  -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    XUNPL,        -- UAcctAssignment [XUNPL]
    BEKKN,        -- SeqNo.PO AccAss [BEKKN]
    _DATAAGING,   -- Data Aging [DATA_TEMPERATURE]
    SDM_VERSION,  -- SDM Versioning [FINS_ML_SDM_VERSION]
    PRIMARY KEY (MANDT, EBELN, EBELP, ZEKKN, VGABE, GJAHR, BELNR, BUZEI)
);

Learn More