MSR_D_FIN_STATUS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AdvncdRetsMgmtCompnStatus | view | from | BASIC | ARM Compensation Status |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA