FINCS_LOG_ITEM01

Consolidation Log Item(ACDOCU) | #transactional | Component: S/4HANA Financial Consolidation, Core Processing
Column Name Description
MANDT Client
CNSLDTNLOGNUMBER Consolidation Log GUID
CNSLDTNLOGITEMNUMBER Consolidation Log Item GUID
Column Name Description
💲 Currency Key (TRANSACTIONCURRENCY):
AMOUNTINTRANSACTIONCURRENCY Value in Transaction Currency
💲 Currency key of the local currency (CNSLDTNLOCALCURRENCY):
AMOUNTINCNSLDTNLOCALCRCY Value in Local Currency
💲 Currency key of the ledger currency (CNSLDTNGROUPCURRENCY):
AMOUNTINCNSLDTNGROUPCRCY Value in Group Currency
Column Name Description
📏 Base Unit of Measure (BASEUNIT):
QUANTITYINBASEUNIT Quantity
Column Name Description
POSTINGDATE Posting Date in the Document
CNSLDTNCRCYTRANSLATIONDATE Value Date for Currency Translation
Column Name Description
CNSLDTNLINEITEMTYPE Log Line Item Type Show values
GLRECORDTYPE Record Type Show values
CNSLDTNPOSTINGLEVEL Posting Level Show values
CNSLDTNAPPORTIONMENT Apportionment Show values
CNSLDTNCRCYCNVRSNDIFFTYPE Currency Translation Show values
CNSLDTNREFDOCUMENTTYPE Document Category Show values
CNSLDTNINVMTACTIVITYTYPE Consolidation of Investments Activity Show values
Column Name Description Domain name
RAW_ROWID Row Number FINCS_ROWID
ENTRYID Journal Entry ID Used in Import Templates
NODE Node SYSUUID_C32
PARENTNODE Node SYSUUID_C32
DRAFTUUID UUID serving as key (parent key, root key) SYSUUID
PARENTDRAFTUUID UUID serving as key (parent key, root key) SYSUUID
CNSLDTNLEDGER Ledger RLDNR
FISCALYEAR Fiscal Year GJAHR
CNSLDTNDOCUMENTNUMBER Document Number of an Accounting Document BELNR
CNSLDTNPOSTINGITEM Six-Character Posting Item for Ledger DOCLN6
CNSLDTNDIMENSION Dimension FC_DIMEN
CNSLDTNVERSION Version RVERS
FISCALPERIOD Posting period POPER
COMPANY Company RCOMP
CNSLDTNUNIT Consolidation Unit FC_BUNIT
CNSLDTNUNITMDMTEXT Medium description TEXT40
CNSLDTNCHARTOFACCOUNTS Consolidation Chart of Accounts FC_ITCLG
CNSLDTNFINSTMNTITM Financial Statement Item FC_ITEM
CNSLDTNPARTNERUNIT Partner Unit FC_BUNIT
CNSLDTNGROUP Consolidation Group FC_CONGR
COMPANYCODE Original company code BUKRS
CNSLDTNFINSTMNTSUBITMCAT Subitem Category FC_SITYP
CNSLDTNFINSTMNTSUBITM Subitem FC_SITEM
CNSLDTNDOCUMENTTYPE Document Type FC_DOCTY
CNSLDTNACQUISITIONYEAR Year of Acquisition GJAHR
CNSLDTNACQUISITIONPERIOD Period of Acquisition NUM03
CNSLDTNINVESTEEUNIT Investee Unit FC_BUNIT
CNSLDTNITEMTEXT Item Text TEXT50
CNSLDTNISAUTOPOSTING Indicator: Automatic posting lines TEXT1
CNSLDTNBUSINESSTRANSACTIONTYPE Business Transaction CHAR4
CNSLDTNREFACCTGDOCUMENT Document Number of an Accounting Document BELNR
CNSLDTNREFFISCALYEAR Fiscal Year GJAHR
CNSLDTNREFACCTGDOCITEM Six-figure number of line item BUZEI6
CNSLDTNREFBUSTRANSTYPE Business Transaction CHAR4
CNSLDTNREVERSEDOCUMENT Reverse Document Number BELNR
CNSLDTNREVERSEDDOCUMENT Number of Reversed Document BELNR
CNSLDTNINVMTACTIVITY Consolidation of Investments Activity Number BELNR
CNSLDTNDOCREVERSALYEAR Year of reversal document or reversed document GJAHR
REFERENCEDOCUMENTTYPE Reference procedure AWTYP
REFERENCEDOCUMENTCONTEXT Reference Organizational Units AWORG
LOGICALSYSTEM Logical system LOGSYS
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
LATEST_INDI Latest Record Indicator CHAR1
LOGDATE Date TZNTSTMPL
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
CNSLDTNGROUPJRNLENTRYBUNDLE Document Bundle Number FINCS_BUNNR