I_TaskListSequence

DDL: I_TASKLISTSEQUENCE Type: view_entity COMPOSITE

Task List Sequence

I_TaskListSequence is a Composite CDS View that provides data about "Task List Sequence" in SAP S/4HANA. It reads from 1 data source (I_MfgBOOSequenceChangeState) and exposes 17 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOSqncInternalVersionCounter. It has 4 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgBOOSequenceChangeState I_MfgBOOSequenceChangeState from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_MfgBOOOperationChangeState _BranchOperation $projection.BillOfOperationsType = _BranchOperation.BillOfOperationsType and $projection.BillOfOperationsGroup = _BranchOperation.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BranchOperation.BillOfOperationsVariant and $projection.BillOfOperationsRefSequence = _BranchOperation.BillOfOperationsSequence and $projection.BOOSqncBranchOpInternalID = _BranchOperation.BOOOperationInternalID and $projection.ValidityEndDate >= _BranchOperation.ValidityStartDate and $projection.ValidityStartDate <= _BranchOperation.ValidityEndDate
[0..1] I_MfgBOOOperationChangeState _ReturnOperation $projection.BillOfOperationsType = _ReturnOperation.BillOfOperationsType and $projection.BillOfOperationsGroup = _ReturnOperation.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _ReturnOperation.BillOfOperationsVariant and $projection.BillOfOperationsRefSequence = _ReturnOperation.BillOfOperationsSequence and $projection.BOOSqncReturnOpInternalID = _ReturnOperation.BOOOperationInternalID and $projection.ValidityEndDate >= _ReturnOperation.ValidityStartDate and $projection.ValidityStartDate <= _ReturnOperation.ValidityEndDate
[1..1] I_SequenceCategoryText _CategoryText _CategoryText.SequenceCategory = $projection.SequenceCategory and _CategoryText.Language = $session.system_language
[1..*] I_RoutingHeader _RoutingHeader $projection.BillOfOperationsType = _RoutingHeader.BillOfOperationsType and $projection.BillOfOperationsGroup = _RoutingHeader.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _RoutingHeader.BillOfOperationsVariant

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Task List Sequence view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType BillOfOperationsType
KEY BillOfOperationsGroup BillOfOperationsGroup
KEY BillOfOperationsVariant BillOfOperationsVariant
KEY BillOfOperationsSequence BillOfOperationsSequence
KEY BOOSqncInternalVersionCounter BOOSqncInternalVersionCounter
SequenceCategory SequenceCategory
SequenceCategoryName _CategoryText SequenceCategoryName
BillOfOperationsRefSequence BillOfOperationsRefSequence
BOOSqncBranchOpInternalID BOOSqncBranchOpInternalID
BOOSequenceBranchOperation
BOOSqncReturnOpInternalID BOOSqncReturnOpInternalID
BOOSequenceReturnOperation
SequenceText SequenceText
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
_RoutingHeader _RoutingHeader
_CategoryText _CategoryText 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Task List Sequence'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED }
@VDM.viewType: #COMPOSITE
define view entity I_TaskListSequence
  as select from I_MfgBOOSequenceChangeState
  association [0..1] to I_MfgBOOOperationChangeState as _BranchOperation on  $projection.BillOfOperationsType        =  _BranchOperation.BillOfOperationsType
                                                                         and $projection.BillOfOperationsGroup       =  _BranchOperation.BillOfOperationsGroup
                                                                         and $projection.BillOfOperationsVariant     =  _BranchOperation.BillOfOperationsVariant
                                                                         and $projection.BillOfOperationsRefSequence =  _BranchOperation.BillOfOperationsSequence
                                                                         and $projection.BOOSqncBranchOpInternalID   =  _BranchOperation.BOOOperationInternalID
                                                                         and $projection.ValidityEndDate             >= _BranchOperation.ValidityStartDate
                                                                         and $projection.ValidityStartDate           <= _BranchOperation.ValidityEndDate

  association [0..1] to I_MfgBOOOperationChangeState as _ReturnOperation on  $projection.BillOfOperationsType        =  _ReturnOperation.BillOfOperationsType
                                                                         and $projection.BillOfOperationsGroup       =  _ReturnOperation.BillOfOperationsGroup
                                                                         and $projection.BillOfOperationsVariant     =  _ReturnOperation.BillOfOperationsVariant
                                                                         and $projection.BillOfOperationsRefSequence =  _ReturnOperation.BillOfOperationsSequence
                                                                         and $projection.BOOSqncReturnOpInternalID   =  _ReturnOperation.BOOOperationInternalID
                                                                         and $projection.ValidityEndDate             >= _ReturnOperation.ValidityStartDate
                                                                         and $projection.ValidityStartDate           <= _ReturnOperation.ValidityEndDate

  association [1..1] to I_SequenceCategoryText       as _CategoryText    on  _CategoryText.SequenceCategory = $projection.SequenceCategory
                                                                         and _CategoryText.Language         = $session.system_language

  //Added for Role Check

  association [1..*] to I_RoutingHeader              as _RoutingHeader   on  $projection.BillOfOperationsType    = _RoutingHeader.BillOfOperationsType
                                                                         and $projection.BillOfOperationsGroup   = _RoutingHeader.BillOfOperationsGroup
                                                                         and $projection.BillOfOperationsVariant = _RoutingHeader.BillOfOperationsVariant
{
  key BillOfOperationsType,
  key BillOfOperationsGroup,
  key BillOfOperationsVariant,
  key BillOfOperationsSequence,
  key BOOSqncInternalVersionCounter,
      SequenceCategory,
      _CategoryText.SequenceCategoryName                            as SequenceCategoryName,
      BillOfOperationsRefSequence,
      BOOSqncBranchOpInternalID,
      cast(_BranchOperation.Operation as pph_vornr preserving type) as BOOSequenceBranchOperation,
      BOOSqncReturnOpInternalID,
      cast(_ReturnOperation.Operation as pph_vornr preserving type) as BOOSequenceReturnOperation,
      SequenceText,
      ValidityStartDate,
      ValidityEndDate,

      /*Associations*/
      _RoutingHeader,
      _CategoryText

}
where
  (
        BillOfOperationsType = 'N'
    or  BillOfOperationsType = '2'
  )
  and(
        IsDeleted            is initial
    and IsImplicitlyDeleted  is initial
  )
  and(
        ValidityStartDate    <= $session.system_date
    and ValidityEndDate      >= $session.system_date
  )

Learn More