I_ProdnRtgSequenceToHeader

DDL: I_PRODNRTGSEQUENCETOHEADER Type: view_entity COMPOSITE Package: VDM_PP_MD_RTG

Prodn Routing Sequence to Header

I_ProdnRtgSequenceToHeader is a Composite CDS View that provides data about "Prodn Routing Sequence to Header" in SAP S/4HANA. It reads from 2 data sources (I_MfgBillOfOperationsChgSt, I_MfgBOOSequenceChangeState) and exposes 6 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingSequence, ProductionRoutingSqncIntVers. Part of development package VDM_PP_MD_RTG.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_MfgBillOfOperationsChgSt Header inner
I_MfgBOOSequenceChangeState Sequence from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Prodn Routing Sequence to Header view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ProductionRoutingGroup I_MfgBOOSequenceChangeState BillOfOperationsGroup
KEY ProductionRouting I_MfgBOOSequenceChangeState BillOfOperationsVariant
KEY ProductionRoutingSequence I_MfgBOOSequenceChangeState BillOfOperationsSequence
KEY ProductionRoutingSqncIntVers I_MfgBOOSequenceChangeState BOOSqncInternalVersionCounter
ValidityStartDate
ValidityEndDate 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Prodn Routing Sequence to Header'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{serviceQuality: #C,sizeCategory: #M,dataClass: #MASTER}
@VDM.viewType: #COMPOSITE
define view entity I_ProdnRtgSequenceToHeader
  as select from I_MfgBOOSequenceChangeState as Sequence
    inner join   I_MfgBillOfOperationsChgSt  as Header on  Header.BillOfOperationsType  =  Sequence.BillOfOperationsType
                                                       and Header.BillOfOperationsGroup   =  Sequence.BillOfOperationsGroup
                                                       and Header.BillOfOperationsVariant =  Sequence.BillOfOperationsVariant
                                                       and Header.ValidityEndDate         >= Sequence.ValidityStartDate
                                                       and Header.ValidityStartDate       <= Sequence.ValidityEndDate
{

  key Sequence.BillOfOperationsGroup         as ProductionRoutingGroup,
  key Sequence.BillOfOperationsVariant       as ProductionRouting,
  key Sequence.BillOfOperationsSequence      as ProductionRoutingSequence,
  key Sequence.BOOSqncInternalVersionCounter as ProductionRoutingSqncIntVers,
      min(Header.ValidityStartDate)          as ValidityStartDate,
      max(Header.ValidityEndDate)            as ValidityEndDate
}
where
      Sequence.BillOfOperationsType =  'N'
  and Sequence.IsDeleted            <> 'X'
  and Sequence.IsImplicitlyDeleted  <> 'X'
  and Header.ValidityEndDate        >= Header.ValidityStartDate
  and Header.IsDeleted              <> 'X'
  and Header.IsImplicitlyDeleted    <> 'X'
group by
  Sequence.BillOfOperationsGroup,
  Sequence.BillOfOperationsVariant,
  Sequence.BillOfOperationsSequence,
  Sequence.BOOSqncInternalVersionCounter

Learn More