R_ProdnRoutingSequenceTP_2

DDL: R_PRODNROUTINGSEQUENCETP_2 Type: view_entity TRANSACTIONAL Package: VDM_PP_MD_RTG

Production Routing Sequence

R_ProdnRoutingSequenceTP_2 is a Transactional CDS View that provides data about "Production Routing Sequence" in SAP S/4HANA. It reads from 2 data sources (I_ProdnRtgSequenceToHeader, I_MfgBOOSequenceChangeState) and exposes 28 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingSequence, ProductionRoutingSqncIntVers. It has 2 associations to related views. Part of development package VDM_PP_MD_RTG.

2 data source(s) 28 fields

Data Sources (2)

SourceAliasJoin Type
I_ProdnRtgSequenceToHeader headerseq inner
I_MfgBOOSequenceChangeState sequence from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_ProdnRoutingOperationTP_2 _Operation $projection.ProductionRoutingGroup = _Operation.ProductionRoutingGroup and $projection.ProductionRouting = _Operation.ProductionRouting and $projection.ProductionRoutingSequence = _Operation.ProductionRoutingSequence and $projection.ValidityEndDate >= _Operation.ValidityStartDate and $projection.ValidityStartDate <= _Operation.ValidityEndDate
[1..*] R_ProductionRoutingHeaderTP_2 _Header $projection.ProductionRoutingGroup = _Header.ProductionRoutingGroup and $projection.ProductionRouting = _Header.ProductionRouting and $projection.ValidityEndDate >= _Header.ValidityStartDate and $projection.ValidityStartDate <= _Header.ValidityEndDate

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Production Routing Sequence view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey ProductionRoutingSqncIntVers view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ProductionRoutingGroup I_MfgBOOSequenceChangeState BillOfOperationsGroup
KEY ProductionRouting I_MfgBOOSequenceChangeState BillOfOperationsVariant
KEY ProductionRoutingSequence I_MfgBOOSequenceChangeState BillOfOperationsSequence
KEY ProductionRoutingSqncIntVers I_MfgBOOSequenceChangeState BOOSqncInternalVersionCounter
IsDeleted I_MfgBOOSequenceChangeState IsDeleted
IsImplicitlyDeleted I_MfgBOOSequenceChangeState IsImplicitlyDeleted
ChangeNumber I_MfgBOOSequenceChangeState ChangeNumber
ValidityStartDate I_MfgBOOSequenceChangeState ValidityStartDate
ValidityEndDate I_MfgBOOSequenceChangeState ValidityEndDate
SequenceCategory I_MfgBOOSequenceChangeState SequenceCategory
BillOfOperationsRefSequence I_MfgBOOSequenceChangeState BillOfOperationsRefSequence
BOOSqncBranchOpInternalID I_MfgBOOSequenceChangeState BOOSqncBranchOpInternalID
BOOSqncReturnOpInternalID I_MfgBOOSequenceChangeState BOOSqncReturnOpInternalID
MinimumLotSizeQuantity I_MfgBOOSequenceChangeState MinimumLotSizeQuantity
MaximumLotSizeQuantity I_MfgBOOSequenceChangeState MaximumLotSizeQuantity
BillOfOperationsUnit I_MfgBOOSequenceChangeState BillOfOperationsUnit
SequenceText I_MfgBOOSequenceChangeState SequenceText
CreationDate I_MfgBOOSequenceChangeState CreationDate
CreatedByUser I_MfgBOOSequenceChangeState CreatedByUser
LastChangeDate I_MfgBOOSequenceChangeState LastChangeDate
LastChangedByUser I_MfgBOOSequenceChangeState LastChangedByUser
ChangedDateTime _NonSqnc ChangedDateTime
_Header _Header
_ChangeMaster I_MfgBOOSequenceChangeState _ChangeMaster
_SequenceCategory I_MfgBOOSequenceChangeState _SequenceCategory
_NonSqnc _NonSqnc
_Operation _Operation
_ProdnRtgTP _ProdnRtgTP 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Production Routing Sequence'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED }
@ObjectModel.representativeKey: 'ProductionRoutingSqncIntVers'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
define view entity R_ProdnRoutingSequenceTP_2
  as select from I_MfgBOOSequenceChangeState  as sequence
    inner join   I_ProdnRtgSequenceToHeader as headerseq on  sequence.BillOfOperationsGroup         = headerseq.ProductionRoutingGroup
                                                           and sequence.BillOfOperationsVariant       = headerseq.ProductionRouting
                                                           and sequence.BillOfOperationsSequence      = headerseq.ProductionRoutingSequence
                                                           and sequence.BOOSqncInternalVersionCounter = headerseq.ProductionRoutingSqncIntVers
  association [0..*] to R_ProdnRoutingOperationTP_2          as _Operation  on  $projection.ProductionRoutingGroup    =  _Operation.ProductionRoutingGroup
                                                                            and $projection.ProductionRouting         =  _Operation.ProductionRouting
                                                                            and $projection.ProductionRoutingSequence =  _Operation.ProductionRoutingSequence
                                                                            and $projection.ValidityEndDate           >= _Operation.ValidityStartDate
                                                                            and $projection.ValidityStartDate         <= _Operation.ValidityEndDate
  association [1..*] to R_ProductionRoutingHeaderTP_2        as _Header     on  $projection.ProductionRoutingGroup =  _Header.ProductionRoutingGroup
                                                                            and $projection.ProductionRouting      =  _Header.ProductionRouting
                                                                            and $projection.ValidityEndDate        >= _Header.ValidityStartDate
                                                                            and $projection.ValidityStartDate      <= _Header.ValidityEndDate
  association        to R_ProductionRoutingTP_2              as _ProdnRtgTP on  $projection.ProductionRoutingGroup = _ProdnRtgTP.ProductionRoutingGroup
                                                                            and $projection.ProductionRouting      = _ProdnRtgTP.ProductionRouting
  association        to parent R_ProdnRtgNonHistoricSqncTP_2 as _NonSqnc    on  $projection.ProductionRoutingGroup    = _NonSqnc.ProductionRoutingGroup
                                                                            and $projection.ProductionRouting         = _NonSqnc.ProductionRouting
                                                                            and $projection.ProductionRoutingSequence = _NonSqnc.ProductionRoutingSequence

{
  key sequence.BillOfOperationsGroup         as ProductionRoutingGroup,
  key sequence.BillOfOperationsVariant       as ProductionRouting,
  key sequence.BillOfOperationsSequence      as ProductionRoutingSequence,
  key sequence.BOOSqncInternalVersionCounter as ProductionRoutingSqncIntVers,

      sequence.IsDeleted,
      sequence.IsImplicitlyDeleted,
      sequence.ChangeNumber,
      @Semantics.businessDate.from: true
      sequence.ValidityStartDate,
      @Semantics.businessDate.to: true
      sequence.ValidityEndDate,
      sequence.SequenceCategory,
      sequence.BillOfOperationsRefSequence,
      sequence.BOOSqncBranchOpInternalID,
      sequence.BOOSqncReturnOpInternalID,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      sequence.MinimumLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      sequence.MaximumLotSizeQuantity,
      sequence.BillOfOperationsUnit,
      sequence.SequenceText,
      sequence.CreationDate,
      sequence.CreatedByUser,
      sequence.LastChangeDate,
      sequence.LastChangedByUser,
      _NonSqnc.ChangedDateTime,

      /* Associations */
      _Header,
      sequence._ChangeMaster,
      sequence._SequenceCategory,
      _NonSqnc,
      _Operation,
      _ProdnRtgTP
}
where
      sequence.BillOfOperationsType =  'N'
  and sequence.IsDeleted            <> 'X'
  and sequence.IsImplicitlyDeleted  <> 'X'

Learn More