FINS_CLS_WL
Temporary WorkList Table
FINS_CLS_WL is an SAP database table in S/4HANA. Temporary WorkList Table. It contains 181 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| VALUATIONREORGLINEITEM | view | from | ||
| VALUATIONWORKLIST | view_entity | from | Worklist View |
Fields (181)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | jrnlperiodendclosingrunloguuid | CLS_RUN_ID | Closing Run UUID | |||
| sourceledger | FINS_LEDGER_PERS | Source Ledger | ||||
| companycode | FIS_BUKRS | Company Code | ||||
| fiscalyear | FIS_GJAHR | Fiscal Year | ||||
| currentfiscalyear | FIS_GJAHR | Fiscal Year | ||||
| accountingdocument | FIS_BELNR | Journal Entry | ||||
| ledgergllineitem | FIS_DOCLN | Journal Entry Item | ||||
| newaccountingdocument | FIS_BELNR | Journal Entry | ||||
| newledgergllineitem | FIS_DOCLN | Journal Entry Item | ||||
| ledger | FINS_LEDGER | Ledger | ||||
| accountingprinciple | ACC_PRINCIPLE_LD_CMP | AP Ledger/CoCode | ||||
| lastchangedatetime | FIS_CHNG_TSTAMP | Last Changed At | ||||
| creationdatetime | FIS_CREA_TSTAMP | Creation Time | ||||
| glaccount | FIS_RACCT | G/L Account | ||||
| foreignexchangegainorlossgroup | CHAR72 | Long text - line width 72 | ||||
| grouping_rule | FINS_VAL_GROUPING_RULE | Grouping Rule | ||||
| grouping_rule_step | FINS_VAL_GROUPING_RULE_STEP | Step of Grpng Rule | ||||
| group_id | CLS_RUN_GROUP_ID | Group ID | ||||
| finclosingvaluationcriterion | CLS_RUN_VALUATION_CRITERION | Valuated by (Type) | ||||
| netduedate | FAEDT_FPOS | Net Due Date | ||||
| oldestopenitemnetduedate | CLS_RUN_GROUP_NET_DUE_DATE | Group Net Due Date | ||||
| subledgeracctlineitemtype | SLALITTYPE | SLALineItemType | ||||
| subledgeracctlineitemtypeoffs | SLALITTYPE | SLALineItemType | ||||
| chartofaccounts | FIS_KTOPL | Chart of Accounts | ||||
| postingdate | FIS_BUDAT | Posting Date | ||||
| documentdate | FIS_BLDAT | Journal Entry Date | ||||
| accountingdocumentcategory | FIS_BSTAT | Journal Entry Category | ||||
| isopenitemmanaged | FIS_XOPVW | Open Item Management | ||||
| is_cleared_at_keydate | FINS_CLS_IS_CLEARED_AT_KEYDATE | Cleared bef. Key Dte | ||||
| offsettingaccount | FX_UNREALIZED_LOSS | FX Loss Unrealized | ||||
| fiscalperiod | FINS_FISCALPERIOD | Fiscal Period | ||||
| debitcreditcode | FIS_SHKZG | Debit/Credit Code | ||||
| postingkey | FIS_BSCHL | Posting Key | ||||
| exchangerate | VALUATIONEXCHANGERATE | Exch. Rate Key Date | ||||
| temp_id | FINS_ACDOCTEMP_ID | Temp. Data ID | ||||
| result_list_id | CLS_RUN_RESULT_LIST_ID | Result List UUID | ||||
| account_type | KOART | Account type | ||||
| customer_supplier_group_key | KONZS | Group | ||||
| glaccount_type | GLACCOUNT_TYPE | G/L Account Type | ||||
| businesspartner | BU_PARTNER | Busn. Partner | ||||
| predecessorreferencedoctype | FINS_PREC_AWTYP | PrecRefTransact | ||||
| predecessorreferencedoccntxt | FINS_PREC_AWORG | PrecRefOrgUnit | ||||
| predecessorreferencedocument | FINS_PREC_AWREF | PrecRefDocument | ||||
| predecessorreferencedocitem | FINS_PREC_AWITEM | Prec. Ref. Doc. Item | ||||
| prdcssrjournalentrycompanycode | FINS_PREC_BUKRS_GFC | Predecessor Journal Entry Company Code | ||||
| prdcssrjournalentryfiscalyear | FINS_PREC_GJAHR_GFC | Predecessor Journal Entry Fiscal Year | ||||
| predecessorjournalentry | FINS_PREC_BELNR_GFC | Predecessor Journal Entry | ||||
| predecessorjournalentryitem | FINS_PREC_DOCLN_GFC | Predecessor Journal Entry Item | ||||
| invoiceitemreference | FIS_REBZZ | Invoice Item Reference | ||||
| invoicereference | FIS_REBZG | Invoice Reference | ||||
| invoicereferencefiscalyear | FIS_REBZJ | Invoice Reference Fiscal Year | ||||
| followondocumenttype | FARP_REBZT | Follow-On Doc.Type | ||||
| accountingdocumentitem | FIS_BUZEI | Posting View Item | ||||
| clearingdate | FIS_AUGDT | Clearing Date | ||||
| clearingaccountingdocument | FIS_AUGBL | Clearing Journal Entry | ||||
| clearingdocfiscalyear | FIS_AUGGJ | Fiscal Year of Clearing Journal Entry | ||||
| housebank | FARP_HBKID | House Bank | ||||
| housebankaccount | FAC_HKTID | House Bank Account | ||||
| costctractivitytype | LSTAR | Activity Type | ||||
| wbselementinternalid | FIS_WBSINT_NO_CONV | WBS Element Internal ID | ||||
| financialtransactiontype | FIS_RMVCT | Financial Transaction Type | ||||
| jointventure | JV_NAME | Joint venture | ||||
| jointventureequitygroup | JV_EGROUP_CDS | Joint Venture Equity Group | ||||
| partnerventure | JV_PVNAME_CDS | PartnerVenture | ||||
| jointventurepartner | JV_PART_CDS | Joint Venture Partner | ||||
| jointventurecostrecoverycode | JV_RECIND_CDS | Joint Venture Cost Recovery Code | ||||
| jointventureequitytype | JV_ETYPE_CDS | Joint Venture Equity Type | ||||
| projectnetwork | NPLNR | Network | ||||
| relatednetworkactivity | NPVRG | Netwk activity | ||||
| relatednetworkactivityinternal | CLS_RUN_NPLNR_VORGN_HELPER | Helper for posting network activity | ||||
| orderid | FIS_AUFNR | Order ID | ||||
| businessprocess | CO_PRZNR | Business Process | ||||
| salesorder | VDM_SALES_ORDER | Sales Order | ||||
| salesorderitem | SALES_ORDER_ITEM | Item | ||||
| costobject | KSTRG | Cost Object | ||||
| costcenter | FIS_KOSTL | Cost Center | ||||
| profitcenter | FIS_PRCTR | Profit Center | ||||
| functionalarea | FM_FAREA | Functional Area | ||||
| businessarea | FIS_RBUSA | Business Area | ||||
| controllingarea | FIS_KOKRS | Controlling Area | ||||
| segment | FB_SEGMENT | Segment | ||||
| partnercostcenter | FIS_SKOST | Partner Cost Center | ||||
| partnerprofitcenter | FIS_PPRCTR | Partner Profit Center | ||||
| partnerfunctionalarea | FIS_SFKBER | Partner Func. Area | ||||
| partnerbusinessarea | FIS_PARGB | Partner Bus. Area | ||||
| partnercompany | FIS_RASSC | Trading Partner | ||||
| partnersegment | FB_PSEGMENT | Partner Segment | ||||
| supplier | MD_SUPPLIER | Supplier | ||||
| customer | KUNNR | Customer | ||||
| wbselement | FIS_WBS | WBS Element | ||||
| rebusinessentity | REBDBENO | Business Entity | ||||
| realestatebuilding | REBDBUNO | Building | ||||
| realestateproperty | REBDPRNO | Land | ||||
| fund | BP_GEBER | Fund | ||||
| budgetperiod | FM_BUDGET_PERIOD | Budget Period | ||||
| grantid | GM_GRANT_NBR | Grant | ||||
| pubsecbudgetaccount | PSM_BDGT_ACCOUNT | Budget Account | ||||
| cashledgeraccount | FIS_RE_ACCOUNT | Cash Origin Account | ||||
| sponsoredprogram | GM_SPONSORED_PROG | Sponsored Program | ||||
| sponsoredclass | GM_SPONSORED_CLASS | Sponsored Class | ||||
| plant | WERKS_D | Plant | ||||
| product | MATNR | Material | ||||
| shiptoparty | KUNWE | Ship-to Party | ||||
| paobjnr | RKEOBJNR | Profit. segment | ||||
| partnerfund | BP_P_GEBER | Partner Fund | ||||
| partnergrant | GM_GRANT_PARTNER | Partner Grant | ||||
| cashledgercompanycode | FIS_RE_BUKRS | Cash Origin CoCode | ||||
| fundscenter | FARP_FISTL | Funds Center | ||||
| partnerequitygroup | JV_PEGRUP | Partner EG (JVA) | ||||
| fundedprogram | FM_MEASURE | Funded Program | ||||
| partnerbudgetperiod | FIS_FM_PBUDGET_PERIOD | Partner Budget Period | ||||
| assignmentreference | DZUONR | Assignment | ||||
| financialvaluationobjecttype | VAL_OBJ_TYPE | Type of Fin.Val.Obj. | ||||
| financialvaluationobject | VAL_OBJ_ID | Fin Valuation Object | ||||
| financialvaluationsubobject | VAL_SUBOBJ_ID | Fin.Val.Sub.Object | ||||
| pubsecbudgetaccountcocode | PSM_BDGT_ACCOUNT_COCODE | Company Code for Budget Account | ||||
| servicedocument | FCO_SRVDOC_ID | Service Document | ||||
| servicedocumentitem | FCO_SRVDOC_ITEM_ID | Service Doc. Item | ||||
| servicedocumenttype | FCO_SRVDOC_TYPE | Service Doc. Type | ||||
| material | MATNR | Material | ||||
| accrualobjecttype | ACR_OBJ_TYPE | Accrual Object Type | ||||
| accrualobject | ACR_OBJ_ID | Accrual Object | ||||
| accrualsubobject | ACR_SUBOBJ_ID | Accrual Subobject | ||||
| accrualitemtype | ACR_ITEM_TYPE | Accrual Item Type | ||||
| accrualreferenceobject | ACR_REFOBJ_ID | Acr. Reference ID | ||||
| accrualobjectlogicalsystem | ACR_LOGSYS | Logical Syst. AcrObj | ||||
| acdoc_eew_dummy | CFD_DUMMY | Dummy | ||||
| dummy_incl_eew_cobl | CFD_DUMMY | Dummy | ||||
| amountinbalancetransaccrcy | FIS_TSL | Amount in Balance Transaction Currency | ||||
| amountincompanycodecurrency | FIS_HSL | Amount in Company Code Currency | ||||
| amountinglobalcurrency | FIS_KSL | Amount in Global Currency | ||||
| amountinfreedefinedcurrency1 | FIS_OSL | Amount in Freely Defined Currency 1 | ||||
| amountinfreedefinedcurrency2 | FIS_VSL | Amount in Freely Defined Currency 2 | ||||
| amountinfreedefinedcurrency3 | FIS_BSL | Amount in Freely Defined Currency 3 | ||||
| amountinfreedefinedcurrency4 | FIS_CSL | Amount in Freely Defined Currency 4 | ||||
| amountinfreedefinedcurrency5 | FIS_DSL | Amount in Freely Defined Currency 5 | ||||
| amountinfreedefinedcurrency6 | FIS_ESL | Amount in Freely Defined Currency 6 | ||||
| amountinfreedefinedcurrency7 | FIS_FSL | Amount in Freely Defined Currency 7 | ||||
| amountinfreedefinedcurrency8 | FIS_GSL | Amount in Freely Defined Currency 8 | ||||
| balancetransactioncurrency | FIS_RTCUR | Balance Transaction Currency | ||||
| companycodecurrency | FIS_HWAER | Company Code Currency | ||||
| globalcurrency | FIS_RKCUR | Global Currency | ||||
| freedefinedcurrency1 | FIS_ROCUR | Freely Defined Currency 1 | ||||
| freedefinedcurrency2 | FIS_RVCUR | Freely Defined Currency 2 | ||||
| freedefinedcurrency3 | FINS_CURR3 | Free Defined Crcy 3 | ||||
| freedefinedcurrency4 | FINS_CURR4 | Free Defined Crcy 4 | ||||
| freedefinedcurrency5 | FINS_CURR5 | Free Defined Crcy 5 | ||||
| freedefinedcurrency6 | FINS_CURR6 | Free Defined Crcy 6 | ||||
| freedefinedcurrency7 | FIS_RFCUR | Freely Defined Currency 7 | ||||
| freedefinedcurrency8 | FINS_CURR8 | Free Defined Crcy 8 | ||||
| result_list_amnt1 | FINS_VOCUR12 | Amount in Currency 1 | ||||
| result_list_curr1 | FINS_CURR1 | Free Defined Crcy 1 | ||||
| result_list_amnt2 | FINS_VVCUR12 | Amount in Currency 2 | ||||
| result_list_curr2 | FINS_CURR2 | Free Defined Crcy 2 | ||||
| result_list_amnt3 | FINS_VBCUR12 | Amount in Currency 3 | ||||
| result_list_curr3 | FINS_CURR3 | Free Defined Crcy 3 | ||||
| result_list_amnt4 | FINS_V4CUR12 | Amount in Currency 4 | ||||
| result_list_curr4 | FINS_CURR4 | Free Defined Crcy 4 | ||||
| result_list_amnt5 | FINS_V5CUR12 | Amount in Currency 5 | ||||
| result_list_curr5 | FINS_CURR5 | Free Defined Crcy 5 | ||||
| result_list_amnt6 | FINS_V6CUR12 | Amount in Currency 6 | ||||
| result_list_curr6 | FINS_CURR6 | Free Defined Crcy 6 | ||||
| result_list_amnt7 | FINS_V7CUR12 | Amount in Currency 7 | ||||
| result_list_curr7 | FINS_CURR7 | Free Defined Crcy 7 | ||||
| result_list_amnt8 | FINS_V8CUR12 | Amount in Currency 8 | ||||
| result_list_curr8 | FINS_CURR8 | Free Defined Crcy 8 | ||||
| financialclosinglineitemstatus | CLS_LINE_ITEM_STATUS | Status | ||||
| finclosinglineitemprocessstep | CHAR30 | 30 Characters | ||||
| financialclosinglineitemtype | CLS_LINE_ITEM_TYPE | Line Item Type | ||||
| finclosingentrycalculationtype | CLS_RUN_CALCULATION_TYPE | Calc. Line Type | ||||
| line_type | FINS_CLS_VAL_LINE_TYPE | Valuation line type | ||||
| line_item_status_detail | CLS_LINE_ITEM_STATUS_DETAIL | Status Detail | ||||
| marked_for_deletion | CLS_RUN_MARKED_FOR_DELETION | Entries are marked to be deleted | ||||
| valuation_rule_step | FINS_VAL_RULE_STEP | Rule Step | ||||
| creditriskclass | CREDIT_RISK_CLASS | Credit Risk Class | ||||
| generalledgeragingincrement | FINS_INCRMNT | Increment | ||||
| generalledgeragingscope | FINS_AGING | Aging | ||||
| expectedcreditlosspercent | FINS_ECL_RATE | ECL Rate (%) | ||||
| taxcode | FIS_MWSKZ | Tax Code | ||||
| taxcountry | FOT_TAX_COUNTRY | Tax Ctry/Reg. |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Temporary WorkList Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_CLS_WL (
CLIENT, -- Client [MANDT]
JRNLPERIODENDCLOSINGRUNLOGUUID, -- Closing Run UUID [CLS_RUN_ID]
SOURCELEDGER, -- Source Ledger [FINS_LEDGER_PERS]
COMPANYCODE, -- Company Code [FIS_BUKRS]
FISCALYEAR, -- Fiscal Year [FIS_GJAHR]
CURRENTFISCALYEAR, -- Fiscal Year [FIS_GJAHR]
ACCOUNTINGDOCUMENT, -- Journal Entry [FIS_BELNR]
LEDGERGLLINEITEM, -- Journal Entry Item [FIS_DOCLN]
NEWACCOUNTINGDOCUMENT, -- Journal Entry [FIS_BELNR]
NEWLEDGERGLLINEITEM, -- Journal Entry Item [FIS_DOCLN]
LEDGER, -- Ledger [FINS_LEDGER]
ACCOUNTINGPRINCIPLE, -- AP Ledger/CoCode [ACC_PRINCIPLE_LD_CMP]
LASTCHANGEDATETIME, -- Last Changed At [FIS_CHNG_TSTAMP]
CREATIONDATETIME, -- Creation Time [FIS_CREA_TSTAMP]
GLACCOUNT, -- G/L Account [FIS_RACCT]
FOREIGNEXCHANGEGAINORLOSSGROUP, -- Long text - line width 72 [CHAR72]
GROUPING_RULE, -- Grouping Rule [FINS_VAL_GROUPING_RULE]
GROUPING_RULE_STEP, -- Step of Grpng Rule [FINS_VAL_GROUPING_RULE_STEP]
GROUP_ID, -- Group ID [CLS_RUN_GROUP_ID]
FINCLOSINGVALUATIONCRITERION, -- Valuated by (Type) [CLS_RUN_VALUATION_CRITERION]
NETDUEDATE, -- Net Due Date [FAEDT_FPOS]
OLDESTOPENITEMNETDUEDATE, -- Group Net Due Date [CLS_RUN_GROUP_NET_DUE_DATE]
SUBLEDGERACCTLINEITEMTYPE, -- SLALineItemType [SLALITTYPE]
SUBLEDGERACCTLINEITEMTYPEOFFS, -- SLALineItemType [SLALITTYPE]
CHARTOFACCOUNTS, -- Chart of Accounts [FIS_KTOPL]
POSTINGDATE, -- Posting Date [FIS_BUDAT]
DOCUMENTDATE, -- Journal Entry Date [FIS_BLDAT]
ACCOUNTINGDOCUMENTCATEGORY, -- Journal Entry Category [FIS_BSTAT]
ISOPENITEMMANAGED, -- Open Item Management [FIS_XOPVW]
IS_CLEARED_AT_KEYDATE, -- Cleared bef. Key Dte [FINS_CLS_IS_CLEARED_AT_KEYDATE]
OFFSETTINGACCOUNT, -- FX Loss Unrealized [FX_UNREALIZED_LOSS]
FISCALPERIOD, -- Fiscal Period [FINS_FISCALPERIOD]
DEBITCREDITCODE, -- Debit/Credit Code [FIS_SHKZG]
POSTINGKEY, -- Posting Key [FIS_BSCHL]
EXCHANGERATE, -- Exch. Rate Key Date [VALUATIONEXCHANGERATE]
TEMP_ID, -- Temp. Data ID [FINS_ACDOCTEMP_ID]
RESULT_LIST_ID, -- Result List UUID [CLS_RUN_RESULT_LIST_ID]
ACCOUNT_TYPE, -- Account type [KOART]
CUSTOMER_SUPPLIER_GROUP_KEY, -- Group [KONZS]
GLACCOUNT_TYPE, -- G/L Account Type [GLACCOUNT_TYPE]
BUSINESSPARTNER, -- Busn. Partner [BU_PARTNER]
PREDECESSORREFERENCEDOCTYPE, -- PrecRefTransact [FINS_PREC_AWTYP]
PREDECESSORREFERENCEDOCCNTXT, -- PrecRefOrgUnit [FINS_PREC_AWORG]
PREDECESSORREFERENCEDOCUMENT, -- PrecRefDocument [FINS_PREC_AWREF]
PREDECESSORREFERENCEDOCITEM, -- Prec. Ref. Doc. Item [FINS_PREC_AWITEM]
PRDCSSRJOURNALENTRYCOMPANYCODE, -- Predecessor Journal Entry Company Code [FINS_PREC_BUKRS_GFC]
PRDCSSRJOURNALENTRYFISCALYEAR, -- Predecessor Journal Entry Fiscal Year [FINS_PREC_GJAHR_GFC]
PREDECESSORJOURNALENTRY, -- Predecessor Journal Entry [FINS_PREC_BELNR_GFC]
PREDECESSORJOURNALENTRYITEM, -- Predecessor Journal Entry Item [FINS_PREC_DOCLN_GFC]
INVOICEITEMREFERENCE, -- Invoice Item Reference [FIS_REBZZ]
INVOICEREFERENCE, -- Invoice Reference [FIS_REBZG]
INVOICEREFERENCEFISCALYEAR, -- Invoice Reference Fiscal Year [FIS_REBZJ]
FOLLOWONDOCUMENTTYPE, -- Follow-On Doc.Type [FARP_REBZT]
ACCOUNTINGDOCUMENTITEM, -- Posting View Item [FIS_BUZEI]
CLEARINGDATE, -- Clearing Date [FIS_AUGDT]
CLEARINGACCOUNTINGDOCUMENT, -- Clearing Journal Entry [FIS_AUGBL]
CLEARINGDOCFISCALYEAR, -- Fiscal Year of Clearing Journal Entry [FIS_AUGGJ]
HOUSEBANK, -- House Bank [FARP_HBKID]
HOUSEBANKACCOUNT, -- House Bank Account [FAC_HKTID]
COSTCTRACTIVITYTYPE, -- Activity Type [LSTAR]
WBSELEMENTINTERNALID, -- WBS Element Internal ID [FIS_WBSINT_NO_CONV]
FINANCIALTRANSACTIONTYPE, -- Financial Transaction Type [FIS_RMVCT]
JOINTVENTURE, -- Joint venture [JV_NAME]
JOINTVENTUREEQUITYGROUP, -- Joint Venture Equity Group [JV_EGROUP_CDS]
PARTNERVENTURE, -- PartnerVenture [JV_PVNAME_CDS]
JOINTVENTUREPARTNER, -- Joint Venture Partner [JV_PART_CDS]
JOINTVENTURECOSTRECOVERYCODE, -- Joint Venture Cost Recovery Code [JV_RECIND_CDS]
JOINTVENTUREEQUITYTYPE, -- Joint Venture Equity Type [JV_ETYPE_CDS]
PROJECTNETWORK, -- Network [NPLNR]
RELATEDNETWORKACTIVITY, -- Netwk activity [NPVRG]
RELATEDNETWORKACTIVITYINTERNAL, -- Helper for posting network activity [CLS_RUN_NPLNR_VORGN_HELPER]
ORDERID, -- Order ID [FIS_AUFNR]
BUSINESSPROCESS, -- Business Process [CO_PRZNR]
SALESORDER, -- Sales Order [VDM_SALES_ORDER]
SALESORDERITEM, -- Item [SALES_ORDER_ITEM]
COSTOBJECT, -- Cost Object [KSTRG]
COSTCENTER, -- Cost Center [FIS_KOSTL]
PROFITCENTER, -- Profit Center [FIS_PRCTR]
FUNCTIONALAREA, -- Functional Area [FM_FAREA]
BUSINESSAREA, -- Business Area [FIS_RBUSA]
CONTROLLINGAREA, -- Controlling Area [FIS_KOKRS]
SEGMENT, -- Segment [FB_SEGMENT]
PARTNERCOSTCENTER, -- Partner Cost Center [FIS_SKOST]
PARTNERPROFITCENTER, -- Partner Profit Center [FIS_PPRCTR]
PARTNERFUNCTIONALAREA, -- Partner Func. Area [FIS_SFKBER]
PARTNERBUSINESSAREA, -- Partner Bus. Area [FIS_PARGB]
PARTNERCOMPANY, -- Trading Partner [FIS_RASSC]
PARTNERSEGMENT, -- Partner Segment [FB_PSEGMENT]
SUPPLIER, -- Supplier [MD_SUPPLIER]
CUSTOMER, -- Customer [KUNNR]
WBSELEMENT, -- WBS Element [FIS_WBS]
REBUSINESSENTITY, -- Business Entity [REBDBENO]
REALESTATEBUILDING, -- Building [REBDBUNO]
REALESTATEPROPERTY, -- Land [REBDPRNO]
FUND, -- Fund [BP_GEBER]
BUDGETPERIOD, -- Budget Period [FM_BUDGET_PERIOD]
GRANTID, -- Grant [GM_GRANT_NBR]
PUBSECBUDGETACCOUNT, -- Budget Account [PSM_BDGT_ACCOUNT]
CASHLEDGERACCOUNT, -- Cash Origin Account [FIS_RE_ACCOUNT]
SPONSOREDPROGRAM, -- Sponsored Program [GM_SPONSORED_PROG]
SPONSOREDCLASS, -- Sponsored Class [GM_SPONSORED_CLASS]
PLANT, -- Plant [WERKS_D]
PRODUCT, -- Material [MATNR]
SHIPTOPARTY, -- Ship-to Party [KUNWE]
PAOBJNR, -- Profit. segment [RKEOBJNR]
PARTNERFUND, -- Partner Fund [BP_P_GEBER]
PARTNERGRANT, -- Partner Grant [GM_GRANT_PARTNER]
CASHLEDGERCOMPANYCODE, -- Cash Origin CoCode [FIS_RE_BUKRS]
FUNDSCENTER, -- Funds Center [FARP_FISTL]
PARTNEREQUITYGROUP, -- Partner EG (JVA) [JV_PEGRUP]
FUNDEDPROGRAM, -- Funded Program [FM_MEASURE]
PARTNERBUDGETPERIOD, -- Partner Budget Period [FIS_FM_PBUDGET_PERIOD]
ASSIGNMENTREFERENCE, -- Assignment [DZUONR]
FINANCIALVALUATIONOBJECTTYPE, -- Type of Fin.Val.Obj. [VAL_OBJ_TYPE]
FINANCIALVALUATIONOBJECT, -- Fin Valuation Object [VAL_OBJ_ID]
FINANCIALVALUATIONSUBOBJECT, -- Fin.Val.Sub.Object [VAL_SUBOBJ_ID]
PUBSECBUDGETACCOUNTCOCODE, -- Company Code for Budget Account [PSM_BDGT_ACCOUNT_COCODE]
SERVICEDOCUMENT, -- Service Document [FCO_SRVDOC_ID]
SERVICEDOCUMENTITEM, -- Service Doc. Item [FCO_SRVDOC_ITEM_ID]
SERVICEDOCUMENTTYPE, -- Service Doc. Type [FCO_SRVDOC_TYPE]
MATERIAL, -- Material [MATNR]
ACCRUALOBJECTTYPE, -- Accrual Object Type [ACR_OBJ_TYPE]
ACCRUALOBJECT, -- Accrual Object [ACR_OBJ_ID]
ACCRUALSUBOBJECT, -- Accrual Subobject [ACR_SUBOBJ_ID]
ACCRUALITEMTYPE, -- Accrual Item Type [ACR_ITEM_TYPE]
ACCRUALREFERENCEOBJECT, -- Acr. Reference ID [ACR_REFOBJ_ID]
ACCRUALOBJECTLOGICALSYSTEM, -- Logical Syst. AcrObj [ACR_LOGSYS]
ACDOC_EEW_DUMMY, -- Dummy [CFD_DUMMY]
DUMMY_INCL_EEW_COBL, -- Dummy [CFD_DUMMY]
AMOUNTINBALANCETRANSACCRCY, -- Amount in Balance Transaction Currency [FIS_TSL]
AMOUNTINCOMPANYCODECURRENCY, -- Amount in Company Code Currency [FIS_HSL]
AMOUNTINGLOBALCURRENCY, -- Amount in Global Currency [FIS_KSL]
AMOUNTINFREEDEFINEDCURRENCY1, -- Amount in Freely Defined Currency 1 [FIS_OSL]
AMOUNTINFREEDEFINEDCURRENCY2, -- Amount in Freely Defined Currency 2 [FIS_VSL]
AMOUNTINFREEDEFINEDCURRENCY3, -- Amount in Freely Defined Currency 3 [FIS_BSL]
AMOUNTINFREEDEFINEDCURRENCY4, -- Amount in Freely Defined Currency 4 [FIS_CSL]
AMOUNTINFREEDEFINEDCURRENCY5, -- Amount in Freely Defined Currency 5 [FIS_DSL]
AMOUNTINFREEDEFINEDCURRENCY6, -- Amount in Freely Defined Currency 6 [FIS_ESL]
AMOUNTINFREEDEFINEDCURRENCY7, -- Amount in Freely Defined Currency 7 [FIS_FSL]
AMOUNTINFREEDEFINEDCURRENCY8, -- Amount in Freely Defined Currency 8 [FIS_GSL]
BALANCETRANSACTIONCURRENCY, -- Balance Transaction Currency [FIS_RTCUR]
COMPANYCODECURRENCY, -- Company Code Currency [FIS_HWAER]
GLOBALCURRENCY, -- Global Currency [FIS_RKCUR]
FREEDEFINEDCURRENCY1, -- Freely Defined Currency 1 [FIS_ROCUR]
FREEDEFINEDCURRENCY2, -- Freely Defined Currency 2 [FIS_RVCUR]
FREEDEFINEDCURRENCY3, -- Free Defined Crcy 3 [FINS_CURR3]
FREEDEFINEDCURRENCY4, -- Free Defined Crcy 4 [FINS_CURR4]
FREEDEFINEDCURRENCY5, -- Free Defined Crcy 5 [FINS_CURR5]
FREEDEFINEDCURRENCY6, -- Free Defined Crcy 6 [FINS_CURR6]
FREEDEFINEDCURRENCY7, -- Freely Defined Currency 7 [FIS_RFCUR]
FREEDEFINEDCURRENCY8, -- Free Defined Crcy 8 [FINS_CURR8]
RESULT_LIST_AMNT1, -- Amount in Currency 1 [FINS_VOCUR12]
RESULT_LIST_CURR1, -- Free Defined Crcy 1 [FINS_CURR1]
RESULT_LIST_AMNT2, -- Amount in Currency 2 [FINS_VVCUR12]
RESULT_LIST_CURR2, -- Free Defined Crcy 2 [FINS_CURR2]
RESULT_LIST_AMNT3, -- Amount in Currency 3 [FINS_VBCUR12]
RESULT_LIST_CURR3, -- Free Defined Crcy 3 [FINS_CURR3]
RESULT_LIST_AMNT4, -- Amount in Currency 4 [FINS_V4CUR12]
RESULT_LIST_CURR4, -- Free Defined Crcy 4 [FINS_CURR4]
RESULT_LIST_AMNT5, -- Amount in Currency 5 [FINS_V5CUR12]
RESULT_LIST_CURR5, -- Free Defined Crcy 5 [FINS_CURR5]
RESULT_LIST_AMNT6, -- Amount in Currency 6 [FINS_V6CUR12]
RESULT_LIST_CURR6, -- Free Defined Crcy 6 [FINS_CURR6]
RESULT_LIST_AMNT7, -- Amount in Currency 7 [FINS_V7CUR12]
RESULT_LIST_CURR7, -- Free Defined Crcy 7 [FINS_CURR7]
RESULT_LIST_AMNT8, -- Amount in Currency 8 [FINS_V8CUR12]
RESULT_LIST_CURR8, -- Free Defined Crcy 8 [FINS_CURR8]
FINANCIALCLOSINGLINEITEMSTATUS, -- Status [CLS_LINE_ITEM_STATUS]
FINCLOSINGLINEITEMPROCESSSTEP, -- 30 Characters [CHAR30]
FINANCIALCLOSINGLINEITEMTYPE, -- Line Item Type [CLS_LINE_ITEM_TYPE]
FINCLOSINGENTRYCALCULATIONTYPE, -- Calc. Line Type [CLS_RUN_CALCULATION_TYPE]
LINE_TYPE, -- Valuation line type [FINS_CLS_VAL_LINE_TYPE]
LINE_ITEM_STATUS_DETAIL, -- Status Detail [CLS_LINE_ITEM_STATUS_DETAIL]
MARKED_FOR_DELETION, -- Entries are marked to be deleted [CLS_RUN_MARKED_FOR_DELETION]
VALUATION_RULE_STEP, -- Rule Step [FINS_VAL_RULE_STEP]
CREDITRISKCLASS, -- Credit Risk Class [CREDIT_RISK_CLASS]
GENERALLEDGERAGINGINCREMENT, -- Increment [FINS_INCRMNT]
GENERALLEDGERAGINGSCOPE, -- Aging [FINS_AGING]
EXPECTEDCREDITLOSSPERCENT, -- ECL Rate (%) [FINS_ECL_RATE]
TAXCODE, -- Tax Code [FIS_MWSKZ]
TAXCOUNTRY, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
PRIMARY KEY (CLIENT, JRNLPERIODENDCLOSINGRUNLOGUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA