MSR_D_ITEM

Transparent Table Application Table
21 Fields 2 CDS Views

Advanced Returns Management - Tracking Item Data

MSR_D_ITEM is an SAP database table in S/4HANA. Advanced Returns Management - Tracking Item Data. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AdvncdRetsMgmtProcItemBasic view from BASIC Advanced Returns Mgmt Process Item
I_RetsMgmtProcessItem view from BASIC Returns Management Process Item

Fields (21)

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
item_complete MSR_COMPLETE Completed
matnr MATNR Material
ref_doc_type MSR_DOC_TYPE Doc. Type
ref_doc_nr MSR_DOC_NR Document Number
ref_doc_item MSR_DOC_ITEM Document Item
rma_customer MSR_CRMA_NR Customer RMA
cust_insp_code MSR_CUST_INSP_CODE Cust. Insp.Code
nfu_code MSR_NFU_CODE Next Follow-Up
crm_logsys MSR_CRM_LOGSYS CRM Logical System
crm_obj_guid MSR_CRM_OBJ_GUID CRM Object GUID
crm_obj_id MSR_CRM_OBJ_ID CRM Object ID
crm_obj_type MSR_CRM_OBJ_TYPE CRM Object Type
cmr_abgru MSR_CMR_ABGRU CMR Rej. Reason
abgru_text ABGRU_TEXT Reason for Rejection
ext_retdlv_vbeln VBELN_VL Delivery
ext_retdlv_posnr POSNR_VL Item
original_transaction_type MSR_ORIGINAL_TRANS_TYPE Original Transaction Type
suspend_valuation MSR_SUSPEND_VALUATION Suspend Valuation

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 Item Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSR_D_ITEM (
    MANDT,                      -- Client [MANDT]
    MSR_ID,                     -- Process ID No. [MSR_PROCESS_ID]
    ITEM,                       -- Item in Process [MSR_PROCESS_ITEM]
    ITEM_COMPLETE,              -- Completed [MSR_COMPLETE]
    MATNR,                      -- Material [MATNR]
    REF_DOC_TYPE,               -- Doc. Type [MSR_DOC_TYPE]
    REF_DOC_NR,                 -- Document Number [MSR_DOC_NR]
    REF_DOC_ITEM,               -- Document Item [MSR_DOC_ITEM]
    RMA_CUSTOMER,               -- Customer RMA [MSR_CRMA_NR]
    CUST_INSP_CODE,             -- Cust. Insp.Code [MSR_CUST_INSP_CODE]
    NFU_CODE,                   -- Next Follow-Up [MSR_NFU_CODE]
    CRM_LOGSYS,                 -- CRM Logical System [MSR_CRM_LOGSYS]
    CRM_OBJ_GUID,               -- CRM Object GUID [MSR_CRM_OBJ_GUID]
    CRM_OBJ_ID,                 -- CRM Object ID [MSR_CRM_OBJ_ID]
    CRM_OBJ_TYPE,               -- CRM Object Type [MSR_CRM_OBJ_TYPE]
    CMR_ABGRU,                  -- CMR Rej. Reason [MSR_CMR_ABGRU]
    ABGRU_TEXT,                 -- Reason for Rejection [ABGRU_TEXT]
    EXT_RETDLV_VBELN,           -- Delivery [VBELN_VL]
    EXT_RETDLV_POSNR,           -- Item [POSNR_VL]
    ORIGINAL_TRANSACTION_TYPE,  -- Original Transaction Type [MSR_ORIGINAL_TRANS_TYPE]
    SUSPEND_VALUATION,          -- Suspend Valuation [MSR_SUSPEND_VALUATION]
    PRIMARY KEY (MANDT, MSR_ID, ITEM)
);

Learn More