MSR_D_EXECUTED

Transparent Table Application Table
60 Fields 5 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. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
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 Returns Mgmt Process Item Execution 2

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