FINCS_LOG_MESSAG

Transparent Table Application Table
14 Fields 5 CDS Views

Consolidation Generic Log Message

FINCS_LOG_MESSAG is an SAP database table in S/4HANA. Consolidation Generic Log Message. It contains 14 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CnsldtnInputTskLgItemMsg view from BASIC View for fincslogitem01 & fincslogmessag
I_CnsldtnRecnclnTskLgMsg view_entity from BASIC Reconciliation Message
I_ConsolidationTaskLogMessage view_entity from BASIC Consolidation Task Log Message
P_GEN_MESSAGE_DETAIL view from BASIC
P_IJE_LOG_MESSAGE view from BASIC

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cnsldtnlognumber FINCS_LOGNUMBER Consolidation Log GUID
KEY cnsldtnlogitemnumber FINCS_LOGITEMNUMBER Consolidation Log Item Number GUID
KEY cnsldtnlogmessageno FINCS_LOGMESSAGENO Consolidation Log Message Number
msgid SYST_MSGID Message ID
msgty FINCS_MSG_TYPE Message Type
msgno SYST_MSGNO Message Number
msgv1 SYST_MSGV Message Variable
msgv2 SYST_MSGV Message Variable
msgv3 SYST_MSGV Message Variable
msgv4 SYST_MSGV Message Variable
latest_indi FINCS_LATESTINDI Latest Record Indicator
logdate FICNS_TIMESTAMP Date
externalid FINCS_EXTID External Ref. ID

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.

-- Consolidation Generic Log Message
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_LOG_MESSAG (
    MANDT,                 -- Client [MANDT]
    CNSLDTNLOGNUMBER,      -- Consolidation Log GUID [FINCS_LOGNUMBER]
    CNSLDTNLOGITEMNUMBER,  -- Consolidation Log Item Number GUID [FINCS_LOGITEMNUMBER]
    CNSLDTNLOGMESSAGENO,   -- Consolidation Log Message Number [FINCS_LOGMESSAGENO]
    MSGID,                 -- Message ID [SYST_MSGID]
    MSGTY,                 -- Message Type [FINCS_MSG_TYPE]
    MSGNO,                 -- Message Number [SYST_MSGNO]
    MSGV1,                 -- Message Variable [SYST_MSGV]
    MSGV2,                 -- Message Variable [SYST_MSGV]
    MSGV3,                 -- Message Variable [SYST_MSGV]
    MSGV4,                 -- Message Variable [SYST_MSGV]
    LATEST_INDI,           -- Latest Record Indicator [FINCS_LATESTINDI]
    LOGDATE,               -- Date [FICNS_TIMESTAMP]
    EXTERNALID,            -- External Ref. ID [FINCS_EXTID]
    PRIMARY KEY (MANDT, CNSLDTNLOGNUMBER, CNSLDTNLOGITEMNUMBER, CNSLDTNLOGMESSAGENO)
);

Learn More