P_OperationSequence

DDL: P_OPERATIONSEQUENCE Type: view_entity CONSUMPTION

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 14 fields with key fields OrderInternalID, SequenceInternalID. It has 2 associations to related views.

1 data source(s) 14 fields

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 (14)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID I_OrderSequence OrderInternalID
KEY SequenceInternalID I_OrderSequence SequenceInternalID
Sequence I_OrderSequence Sequence
ProductionSupervisor I_OrderSequence ProductionSupervisor
OrderID I_OrderSequence OrderID
OrderCategory I_OrderSequence OrderCategory
SequenceCategory I_OrderSequence SequenceCategory
SequenceCategoryName
ReferenceSequence I_OrderSequence ReferenceSequence
BranchOperationInternalID I_OrderSequence BranchOperationInternalID
ReturnOperationInternalID I_OrderSequence ReturnOperationInternalID
MfgOrderSequenceBrnchOperation _BranchOperation Operation
MfgOrderSequenceRetOperation _ReturnOperation Operation
_SequenceCategory I_OrderSequence _SequenceCategory 
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'View to retrieve the sequence category branch to and from'
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ObjectModel.usageType:{serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}

define view entity P_OperationSequence as select from I_OrderSequence as ordSequence

 association [0..1] to I_OrderOperationBasic as _BranchOperation                     on   $projection.OrderInternalID          = _BranchOperation.OrderInternalID
                                                                                   and $projection.BranchOperationInternalID = _BranchOperation.OrderOperationInternalID
                                                                                   and _BranchOperation.BillOfOperationsType <> 'R'
                                                                                   and _BranchOperation.BillOfOperationsType <> '3'
 association [0..1] to I_OrderOperationBasic as _ReturnOperation                     on   $projection.OrderInternalID          = _ReturnOperation.OrderInternalID
                                                                                   and $projection.ReturnOperationInternalID = _ReturnOperation.OrderOperationInternalID  
                                                                                   and _ReturnOperation.BillOfOperationsType <> 'R'
                                                                                   and _ReturnOperation.BillOfOperationsType <> '3'                                                                                                                                                                                                                      
  {

    key ordSequence.OrderInternalID,
    key ordSequence.SequenceInternalID,
    
    ordSequence.Sequence,
    ordSequence.ProductionSupervisor,
    ordSequence.OrderID,
    ordSequence.OrderCategory,
    @ObjectModel.foreignKey.association: '_SequenceCategory'
    ordSequence.SequenceCategory,
    _SequenceCategory._Text[1: Language=$session.system_language].SequenceCategoryName,
    ordSequence.ReferenceSequence,
    ordSequence.BranchOperationInternalID,
    ordSequence.ReturnOperationInternalID,
    _BranchOperation.Operation as MfgOrderSequenceBrnchOperation,
    _ReturnOperation.Operation as MfgOrderSequenceRetOperation,
    ordSequence._SequenceCategory
    
    
}
where ordSequence.OrderCategory = '10'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORDEROPERATIONBASIC",
"I_ORDERSEQUENCE",
"I_SEQUENCECATEGORY",
"I_SEQUENCECATEGORYTEXT"
],
"ASSOCIATED":
[
"I_SEQUENCECATEGORY"
],
"BASE":
[
"I_ORDERSEQUENCE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More