FINCS_LOG_ITEM

Consolidation Generic Log Item | #transactional | Component: S/4HANA Financial Consolidation, Core Processing
Column Name Description
MANDT Client
CNSLDTNLOGNUMBER FK Consolidation Log GUID
CNSLDTNLOGITEMNUMBER Consolidation Log Item GUID
Column Name Description
💲 Transaction currency (TRANSACTIONCURRENCY):
AMOUNTINTRANSACTIONCRCY Amount in Balance Transaction Currency
💲 Local Currency (CNSLDTNLOCALCURRENCY):
AMOUNTINLOCALCRCY Amount in Company Code Currency
💲 Group Currency (CNSLDTNGROUPCURRENCY):
AMOUNTINGROUPCRCY Amount in Global Currency
DIFFAMOUNT Translation Difference
REFFAMOUNT Reference Amount
Column Name Description
📏 Base Unit of Measure (BASEUNIT):
QUANTITYINBASEUNIT Quantity
Column Name Description
Column Name Description
CNSLDTNLINEITEMTYPE Log Line Item Type Show values
CNSLDTNCRCYCNVRSNDIFFTYPE Currency Translation Show values
CNSLDTNAPPORTIONMENT Apportionment Show values
CNSLDTNISAUTOPOSTING Automatic line item Show values
CURRENCYTRANSKEY Currency translation key Show values
Column Name Description Domain name
NODE Node SYSUUID_C32
PARENTNODE Node SYSUUID_C32
CNSLDTNGROUP Consolidation Group FC_CONGR
CNSLDTNUNIT Consolidation Unit FC_BUNIT
CNSLDTNPARTNERUNIT Partner Unit FC_BUNIT
CNSLDTNSETIDENTIFICATION Selection SETID
CNSLDTNDOCUMENTNUMBER Document number for the consolidation document BELNR
CNSLDTNPOSTINGITEM Six-Character Posting Item for Ledger DOCLN6
CNSLDTNFINSTMNTITM Financial Statement Item FC_ITEM
CNSLDTNFINSTMNTSUBITMCAT Subitem Category FC_SITYP
CNSLDTNFINSTMNTSUBITM Subitem FC_SITEM
CNSLDTNACQUISITIONYEAR Year of Acquisition GJAHR
CNSLDTNACQUISITIONPERIOD Period of acquisition NUM03
PERCENTAGE Tax Rate PRZ34
SEQNO Sequence number in a method SEQNO
RECORDINDICATOR Source/Target Indicator CHAR1
CNSLDTNMETHOD Method FC_CMETH
SORTORDER 4 Byte Signed Integer INT4
REEXCHANGERATEINDICATOR Reference exchange rate indicator FC_EXRIND
REEXCHAGERATE Reference exchange rate CHAR12
EXCHANGERATEINDICATOR Exchange rate indicator FC_EXRIND
EXCHANGERATE Exchange rate CHAR12
CNSLDTNFINSTMNTITMR Financial Statement Item FC_ITEM
CNSLDTNFINSTMNTSUBITMR Subitem FC_SITEM
SELECTION_ID Selection ID FINCS_SEL_ID
CHARTOFACCOUNTS Chart of Accounts KTOPL
GLACCOUNT Account Number SAKNR
ASSIGNMENTREFERENCE Assignment number ZUONR
COSTCENTER Cost Center KOSTL
PROFITCENTER Profit Center PRCTR
FUNCTIONALAREA Functional Area FKBER
BUSINESSAREA Business Area GSBER
CONTROLLINGAREA Controlling Area CACCD
SEGMENT Segment for Segmental Reporting FB_SEGMENT
PARTNERCOSTCENTER Sender cost center KOSTL
PARTNERPROFITCENTER Partner Profit Center PRCTR
PARTNERFUNCTIONALAREA Partner Functional Area FKBER
PARTNERBUSINESSAREA Trading partner's business area GSBER
PARTNERCOMPANY Company ID of Trading Partner RCOMP
PARTNERSEGMENT Partner Segment for Segmental Reporting FB_SEGMENT
ORDERID Order Number AUFNR
MATERIAL Material Number MATNR
MATERIALGROUP Material Group MATKL
PLANT Plant WERKS
FINANCIALTRANSACTIONTYPE Transaction type RMVCT
WBSELEMENTINTERNALID Work Breakdown Structure Element (WBS Element) PS_POSNR
PARTNERWBSELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID
PROJECT Project definition PS_PSPID
BILLINGDOCUMENTTYPE Billing Type FKART
SALESORGANIZATION Sales Organization VKORG
DISTRIBUTIONCHANNEL Distribution Channel VTWEG
ORGANIZATIONDIVISION Division SPART
SOLDMATERIAL Product Sold MATNR
PRODUCTGROUP Product Sold Group MATKL
CUSTOMERGROUP Customer Group KDGRP
CUSTOMERSUPPLIERCOUNTRY Country/Region Key LAND1
CUSTOMERSUPPLIERINDUSTRY Industry key BRSCH
SALESDISTRICT Sales District BZIRK
CUSTOMERSUPPLIERCORPORATEGROUP Group key KONZS
CUSTOMER Customer Number KUNNR
SUPPLIER Account Number of Supplier LIFNR
SOLDPRODUCT Product Sold MATNR
SOLDPRODUCTGROUP Product Sold Group MATKL
BILLTOPARTY Bill-to Party KUNNR
SHIPTOPARTY Ship-to Party KUNNR
DUMMY_CJE_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes