Which tables does I_RoutingSequenceSearchModel use?

I_RoutingSequenceSearchModel reads from 1 data source(s): plfl.

I_RoutingSequenceSearchModel

Q: How many fields does I_RoutingSequenceSearchModel have?

I_RoutingSequenceSearchModel has 34 fields. Key fields: BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOSqncInternalVersionCounter.

DDL: I_ROUTINGSEQUENCESEARCHMODEL Type: view_entity BASIC Package: PPH_ROUTING

Bill of Operations Sequence

I_RoutingSequenceSearchModel is a Basic CDS View that provides data about "Bill of Operations Sequence" in SAP S/4HANA. It reads from 1 data source (plfl) and exposes 34 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOSqncInternalVersionCounter. It has 11 associations to related views. Part of development package PPH_ROUTING.

Data Sources (1)

Source	Alias	Join Type
plfl	plfl	from

Associations (11)

Cardinality	Target	Alias	Condition
[1..1]	I_BillOfOperationsType	_BillOfOperationsType	`$projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType`
[1..1]	I_BillOfOperationsGroup	_BillOfOperationsGroup	`$projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup`
[1..1]	I_BillOfOperations	_BillOfOperations	`$projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant`
[1..1]	I_BillOfOperationsSequence	_BillOfOperationsSequence	`$projection.BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant and $projection.BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence`
[1..1]	I_BillOfOperationsSequenceCat	_BillOfOperationsSequenceCat	`$projection.BillOfOperationsSequenceCat = _BillOfOperationsSequenceCat.BillOfOperationsSequenceCat`
[0..1]	I_SequenceSchedulingAlignment	_SequenceSchedulingAlignment	`$projection.SequenceSchedulingAlignment = _SequenceSchedulingAlignment.SequenceSchedulingAlignment`
[1..1]	I_BillOfOperationsSequence	_BillOfOperationsRefSequence	`$projection.BillOfOperationsType = _BillOfOperationsRefSequence.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsRefSequence.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperationsRefSequence.BillOfOperationsVariant and $projection.BillOfOperationsRefSequence = _BillOfOperationsRefSequence.BillOfOperationsSequence`
[0..1]	I_BillOfOperationsOperation	_BOOOperationsBranchOperation	`$projection.BillOfOperationsType = _BOOOperationsBranchOperation.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOOperationsBranchOperation.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BOOOperationsBranchOperation.BillOfOperationsVariant and $projection.BillOfOperationsRefSequence = _BOOOperationsBranchOperation.BillOfOperationsSequence and $projection.BOOSqncBranchOpInternalID = _BOOOperationsBranchOperation.BOOOperationInternalID`
[0..1]	I_BillOfOperationsOperation	_BOOOperationsReturnOperation	`$projection.BillOfOperationsType = _BOOOperationsReturnOperation.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOOperationsReturnOperation.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BOOOperationsReturnOperation.BillOfOperationsVariant and $projection.BillOfOperationsRefSequence = _BOOOperationsReturnOperation.BillOfOperationsSequence and $projection.BOOSqncReturnOpInternalID = _BOOOperationsReturnOperation.BOOOperationInternalID`
[0..1]	I_ChangeMaster	_ChangeMaster	`$projection.ChangeNumber = _ChangeMaster.ChangeNumber`
[0..*]	I_RoutingOpSqncAllocSrchMod	_RtgOpSqncAllocSrchMod	`$projection.BillOfOperationsType = _RtgOpSqncAllocSrchMod.BillOfOperationsType and $projection.BillOfOperationsGroup = _RtgOpSqncAllocSrchMod.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _RtgOpSqncAllocSrchMod.BillOfOperationsVariant and $projection.BillOfOperationsSequence = _RtgOpSqncAllocSrchMod.BillOfOperationsSequence`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#BASIC	view
ObjectModel.representativeKey	BOOSqncInternalVersionCounter	view
Analytics.technicalName	IRTGSEQSRCHMOD	view
EndUserText.label	Bill of Operations Sequence	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (34)

Key	Field	Source Table	Source Field
KEY	BillOfOperationsType	plfl	plnty
KEY	BillOfOperationsGroup	plfl	plnnr
KEY	BillOfOperationsVariant	plfl	plnal
KEY	BillOfOperationsSequence	plfl	plnfl
KEY	BOOSqncInternalVersionCounter	plfl	zaehl
	BillOfOperationsVersion	plfl	versn
	BillOfOperationsUnit	plko	plnme
	IsDeleted	plfl	loekz
	IsImplicitlyDeleted	plfl	loekz_inherited
	flgatasBillOfOperationsSequenceCat
	SequenceText	plfl	ltxa1
	SequenceSchedulingAlignment	plfl	auschl
	bezflasBillOfOperationsRefSequence
	BOOSqncBranchOpInternalID	plfl	bknt1
	BOOSqncReturnOpInternalID	plfl	bknt2
	MaximumLotSizeQuantity
	aennrasChangeNumber
	ValidityStartDate
	ValidityEndDate
	CreationDate	plfl	andat
	CreatedByUser
	LastChangeDate	plfl	aedat
	LastChangedByUser
	_BOOOperationsBranchOperation		_BOOOperationsBranchOperation
	_BOOOperationsReturnOperation		_BOOOperationsReturnOperation
	_BillOfOperations		_BillOfOperations
	_BillOfOperationsGroup		_BillOfOperationsGroup
	_BillOfOperationsRefSequence		_BillOfOperationsRefSequence
	_BillOfOperationsSequence		_BillOfOperationsSequence
	_BillOfOperationsSequenceCat		_BillOfOperationsSequenceCat
	_BillOfOperationsType		_BillOfOperationsType
	_ChangeMaster		_ChangeMaster
	_SequenceSchedulingAlignment		_SequenceSchedulingAlignment
	_RtgOpSqncAllocSrchMod		_RtgOpSqncAllocSrchMod

@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
//@Analytics: {dataCategory: #DIMENSION}

@ObjectModel.representativeKey: 'BOOSqncInternalVersionCounter'
@Analytics.technicalName: 'IRTGSEQSRCHMOD'
@EndUserText.label: 'Bill of Operations Sequence'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
//@Metadata.allowExtensions:true

define view entity I_RoutingSequenceSearchModel
  as select from plfl
    left outer to one join plko on plko.plnty = plfl.plnty and plko.plnnr = plfl.plnnr and plko.plnal = plfl.plnal and plko.zaehl = plfl.zaehl 

  association [1..1] to I_BillOfOperationsType        as _BillOfOperationsType         on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType

  association [1..1] to I_BillOfOperationsGroup       as _BillOfOperationsGroup        on  $projection.BillOfOperationsType  = _BillOfOperationsGroup.BillOfOperationsType
                                                                                       and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup

  association [1..1] to I_BillOfOperations            as _BillOfOperations             on  $projection.BillOfOperationsType    = _BillOfOperations.BillOfOperationsType
                                                                                       and $projection.BillOfOperationsGroup   = _BillOfOperations.BillOfOperationsGroup
                                                                                       and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant
  association [1..1] to I_BillOfOperationsSequence    as _BillOfOperationsSequence     on  $projection.BillOfOperationsType     = _BillOfOperationsSequence.BillOfOperationsType
                                                                                       and $projection.BillOfOperationsGroup    = _BillOfOperationsSequence.BillOfOperationsGroup
                                                                                       and $projection.BillOfOperationsVariant  = _BillOfOperationsSequence.BillOfOperationsVariant
                                                                                       and $projection.BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence

  association [1..1] to I_BillOfOperationsSequenceCat as _BillOfOperationsSequenceCat  on  $projection.BillOfOperationsSequenceCat = _BillOfOperationsSequenceCat.BillOfOperationsSequenceCat

  association [0..1] to I_SequenceSchedulingAlignment as _SequenceSchedulingAlignment  on  $projection.SequenceSchedulingAlignment = _SequenceSchedulingAlignment.SequenceSchedulingAlignment

  association [1..1] to I_BillOfOperationsSequence    as _BillOfOperationsRefSequence  on  $projection.BillOfOperationsType        = _BillOfOperationsRefSequence.BillOfOperationsType
                                                                                       and $projection.BillOfOperationsGroup       = _BillOfOperationsRefSequence.BillOfOperationsGroup
                                                                                       and $projection.BillOfOperationsVariant     = _BillOfOperationsRefSequence.BillOfOperationsVariant
                                                                                       and $projection.BillOfOperationsRefSequence = _BillOfOperationsRefSequence.BillOfOperationsSequence

  association [0..1] to I_BillOfOperationsOperation   as _BOOOperationsBranchOperation on  $projection.BillOfOperationsType        = _BOOOperationsBranchOperation.BillOfOperationsType
                                                                                       and $projection.BillOfOperationsGroup       = _BOOOperationsBranchOperation.BillOfOperationsGroup
                                                                                       and $projection.BillOfOperationsVariant     = _BOOOperationsBranchOperation.BillOfOperationsVariant
                                                                                       and $projection.BillOfOperationsRefSequence = _BOOOperationsBranchOperation.BillOfOperationsSequence
                                                                                       and $projection.BOOSqncBranchOpInternalID   = _BOOOperationsBranchOperation.BOOOperationInternalID

  association [0..1] to I_BillOfOperationsOperation   as _BOOOperationsReturnOperation on  $projection.BillOfOperationsType        = _BOOOperationsReturnOperation.BillOfOperationsType
                                                                                       and $projection.BillOfOperationsGroup       = _BOOOperationsReturnOperation.BillOfOperationsGroup
                                                                                       and $projection.BillOfOperationsVariant     = _BOOOperationsReturnOperation.BillOfOperationsVariant
                                                                                       and $projection.BillOfOperationsRefSequence = _BOOOperationsReturnOperation.BillOfOperationsSequence
                                                                                       and $projection.BOOSqncReturnOpInternalID   = _BOOOperationsReturnOperation.BOOOperationInternalID

  association [0..1] to I_ChangeMaster                as _ChangeMaster                 on  $projection.ChangeNumber = _ChangeMaster.ChangeNumber
  association [0..*] to I_RoutingOpSqncAllocSrchMod   as _RtgOpSqncAllocSrchMod        on  $projection.BillOfOperationsType = _RtgOpSqncAllocSrchMod.BillOfOperationsType
                                                                                       and $projection.BillOfOperationsGroup = _RtgOpSqncAllocSrchMod.BillOfOperationsGroup
                                                                                       and $projection.BillOfOperationsVariant = _RtgOpSqncAllocSrchMod.BillOfOperationsVariant
                                                                                       and $projection.BillOfOperationsSequence = _RtgOpSqncAllocSrchMod.BillOfOperationsSequence
                                                                                      

{
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key plfl.plnty                                                     as   BillOfOperationsType,
      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key plfl.plnnr                                                     as   BillOfOperationsGroup,
      @ObjectModel.foreignKey.association: '_BillOfOperations'
  key plfl.plnal                                                     as   BillOfOperationsVariant,
      @ObjectModel.foreignKey.association: '_BillOfOperationsSequence'
  key plfl.plnfl                                                     as   BillOfOperationsSequence,
      @ObjectModel.text.element: [ 'SequenceText']
  key plfl.zaehl                                                     as   BOOSqncInternalVersionCounter,

      // NOT a key field in THIS view !

      plfl.versn                                                     as   BillOfOperationsVersion,
      plko.plnme                                                     as   BillOfOperationsUnit,
      // ***************** Technical fields not on the CEWB-UI *****************


      plfl.loekz                                                     as   IsDeleted,
      plfl.loekz_inherited                                           as   IsImplicitlyDeleted,

      // *************************** Sequence Detail ***************************


      -- Sequence
      @ObjectModel.foreignKey.association: '_BillOfOperationsSequenceCat'
      plfl.flgat                                                     as   BillOfOperationsSequenceCat,

      @Semantics.text: true
      plfl.ltxa1                                                     as   SequenceText,

      @ObjectModel.foreignKey.association: '_SequenceSchedulingAlignment'
      plfl.auschl                                                    as   SequenceSchedulingAlignment,

      -- Reference
      @ObjectModel.foreignKey.association: '_BillOfOperationsRefSequence'
      plfl.bezfl                                                     as   BillOfOperationsRefSequence,

      @ObjectModel.foreignKey.association: '_BOOOperationsBranchOperation'
      plfl.bknt1                                                     as   BOOSqncBranchOpInternalID,
      @ObjectModel.foreignKey.association: '_BOOOperationsReturnOperation'
      plfl.bknt2                                                     as   BOOSqncReturnOpInternalID,
      
     
      
      -- Alternative Sequence
      
    
     
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      cast(plfl.losvn as bstmi preserving type)                      as   MinimumLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      cast(plfl.losbs as bstma preserving type)                      as   MaximumLotSizeQuantity,



      -- Administrative Data
      @ObjectModel.foreignKey.association: '_ChangeMaster'
      plfl.aennr                                                     as   ChangeNumber,

      @Semantics.businessDate.from: true
      cast(plfl.datuv  as pph_begda preserving type)  as   ValidityStartDate,
      @Semantics.businessDate.to: true
      cast(plfl.valid_to as pph_endda preserving type) as   ValidityEndDate,

      @Semantics.systemDate.createdAt: true
      plfl.andat                                                     as   CreationDate,
      cast(plfl.annam as vdm_createdbyuserid preserving type)        as   CreatedByUser,
      
      @Semantics.systemDate.lastChangedAt: true
      plfl.aedat                                                     as   LastChangeDate,
      cast(plfl.aenam as vdm_lastchangedbyuserid preserving type)    as   LastChangedByUser,

      
      

      // **************************** Associations *****************************


      _BOOOperationsBranchOperation,
      _BOOOperationsReturnOperation,
      _BillOfOperations,
      _BillOfOperationsGroup,
      _BillOfOperationsRefSequence,
      _BillOfOperationsSequence,
      _BillOfOperationsSequenceCat,
      _BillOfOperationsType,
      _ChangeMaster,
      _SequenceSchedulingAlignment,
      _RtgOpSqncAllocSrchMod
}

Depth:

I_RoutingSequenceSearchModel view_entity

plfl

P_WrkCtrMntrAlternateWrkCtr view_entity