FINS_CLS_RUN

Transparent Table Application Table
30 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 30 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 (30)

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
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

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]
    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]
    PRIMARY KEY (CLIENT, JRNLPERIODENDCLOSINGRUNLOGUUID)
);

Learn More