FINCS_ADDLMD

Transparent Table Application Table
8 Fields 3 CDS Views

Additional Master Data

FINCS_ADDLMD is an SAP database table in S/4HANA. Additional Master Data. It contains 8 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 ICA: Profit Center Master Data for OP

Fields (8)

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
creationdatetime fincs_creationdatetime

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]
    CREATIONDATETIME,               -- fincs_creationdatetime
    PRIMARY KEY (MANDT, CNSLDTNADDLMSTRDATAUUID)
);

Learn More