I_NominationMovementScenario

DDL: I_NOMINATIONMOVEMENTSCENARIO SQL: INOMMVTSCEN Type: view BASIC

Nomination Movement Scenario

I_NominationMovementScenario is a Basic CDS View that provides data about "Nomination Movement Scenario" in SAP S/4HANA. It reads from 1 data source (toij_el_mvscen) and exposes 8 fields with key field OilMovementScenario.

Data Sources (1)

SourceAliasJoin Type
toij_el_mvscen toij_el_mvscen from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName INOMMVTSCEN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Nomination Movement Scenario view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY OilMovementScenario mvscenario Mvmt.scenario
NominationScheduleType sityp Trip Schedule Type
NominationReferenceDocType docind Single-Character Flag
IsBookTransferRelevant book_transfer Book transfer
NominationLocationType loc_type Location Type
NominationShippingRelevance shipping_rel Shipping relevance
SDDocumentCategory vbtyp TSW Det.Doc typ
PurchasingDocumentCategory bstyp Source doc.cat.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_NominationMovementScenario.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: INOMMVTSCEN

CREATE VIEW I_NominationMovementScenario AS
SELECT
  mvscenario AS OilMovementScenario,
  sityp AS NominationScheduleType,
  docind AS NominationReferenceDocType,
  book_transfer AS IsBookTransferRelevant,
  loc_type AS NominationLocationType,
  shipping_rel AS NominationShippingRelevance,
  vbtyp AS SDDocumentCategory,
  bstyp AS PurchasingDocumentCategory
FROM toij_el_mvscen
;