FINCS_ADDLMD

Transparent Table Application Table
7 Fields 3 CDS Views

Additional Master Data

FINCS_ADDLMD is an SAP database table in S/4HANA. Additional Master Data. It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CnsldtnAddlMD view from BASIC Consolidation Additional Master Data
I_CnsldtnAddlMDTP view from TRANSACTIONAL Consolidation Additional Master Data
ICA_P_GR_ADDLMD view from

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cnsldtnaddlmstrdatauuid /BOBF/CONF_KEY NodeID
cnsldtnaddlcharcuuid /BOBF/CONF_KEY NodeID
cnsldtnaddlmdcode FINCS_MD_RECORD_ID Record ID
cnsldtnaddlmdsuprordfldval FINCS_MD_REF_VALUE Suprord. Value
additionalmasterdatacode FINCS_MD_RECORD_ID Record ID
additionalmdsuprordfieldvalue FINCS_MD_REF_VALUE Suprord. Value

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.

-- Additional Master Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_ADDLMD (
    MANDT,                          -- Client [MANDT]
    CNSLDTNADDLMSTRDATAUUID,        -- NodeID [/BOBF/CONF_KEY]
    CNSLDTNADDLCHARCUUID,           -- NodeID [/BOBF/CONF_KEY]
    CNSLDTNADDLMDCODE,              -- Record ID [FINCS_MD_RECORD_ID]
    CNSLDTNADDLMDSUPRORDFLDVAL,     -- Suprord. Value [FINCS_MD_REF_VALUE]
    ADDITIONALMASTERDATACODE,       -- Record ID [FINCS_MD_RECORD_ID]
    ADDITIONALMDSUPRORDFIELDVALUE,  -- Suprord. Value [FINCS_MD_REF_VALUE]
    PRIMARY KEY (MANDT, CNSLDTNADDLMSTRDATAUUID)
);

Learn More