P_ProdnRoutingSequenceDEX

DDL: P_PRODNROUTINGSEQUENCEDEX Type: view_entity BASIC Package: VDM_PP_MD_RTG

Bill of Operations Sequence Change State

P_ProdnRoutingSequenceDEX is a Basic CDS View that provides data about "Bill of Operations Sequence Change State" in SAP S/4HANA. It reads from 1 data source (plfl) and exposes 25 fields with key fields BillOfOperationsType, ProductionRoutingGroup, ProductionRouting, ProductionRoutingSequence, ProductionRoutingSqncIntVers. It has 4 associations to related views. Part of development package VDM_PP_MD_RTG.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
plfl plfl from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.ProductionRoutingGroup = _BillOfOperationsGroup.BillOfOperationsGroup
[1..1] I_MfgBillOfOperations _BillOfOperations $projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.ProductionRoutingGroup = _BillOfOperations.BillOfOperationsGroup and $projection.ProductionRouting = _BillOfOperations.BillOfOperationsVariant
[1..1] I_MfgBillOfOperationsSequence _BillOfOperationsSequence $projection.BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType and $projection.ProductionRoutingGroup = _BillOfOperationsSequence.BillOfOperationsGroup and $projection.ProductionRouting = _BillOfOperationsSequence.BillOfOperationsVariant and $projection.ProductionRoutingSequence = _BillOfOperationsSequence.BillOfOperationsSequence

Annotations (9)

NameValueLevelField
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.representativeKey ProductionRoutingSqncIntVers view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.internalName #LOCAL view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType plfl plnty
KEY ProductionRoutingGroup plfl plnnr
KEY ProductionRouting plfl plnal
KEY ProductionRoutingSequence plfl plnfl
KEY ProductionRoutingSqncIntVers plfl zaehl
BillOfOperationsVersion plfl versn
IsDeleted plfl loekz
IsImplicitlyDeleted plfl loekz_inherited
flgatasBillOfOperationsSequenceCat
SequenceText plfl ltxa1
SequenceSchedulingAlignment plfl auschl
bezflasBillOfOperationsRefSequence
BOOSqncBranchOpInternalID plfl bknt1
BOOSqncReturnOpInternalID plfl bknt2
aennrasChangeNumber
ValidityStartDate
ValidityEndDate
CreationDate plfl andat
CreatedByUser
LastChangeDate plfl aedat
LastChangedByUser
_BillOfOperations _BillOfOperations
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsSequence _BillOfOperationsSequence
_BillOfOperationsType _BillOfOperationsType 
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'ProductionRoutingSqncIntVers'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@Analytics.internalName:#LOCAL
@ObjectModel.supportedCapabilities:[#CDS_MODELING_DATA_SOURCE]

define view entity P_ProdnRoutingSequenceDEX
  as select from    plfl as plfl

  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.ProductionRoutingGroup = _BillOfOperationsGroup.BillOfOperationsGroup

  association [1..1] to I_MfgBillOfOperations            as _BillOfOperations             on  $projection.BillOfOperationsType    = _BillOfOperations.BillOfOperationsType
                                                                                       and $projection.ProductionRoutingGroup   = _BillOfOperations.BillOfOperationsGroup
                                                                                       and $projection.ProductionRouting = _BillOfOperations.BillOfOperationsVariant
                                                                                       
  association [1..1] to I_MfgBillOfOperationsSequence  as _BillOfOperationsSequence     on  $projection.BillOfOperationsType     = _BillOfOperationsSequence.BillOfOperationsType
                                                                                        and $projection.ProductionRoutingGroup    = _BillOfOperationsSequence.BillOfOperationsGroup
                                                                                        and $projection.ProductionRouting         = _BillOfOperationsSequence.BillOfOperationsVariant
                                                                                        and $projection.ProductionRoutingSequence = _BillOfOperationsSequence.BillOfOperationsSequence
{
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key plfl.plnty                                                     as   BillOfOperationsType,
      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key plfl.plnnr                                                     as   ProductionRoutingGroup,
      @ObjectModel.foreignKey.association: '_BillOfOperations'
  key plfl.plnal                                                     as   ProductionRouting,
      @ObjectModel.foreignKey.association: '_BillOfOperationsSequence'
  key plfl.plnfl                                                     as   ProductionRoutingSequence,
      @ObjectModel.text.element: ['SequenceText']
  key plfl.zaehl                                                     as   ProductionRoutingSqncIntVers,

      // NOT a key field in THIS view !

      plfl.versn                                                     as   BillOfOperationsVersion,

      // ***************** Technical fields not on the CEWB-UI *****************


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

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


      -- Sequence
      plfl.flgat                                                     as   BillOfOperationsSequenceCat,

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

      plfl.auschl                                                    as   SequenceSchedulingAlignment,

      -- Reference
      plfl.bezfl                                                     as   BillOfOperationsRefSequence,

      plfl.bknt1                                                     as   BOOSqncBranchOpInternalID,
      plfl.bknt2                                                     as   BOOSqncReturnOpInternalID,

      -- Administrative Data
      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 *****************************

      _BillOfOperations,
      _BillOfOperationsGroup,
      _BillOfOperationsSequence,
      _BillOfOperationsType
} where plfl.plnty = 'N';

Learn More