ACDOCA_M_EXTRACT

Transparent Table Application Table
30 Fields 7 CDS Views

ACDOCA Extract Table for Material Ledger

ACDOCA_M_EXTRACT is an SAP database table in S/4HANA. ACDOCA Extract Table for Material Ledger. It contains 30 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_RO_SAFTMatlInitialValue view from COMPOSITE Initial Value of Stocks RO SAFT
P_ACDOCAMEXTRACT view_entity from BASIC Selection of ACDOCA_M_EXTRACT
P_Matval_Manage_Bal_Split view_entity inner COMPOSITE Base View for Mat.Val., Balances
P_Matval_Manage_Baltab view_entity from BASIC Base View for Mat.Val., Balances
P_MLACDOCAEXTRACT view from BASIC ACDOCA Extract Table for Material Ledger
V_ML_ACDOC_EX_AG_DDL view from Aggregation view for ACDOCA_M_EXTRACT
V_ML_ACDOC_EX_UL_DDL view from Aggr. Ultimo lines for ACDOCA_M_EXTRACT

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt mandt Client
KEY rldnr fins_ledger Ledger
KEY rbukrs bukrs Company Code
KEY kalnr ck_kalnr Cost EstimateNo
KEY fiscyearper jahrper Period/Year
KEY belnr belnr_d Document Number
KEY docln docln6 G/L Line Item
matnr matnr Material
bwkey bwkey Valuation Area
bwtar bwtar_d Valuation Type
ryear gjahr_pos G/L Fiscal Year
poper poper Posting Period
ml_sobkz sobkz Special Stock
ml_kdauf mlmat_kdauf SD Doc of Inv.
ml_kdpos mlmat_kdpos SD Item of Inv.
ml_lifnr mlmat_lifnr Vendor of Inv.
ml_pspnr mlmat_pspnr WBSElem of Inv.
vmsl vquan1_12 Val. quantity
hsl fins_vhcur12 Amnt in Comp Cd Crcy
ksl fins_vkcur12 Amnt in Global Crcy
osl fins_vocur12 Amount in Currency 1
vsl fins_vvcur12 Amount in Currency 2
bsl fins_vbcur12 Amount in Currency 3
csl fins_vccur12 Amount in Currency 4
dsl fins_vdcur12 Amount in Currency 5
esl fins_vecur12 Amount in Currency 6
fsl fins_vfcur12 Amount in Currency 7
gsl fins_vgcur12 Amount in Currency 8
hvkwrt mlhvkwrt Value SP LCrcy
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.

-- ACDOCA Extract Table for Material Ledger
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACDOCA_M_EXTRACT (
    RCLNT,        -- Client [mandt]
    RLDNR,        -- Ledger [fins_ledger]
    RBUKRS,       -- Company Code [bukrs]
    KALNR,        -- Cost EstimateNo [ck_kalnr]
    FISCYEARPER,  -- Period/Year [jahrper]
    BELNR,        -- Document Number [belnr_d]
    DOCLN,        -- G/L Line Item [docln6]
    MATNR,        -- Material [matnr]
    BWKEY,        -- Valuation Area [bwkey]
    BWTAR,        -- Valuation Type [bwtar_d]
    RYEAR,        -- G/L Fiscal Year [gjahr_pos]
    POPER,        -- Posting Period [poper]
    ML_SOBKZ,     -- Special Stock [sobkz]
    ML_KDAUF,     -- SD Doc of Inv. [mlmat_kdauf]
    ML_KDPOS,     -- SD Item of Inv. [mlmat_kdpos]
    ML_LIFNR,     -- Vendor of Inv. [mlmat_lifnr]
    ML_PSPNR,     -- WBSElem of Inv. [mlmat_pspnr]
    VMSL,         -- Val. quantity [vquan1_12]
    HSL,          -- Amnt in Comp Cd Crcy [fins_vhcur12]
    KSL,          -- Amnt in Global Crcy [fins_vkcur12]
    OSL,          -- Amount in Currency 1 [fins_vocur12]
    VSL,          -- Amount in Currency 2 [fins_vvcur12]
    BSL,          -- Amount in Currency 3 [fins_vbcur12]
    CSL,          -- Amount in Currency 4 [fins_vccur12]
    DSL,          -- Amount in Currency 5 [fins_vdcur12]
    ESL,          -- Amount in Currency 6 [fins_vecur12]
    FSL,          -- Amount in Currency 7 [fins_vfcur12]
    GSL,          -- Amount in Currency 8 [fins_vgcur12]
    HVKWRT,       -- Value SP LCrcy [mlhvkwrt]
    SDM_VERSION,  -- SDM Versioning [fins_ml_sdm_version]
    PRIMARY KEY (RCLNT, RLDNR, RBUKRS, KALNR, FISCYEARPER, BELNR, DOCLN)
);

Learn More