MSR_D_EXECUTED

Transparent Table Application Table
60 Fields 6 CDS Views

Advanced Returns Management # Tracking of Executed Steps

MSR_D_EXECUTED is an SAP database table in S/4HANA. Advanced Returns Management # Tracking of Executed Steps. It contains 60 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
CIC_RETURNSINFO view_entity from Advanced Returns Management (Industry Cloud Solutions)
I_AdvncdRetsMgmtProcExecuted view from BASIC Advanced Returns Mgmt Process Executed
I_CustRetItmFllwUpActivity view from BASIC Returns Order Item Follow-up Activity
I_RetsMgmtProcItmInspExec view from BASIC Returns Mgmt Process Item Inspection Execution
I_RetsMgmtProcItmRetOrdExec view from BASIC Returns Mgmt Process Item Return Order Execution
P_RetsMgmtProcessItemExec2 view from BASIC

Fields (60)

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 executed_step_id MSR_STEP_ID Step ID
KEY doc_type MSR_DOC_TYPE Doc. Type
KEY doc_nr MSR_DOC_NR Document Number
KEY doc_item MSR_DOC_ITEM Document Item
doc_status MSR_DOC_STATUS Item Status
appr_status MSR_APPROVAL_STATUS Approval Status
executed_seq_id MSR_SEQ_ID Sequence ID
chain_id MSR_CHAIN_ID Chain ID
created_on TIMESTAMP Time Stamp
created_by USER Chgd by
created_lfe MSR_CREATED_LFE Auto. Created
changed_on TIMESTAMP Time Stamp
changed_by USER Chgd by
quantity MSR_QUANTITY Return Qty
unit MEINS Base Unit
werks WERKS_D Plant
lgort LGORT_D Location
insmk INSMK Stock Type
reswk WERKS_D Plant
lifnr LIFNR Supplier
addrnumber AD_ADDRNUM Address Number
rma_vendor MSR_VRMA_NR Supplier RMA
rma_vendor_req MSR_VRMA_REQ RMA Required
inspection_code MSR_INSPECTION_CODE Inspection Code
refund_code MSR_RETURNS_REFUND_CODE Refund Code
refund_control MSR_REFUND_CONTROL Refund Control
ret_reason MSR_RETURNS_REASON Return Reason
replace_matnr MSR_REPLACE_MATNR Repl. Material
replace_qty MSR_REPLACE_QTY Repl. Quantity
replace_unit MSR_REPLACE_UNIT Repl. Mat. UoM
posguid POSGUID Item indicator
replaced_qty MSR_REPLACED_QTY Replaced Qty
replaced_unit MSR_REPLACED_UNIT Repl. Qty UoM
cmr_qty MSR_CMR_QTY CMR Quantity
cmr_unit MSR_CMR_UNIT CMR UoM
abgru ABGRU_VA RejectionReason
refund_type MSR_REFUND_TYPE Refund Type
paying_plant MSR_REPLACE_PLANT Supplying Plant
pre_refund MSR_PRELIMINARY_REFUND Prelim. Refund
replace_released MSR_REPLACEMENT_RELEASED Release SDF
refund_released MSR_REFUNDING_RELEASED Release CMR
replace_request MSR_REPLACEMENT_REQUESTED Repl. Requested
sobkz SOBKZ Special Stock
billing_block MSR_BILLING_BLOCK Billing Block
delivery_block MSR_DELIVERY_BLOCK Delivery Block
ref_doc_type MSR_DOC_TYPE Doc. Type
ref_doc_nr MSR_DOC_NR Document Number
ref_doc_item MSR_DOC_ITEM Document Item
received_matnr MSR_REP_REPLACE_MATNR Repl. Material
fu_code_erp MSR_FU_CODE_ERP FU Code in ERP
im_plant MSR_PLANT_SPECIFIED Target Plant
im_material MSR_MAT_SPECIFIED Target Material
matnr MATNR Material
vrm_complete MSR_VRM_COMPLETE Compl.Log.Proc.
lifex LIFEX Ext. Delivery
abgru_text ABGRU_TEXT Reason for Rejection

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 # Tracking of Executed Steps
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSR_D_EXECUTED (
    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]
    EXECUTED_STEP_ID,  -- Step ID [MSR_STEP_ID]
    DOC_TYPE,          -- Doc. Type [MSR_DOC_TYPE]
    DOC_NR,            -- Document Number [MSR_DOC_NR]
    DOC_ITEM,          -- Document Item [MSR_DOC_ITEM]
    DOC_STATUS,        -- Item Status [MSR_DOC_STATUS]
    APPR_STATUS,       -- Approval Status [MSR_APPROVAL_STATUS]
    EXECUTED_SEQ_ID,   -- Sequence ID [MSR_SEQ_ID]
    CHAIN_ID,          -- Chain ID [MSR_CHAIN_ID]
    CREATED_ON,        -- Time Stamp [TIMESTAMP]
    CREATED_BY,        -- Chgd by [USER]
    CREATED_LFE,       -- Auto. Created [MSR_CREATED_LFE]
    CHANGED_ON,        -- Time Stamp [TIMESTAMP]
    CHANGED_BY,        -- Chgd by [USER]
    QUANTITY,          -- Return Qty [MSR_QUANTITY]
    UNIT,              -- Base Unit [MEINS]
    WERKS,             -- Plant [WERKS_D]
    LGORT,             -- Location [LGORT_D]
    INSMK,             -- Stock Type [INSMK]
    RESWK,             -- Plant [WERKS_D]
    LIFNR,             -- Supplier [LIFNR]
    ADDRNUMBER,        -- Address Number [AD_ADDRNUM]
    RMA_VENDOR,        -- Supplier RMA [MSR_VRMA_NR]
    RMA_VENDOR_REQ,    -- RMA Required [MSR_VRMA_REQ]
    INSPECTION_CODE,   -- Inspection Code [MSR_INSPECTION_CODE]
    REFUND_CODE,       -- Refund Code [MSR_RETURNS_REFUND_CODE]
    REFUND_CONTROL,    -- Refund Control [MSR_REFUND_CONTROL]
    RET_REASON,        -- Return Reason [MSR_RETURNS_REASON]
    REPLACE_MATNR,     -- Repl. Material [MSR_REPLACE_MATNR]
    REPLACE_QTY,       -- Repl. Quantity [MSR_REPLACE_QTY]
    REPLACE_UNIT,      -- Repl. Mat. UoM [MSR_REPLACE_UNIT]
    POSGUID,           -- Item indicator [POSGUID]
    REPLACED_QTY,      -- Replaced Qty [MSR_REPLACED_QTY]
    REPLACED_UNIT,     -- Repl. Qty UoM [MSR_REPLACED_UNIT]
    CMR_QTY,           -- CMR Quantity [MSR_CMR_QTY]
    CMR_UNIT,          -- CMR UoM [MSR_CMR_UNIT]
    ABGRU,             -- RejectionReason [ABGRU_VA]
    REFUND_TYPE,       -- Refund Type [MSR_REFUND_TYPE]
    PAYING_PLANT,      -- Supplying Plant [MSR_REPLACE_PLANT]
    PRE_REFUND,        -- Prelim. Refund [MSR_PRELIMINARY_REFUND]
    REPLACE_RELEASED,  -- Release SDF [MSR_REPLACEMENT_RELEASED]
    REFUND_RELEASED,   -- Release CMR [MSR_REFUNDING_RELEASED]
    REPLACE_REQUEST,   -- Repl. Requested [MSR_REPLACEMENT_REQUESTED]
    SOBKZ,             -- Special Stock [SOBKZ]
    BILLING_BLOCK,     -- Billing Block [MSR_BILLING_BLOCK]
    DELIVERY_BLOCK,    -- Delivery Block [MSR_DELIVERY_BLOCK]
    REF_DOC_TYPE,      -- Doc. Type [MSR_DOC_TYPE]
    REF_DOC_NR,        -- Document Number [MSR_DOC_NR]
    REF_DOC_ITEM,      -- Document Item [MSR_DOC_ITEM]
    RECEIVED_MATNR,    -- Repl. Material [MSR_REP_REPLACE_MATNR]
    FU_CODE_ERP,       -- FU Code in ERP [MSR_FU_CODE_ERP]
    IM_PLANT,          -- Target Plant [MSR_PLANT_SPECIFIED]
    IM_MATERIAL,       -- Target Material [MSR_MAT_SPECIFIED]
    MATNR,             -- Material [MATNR]
    VRM_COMPLETE,      -- Compl.Log.Proc. [MSR_VRM_COMPLETE]
    LIFEX,             -- Ext. Delivery [LIFEX]
    ABGRU_TEXT,        -- Reason for Rejection [ABGRU_TEXT]
    PRIMARY KEY (MANDT, MSR_ID, ITEM, SPLIT_ID, EXECUTED_STEP_ID, DOC_TYPE, DOC_NR, DOC_ITEM)
);

Learn More