P_ProductionRoutingDEX

DDL: P_PRODUCTIONROUTINGDEX Type: view_entity BASIC Package: VDM_PP_MD_RTG

Production Routing Main Header

P_ProductionRoutingDEX is a Basic CDS View that provides data about "Production Routing Main Header" in SAP S/4HANA. It reads from 1 data source (plkz) and exposes 23 fields with key fields BillOfOperationsType, ProductionRoutingGroup, ProductionRouting. It has 2 associations to related views. Part of development package VDM_PP_MD_RTG.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
plkz plkz from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.ProductionRoutingGroup = _BillOfOperationsGroup.BillOfOperationsGroup

Annotations (9)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType plkz plnty
KEY ProductionRoutingGroup plkz plnnr
KEY ProductionRouting plkz plnal
BillOfOperationsVersionType plkz subtype
BillOfOperationsSubtype plkz subtype
LastUsageDate plkz abdat
NumberOfUsages plkz abanz
HasChangeNumber plkz flg_ecm
HasParameterEffectivity plkz flg_ecm_par
aedatasLastChangeDate
LastChangeTime plkz aeuzeit
LastChangedByUser
IsMarkedForDeletion plkz delkz
BillOfOperationsVariantDesc plkz altext
RoutingIsReworkRouting plkz rework
ProdnProcgIsFlexible plkz relaxed
BillOfOperationIsExecutedInMES plkz execution_in_me
BillOfOperationsIsTrnsfdToERP plkz erp_integration
ShopFloorRtgTemplateCategory plkz reference_template_category
ShopFloorRoutingTemplateType plkz reference_template_type
ShopFloorRoutingTemplateOwner plkz reference_template_owner
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType 
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'ProductionRouting'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@Analytics.internalName:#LOCAL
@ObjectModel.supportedCapabilities:[#CDS_MODELING_DATA_SOURCE]

define view entity P_ProductionRoutingDEX
  as select from plkz

  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
{
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key plkz.plnty                                                  as BillOfOperationsType,

      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key plkz.plnnr                                                  as ProductionRoutingGroup,
  key plkz.plnal                                                  as ProductionRouting,

      plkz.subtype                                                as BillOfOperationsVersionType,

      plkz.subtype                                                as BillOfOperationsSubtype, //kept for compatibility reasons


      plkz.abdat                                                  as LastUsageDate,
      plkz.abanz                                                  as NumberOfUsages,

      plkz.flg_ecm                                                as HasChangeNumber,
      plkz.flg_ecm_par                                            as HasParameterEffectivity,

      -- Administrative Data
      @Semantics.systemDate.lastChangedAt: true
      plkz.aedat                                                  as LastChangeDate,
      plkz.aeuzeit                                                as LastChangeTime,
      @Semantics.user.lastChangedBy: true
      cast(plkz.aenam as vdm_lastchangedbyuserid preserving type) as LastChangedByUser,
      plkz.delkz                                                  as IsMarkedForDeletion,
      
      plkz.altext                                                 as BillOfOperationsVariantDesc,

      plkz.rework                                                 as RoutingIsReworkRouting,
      plkz.relaxed                                                as ProdnProcgIsFlexible,
      @Semantics.booleanIndicator:true
      plkz.execution_in_me                                        as BillOfOperationIsExecutedInMES,
      @Semantics.booleanIndicator:true
      plkz.erp_integration                                        as BillOfOperationsIsTrnsfdToERP,
      
      plkz.reference_template_category                            as ShopFloorRtgTemplateCategory,
      plkz.reference_template_type                                as ShopFloorRoutingTemplateType,
//      plkz.reference_template_subtype                             as ShopFloorRtgTemplateSubType,

      plkz.reference_template_owner                               as ShopFloorRoutingTemplateOwner,

      // **************************** Associations *****************************


      _BillOfOperationsGroup,
      _BillOfOperationsType
} where plkz.plnty = 'N'

Learn More