FINCS_LOG_ITEM01 - Consolidation Log Item(ACDOCU)

Consolidation Log Item(ACDOCU) information is stored in SAP table FINCS_LOG_ITEM01.
It is part of development package FIN_CS_TASK_LOG in software component FIN-CS-COR. This development package consists of objects that can be grouped under "Financial Consolidation - Task Log".

Fields for table FINCS_LOG_ITEM01

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
CNSLDTNLOGNUMBER	Consolidation Log GUID	X	FINCS_LOGNUMBER	CHAR	64
CNSLDTNLOGITEMNUMBER	Consolidation Log Item GUID	X	FINCS_LOGITEMNUMBER	CHAR	64
.INCLUDE				FINCS_S_LOG_ITEM01	0
CNSLDTNLINEITEMTYPE	Log Line Item Type		FINCS_LINEITEMTYPE	CHAR	4
RAW_ROWID	Row Number		FINCS_ROWID	NUMC	12
ENTRYID	Journal Entry ID Used in Import Templates		FINCS_ENTRYID	NUMC	20
NODE	Node		FINCS_NODE	CHAR	64
PARENTNODE	Node		FINCS_NODE	CHAR	64
DRAFTUUID	UUID serving as key (parent key, root key)		/BOBF/UUID	RAW	16
PARENTDRAFTUUID	UUID serving as key (parent key, root key)		/BOBF/UUID	RAW	16
CNSLDTNLEDGER	Ledger		RLDNR	CHAR	4
FISCALYEAR	Fiscal Year		GJAHR	NUMC	8
CNSLDTNDOCUMENTNUMBER	Document Number of an Accounting Document		BELNR_D	CHAR	20
CNSLDTNPOSTINGITEM	Six-Character Posting Item for Ledger		DOCLN6	CHAR	12
CNSLDTNDIMENSION	Dimension		FC_DIMEN	CHAR	4
GLRECORDTYPE	Record Type		FC_RRCTY	CHAR	2
CNSLDTNVERSION	Version		RVERS	CHAR	6	*
TRANSACTIONCURRENCY	Currency Key		RTCUR	CUKY	10	*
CNSLDTNLOCALCURRENCY	Currency key of the local currency		LCURR	CUKY	10	*
CNSLDTNGROUPCURRENCY	Currency key of the ledger currency		GCURR	CUKY	10	*
BASEUNIT	Base Unit of Measure		MEINS	UNIT	6	*
FISCALPERIOD	Posting period		POPER	NUMC	6
COMPANY	Company		RCOMP_D	CHAR	12	*
CNSLDTNUNIT	Consolidation Unit		FC_BUNIT	CHAR	36	*
CNSLDTNUNITMDMTEXT	Medium description		RSTXTMD	CHAR	80
CNSLDTNCHARTOFACCOUNTS	Consolidation Chart of Accounts		FC_ITCLG	CHAR	4
CNSLDTNFINSTMNTITM	Financial Statement Item		FC_ITEM	CHAR	20	*
CNSLDTNPARTNERUNIT	Partner Unit		FC_BUPTR	CHAR	36	*
CNSLDTNGROUP	Consolidation Group		FC_CONGR	CHAR	36	*
COMPANYCODE	Original company code		OBUKR	CHAR	8	*
CNSLDTNFINSTMNTSUBITMCAT	Subitem Category		FC_SITYP	CHAR	6
CNSLDTNFINSTMNTSUBITM	Subitem		FC_SITEM	CHAR	20	*
CNSLDTNPOSTINGLEVEL	Posting Level		FC_PLEVL	CHAR	4
CNSLDTNAPPORTIONMENT	Apportionment		FC_RPFLG	NUMC	2
CNSLDTNCRCYCNVRSNDIFFTYPE	Currency Translation		FC_RTFLG	NUMC	2
CNSLDTNDOCUMENTTYPE	Document Type		FC_DOCTY	CHAR	4	*
CNSLDTNACQUISITIONYEAR	Year of Acquisition		FC_RYACQ	NUMC	8
CNSLDTNACQUISITIONPERIOD	Period of Acquisition		RPACQ	NUMC	6
CNSLDTNINVESTEEUNIT	Investee Unit		FC_COICU	CHAR	36	*
AMOUNTINTRANSACTIONCURRENCY	Value in Transaction Currency		VTCUR12	CURR	12
AMOUNTINCNSLDTNLOCALCRCY	Value in Local Currency		VLCUR12	CURR	12
AMOUNTINCNSLDTNGROUPCRCY	Value in Group Currency		VGCUR12	CURR	12
QUANTITYINBASEUNIT	Quantity		FINCS_QUAN	QUAN	15
CNSLDTNITEMTEXT	Item Text		SGTXT	CHAR	100
CNSLDTNISAUTOPOSTING	Indicator: Automatic posting lines		AUTOM	CHAR	2
CNSLDTNBUSINESSTRANSACTIONTYPE	Business Transaction		GLVOR	CHAR	8
POSTINGDATE	Posting Date in the Document		BUDAT	DATS	16
CNSLDTNCRCYTRANSLATIONDATE	Value Date for Currency Translation		WSDAT	DATS	16
CNSLDTNREFACCTGDOCUMENT	Document Number of an Accounting Document		BELNR_D	CHAR	20
CNSLDTNREFFISCALYEAR	Fiscal Year		GJAHR	NUMC	8
CNSLDTNREFACCTGDOCITEM	Six-figure number of line item		BUZEI6	NUMC	12
CNSLDTNREFDOCUMENTTYPE	Document Category		DOCCT	CHAR	2
CNSLDTNREFBUSTRANSTYPE	Business Transaction		GLVOR	CHAR	8
CNSLDTNREVERSEDOCUMENT	Reverse Document Number		STBLG	CHAR	20
CNSLDTNREVERSEDDOCUMENT	Number of Reversed Document		STBLN	CHAR	20
CNSLDTNINVMTACTIVITYTYPE	Consolidation of Investments Activity		FC_COIAC	CHAR	4
CNSLDTNINVMTACTIVITY	Consolidation of Investments Activity Number		FC_COINR	CHAR	20
CNSLDTNDOCREVERSALYEAR	Year of reversal document or reversed document		FC_REVYEAR	NUMC	8
REFERENCEDOCUMENTTYPE	Reference procedure		AWTYP	CHAR	10	*
REFERENCEDOCUMENTCONTEXT	Reference Organizational Units		AWORG	CHAR	20
LOGICALSYSTEM	Logical system		LOGSYS	CHAR	20	*
CHARTOFACCOUNTS	Chart of Accounts		KTOPL	CHAR	8
GLACCOUNT	Account Number		RACCT	CHAR	20	*
ASSIGNMENTREFERENCE	Assignment number		DZUONR	CHAR	36
COSTCENTER	Cost Center		KOSTL	CHAR	20	*
PROFITCENTER	Profit Center		PRCTR	CHAR	20
FUNCTIONALAREA	Functional Area		FKBER	CHAR	32	*
BUSINESSAREA	Business Area		GSBER	CHAR	8	*
CONTROLLINGAREA	Controlling Area		KOKRS	CHAR	8	*
SEGMENT	Segment for Segmental Reporting		FB_SEGMENT	CHAR	20	*
PARTNERCOSTCENTER	Sender cost center		SKOST	CHAR	20	*
PARTNERPROFITCENTER	Partner Profit Center		PPRCTR	CHAR	20	*
PARTNERFUNCTIONALAREA	Partner Functional Area		SFKBER	CHAR	32	*
PARTNERBUSINESSAREA	Trading partner's business area		PARGB	CHAR	8	*
PARTNERCOMPANY	Company ID of Trading Partner		RASSC	CHAR	12	*
PARTNERSEGMENT	Partner Segment for Segmental Reporting		FB_PSEGMENT	CHAR	20	*
ORDERID	Order Number		AUFNR	CHAR	24	*
MATERIAL	Material Number		MATNR	CHAR	80
MATERIALGROUP	Material Group		FINS_MATKL_MM	CHAR	18
PLANT	Plant		WERKS_D	CHAR	8
FINANCIALTRANSACTIONTYPE	Transaction type		RMVCT	CHAR	6	*
WBSELEMENTINTERNALID	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	*
PARTNERWBSELEMENT	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
PROJECT	Project definition		PS_PSPID	CHAR	48
BILLINGDOCUMENTTYPE	Billing Type		FKART	CHAR	8	*
SALESORGANIZATION	Sales Organization		VKORG	CHAR	8
DISTRIBUTIONCHANNEL	Distribution Channel		VTWEG	CHAR	4
ORGANIZATIONDIVISION	Division		SPART	CHAR	4
SOLDMATERIAL	Product Sold		FINS_MATNR_PA	CHAR	80	*
PRODUCTGROUP	Product Sold Group		FINS_MATKL_PA	CHAR	18
CUSTOMERGROUP	Customer Group		KDGRP	CHAR	4	*
CUSTOMERSUPPLIERCOUNTRY	Country/Region Key		LAND1	CHAR	6	*
CUSTOMERSUPPLIERINDUSTRY	Industry key		BRSCH	CHAR	8	*
SALESDISTRICT	Sales District		BZIRK	CHAR	12	*
CUSTOMERSUPPLIERCORPORATEGROUP	Group key		KONZS	CHAR	20
LATEST_INDI	Latest Record Indicator		FINCS_LATESTINDI	CHAR	2
LOGDATE	Date		FICNS_TIMESTAMP	DEC	11
CUSTOMER	Customer Number		KUNNR	CHAR	20
SUPPLIER	Account Number of Supplier		LIFNR	CHAR	20
SOLDPRODUCT	Product Sold		FINS_MATNR_PA	CHAR	80	*
SOLDPRODUCTGROUP	Product Sold Group		FINS_MATKL_PA	CHAR	18
BILLTOPARTY	Bill-to Party		KUNRE	CHAR	20	*
SHIPTOPARTY	Ship-to Party		KUNWE	CHAR	20	*
.INCLUDE	CJE_PS			CJE_S_INCL_EEW_PS	0
DUMMY_CJE_INCL_EEW_PS	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2
CNSLDTNGROUPJRNLENTRYBUNDLE	Document Bundle Number		FINCS_BUNNR	CHAR	26