FINCS_LOG_HEADER

Transparent Table Application Table
33 Fields 10 CDS Views

Consolidation Generic Log Header

FINCS_LOG_HEADER is an SAP database table in S/4HANA. Consolidation Generic Log Header. It contains 33 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
FINCS_LOG_HEADER_OLD view from Old log header enhancement
I_CnsldtnTaskLogHeader view from BASIC Interface for FINCS_LOG_HEADER
I_ConsolidationTaskLog view_entity from BASIC Consolidation Task Log
P_GEN_LOG_HEADER view from BASIC
P_LOG_API_Header view from BASIC
P_LOG_BV_HEADER view_entity from BASIC
P_LOG_CT_Header view from BASIC
P_LOG_DRR_HEADER_BASIC view_entity from BASIC
P_LOG_IJE_Header view from BASIC
P_LOG_RE_Header view from BASIC

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cnsldtnlognumber FINCS_LOGNUMBER Consolidation Log GUID
cnsldtntasktype FC_CACTT Task category
cnsldtndimension FC_DIMEN Dimension
cnsldtngroup FC_CONGR Cons. Group
cnsldtnledger RLDNR Ledger
cnsldtnversion RVERS Version
fiscalyear GJAHR Fiscal Year
fiscalperiod POPER Posting Period
cnsldtntask FC_CACTI Task
cnsldtnmethod FC_CMETH Method
cnsldtndocumenttype FC_DOCTY Document Type
cnsldtnchartofaccounts FC_ITCLG Cons. COA
cnsldtngroupcurrency FINCS_GROUPCURRENCY Group Currency
iscnsldtntestrun FC_TESTRUN Test Run
userid XUBNAME User
cnsldtnlogdate FINCS_LOGDATE Log Date
cnsldtnlogtime FINCS_LOGTIME Log Time
deletion FINCS_DELETE_FALG Deletion Flag
status FINCS_LOGSTATUS Log Status
externalid FINCS_EXTID External Ref. ID
cnsldtnunit FC_BUNIT Cons. Unit
consolidationlogtype FINCS_LOG_TYPE Log Type
update_mode FC_UPDMODE Update mode
is_cumulative FINCS_CUM_INDI Is Cumulative
consolidationlogitemstruc STRUKNAME Structure
timestamp TIMESTAMP Time Stamp
createddatetime TIMESTAMP Time Stamp
applicationjobname BTCJOB Job Name
applicationjobcount BTCJOBCNT Job No.
stepcount BTCSTEPCNT Step no.
logid_timestamp FINCS_TIME_ID Log Compound ID
yearperiod FINCS_FISCALYEARPER Fiscal Year Period

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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_LOG_HEADER (
    MANDT,                      -- Client [MANDT]
    CNSLDTNLOGNUMBER,           -- Consolidation Log GUID [FINCS_LOGNUMBER]
    CNSLDTNTASKTYPE,            -- Task category [FC_CACTT]
    CNSLDTNDIMENSION,           -- Dimension [FC_DIMEN]
    CNSLDTNGROUP,               -- Cons. Group [FC_CONGR]
    CNSLDTNLEDGER,              -- Ledger [RLDNR]
    CNSLDTNVERSION,             -- Version [RVERS]
    FISCALYEAR,                 -- Fiscal Year [GJAHR]
    FISCALPERIOD,               -- Posting Period [POPER]
    CNSLDTNTASK,                -- Task [FC_CACTI]
    CNSLDTNMETHOD,              -- Method [FC_CMETH]
    CNSLDTNDOCUMENTTYPE,        -- Document Type [FC_DOCTY]
    CNSLDTNCHARTOFACCOUNTS,     -- Cons. COA [FC_ITCLG]
    CNSLDTNGROUPCURRENCY,       -- Group Currency [FINCS_GROUPCURRENCY]
    ISCNSLDTNTESTRUN,           -- Test Run [FC_TESTRUN]
    USERID,                     -- User [XUBNAME]
    CNSLDTNLOGDATE,             -- Log Date [FINCS_LOGDATE]
    CNSLDTNLOGTIME,             -- Log Time [FINCS_LOGTIME]
    DELETION,                   -- Deletion Flag [FINCS_DELETE_FALG]
    STATUS,                     -- Log Status [FINCS_LOGSTATUS]
    EXTERNALID,                 -- External Ref. ID [FINCS_EXTID]
    CNSLDTNUNIT,                -- Cons. Unit [FC_BUNIT]
    CONSOLIDATIONLOGTYPE,       -- Log Type [FINCS_LOG_TYPE]
    UPDATE_MODE,                -- Update mode [FC_UPDMODE]
    IS_CUMULATIVE,              -- Is Cumulative [FINCS_CUM_INDI]
    CONSOLIDATIONLOGITEMSTRUC,  -- Structure [STRUKNAME]
    TIMESTAMP,                  -- Time Stamp [TIMESTAMP]
    CREATEDDATETIME,            -- Time Stamp [TIMESTAMP]
    APPLICATIONJOBNAME,         -- Job Name [BTCJOB]
    APPLICATIONJOBCOUNT,        -- Job No. [BTCJOBCNT]
    STEPCOUNT,                  -- Step no. [BTCSTEPCNT]
    LOGID_TIMESTAMP,            -- Log Compound ID [FINCS_TIME_ID]
    YEARPERIOD,                 -- Fiscal Year Period [FINCS_FISCALYEARPER]
    PRIMARY KEY (MANDT, CNSLDTNLOGNUMBER)
);

Learn More