I_ProdnRtgSequenceTP

DDL: I_PRODNRTGSEQUENCETP SQL: IRTGSQNCTP Type: view_entity TRANSACTIONAL Package: VDM_PP_MD_RTG

Transaction View for Production Routing Sequence

I_ProdnRtgSequenceTP is a Transactional CDS View that provides data about "Transaction View for 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. Part of development package VDM_PP_MD_RTG.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgBOOSequenceChangeState I_MfgBOOSequenceChangeState from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ProdnRtgOperationTP _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..*] I_ProductionRoutingHeaderTP _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 #CHECK view
EndUserText.label Transaction View for 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 
//@AbapCatalog.sqlViewName: 'IRTGSQNCTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Transaction View for Production Routing Sequence'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED }
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'ProductionRoutingSqncIntVers'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
define view entity I_ProdnRtgSequenceTP
  as select from I_MfgBOOSequenceChangeState
  association [0..*] to I_ProdnRtgOperationTP              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 I_ProductionRoutingHeaderTP        as _Header     on  $projection.ProductionRoutingGroup =  _Header.ProductionRoutingGroup
                                                                          and $projection.ProductionRouting      =  _Header.ProductionRouting
                                                                          and $projection.ValidityEndDate        >= _Header.ValidityStartDate
                                                                          and $projection.ValidityStartDate      <= _Header.ValidityEndDate
  association        to I_ProdnRtgNonHistoricHdrTP         as _ProdnRtgTP on  $projection.ProductionRoutingGroup = _ProdnRtgTP.ProductionRoutingGroup
                                                                          and $projection.ProductionRouting      = _ProdnRtgTP.ProductionRouting
  association        to parent I_ProdnRtgNonHistoricSqncTP 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'

Learn More