P_OperationSequence

DDL: P_OPERATIONSEQUENCE Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 2 Associations

View to retrieve the sequence category branch to and from

P_OperationSequence is a Consumption CDS View that provides data about "View to retrieve the sequence category branch to and from" in SAP S/4HANA. It reads from 1 data source (I_OrderSequence) and exposes 17 fields with key fields OrderInternalID, SequenceInternalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_OrderSequence ordSequence from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_OrderOperationBasic _BranchOperation $projection.OrderInternalID = _BranchOperation.OrderInternalID and $projection.BranchOperationInternalID = _BranchOperation.OrderOperationInternalID and _BranchOperation.BillOfOperationsType <> 'R' and _BranchOperation.BillOfOperationsType <> '3'
[0..1] I_OrderOperationBasic _ReturnOperation $projection.OrderInternalID = _ReturnOperation.OrderInternalID and $projection.ReturnOperationInternalID = _ReturnOperation.OrderOperationInternalID and _ReturnOperation.BillOfOperationsType <> 'R' and _ReturnOperation.BillOfOperationsType <> '3'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label View to retrieve the sequence category branch to and from view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID I_OrderSequence OrderInternalID Plan No.f.Oper.
KEY SequenceInternalID I_OrderSequence SequenceInternalID
Sequence I_OrderSequence Sequence Visit Sequence
SequenceText I_OrderSequence SequenceText Short Text
ProductionSupervisor I_OrderSequence ProductionSupervisor Prodn Supervisor
OrderID I_OrderSequence OrderID Order ID
OrderCategory I_OrderSequence OrderCategory Order Category
SequenceCategory I_OrderSequence SequenceCategory Sequence Category
SequenceCategoryName
ReferenceSequence I_OrderSequence ReferenceSequence Ref. Sequence
BranchOperationInternalID I_OrderSequence BranchOperationInternalID RefOpSet from
ReturnOperationInternalID I_OrderSequence ReturnOperationInternalID Ref.oper. to
MfgOrderSequenceBrnchOperation _BranchOperation Operation Transaction
BOOSqncBranchOperationText _BranchOperation OperationText Description
MfgOrderSequenceRetOperation _ReturnOperation Operation Transaction
BOOSqncReturnOperationText _ReturnOperation OperationText Description
_SequenceCategory I_OrderSequence _SequenceCategory

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 P_OperationSequence.
-- 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.

CREATE VIEW P_OperationSequence AS
SELECT
  ordSequence.OrderInternalID AS OrderInternalID,
  ordSequence.SequenceInternalID AS SequenceInternalID,
  ordSequence.Sequence AS Sequence,
  ordSequence.SequenceText AS SequenceText,
  ordSequence.ProductionSupervisor AS ProductionSupervisor,
  ordSequence.OrderID AS OrderID,
  ordSequence.OrderCategory AS OrderCategory,
  ordSequence.SequenceCategory AS SequenceCategory,
  _SequenceCategory._Text[1: Language=$session.system_language].SequenceCategoryName AS SequenceCategoryName,
  ordSequence.ReferenceSequence AS ReferenceSequence,
  ordSequence.BranchOperationInternalID AS BranchOperationInternalID,
  ordSequence.ReturnOperationInternalID AS ReturnOperationInternalID,
  _BranchOperation.Operation AS MfgOrderSequenceBrnchOperation,
  _BranchOperation.OperationText AS BOOSqncBranchOperationText,
  _ReturnOperation.Operation AS MfgOrderSequenceRetOperation,
  _ReturnOperation.OperationText AS BOOSqncReturnOperationText,
  ordSequence._SequenceCategory AS _SequenceCategory
FROM I_OrderSequence AS ordSequence
LEFT OUTER JOIN I_OrderOperationBasic AS _BranchOperation ON OrderInternalID = _BranchOperation.OrderInternalID AND BranchOperationInternalID = _BranchOperation.OrderOperationInternalID AND _BranchOperation.BillOfOperationsType <> 'R' AND _BranchOperation.BillOfOperationsType <> '3'  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _ReturnOperation ON OrderInternalID = _ReturnOperation.OrderInternalID AND ReturnOperationInternalID = _ReturnOperation.OrderOperationInternalID AND _ReturnOperation.BillOfOperationsType <> 'R' AND _ReturnOperation.BillOfOperationsType <> '3'  -- association [0..1]
;

Learn More