MLDOCUCB_EXTRACT

Transparent Table Application Table
15 Fields 1 CDS Views

Extract of ML Document Universal Component Breakdown

MLDOCUCB_EXTRACT is an SAP database table in S/4HANA. Extract of ML Document Universal Component Breakdown. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
MLDOC_UCB_EXTRACT view_entity union_all MLDOC with joined UCB all records

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kalnr ck_kalnr Cost EstimateNo
KEY jahrper ml4h_jahrper Year / Period
KEY docref ml4h_docref Document Reference
KEY curtp fins_ext_curtype Crcy Type/Valn View
KEY ucb_method fucb_method Breakdown Method
KEY ucb_component fucb_component Breakdown Component
KEY svrel ml4h_svrel Relev. f. Stock Val.
rldnr fins_ledger Ledger
waers waers Currency
quantity_unit fucb_quantity_unit Qty. Unit of Measure
tot ml4h_total Total Value
fix ml4h_fix Fixed Value
quant_tot fucb_quantity Quantity
quant_fix fucb_fixed_quantity Fixed Quantity

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.

-- Extract of ML Document Universal Component Breakdown
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLDOCUCB_EXTRACT (
    MANDT,          -- Client [mandt]
    KALNR,          -- Cost EstimateNo [ck_kalnr]
    JAHRPER,        -- Year / Period [ml4h_jahrper]
    DOCREF,         -- Document Reference [ml4h_docref]
    CURTP,          -- Crcy Type/Valn View [fins_ext_curtype]
    UCB_METHOD,     -- Breakdown Method [fucb_method]
    UCB_COMPONENT,  -- Breakdown Component [fucb_component]
    SVREL,          -- Relev. f. Stock Val. [ml4h_svrel]
    RLDNR,          -- Ledger [fins_ledger]
    WAERS,          -- Currency [waers]
    QUANTITY_UNIT,  -- Qty. Unit of Measure [fucb_quantity_unit]
    TOT,            -- Total Value [ml4h_total]
    FIX,            -- Fixed Value [ml4h_fix]
    QUANT_TOT,      -- Quantity [fucb_quantity]
    QUANT_FIX,      -- Fixed Quantity [fucb_fixed_quantity]
    PRIMARY KEY (MANDT, KALNR, JAHRPER, DOCREF, CURTP, UCB_METHOD, UCB_COMPONENT, SVREL)
);

Learn More