FINCS_LOG_ITEM - Consolidation Generic Log Item

Consolidation Generic Log Item information is stored in SAP table FINCS_LOG_ITEM.
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_ITEM

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	FINCS_LOG_HEADER
CNSLDTNLOGITEMNUMBER	Consolidation Log Item GUID	X	FINCS_LOGITEMNUMBER	CHAR	64
.INCLUDE				FINCS_S_LOG_ITEM	0
CNSLDTNLINEITEMTYPE	Log Line Item Type		FINCS_LINEITEMTYPE	CHAR	4
NODE	Node		FINCS_NODE	CHAR	64
PARENTNODE	Node		FINCS_NODE	CHAR	64
CNSLDTNGROUP	Consolidation Group		FC_CONGR	CHAR	36	*
CNSLDTNUNIT	Consolidation Unit		FC_BUNIT	CHAR	36	*
CNSLDTNPARTNERUNIT	Partner Unit		FC_BUPTR	CHAR	36	*
CNSLDTNSETIDENTIFICATION	Selection		FINCS_SELID	CHAR	68
CNSLDTNDOCUMENTNUMBER	Document number for the consolidation document		FC_DOCNR	CHAR	20
CNSLDTNPOSTINGITEM	Six-Character Posting Item for Ledger		DOCLN6	CHAR	12
CNSLDTNFINSTMNTITM	Financial Statement Item		FC_ITEM	CHAR	20	*
CNSLDTNFINSTMNTSUBITMCAT	Subitem Category		FC_SITYP	CHAR	6
CNSLDTNFINSTMNTSUBITM	Subitem		FC_SITEM	CHAR	20	*
TRANSACTIONCURRENCY	Transaction currency		FC_RTCUR	CUKY	10
BASEUNIT	Base Unit of Measure		MEINS	UNIT	6	*
CNSLDTNACQUISITIONYEAR	Year of Acquisition		FC_RYACQ	NUMC	8
CNSLDTNACQUISITIONPERIOD	Period of acquisition		FC_RPACQ	NUMC	6
CNSLDTNCRCYCNVRSNDIFFTYPE	Currency Translation		FC_RTFLG	NUMC	2
CNSLDTNAPPORTIONMENT	Apportionment		FC_RPFLG	NUMC	2
CNSLDTNISAUTOPOSTING	Automatic line item		FC_AUTOM	CHAR	2
PERCENTAGE	Tax Rate		FC_TAXRT	DEC	4
AMOUNTINTRANSACTIONCRCY	Amount in Balance Transaction Currency		FINS_VTCUR12	CURR	12
AMOUNTINLOCALCRCY	Amount in Company Code Currency		FINS_VHCUR12	CURR	12
AMOUNTINGROUPCRCY	Amount in Global Currency		FINS_VKCUR12	CURR	12
QUANTITYINBASEUNIT	Quantity		FINCS_QUAN	QUAN	15
CNSLDTNLOCALCURRENCY	Local Currency		FC_CURR	CUKY	10
CNSLDTNGROUPCURRENCY	Group Currency		FINCS_GROUPCURRENCY	CUKY	10	*
SEQNO	Sequence number in a method		FC_SEQNO	CHAR	6
RECORDINDICATOR	Source/Target Indicator		FINCS_STINDICATOR	CHAR	2
CNSLDTNMETHOD	Method		FC_CMETH	CHAR	10	*
SORTORDER	4 Byte Signed Integer		INT4	INT4	4
REEXCHANGERATEINDICATOR	Reference exchange rate indicator		FC_RERIN	CHAR	2	*
REEXCHAGERATE	Reference exchange rate		FC_RRATE	CHAR	24
EXCHANGERATEINDICATOR	Exchange rate indicator		FC_EXRIND	CHAR	2
EXCHANGERATE	Exchange rate		FC_ERATE	CHAR	24
CURRENCYTRANSKEY	Currency translation key		FC_CTKEY	CHAR	2
CNSLDTNFINSTMNTITMR	Financial Statement Item		FC_ITEM	CHAR	20	*
CNSLDTNFINSTMNTSUBITMR	Subitem		FC_SITEM	CHAR	20	*
DIFFAMOUNT	Translation Difference		FINCS_DIFFAMOUNT	CURR	12
REFFAMOUNT	Reference Amount		FINCS_REFAMOUNT	CURR	12
SELECTION_ID	Selection ID		FINCS_SEL_ID	CHAR	40
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
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