FINS_CLS_RUN_RL2

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
I_JrnlPerdEndClsgRunLogResult view from BASIC Related results of period end closing run log entry
ReclassPostNaviToDoc view_entity from

Fields (44)

KeyField Data ElementDescription DomainTypeLength
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)
);