R_ProdnRoutingSequenceTP_2

DDL: R_PRODNROUTINGSEQUENCETP_2 Type: view_entity TRANSACTIONAL

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 1 data source (I_MfgBOOSequenceChangeState) and exposes 28 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingSequence, ProductionRoutingSqncIntVers. It has 2 associations to related views.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgBOOSequenceChangeState I_MfgBOOSequenceChangeState 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 BillOfOperationsGroup
KEY ProductionRouting BillOfOperationsVariant
KEY ProductionRoutingSequence BillOfOperationsSequence
KEY ProductionRoutingSqncIntVers BOOSqncInternalVersionCounter
IsDeleted IsDeleted
IsImplicitlyDeleted IsImplicitlyDeleted
ChangeNumber ChangeNumber
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
SequenceCategory SequenceCategory
BillOfOperationsRefSequence BillOfOperationsRefSequence
BOOSqncBranchOpInternalID BOOSqncBranchOpInternalID
BOOSqncReturnOpInternalID BOOSqncReturnOpInternalID
MinimumLotSizeQuantity MinimumLotSizeQuantity
MaximumLotSizeQuantity MaximumLotSizeQuantity
BillOfOperationsUnit BillOfOperationsUnit
SequenceText SequenceText
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
ChangedDateTime _NonSqnc ChangedDateTime
_Header _Header
_ChangeMaster _ChangeMaster
_SequenceCategory _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
  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 BillOfOperationsGroup         as ProductionRoutingGroup,
  key BillOfOperationsVariant       as ProductionRouting,
  key BillOfOperationsSequence      as ProductionRoutingSequence,
  key BOOSqncInternalVersionCounter as ProductionRoutingSqncIntVers,

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

      /* Associations */
      _Header,
      _ChangeMaster,
      _SequenceCategory,
      _NonSqnc,
      _Operation,
      _ProdnRtgTP
}
where
      BillOfOperationsType =  'N'
  and IsDeleted            <> 'X'
  and IsImplicitlyDeleted  <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGBOOSEQUENCECHANGESTATE",
"R_PRODNRTGNONHISTORICSQNCTP_2"
],
"ASSOCIATED":
[
"I_CHANGEMASTER",
"I_SEQUENCECATEGORY",
"R_PRODNROUTINGOPERATIONTP_2",
"R_PRODNRTGNONHISTORICSQNCTP_2",
"R_PRODUCTIONROUTINGHEADERTP_2",
"R_PRODUCTIONROUTINGTP_2"
],
"BASE":
[
"I_MFGBOOSEQUENCECHANGESTATE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More