MSR_D_FIN_STATUS

Transparent Table Application Table
22 Fields 1 CDS Views

Advanced Returns Management - Next Financial Steps

MSR_D_FIN_STATUS is an SAP database table in S/4HANA. Advanced Returns Management - Next Financial Steps. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AdvncdRetsMgmtCompnStatus view from BASIC ARM Compensation Status

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY msr_id MSR_PROCESS_ID Process ID No.
KEY item MSR_PROCESS_ITEM Item in Process
KEY split_id MSR_SPLIT_ID Split ID
KEY fin_step_counter MSR_COUNTER Counter
executed_seq_id MSR_SEQ_ID Sequence ID
next_fin_step_id MSR_STEP_ID Step ID
paying_status MSR_FIN_STATUS Refund. Status
earning_status MSR_FIN_STATUS Refund. Status
kunnr KUNNR Customer
paying_plant WERKS_D Plant
earning_plant WERKS_D Plant
lifnr LIFNR Supplier
vkorg VKORG Sales Org.
doc_type MSR_DOC_TYPE Doc. Type
doc_nr MSR_DOC_NR Document Number
doc_item MSR_DOC_ITEM Document Item
deviation MSR_FIN_DEVIATION Credit Deviat.
execution_type MSR_EXECUTION_TYPE Execution Type
error_timestamp TIMESTAMP Time Stamp
wait_for_credit MSR_WAIT_FOR_CREDIT Wait for CM
created_by ERNAM Created By

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.

-- Advanced Returns Management - Next Financial Steps
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSR_D_FIN_STATUS (
    MANDT,             -- Client [MANDT]
    MSR_ID,            -- Process ID No. [MSR_PROCESS_ID]
    ITEM,              -- Item in Process [MSR_PROCESS_ITEM]
    SPLIT_ID,          -- Split ID [MSR_SPLIT_ID]
    FIN_STEP_COUNTER,  -- Counter [MSR_COUNTER]
    EXECUTED_SEQ_ID,   -- Sequence ID [MSR_SEQ_ID]
    NEXT_FIN_STEP_ID,  -- Step ID [MSR_STEP_ID]
    PAYING_STATUS,     -- Refund. Status [MSR_FIN_STATUS]
    EARNING_STATUS,    -- Refund. Status [MSR_FIN_STATUS]
    KUNNR,             -- Customer [KUNNR]
    PAYING_PLANT,      -- Plant [WERKS_D]
    EARNING_PLANT,     -- Plant [WERKS_D]
    LIFNR,             -- Supplier [LIFNR]
    VKORG,             -- Sales Org. [VKORG]
    DOC_TYPE,          -- Doc. Type [MSR_DOC_TYPE]
    DOC_NR,            -- Document Number [MSR_DOC_NR]
    DOC_ITEM,          -- Document Item [MSR_DOC_ITEM]
    DEVIATION,         -- Credit Deviat. [MSR_FIN_DEVIATION]
    EXECUTION_TYPE,    -- Execution Type [MSR_EXECUTION_TYPE]
    ERROR_TIMESTAMP,   -- Time Stamp [TIMESTAMP]
    WAIT_FOR_CREDIT,   -- Wait for CM [MSR_WAIT_FOR_CREDIT]
    CREATED_BY,        -- Created By [ERNAM]
    PRIMARY KEY (MANDT, MSR_ID, ITEM, SPLIT_ID, FIN_STEP_COUNTER)
);

Learn More