FINS_CLS_RUN_MDC

Transparent Table Application Table
31 Fields 1 CDS Views

Universal Journal Closing Run Result List - MDC

FINS_CLS_RUN_MDC is an SAP database table in S/4HANA. Universal Journal Closing Run Result List - MDC. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_MstrDtaChgRunRsltListItm view_entity from BASIC MDC Result List Item

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY jrnlperdendclsgrunresultuuid CLS_RUN_RESULT_LIST_ID Result List UUID
KEY curtp CURTP Crcy type/val.
currency TARGETCURRENCY Functional Crcy
mdc_valn_amt CLS_MDC_VALN_AMT_TO_BE_ADJD Amt. To Be Adjd.
posted_mdc_amnt CLS_MDC_POSTED_AMOUNT Posted MDC
to_be_posted_mdc_amnt CLS_MDC_TO_BE_POSTED_AMT MDC To Be Posted
jrnlperiodendclosingrunloguuid CLS_RUN_ID Closing Run UUID
finclosingrunistestexecution CLS_RUN_IS_TEST_RUN Test Run
financialclosinglineitemstatus CLS_LINE_ITEM_STATUS Status
ledger FINS_LEDGER Ledger
companycode BUKRS Company Code
fiscalyear GJAHR Fiscal Year
accountingdocument CLS_MDC_POSTED_JOURNAL_ENTRY Posted Journal Entry
ledgergllineitem CLS_MDC_POSTED_JOURNAL_ITEM Posted Journal Item
postingdate FIS_BUDAT Posting Date
businesspartnername CLS_MDC_BUSINESS_PARTNER_NAME BP Name
businesspartnerid CLS_MDC_BUSINESS_PARTNER_NUMB BP Number
supplier MD_SUPPLIER Supplier
customer KUNNR Customer
reconciliationaccount CLS_MDC_RECON_ACCOUNT_OLD Old Rec. Accnt
newreconciliationaccount CLS_MDC_RECON_ACCOUNT_NEW New Rec. Accnt
partnercompany CLS_MDC_TRADING_PARTNER_OLD Old Company ID
newpartnercompany CLS_MDC_TRADING_PARTNER_NEW New Company ID
subledgeracctlineitemtype SLALITTYPE SLALineItemType
group_id CLS_RUN_GROUP_ID Group ID
grouping_rule FINS_VAL_GROUPING_RULE Grouping Rule
grouping_rule_step FINS_VAL_GROUPING_RULE_STEP Step of Grpng Rule
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

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 - MDC
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_CLS_RUN_MDC (
    CLIENT,                          -- abap.clnt
    JRNLPERDENDCLSGRUNRESULTUUID,    -- Result List UUID [CLS_RUN_RESULT_LIST_ID]
    CURTP,                           -- Crcy type/val. [CURTP]
    CURRENCY,                        -- Functional Crcy [TARGETCURRENCY]
    MDC_VALN_AMT,                    -- Amt. To Be Adjd. [CLS_MDC_VALN_AMT_TO_BE_ADJD]
    POSTED_MDC_AMNT,                 -- Posted MDC [CLS_MDC_POSTED_AMOUNT]
    TO_BE_POSTED_MDC_AMNT,           -- MDC To Be Posted [CLS_MDC_TO_BE_POSTED_AMT]
    JRNLPERIODENDCLOSINGRUNLOGUUID,  -- Closing Run UUID [CLS_RUN_ID]
    FINCLOSINGRUNISTESTEXECUTION,    -- Test Run [CLS_RUN_IS_TEST_RUN]
    FINANCIALCLOSINGLINEITEMSTATUS,  -- Status [CLS_LINE_ITEM_STATUS]
    LEDGER,                          -- Ledger [FINS_LEDGER]
    COMPANYCODE,                     -- Company Code [BUKRS]
    FISCALYEAR,                      -- Fiscal Year [GJAHR]
    ACCOUNTINGDOCUMENT,              -- Posted Journal Entry [CLS_MDC_POSTED_JOURNAL_ENTRY]
    LEDGERGLLINEITEM,                -- Posted Journal Item [CLS_MDC_POSTED_JOURNAL_ITEM]
    POSTINGDATE,                     -- Posting Date [FIS_BUDAT]
    BUSINESSPARTNERNAME,             -- BP Name [CLS_MDC_BUSINESS_PARTNER_NAME]
    BUSINESSPARTNERID,               -- BP Number [CLS_MDC_BUSINESS_PARTNER_NUMB]
    SUPPLIER,                        -- Supplier [MD_SUPPLIER]
    CUSTOMER,                        -- Customer [KUNNR]
    RECONCILIATIONACCOUNT,           -- Old Rec. Accnt [CLS_MDC_RECON_ACCOUNT_OLD]
    NEWRECONCILIATIONACCOUNT,        -- New Rec. Accnt [CLS_MDC_RECON_ACCOUNT_NEW]
    PARTNERCOMPANY,                  -- Old Company ID [CLS_MDC_TRADING_PARTNER_OLD]
    NEWPARTNERCOMPANY,               -- New Company ID [CLS_MDC_TRADING_PARTNER_NEW]
    SUBLEDGERACCTLINEITEMTYPE,       -- SLALineItemType [SLALITTYPE]
    GROUP_ID,                        -- Group ID [CLS_RUN_GROUP_ID]
    GROUPING_RULE,                   -- Grouping Rule [FINS_VAL_GROUPING_RULE]
    GROUPING_RULE_STEP,              -- Step of Grpng Rule [FINS_VAL_GROUPING_RULE_STEP]
    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]
    PRIMARY KEY (CLIENT, JRNLPERDENDCLSGRUNRESULTUUID, CURTP)
);

Learn More