FINS_CLS_RUN

Transparent Table Application Table
32 Fields 1 CDS Views

Universal Journal Closing Run Table

FINS_CLS_RUN is an SAP database table in S/4HANA. Universal Journal Closing Run Table. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_JrnlPeriodEndClosingRunLog view from BASIC Log entries for period end closing runs

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY jrnlperiodendclosingrunloguuid cls_run_id Closing Run UUID
jrnlperiodendclosingrunlogid cls_run_short_id Closing Run ID
businesstransactioncategory fins_bttype Bus. Trans. Category
businesstransactiontype fins_custbttype Bus. Trans. Type
financialclosingruntype cls_run_type Closing Run Type
financialclosingstep fins_closingstep Closing Step
jrnlperdendclsgruncrtndtetime cls_run_creation_time Started At
jrnlperdendclsgruncrtedbyuser cls_run_author Started By
jrnlperdendclsgrunchgddatetime cls_run_change_time Changed at
run_time_end cls_run_time_end Ended at
jrnlperdendclsgrunchgdbyuser cls_run_changer Changed by
finclsgrunconfignjsonstring cls_run_configuration Configuration
finclsgruninputparamjsonstr cls_run_input Configuration
financialclosingrunprogram cls_run_program
finclosingrunexecutionstatus cls_run_status Execution Status
finclosingrunbatchjobname btcjob Job Name
financialclosingrunbatchjob btcjobcnt Job No.
finclosingrunistestexecution cls_run_is_test_run Test Run
companycode bukrs Company Code
ledger rldnr Ledger
keydate vdm_v_key_date Key Date
fiscalyear fis_gjahr Fiscal Year
fiscalperiod fins_fiscalperiod Fiscal Period
msg_cnt_e balcnte E
msg_cnt_w balcntw W
duration cls_run_duration Closing run duration
number_obj_ok cls_run_obj_processed_ok Objects successfully
number_obj_fail cls_run_obj_processed_fail Objects fail
docln_ok cls_run_lines_posted Lines posted
docln_fail cls_run_lines_failed Lines failed
log_handle balloghndl Handle

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 Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_CLS_RUN (
    CLIENT,                          -- abap.clnt
    JRNLPERIODENDCLOSINGRUNLOGUUID,  -- Closing Run UUID [cls_run_id]
    JRNLPERIODENDCLOSINGRUNLOGID,    -- Closing Run ID [cls_run_short_id]
    BUSINESSTRANSACTIONCATEGORY,     -- Bus. Trans. Category [fins_bttype]
    BUSINESSTRANSACTIONTYPE,         -- Bus. Trans. Type [fins_custbttype]
    FINANCIALCLOSINGRUNTYPE,         -- Closing Run Type [cls_run_type]
    FINANCIALCLOSINGSTEP,            -- Closing Step [fins_closingstep]
    JRNLPERDENDCLSGRUNCRTNDTETIME,   -- Started At [cls_run_creation_time]
    JRNLPERDENDCLSGRUNCRTEDBYUSER,   -- Started By [cls_run_author]
    JRNLPERDENDCLSGRUNCHGDDATETIME,  -- Changed at [cls_run_change_time]
    RUN_TIME_END,                    -- Ended at [cls_run_time_end]
    JRNLPERDENDCLSGRUNCHGDBYUSER,    -- Changed by [cls_run_changer]
    FINCLSGRUNCONFIGNJSONSTRING,     -- Configuration [cls_run_configuration]
    FINCLSGRUNINPUTPARAMJSONSTR,     -- Configuration [cls_run_input]
    FINANCIALCLOSINGRUNPROGRAM,      -- cls_run_program
    FINCLOSINGRUNEXECUTIONSTATUS,    -- Execution Status [cls_run_status]
    FINCLOSINGRUNBATCHJOBNAME,       -- Job Name [btcjob]
    FINANCIALCLOSINGRUNBATCHJOB,     -- Job No. [btcjobcnt]
    FINCLOSINGRUNISTESTEXECUTION,    -- Test Run [cls_run_is_test_run]
    COMPANYCODE,                     -- Company Code [bukrs]
    LEDGER,                          -- Ledger [rldnr]
    KEYDATE,                         -- Key Date [vdm_v_key_date]
    FISCALYEAR,                      -- Fiscal Year [fis_gjahr]
    FISCALPERIOD,                    -- Fiscal Period [fins_fiscalperiod]
    MSG_CNT_E,                       -- E [balcnte]
    MSG_CNT_W,                       -- W [balcntw]
    DURATION,                        -- Closing run duration [cls_run_duration]
    NUMBER_OBJ_OK,                   -- Objects successfully [cls_run_obj_processed_ok]
    NUMBER_OBJ_FAIL,                 -- Objects fail [cls_run_obj_processed_fail]
    DOCLN_OK,                        -- Lines posted [cls_run_lines_posted]
    DOCLN_FAIL,                      -- Lines failed [cls_run_lines_failed]
    LOG_HANDLE,                      -- Handle [balloghndl]
    PRIMARY KEY (CLIENT, JRNLPERIODENDCLOSINGRUNLOGUUID)
);

Learn More