TOIJ_EL_MVSCEN
TSW: Define Movement scenarios
TOIJ_EL_MVSCEN is an SAP database table in S/4HANA. TSW: Define Movement scenarios. It contains 30 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_NominationMovementScenario | view | from | BASIC | Nomination Movement Scenario |
Fields (30)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | mvscenario | OIJ_MVSCEN | Mvmt.scenario | |||
| sityp | OIJ_SITYP | Sched.type | ||||
| docind | OIJ_DOCIND | Ref.Doc.Ind. | ||||
| book_transfer | OIJ_EL_BOOK_TRANSFER | Book transfer | ||||
| vbtyp | VBTYPL | Document Cat. | ||||
| auart | AUART | Sales Doc. Type | ||||
| bstyp | EBSTYP | Doc. Category | ||||
| bsakz | BSAKZ | Control | ||||
| bsart | ESART | Document Type | ||||
| bdart | BDART | RequirementType | ||||
| exgtyp | OIA_EXGTYP | Exchange type | ||||
| loc_type | OIJ_EL_LOC_TYPE | Location type | ||||
| func_grp | OI0_GRP | Function group | ||||
| correcting_group | OI0_GRP_C | Correction group | ||||
| rpart | OIJ_RPART | Role part. type | ||||
| rtype | OIJ_RTYPE | Role type | ||||
| shipping_rel | OIJ_EL_SHIPPING_RELEVANCE | Shipping relevance | ||||
| orig_plant | OIJ_EL_CHECK_PLANT | Check plant | ||||
| dest_plant | OIJ_EL_CHECK_PLANT | Check plant | ||||
| sd_coo_type | AUART | Sales Doc. Type | ||||
| td_close | OIG_VCLOSE | Vehicle close | ||||
| mm_coo_type | ESART | Document Type | ||||
| post_automatic | OIJ_PA_INDICATOR | Process automatic | ||||
| related_mvscen | OIJ_MVSCEN | Mvmt.scenario | ||||
| reverting_group | OI0_GRP_R | Reverting group | ||||
| batch_creation | OIJ_BATCH_CR | batch creation | ||||
| batch_nom_upd | OIJ_BATCH_NOM_UPD | Update Batch | ||||
| cons_scen | OIJ_CONSCEN | Consumption Scen. | ||||
| batch_maint | OIJ_BATCH_MAINT | Batch maint. |
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.
-- TSW: Define Movement scenarios
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TOIJ_EL_MVSCEN (
CLIENT, -- Client [MANDT]
MVSCENARIO, -- Mvmt.scenario [OIJ_MVSCEN]
SITYP, -- Sched.type [OIJ_SITYP]
DOCIND, -- Ref.Doc.Ind. [OIJ_DOCIND]
BOOK_TRANSFER, -- Book transfer [OIJ_EL_BOOK_TRANSFER]
VBTYP, -- Document Cat. [VBTYPL]
AUART, -- Sales Doc. Type [AUART]
BSTYP, -- Doc. Category [EBSTYP]
BSAKZ, -- Control [BSAKZ]
BSART, -- Document Type [ESART]
BDART, -- RequirementType [BDART]
EXGTYP, -- Exchange type [OIA_EXGTYP]
LOC_TYPE, -- Location type [OIJ_EL_LOC_TYPE]
FUNC_GRP, -- Function group [OI0_GRP]
CORRECTING_GROUP, -- Correction group [OI0_GRP_C]
RPART, -- Role part. type [OIJ_RPART]
RTYPE, -- Role type [OIJ_RTYPE]
SHIPPING_REL, -- Shipping relevance [OIJ_EL_SHIPPING_RELEVANCE]
ORIG_PLANT, -- Check plant [OIJ_EL_CHECK_PLANT]
DEST_PLANT, -- Check plant [OIJ_EL_CHECK_PLANT]
SD_COO_TYPE, -- Sales Doc. Type [AUART]
TD_CLOSE, -- Vehicle close [OIG_VCLOSE]
MM_COO_TYPE, -- Document Type [ESART]
POST_AUTOMATIC, -- Process automatic [OIJ_PA_INDICATOR]
RELATED_MVSCEN, -- Mvmt.scenario [OIJ_MVSCEN]
REVERTING_GROUP, -- Reverting group [OI0_GRP_R]
BATCH_CREATION, -- batch creation [OIJ_BATCH_CR]
BATCH_NOM_UPD, -- Update Batch [OIJ_BATCH_NOM_UPD]
CONS_SCEN, -- Consumption Scen. [OIJ_CONSCEN]
BATCH_MAINT, -- Batch maint. [OIJ_BATCH_MAINT]
PRIMARY KEY (CLIENT, MVSCENARIO)
);
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