FINS_CLS_RUN_RL2
Universal Journal Closing Run Result List
FINS_CLS_RUN_RL2 is an SAP database table in S/4HANA. Universal Journal Closing Run Result List. It contains 44 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_JrnlPerdEndClsgRunLogResult | view | from | BASIC | Related results of period end closing run log entry |
| ReclassPostNaviToDoc | view_entity | from |
Fields (44)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | abap.clnt | ||||
| KEY | jrnlperdendclsgrunresultuuid | cls_run_result_list_id | Result List UUID | |||
| jrnlperiodendclosingrunloguuid | cls_run_id | Closing Run UUID | ||||
| finclosingrunistestexecution | cls_run_is_test_run | Test Run | ||||
| financialclosinglineitemstatus | cls_line_item_status | Status | ||||
| financialclosinglineitemtype | cls_line_item_type | Line Item Type | ||||
| finclosingentrycalculationtype | cls_run_calculation_type | Calc. Line Type | ||||
| ledger | fins_ledger | Ledger | ||||
| companycode | bukrs | Company Code | ||||
| fiscalyear | gjahr | Fiscal Year | ||||
| accountingdocument | belnr_d | Document Number | ||||
| ledgergllineitem | docln6 | G/L Line Item | ||||
| finclsgrunrsltamtinfdcrcy1 | fins_vocur12 | Amount in Currency 1 | ||||
| finclsgrunrsltamtinfdcrcy2 | fins_vvcur12 | Amount in Currency 2 | ||||
| finclsgrunrsltamtinfdcrcy3 | fins_vbcur12 | Amount in Currency 3 | ||||
| finclsgrunrsltamtinfdcrcy4 | fins_v4cur12 | Amount in Currency 4 | ||||
| finclsgrunrsltamtinfdcrcy5 | fins_v5cur12 | Amount in Currency 5 | ||||
| finclsgrunrsltamtinfdcrcy6 | fins_v6cur12 | Amount in Currency 6 | ||||
| finclsgrunrsltamtinfdcrcy7 | fins_v7cur12 | Amount in Currency 7 | ||||
| finclsgrunrsltamtinfdcrcy8 | fins_v8cur12 | Amount in Currency 8 | ||||
| exchangerate | valuationexchangerate | Exch. Rate Key Date | ||||
| freedefinedcurrency1 | fins_curr1 | Free Defined Crcy 1 | ||||
| freedefinedcurrency2 | fins_curr2 | Free Defined Crcy 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 | fins_curr7 | Free Defined Crcy 7 | ||||
| freedefinedcurrency8 | fins_curr8 | Free Defined Crcy 8 | ||||
| finclosingvaluationcriterion | cls_run_valuation_criterion | Valuated by (Type) | ||||
| finclsgvaluationcriterionvalue | cls_run_valn_criterion_value | Valuated by Number | ||||
| subledgeracctlineitemtype | slalittype | SLALineItemType | ||||
| creditriskclass | credit_risk_class | Credit Risk Class | ||||
| generalledgeragingincrement | fins_incrmnt | Increment | ||||
| netduedate | netdt | Due On | ||||
| oldestopenitemnetduedate | cls_run_group_net_due_date | Group Net Due Date | ||||
| expectedcreditlosspercent | fins_ecl_rate | ECL Rate (%) | ||||
| 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 | ||||
| line_item_status_detail | cls_line_item_status_detail | Status Detail | ||||
| valuation_rule | fins_val_rule | Rule | ||||
| valuation_rule_step | fins_val_rule_step | Rule Step | ||||
| prdcssrperdendclsgrunrsltuuid | cls_prec_run_result_list_id | Predecessor Result List UUID |
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.
-- Universal Journal Closing Run Result List
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_CLS_RUN_RL2 (
CLIENT, -- abap.clnt
JRNLPERDENDCLSGRUNRESULTUUID, -- Result List UUID [cls_run_result_list_id]
JRNLPERIODENDCLOSINGRUNLOGUUID, -- Closing Run UUID [cls_run_id]
FINCLOSINGRUNISTESTEXECUTION, -- Test Run [cls_run_is_test_run]
FINANCIALCLOSINGLINEITEMSTATUS, -- Status [cls_line_item_status]
FINANCIALCLOSINGLINEITEMTYPE, -- Line Item Type [cls_line_item_type]
FINCLOSINGENTRYCALCULATIONTYPE, -- Calc. Line Type [cls_run_calculation_type]
LEDGER, -- Ledger [fins_ledger]
COMPANYCODE, -- Company Code [bukrs]
FISCALYEAR, -- Fiscal Year [gjahr]
ACCOUNTINGDOCUMENT, -- Document Number [belnr_d]
LEDGERGLLINEITEM, -- G/L Line Item [docln6]
FINCLSGRUNRSLTAMTINFDCRCY1, -- Amount in Currency 1 [fins_vocur12]
FINCLSGRUNRSLTAMTINFDCRCY2, -- Amount in Currency 2 [fins_vvcur12]
FINCLSGRUNRSLTAMTINFDCRCY3, -- Amount in Currency 3 [fins_vbcur12]
FINCLSGRUNRSLTAMTINFDCRCY4, -- Amount in Currency 4 [fins_v4cur12]
FINCLSGRUNRSLTAMTINFDCRCY5, -- Amount in Currency 5 [fins_v5cur12]
FINCLSGRUNRSLTAMTINFDCRCY6, -- Amount in Currency 6 [fins_v6cur12]
FINCLSGRUNRSLTAMTINFDCRCY7, -- Amount in Currency 7 [fins_v7cur12]
FINCLSGRUNRSLTAMTINFDCRCY8, -- Amount in Currency 8 [fins_v8cur12]
EXCHANGERATE, -- Exch. Rate Key Date [valuationexchangerate]
FREEDEFINEDCURRENCY1, -- Free Defined Crcy 1 [fins_curr1]
FREEDEFINEDCURRENCY2, -- Free Defined Crcy 2 [fins_curr2]
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, -- Free Defined Crcy 7 [fins_curr7]
FREEDEFINEDCURRENCY8, -- Free Defined Crcy 8 [fins_curr8]
FINCLOSINGVALUATIONCRITERION, -- Valuated by (Type) [cls_run_valuation_criterion]
FINCLSGVALUATIONCRITERIONVALUE, -- Valuated by Number [cls_run_valn_criterion_value]
SUBLEDGERACCTLINEITEMTYPE, -- SLALineItemType [slalittype]
CREDITRISKCLASS, -- Credit Risk Class [credit_risk_class]
GENERALLEDGERAGINGINCREMENT, -- Increment [fins_incrmnt]
NETDUEDATE, -- Due On [netdt]
OLDESTOPENITEMNETDUEDATE, -- Group Net Due Date [cls_run_group_net_due_date]
EXPECTEDCREDITLOSSPERCENT, -- ECL Rate (%) [fins_ecl_rate]
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]
LINE_ITEM_STATUS_DETAIL, -- Status Detail [cls_line_item_status_detail]
VALUATION_RULE, -- Rule [fins_val_rule]
VALUATION_RULE_STEP, -- Rule Step [fins_val_rule_step]
PRDCSSRPERDENDCLSGRUNRSLTUUID, -- Predecessor Result List UUID [cls_prec_run_result_list_id]
PRIMARY KEY (CLIENT, JRNLPERDENDCLSGRUNRESULTUUID)
);
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