FINCS_LOG_MESSAG

Transparent Table Application Table
7 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 7 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 log
P_IJE_LOG_MESSAGE view from BASIC Import Journal Entries Log Message

Fields (7)

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
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]
    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