FINS_CLS_WL - Temporary WorkList Table

Temporary WorkList Table information is stored in SAP table FINS_CLS_WL.
It is part of development package FINS_FI_CLS_VAL_COMMON in software component FI-GL-GL-G. This development package consists of objects that can be grouped under "Common objects for valuations".

Fields for table FINS_CLS_WL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
JRNLPERIODENDCLOSINGRUNLOGUUID	UUID of Financial Closing Run	X	CLS_RUN_ID	RAW	16
SOURCELEDGER	Source Ledger		FINS_LEDGER_PERS	CHAR	4	FINSC_LEDGER
COMPANYCODE	Company Code		FIS_BUKRS	CHAR	8	T001
FISCALYEAR	Fiscal Year		FIS_GJAHR	NUMC	8
CURRENTFISCALYEAR	Fiscal Year		FIS_GJAHR	NUMC	8
ACCOUNTINGDOCUMENT	Journal Entry		FIS_BELNR	CHAR	20
LEDGERGLLINEITEM	Ledger Journal Entry Item		FIS_DOCLN	CHAR	12
NEWACCOUNTINGDOCUMENT	Journal Entry		FIS_BELNR	CHAR	20
NEWLEDGERGLLINEITEM	Ledger Journal Entry Item		FIS_DOCLN	CHAR	12
LEDGER	Ledger in General Ledger Accounting		FINS_LEDGER	CHAR	4	FINSC_LEDGER
ACCOUNTINGPRINCIPLE	Accounting Principle for Ledger/Company Code		ACC_PRINCIPLE_LD_CMP	CHAR	8	TACC_PRINCIPLE
LASTCHANGEDATETIME	Time Stamp of Last Change		FIS_CHNG_TSTAMP	DEC	8
CREATIONDATETIME	Time Stamp of Creation		FIS_CREA_TSTAMP	DEC	8
GLACCOUNT	G/L Account		FIS_RACCT	CHAR	20	SKB1
FOREIGNEXCHANGEGAINORLOSSGROUP	Long text - line width 72		CHAR72	CHAR	144
GROUPING_RULE	Rule for Grouping Journal Entry Line Items for Valuation		FINS_VAL_GROUPING_RULE	CHAR	8
GROUPING_RULE_STEP	Step of a Grouping Rule		FINS_VAL_GROUPING_RULE_STEP	NUMC	8
GROUP_ID	Group ID for Grouping Journal Entry Line Items		CLS_RUN_GROUP_ID	CHAR	160
FINCLOSINGVALUATIONCRITERION	Valuation Criteria of Financial Closing Run		CLS_RUN_VALUATION_CRITERION	CHAR	60
FINANCIALVALUATIONOBJECTTYPE	Type of the Financial Valuation Object		VAL_OBJ_TYPE	CHAR	8	FINSC_VAL_TYPE
FINANCIALVALUATIONOBJECT	Identifier of the Financial Valuation Object		VAL_OBJ_ID	CHAR	64
FINANCIALVALUATIONSUBOBJECT	Identifier of the Financial Valuation Subobject		VAL_SUBOBJ_ID	CHAR	64
NETDUEDATE	Net Due Date		FAEDT_FPOS	DATS	16
OLDESTOPENITEMNETDUEDATE	Net due date of the oldest open item		CLS_RUN_GROUP_NET_DUE_DATE	DATS	16
SUBLEDGERACCTLINEITEMTYPE	Subledger-Specific Line Item Type		SLALITTYPE	NUMC	10	FINSTS_SLALITTY
SUBLEDGERACCTLINEITEMTYPEOFFS	Subledger-Specific Line Item Type		SLALITTYPE	NUMC	10	FINSTS_SLALITTY
CHARTOFACCOUNTS	Chart of Accounts		FIS_KTOPL	CHAR	8	T004
POSTINGDATE	Posting Date		FIS_BUDAT	DATS	16
DOCUMENTDATE	Journal Entry Date		FIS_BLDAT	DATS	16
ACCOUNTINGDOCUMENTCATEGORY	Journal Entry Category		FIS_BSTAT	CHAR	2
ISOPENITEMMANAGED	Managed on an Open Item Basis		FIS_XOPVW	CHAR	2
IS_CLEARED_AT_KEYDATE	The open item was cleared in current period before key date		FINS_CLS_IS_CLEARED_AT_KEYDATE	CHAR	2
OFFSETTINGACCOUNT	Unrealized Loss from Foreign Currency Valuation		FX_UNREALIZED_LOSS	CHAR	20	SKB1
FISCALPERIOD	Fiscal Period		FINS_FISCALPERIOD	NUMC	6
DEBITCREDITCODE	Debit/Credit Code		FIS_SHKZG	CHAR	2
POSTINGKEY	Posting Key		FIS_BSCHL	CHAR	4
EXCHANGERATE	Key Date Exchange Rate		VALUATIONEXCHANGERATE	DEC	5
TEMP_ID	ID of temporary data set		FINS_ACDOCTEMP_ID	CHAR	60
RESULT_LIST_ID	Financial Closing Run Message ID		CLS_RUN_RESULT_LIST_ID	RAW	16
ACCOUNT_TYPE	Account type		KOART	CHAR	2
CUSTOMER_SUPPLIER_GROUP_KEY	Group key		KONZS	CHAR	20
GLACCOUNT_TYPE	Type of a General Ledger Account		GLACCOUNT_TYPE	CHAR	2
ASSIGNMENTREFERENCE	Assignment number		DZUONR	CHAR	36
BUSINESSPARTNER	Business Partner Number		BU_PARTNER	CHAR	20	BUT000
.INCLUDE	REFERENCES			FINS_CLS_REFERENCES	0
PREDECESSORREFERENCEDOCTYPE	Preceding Document Reference Transaction		FINS_PREC_AWTYP	CHAR	10	TTYP
PREDECESSORREFERENCEDOCCNTXT	Preceding Document Reference Organizational Units		FINS_PREC_AWORG	CHAR	20
PREDECESSORREFERENCEDOCUMENT	Preceding Document Reference Document Number		FINS_PREC_AWREF	CHAR	20
PREDECESSORREFERENCEDOCITEM	Preceding Reference Document Line Item		FINS_PREC_AWITEM	NUMC	12
PRDCSSRJOURNALENTRYCOMPANYCODE	Preceding Journal Entry Company Code		FINS_PREC_BUKRS_GFC	CHAR	8	T001
PRDCSSRJOURNALENTRYFISCALYEAR	Preceding Journal Entry Fiscal Year		FINS_PREC_GJAHR_GFC	NUMC	8
PREDECESSORJOURNALENTRY	Preceding Journal Entry Document Number		FINS_PREC_BELNR_GFC	CHAR	20
PREDECESSORJOURNALENTRYITEM	Preceding Journal Entry Line Item		FINS_PREC_DOCLN_GFC	CHAR	12
INVOICEITEMREFERENCE	Invoice Item Reference		FIS_REBZZ	NUMC	6
INVOICEREFERENCE	Invoice Reference		FIS_REBZG	CHAR	20
INVOICEREFERENCEFISCALYEAR	Invoice Reference Fiscal Year		FIS_REBZJ	NUMC	8
FOLLOWONDOCUMENTTYPE	Follow-On Document Type		FARP_REBZT	CHAR	2
ACCOUNTINGDOCUMENTITEM	Journal Entry Posting View Item		FIS_BUZEI	NUMC	6
CLEARINGDATE	Clearing Date		FIS_AUGDT	DATS	16
CLEARINGACCOUNTINGDOCUMENT	Clearing Journal Entry		FIS_AUGBL	CHAR	20
CLEARINGDOCFISCALYEAR	Fiscal Year of Clearing Journal Entry		FIS_AUGGJ	NUMC	8
.INCLUDE	VALUATIONFIELDS			FINS_CLS_VALUATION_FIELDS	0
HOUSEBANK	House Bank Key		FARP_HBKID	CHAR	10	T012
HOUSEBANKACCOUNT	House Bank Account		FAC_HKTID	CHAR	10	T012K
COSTCTRACTIVITYTYPE	Activity Type		LSTAR	CHAR	12	CSLA
WBSELEMENTINTERNALID	WBS Element Internal ID		FIS_WBSINT_NO_CONV	NUMC	16	*
FINANCIALTRANSACTIONTYPE	Financial Transaction Type		FIS_RMVCT	CHAR	6	T856
JOINTVENTURE	Joint venture		JV_NAME	CHAR	12	T8JV
JOINTVENTUREEQUITYGROUP	Joint Venture Equity Group		JV_EGROUP_CDS	CHAR	6	T8JF
PARTNERVENTURE	Partner Venture		JV_PVNAME_CDS	CHAR	12	T8JV
JOINTVENTUREPARTNER	Joint Venture Partner		JV_PART_CDS	CHAR	20	KNA1
JOINTVENTURECOSTRECOVERYCODE	Joint Venture Cost Recovery Code		JV_RECIND_CDS	CHAR	4	T8JJ
PROJECTNETWORK	Network Number for Account Assignment		NPLNR	CHAR	24	AUFK
RELATEDNETWORKACTIVITY	Network activity		NPVRG	CHAR	8
RELATEDNETWORKACTIVITYINTERNAL	Closing run Internal hepler field for NPLNR_VORGN		CLS_RUN_NPLNR_VORGN_HELPER	CHAR	66
ORDERID	Order ID		FIS_AUFNR	CHAR	24	AUFK
BUSINESSPROCESS	Business Process		CO_PRZNR	CHAR	24	CBPR
SALESORDER	Sales Order		VDM_SALES_ORDER	CHAR	20
SALESORDERITEM	Sales Order Item		SALES_ORDER_ITEM	NUMC	12
COSTOBJECT	Cost Object		KSTRG	CHAR	24	CKPH
COSTCENTER	Cost Center		FIS_KOSTL	CHAR	20	CSKS
PROFITCENTER	Profit Center		FIS_PRCTR	CHAR	20	CEPC
FUNCTIONALAREA	Functional Area		FM_FAREA	CHAR	32	TFKB
BUSINESSAREA	Business Area		FIS_RBUSA	CHAR	8	TGSB
CONTROLLINGAREA	Controlling Area		FIS_KOKRS	CHAR	8	TKA01
SEGMENT	Segment for Segmental Reporting		FB_SEGMENT	CHAR	20	FAGL_SEGM
PARTNERCOSTCENTER	Partner Cost Center		FIS_SKOST	CHAR	20	CSKS
PARTNERPROFITCENTER	Partner Profit Center		FIS_PPRCTR	CHAR	20	CEPC
PARTNERFUNCTIONALAREA	Partner Functional Area		FIS_SFKBER	CHAR	32	TFKB
PARTNERBUSINESSAREA	Partner Business Area		FIS_PARGB	CHAR	8	TGSB
PARTNERCOMPANY	Company ID of Trading Partner		FIS_RASSC	CHAR	12	T880
PARTNERSEGMENT	Partner Segment for Segmental Reporting		FB_PSEGMENT	CHAR	20	FAGL_SEGM
SUPPLIER	Supplier		MD_SUPPLIER	CHAR	20	LFA1
CUSTOMER	Customer Number		KUNNR	CHAR	20	KNA1
WBSELEMENT	WBS Element		FIS_WBS	CHAR	48
REBUSINESSENTITY	Business Entity Number		REBDBENO	CHAR	16	*
REALESTATEBUILDING	Number of Building		REBDBUNO	CHAR	16
REALESTATEPROPERTY	Number of Land		REBDPRNO	CHAR	16
FUND	Fund		BP_GEBER	CHAR	20	*
BUDGETPERIOD	Budget Period		FM_BUDGET_PERIOD	CHAR	20	*
GRANTID	Grant		GM_GRANT_NBR	CHAR	40	*
PUBSECBUDGETACCOUNT	Budget Account		PSM_BDGT_ACCOUNT	CHAR	20	*
CASHLEDGERACCOUNT	Cash Origin Account		FIS_RE_ACCOUNT	CHAR	20	*
SPONSOREDPROGRAM	Sponsored Program		GM_SPONSORED_PROG	CHAR	40	*
SPONSOREDCLASS	Sponsored Class		GM_SPONSORED_CLASS	CHAR	40	*
PLANT	Plant		WERKS_D	CHAR	8	T001W
PRODUCT	Material Number		MATNR	CHAR	80	MARA
SHIPTOPARTY	Ship-to Party		KUNWE	CHAR	20	KNA1
PAOBJNR	Profitability Segment Number (CO-PA)		RKEOBJNR	NUMC	20
PARTNERFUND	Partner Fund		BP_P_GEBER	CHAR	20	*
PARTNERGRANT	Partner Grant		GM_GRANT_PARTNER	CHAR	40
CASHLEDGERCOMPANYCODE	Cash Origin Company Code		FIS_RE_BUKRS	CHAR	8	*
.INCLUDE	EXT			ACDOC_SI_EXT	0
.INCLUDE	JEI			INCL_EEW_ACDOC	0
ACDOC_EEW_DUMMY	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2
.INCLUDE	COB			INCL_EEW_COBL	0
.INCLUDE				CI_COBL	0
DUMMY_INCL_EEW_COBL	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2
.INCLUDE	CI_PRS_CPILS_2			CI_PRS_CPILS_2	0
.INCLUDE	VALUES			FINS_CLS_VALUES	0
BALANCETRANSACTIONCURRENCY	Balance Transaction Currency		FIS_RTCUR	CUKY	10	TCURC
AMOUNTINBALANCETRANSACCRCY	Amount in Balance Transaction Currency		FIS_TSL	CURR	12
COMPANYCODECURRENCY	Company Code Currency		FIS_HWAER	CUKY	10	TCURC
AMOUNTINCOMPANYCODECURRENCY	Amount in Company Code Currency		FIS_HSL	CURR	12
GLOBALCURRENCY	Global Currency		FIS_RKCUR	CUKY	10	TCURC
AMOUNTINGLOBALCURRENCY	Amount in Global Currency		FIS_KSL	CURR	12
FREEDEFINEDCURRENCY1	Freely Defined Currency 1		FIS_ROCUR	CUKY	10	TCURC
AMOUNTINFREEDEFINEDCURRENCY1	Amount in Freely Defined Currency 1		FIS_OSL	CURR	12
FREEDEFINEDCURRENCY2	Freely Defined Currency 2		FIS_RVCUR	CUKY	10	TCURC
AMOUNTINFREEDEFINEDCURRENCY2	Amount in Freely Defined Currency 2		FIS_VSL	CURR	12
FREEDEFINEDCURRENCY3	Freely Defined Currency 3		FINS_CURR3	CUKY	10	TCURC
AMOUNTINFREEDEFINEDCURRENCY3	Amount in Freely Defined Currency 3		FIS_BSL	CURR	12
FREEDEFINEDCURRENCY4	Freely Defined Currency 4		FINS_CURR4	CUKY	10	TCURC
AMOUNTINFREEDEFINEDCURRENCY4	Amount in Freely Defined Currency 4		FIS_CSL	CURR	12
FREEDEFINEDCURRENCY5	Freely Defined Currency 5		FINS_CURR5	CUKY	10	TCURC
AMOUNTINFREEDEFINEDCURRENCY5	Amount in Freely Defined Currency 5		FIS_DSL	CURR	12
FREEDEFINEDCURRENCY6	Freely Defined Currency 6		FINS_CURR6	CUKY	10	TCURC
AMOUNTINFREEDEFINEDCURRENCY6	Amount in Freely Defined Currency 6		FIS_ESL	CURR	12
FREEDEFINEDCURRENCY7	Freely Defined Currency 7		FIS_RFCUR	CUKY	10	TCURC
AMOUNTINFREEDEFINEDCURRENCY7	Amount in Freely Defined Currency 7		FIS_FSL	CURR	12
FREEDEFINEDCURRENCY8	Freely Defined Currency 8		FINS_CURR8	CUKY	10	TCURC
AMOUNTINFREEDEFINEDCURRENCY8	Amount in Freely Defined Currency 8		FIS_GSL	CURR	12
.INCLUDE	RL_AMOUNTS			FINS_CLS_VAL_RL_AMOUNTS	0
RESULT_LIST_AMNT1	Amount in Freely Defined Currency 1		FINS_VOCUR12	CURR	12
RESULT_LIST_CURR1	Freely Defined Currency 1		FINS_CURR1	CUKY	10	TCURC
RESULT_LIST_AMNT2	Amount in Freely Defined Currency 2		FINS_VVCUR12	CURR	12
RESULT_LIST_CURR2	Freely Defined Currency 2		FINS_CURR2	CUKY	10	TCURC
RESULT_LIST_AMNT3	Amount in Freely Defined Currency 3		FINS_VBCUR12	CURR	12
RESULT_LIST_CURR3	Freely Defined Currency 3		FINS_CURR3	CUKY	10	TCURC
RESULT_LIST_AMNT4	Amount in Freely Defined Currency 4		FINS_V4CUR12	CURR	12
RESULT_LIST_CURR4	Freely Defined Currency 4		FINS_CURR4	CUKY	10	TCURC
RESULT_LIST_AMNT5	Amount in Freely Defined Currency 5		FINS_V5CUR12	CURR	12
RESULT_LIST_CURR5	Freely Defined Currency 5		FINS_CURR5	CUKY	10	TCURC
RESULT_LIST_AMNT6	Amount in Freely Defined Currency 6		FINS_V6CUR12	CURR	12
RESULT_LIST_CURR6	Freely Defined Currency 6		FINS_CURR6	CUKY	10	TCURC
RESULT_LIST_AMNT7	Amount in Freely Defined Currency 7		FINS_V7CUR12	CURR	12
RESULT_LIST_CURR7	Freely Defined Currency 7		FINS_CURR7	CUKY	10	TCURC
RESULT_LIST_AMNT8	Amount in Freely Defined Currency 8		FINS_V8CUR12	CURR	12
RESULT_LIST_CURR8	Freely Defined Currency 8		FINS_CURR8	CUKY	10	TCURC
.INCLUDE	ADMIN			FINS_CLS_ADMIN	0
FINANCIALCLOSINGLINEITEMSTATUS	Financial Closing Run Line Item Status		CLS_LINE_ITEM_STATUS	CHAR	2
FINCLOSINGLINEITEMPROCESSSTEP	30 Characters		CHAR30	CHAR	60
FINANCIALCLOSINGLINEITEMTYPE	Financial Closing Run Type		CLS_LINE_ITEM_TYPE	CHAR	2
FINCLOSINGENTRYCALCULATIONTYPE	Financial Closing Entry Calculation Type		CLS_RUN_CALCULATION_TYPE	CHAR	60
LINE_TYPE	Financial closing valuation line type		FINS_CLS_VAL_LINE_TYPE	CHAR	100
LINE_ITEM_STATUS_DETAIL	Financial Closing Run Line Item Status Detail		CLS_LINE_ITEM_STATUS_DETAIL	CHAR	12
MARKED_FOR_DELETION	Entries are marked to be deleted		CLS_RUN_MARKED_FOR_DELETION	CHAR	2
.INCLUDE	IMP_ATTRIBUTES			FINS_CLS_IMP_WL_ATTRIBUTES	0
CREDITRISKCLASS	Credit Risk Class		CREDIT_RISK_CLASS	CHAR	6	UKM_RISK_CL
GENERALLEDGERAGINGINCREMENT	Aging Increment		FINS_INCRMNT	CHAR	30	*
EXPECTEDCREDITLOSSPERCENT	Expected Credit Loss Percentage		FINS_ECL_RATE	DEC	4
.INCLUDE				FINS_CLS_TAX	0
TAXCODE	Tax on Sales/Purchases Code		FIS_MWSKZ	CHAR	4	*
TAXCOUNTRY	Tax Reporting Country/Region		FOT_TAX_COUNTRY	CHAR	6