I_OrderSequenceBySemKey

DDL: I_ORDERSEQUENCEBYSEMKEY SQL: IORDSEQBYSEMKEY Type: view BASIC
39 Fields 1 Data Sources 1 Associations

Order Sequence by Semantic Key

I_OrderSequenceBySemKey is a Basic CDS View (Dimension) that provides data about "Order Sequence by Semantic Key" in SAP S/4HANA. It reads from 1 data source (I_OrderSequence) and exposes 39 fields with key fields OrderID, Sequence. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_OrderSequence affl from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_OrderSequence _OrderSequence $projection.OrderInternalID = _OrderSequence.OrderInternalID and $projection.SequenceInternalID = _OrderSequence.SequenceInternalID

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IORDSEQBYSEMKEY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey Sequence view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Order Sequence by Semantic Key view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY OrderID I_OrderSequence OrderID Order ID
KEY Sequence I_OrderSequence Sequence Visit Sequence
OrderInternalID I_OrderSequence OrderInternalID Plan No.f.Oper.
SequenceInternalID I_OrderSequence SequenceInternalID
SequenceText I_OrderSequence SequenceText Short Text
SequenceHasLongText I_OrderSequence SequenceHasLongText
Language I_OrderSequence Language Report Text Language
OrderCategory I_OrderSequence OrderCategory Order Category
OrderType I_OrderSequence OrderType Order Type
SequenceCategory I_OrderSequence SequenceCategory Sequence Category
ProductionPlant I_OrderSequence ProductionPlant Prod plnt
ProductionSupervisor I_OrderSequence ProductionSupervisor Prodn Supervisor
BillOfOperationsType I_OrderSequence BillOfOperationsType Task List Type
BillOfOperationsGroup I_OrderSequence BillOfOperationsGroup Group
BillOfOperations I_OrderSequence BillOfOperationsVariant Group Counter
SequenceSchedulingAlignment I_OrderSequence SequenceSchedulingAlignment Alignment Key
ReferenceSequence I_OrderSequence ReferenceSequence Ref. Sequence
ObjectInternalID I_OrderSequence ObjectInternalID Object number
BranchOperationInternalID I_OrderSequence BranchOperationInternalID RefOpSet from
ReturnOperationInternalID I_OrderSequence ReturnOperationInternalID Ref.oper. to
BillOfOperationsUnit I_OrderSequence BillOfOperationsUnit Unit
MinimumLotSizeQuantity I_OrderSequence MinimumLotSizeQuantity Min. Lot Size
MaximumLotSizeQuantity I_OrderSequence MaximumLotSizeQuantity Max. Lot Size
_OrderSequence _OrderSequence
_Order I_OrderSequence _Order
_OrderCategory I_OrderSequence _OrderCategory
_OrderType I_OrderSequence _OrderType
_SequenceCategory I_OrderSequence _SequenceCategory
_SequenceSchedulingAlignment I_OrderSequence _SequenceSchedulingAlignment
_ReferenceSequence I_OrderSequence _ReferenceSequence
_OrderInternalID I_OrderSequence _OrderInternalID
_Plant I_OrderSequence _Plant
_ProductionSupervisor I_OrderSequence _ProductionSupervisor
_BillOfOperationsType I_OrderSequence _BillOfOperationsType
_BillOfOperationsGroup I_OrderSequence _BillOfOperationsGroup
_BillOfOperationsVariant I_OrderSequence _BillOfOperationsVariant
_BillOfOperationsUnit I_OrderSequence _BillOfOperationsUnit
_LongText I_OrderSequence _LongText
_Language I_OrderSequence _Language

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_OrderSequenceBySemKey.
-- 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: IORDSEQBYSEMKEY

CREATE VIEW I_OrderSequenceBySemKey AS
SELECT
  affl.OrderID AS OrderID,
  affl.Sequence AS Sequence,
  affl.OrderInternalID AS OrderInternalID,
  affl.SequenceInternalID AS SequenceInternalID,
  affl.SequenceText AS SequenceText,
  affl.SequenceHasLongText AS SequenceHasLongText,
  affl.Language AS Language,
  affl.OrderCategory AS OrderCategory,
  affl.OrderType AS OrderType,
  affl.SequenceCategory AS SequenceCategory,
  affl.ProductionPlant AS ProductionPlant,
  affl.ProductionSupervisor AS ProductionSupervisor,
  affl.BillOfOperationsType AS BillOfOperationsType,
  affl.BillOfOperationsGroup AS BillOfOperationsGroup,
  affl.BillOfOperationsVariant AS BillOfOperations,
  affl.SequenceSchedulingAlignment AS SequenceSchedulingAlignment,
  affl.ReferenceSequence AS ReferenceSequence,
  affl.ObjectInternalID AS ObjectInternalID,
  affl.BranchOperationInternalID AS BranchOperationInternalID,
  affl.ReturnOperationInternalID AS ReturnOperationInternalID,
  affl.BillOfOperationsUnit AS BillOfOperationsUnit,
  affl.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  affl.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  affl._Order AS _Order,
  affl._OrderCategory AS _OrderCategory,
  affl._OrderType AS _OrderType,
  affl._SequenceCategory AS _SequenceCategory,
  affl._SequenceSchedulingAlignment AS _SequenceSchedulingAlignment,
  affl._ReferenceSequence AS _ReferenceSequence,
  affl._OrderInternalID AS _OrderInternalID,
  affl._Plant AS _Plant,
  affl._ProductionSupervisor AS _ProductionSupervisor,
  affl._BillOfOperationsType AS _BillOfOperationsType,
  affl._BillOfOperationsGroup AS _BillOfOperationsGroup,
  affl._BillOfOperationsVariant AS _BillOfOperationsVariant,
  affl._BillOfOperationsUnit AS _BillOfOperationsUnit,
  affl._LongText AS _LongText,
  affl._Language AS _Language
FROM I_OrderSequence AS affl
LEFT OUTER JOIN I_OrderSequence AS _OrderSequence ON OrderInternalID = _OrderSequence.OrderInternalID AND SequenceInternalID = _OrderSequence.SequenceInternalID  -- association [1..1]
;

Learn More