EKBZ_MA
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA