FINCS_LOG_ITEM

Transparent Table Application Table
85 Fields 7 CDS Views

Consolidation Generic Log Item

FINCS_LOG_ITEM is an SAP database table in S/4HANA. Consolidation Generic Log Item. It contains 85 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
E_CnsldtnTaskLogItem view_entity from EXTENSION Extension view for jour. entry task log
I_CnsldtnTaskLogItem view from BASIC Interface for FINCS_LOG_ITEM
I_CnsldtnTskLogItemDataProcess view_entity from BASIC Consolidation Task Log Item Data Process
P_CT_LOG_DETAIL view from BASIC
P_GEN_LOG_DETAIL view from BASIC
P_LOG_CT_Header view left_outer BASIC
P_LOG_RE_Header view left_outer BASIC

Fields (85)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cnsldtnlognumber FINCS_LOGNUMBER Consolidation Log GUID
KEY cnsldtnlogitemnumber FINCS_LOGITEMNUMBER Consolidation Log Item Number GUID
cnsldtnlineitemtype FINCS_LINEITEMTYPE Log Line Item Type
node FINCS_NODE Node
parentnode FINCS_NODE Node
cnsldtngroup FC_CONGR Cons. Group
cnsldtnunit FC_BUNIT Cons. Unit
cnsldtnpartnerunit FC_BUPTR Partner Unit
cnsldtnsetidentification FINCS_SELID Selection
cnsldtndocumentnumber FC_DOCNR Document number
cnsldtnpostingitem DOCLN6 G/L Line Item
cnsldtnfinstmntitm FC_ITEM FS Item
cnsldtnfinstmntsubitmcat FC_SITYP Subitem Category
cnsldtnfinstmntsubitm FC_SITEM Subitem
transactioncurrency FC_RTCUR Trans.currency
baseunit MEINS Base Unit
cnsldtnacquisitionyear FC_RYACQ Acquis. Year
cnsldtnacquisitionperiod FC_RPACQ Acquistion prd
cnsldtncrcycnvrsndifftype FC_RTFLG CT Indicator
cnsldtnapportionment FC_RPFLG Apportionment
cnsldtnisautoposting FC_AUTOM Auto line item
percentage FC_TAXRT Tax Rate
amountintransactioncrcy FINS_VTCUR12 Amnt in Bal Tr Crcy
amountinlocalcrcy FINS_VHCUR12 Amnt in Comp Cd Crcy
amountingroupcrcy FINS_VKCUR12 Amnt in Global Crcy
quantityinbaseunit FINCS_QUAN Quantity
cnsldtnlocalcurrency FC_CURR Local Currency
cnsldtngroupcurrency FINCS_GROUPCURRENCY Group Currency
seqno FC_SEQNO Sequence number
recordindicator FINCS_STINDICATOR Source/Target Indic.
cnsldtnmethod FC_CMETH Method
sortorder INT4 INT4
reexchangerateindicator FC_RERIN Ref.ex.rate ind.
reexchagerate FC_RRATE Ref.exch.rate
exchangerateindicator FC_EXRIND Exch. rate ind.
exchangerate FC_ERATE Exchange rate
currencytranskey FC_CTKEY Translation key
cnsldtnfinstmntitmr FC_ITEM FS Item
cnsldtnfinstmntsubitmr FC_SITEM Subitem
diffamount FINCS_DIFFAMOUNT Trans. Difference
reffamount FINCS_REFAMOUNT Reference Amount
selection_id FINCS_SEL_ID Selection ID
chartofaccounts KTOPL Chart of Accts
glaccount RACCT Account Number
assignmentreference DZUONR Assignment
costcenter KOSTL Cost Center
profitcenter PRCTR Profit Center
functionalarea FKBER Functional Area
businessarea GSBER Business Area
controllingarea KOKRS CO Area
segment FB_SEGMENT Segment
partnercostcenter SKOST Sender Cost Ctr
partnerprofitcenter PPRCTR Partner PC
partnerfunctionalarea SFKBER Partner FArea
partnerbusinessarea PARGB Trdg Part.BA
partnercompany RASSC Trading Partner
partnersegment FB_PSEGMENT Partner Segment
orderid AUFNR Order
material MATNR Material
materialgroup FINS_MATKL_MM Material Group
plant WERKS_D Plant
financialtransactiontype RMVCT Transact. Type
wbselementinternalid PS_PSP_PNR WBS Element
wbselement PS_POSID WBS Element
partnerwbselement PS_POSID WBS Element
project PS_PSPID Project def.
billingdocumenttype FKART Billing Type
salesorganization VKORG Sales Org.
distributionchannel VTWEG Distr. Channel
organizationdivision SPART Division
soldmaterial FINS_MATNR_PA Product Sold
productgroup FINS_MATKL_PA Product Sold Group
customergroup KDGRP Customer Group
customersuppliercountry LAND1 Country/Reg.
customersupplierindustry BRSCH Industry
salesdistrict BZIRK Sales District
customersuppliercorporategroup KONZS Group
customer KUNNR Customer
supplier LIFNR Supplier
soldproduct FINS_MATNR_PA Product Sold
soldproductgroup FINS_MATKL_PA Product Sold Group
billtoparty KUNRE Bill-to Party
shiptoparty KUNWE Ship-to Party
dummy_cje_incl_eew_ps CFD_DUMMY Dummy

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 Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_LOG_ITEM (
    MANDT,                           -- Client [MANDT]
    CNSLDTNLOGNUMBER,                -- Consolidation Log GUID [FINCS_LOGNUMBER]
    CNSLDTNLOGITEMNUMBER,            -- Consolidation Log Item Number GUID [FINCS_LOGITEMNUMBER]
    CNSLDTNLINEITEMTYPE,             -- Log Line Item Type [FINCS_LINEITEMTYPE]
    NODE,                            -- Node [FINCS_NODE]
    PARENTNODE,                      -- Node [FINCS_NODE]
    CNSLDTNGROUP,                    -- Cons. Group [FC_CONGR]
    CNSLDTNUNIT,                     -- Cons. Unit [FC_BUNIT]
    CNSLDTNPARTNERUNIT,              -- Partner Unit [FC_BUPTR]
    CNSLDTNSETIDENTIFICATION,        -- Selection [FINCS_SELID]
    CNSLDTNDOCUMENTNUMBER,           -- Document number [FC_DOCNR]
    CNSLDTNPOSTINGITEM,              -- G/L Line Item [DOCLN6]
    CNSLDTNFINSTMNTITM,              -- FS Item [FC_ITEM]
    CNSLDTNFINSTMNTSUBITMCAT,        -- Subitem Category [FC_SITYP]
    CNSLDTNFINSTMNTSUBITM,           -- Subitem [FC_SITEM]
    TRANSACTIONCURRENCY,             -- Trans.currency [FC_RTCUR]
    BASEUNIT,                        -- Base Unit [MEINS]
    CNSLDTNACQUISITIONYEAR,          -- Acquis. Year [FC_RYACQ]
    CNSLDTNACQUISITIONPERIOD,        -- Acquistion prd [FC_RPACQ]
    CNSLDTNCRCYCNVRSNDIFFTYPE,       -- CT Indicator [FC_RTFLG]
    CNSLDTNAPPORTIONMENT,            -- Apportionment [FC_RPFLG]
    CNSLDTNISAUTOPOSTING,            -- Auto line item [FC_AUTOM]
    PERCENTAGE,                      -- Tax Rate [FC_TAXRT]
    AMOUNTINTRANSACTIONCRCY,         -- Amnt in Bal Tr Crcy [FINS_VTCUR12]
    AMOUNTINLOCALCRCY,               -- Amnt in Comp Cd Crcy [FINS_VHCUR12]
    AMOUNTINGROUPCRCY,               -- Amnt in Global Crcy [FINS_VKCUR12]
    QUANTITYINBASEUNIT,              -- Quantity [FINCS_QUAN]
    CNSLDTNLOCALCURRENCY,            -- Local Currency [FC_CURR]
    CNSLDTNGROUPCURRENCY,            -- Group Currency [FINCS_GROUPCURRENCY]
    SEQNO,                           -- Sequence number [FC_SEQNO]
    RECORDINDICATOR,                 -- Source/Target Indic. [FINCS_STINDICATOR]
    CNSLDTNMETHOD,                   -- Method [FC_CMETH]
    SORTORDER,                       -- INT4 [INT4]
    REEXCHANGERATEINDICATOR,         -- Ref.ex.rate ind. [FC_RERIN]
    REEXCHAGERATE,                   -- Ref.exch.rate [FC_RRATE]
    EXCHANGERATEINDICATOR,           -- Exch. rate ind. [FC_EXRIND]
    EXCHANGERATE,                    -- Exchange rate [FC_ERATE]
    CURRENCYTRANSKEY,                -- Translation key [FC_CTKEY]
    CNSLDTNFINSTMNTITMR,             -- FS Item [FC_ITEM]
    CNSLDTNFINSTMNTSUBITMR,          -- Subitem [FC_SITEM]
    DIFFAMOUNT,                      -- Trans. Difference [FINCS_DIFFAMOUNT]
    REFFAMOUNT,                      -- Reference Amount [FINCS_REFAMOUNT]
    SELECTION_ID,                    -- Selection ID [FINCS_SEL_ID]
    CHARTOFACCOUNTS,                 -- Chart of Accts [KTOPL]
    GLACCOUNT,                       -- Account Number [RACCT]
    ASSIGNMENTREFERENCE,             -- Assignment [DZUONR]
    COSTCENTER,                      -- Cost Center [KOSTL]
    PROFITCENTER,                    -- Profit Center [PRCTR]
    FUNCTIONALAREA,                  -- Functional Area [FKBER]
    BUSINESSAREA,                    -- Business Area [GSBER]
    CONTROLLINGAREA,                 -- CO Area [KOKRS]
    SEGMENT,                         -- Segment [FB_SEGMENT]
    PARTNERCOSTCENTER,               -- Sender Cost Ctr [SKOST]
    PARTNERPROFITCENTER,             -- Partner PC [PPRCTR]
    PARTNERFUNCTIONALAREA,           -- Partner FArea [SFKBER]
    PARTNERBUSINESSAREA,             -- Trdg Part.BA [PARGB]
    PARTNERCOMPANY,                  -- Trading Partner [RASSC]
    PARTNERSEGMENT,                  -- Partner Segment [FB_PSEGMENT]
    ORDERID,                         -- Order [AUFNR]
    MATERIAL,                        -- Material [MATNR]
    MATERIALGROUP,                   -- Material Group [FINS_MATKL_MM]
    PLANT,                           -- Plant [WERKS_D]
    FINANCIALTRANSACTIONTYPE,        -- Transact. Type [RMVCT]
    WBSELEMENTINTERNALID,            -- WBS Element [PS_PSP_PNR]
    WBSELEMENT,                      -- WBS Element [PS_POSID]
    PARTNERWBSELEMENT,               -- WBS Element [PS_POSID]
    PROJECT,                         -- Project def. [PS_PSPID]
    BILLINGDOCUMENTTYPE,             -- Billing Type [FKART]
    SALESORGANIZATION,               -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNEL,             -- Distr. Channel [VTWEG]
    ORGANIZATIONDIVISION,            -- Division [SPART]
    SOLDMATERIAL,                    -- Product Sold [FINS_MATNR_PA]
    PRODUCTGROUP,                    -- Product Sold Group [FINS_MATKL_PA]
    CUSTOMERGROUP,                   -- Customer Group [KDGRP]
    CUSTOMERSUPPLIERCOUNTRY,         -- Country/Reg. [LAND1]
    CUSTOMERSUPPLIERINDUSTRY,        -- Industry [BRSCH]
    SALESDISTRICT,                   -- Sales District [BZIRK]
    CUSTOMERSUPPLIERCORPORATEGROUP,  -- Group [KONZS]
    CUSTOMER,                        -- Customer [KUNNR]
    SUPPLIER,                        -- Supplier [LIFNR]
    SOLDPRODUCT,                     -- Product Sold [FINS_MATNR_PA]
    SOLDPRODUCTGROUP,                -- Product Sold Group [FINS_MATKL_PA]
    BILLTOPARTY,                     -- Bill-to Party [KUNRE]
    SHIPTOPARTY,                     -- Ship-to Party [KUNWE]
    DUMMY_CJE_INCL_EEW_PS,           -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, CNSLDTNLOGNUMBER, CNSLDTNLOGITEMNUMBER)
);

Learn More