MSR_D_NEXTPLANTS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AdvncdRetsMgmtProcNextPlants | view | from | BASIC | Advanced Returns Mgmt Proc Next Plants |
Fields (11)
| 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 | 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)
);
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