MSR_D_NEXTPLANTS

Transparent Table Application Table

Multi-step returns - next plants

MSR_D_NEXTPLANTS is an SAP database table in S/4HANA. Multi-step returns - next plants. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AdvncdRetsMgmtProcNextPlants view from BASIC Advanced Returns Mgmt Proc Next Plants

Fields (11)

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
KEY nxt_plnt_counter MSR_COUNTER Counter
next_plant WERKS_D Plant
transshipment MSR_TRANSSHIPMENT_PLANT_INT Transship Plant

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.

-- Multi-step returns - next plants
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSR_D_NEXTPLANTS (
    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]
    NXT_PLNT_COUNTER,  -- Counter [MSR_COUNTER]
    NEXT_PLANT,        -- Plant [WERKS_D]
    TRANSSHIPMENT,     -- Transship Plant [MSR_TRANSSHIPMENT_PLANT_INT]
    PRIMARY KEY (MANDT, MSR_ID, ITEM, SPLIT_ID, EXECUTED_STEP_ID, DOC_TYPE, DOC_NR, DOC_ITEM, NXT_PLNT_COUNTER)
);