P_ProdnRoutingMatlPRTAssgmtDEX

DDL: P_PRODNROUTINGMATLPRTASSGMTDEX Type: view_entity BASIC Package: VDM_PP_MD_RTG

Production Routing Main Header

P_ProdnRoutingMatlPRTAssgmtDEX is a Basic CDS View that provides data about "Production Routing Main Header" in SAP S/4HANA. It reads from 2 data sources (crvm_a, plfh) and exposes 39 fields with key fields BillOfOperationsType, ProductionRoutingGroup, BOOOperationPRTInternalID. It has 3 associations to related views. Part of development package VDM_PP_MD_RTG.

2 data source(s) 39 fields

Data Sources (2)

SourceAliasJoin Type
crvm_a crvm_a inner
plfh plfh from

Associations (3)

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_BOOOpPRTInternalID _BOOOperationPRTInternalID $projection.BillOfOperationsType = _BOOOperationPRTInternalID.BillOfOperationsType and $projection.ProductionRoutingGroup = _BOOOperationPRTInternalID.BillOfOperationsGroup and $projection.BOOOperationPRTInternalID = _BOOOperationPRTInternalID.BOOOperationPRTInternalID

Annotations (9)

NameValueLevelField
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.representativeKey BOOOperationPRTIntVersCounter 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 (39)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType plfh plnty
KEY ProductionRoutingGroup plfh plnnr
KEY BOOOperationPRTInternalID plfh pzlfh
zaehlasBOOOperationPRTIntVersCounter
ProductionRouting plfh plnal
ProductionRoutingSequence plfh plnfl
ProductionRoutingOpIntID plfh plnkn
BillOfOperationsVersion plfh versn
ProdnRsceToolItemNumber plfh psnfh
ProductionResourceType plfh objty
ProductionResourceInternalID plfh objid
Plant crvm_a werks
Product crvm_a matnr
ProdnRsceToolCategory
ProdnRsceToolControlProfile plfh steuf
ProdnRsceToolStandardTextCode plfh ktsch
ProdnRsceToolText plfh txtz1
CreationDate plfh datui
LastChangeDate plfh datuc
ChangeNumber plfh aennr
ValidityStartDate plfh datuv
ValidityEndDate plfh valid_to
IsDeleted plfh loekz
IsImplicitlyDeleted plfh loekz_inherited
ProdnRsceToolStdWorkQtyUnit plfh mgeinh
ProdnRsceToolStandardWorkQty plfh mgvgw
ProdnRsceToolTotQtyCalcFormula plfh mgform
ProdnRsceToolUsageQuantityUnit plfh eweinh
ProdnRsceToolUsageQuantity plfh ewvgw
ProdnRsceToolUsageQtyCalcFmla plfh ewform
StartDateOffsetReferenceCode plfh bzoffb
StartDateOffsetDurationUnit plfh ehoffb
StartDateOffsetDuration plfh offstb
EndDateOffsetReferenceCode plfh bzoffe
EndDateOffsetDurationUnit plfh ehoffe
EndDateOffsetDuration plfh offste
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BOOOperationPRTInternalID _BOOOperationPRTInternalID 
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'BOOOperationPRTIntVersCounter'
@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_ProdnRoutingMatlPRTAssgmtDEX
  as select from plfh
    inner join   crvm_a on  plfh.objty = crvm_a.objty
                        and plfh.objid = crvm_a.objid

  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_BOOOpPRTInternalID    as _BOOOperationPRTInternalID on  $projection.BillOfOperationsType      = _BOOOperationPRTInternalID.BillOfOperationsType
                                                                              and $projection.ProductionRoutingGroup    = _BOOOperationPRTInternalID.BillOfOperationsGroup
                                                                              and $projection.BOOOperationPRTInternalID = _BOOOperationPRTInternalID.BOOOperationPRTInternalID
{

           @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key      plfh.plnty                                                  as BillOfOperationsType,
           @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'

  key      plfh.plnnr                                                  as ProductionRoutingGroup,

           @ObjectModel.foreignKey.association:  '_BOOOperationPRTInternalID'
  key      plfh.pzlfh                                                  as BOOOperationPRTInternalID,
           -- Representative key
  key      plfh.zaehl                                                  as BOOOperationPRTIntVersCounter,

           plfh.plnal                                                  as ProductionRouting,

           plfh.plnfl                                                  as ProductionRoutingSequence,

           plfh.plnkn                                                  as ProductionRoutingOpIntID,

           plfh.versn                                                  as BillOfOperationsVersion,

           // External key

           plfh.psnfh                                                  as ProdnRsceToolItemNumber,


           plfh.objty                                                  as ProductionResourceType,

           plfh.objid                                                  as ProductionResourceInternalID,

           crvm_a.werks                                                as Plant,

           crvm_a.matnr                                                as Product,

           'M'                                                         as ProdnRsceToolCategory,

           plfh.steuf                                                  as ProdnRsceToolControlProfile,

           // Text


           plfh.ktsch                                                  as ProdnRsceToolStandardTextCode,

           @Semantics.text: true
           plfh.txtz1                                                  as ProdnRsceToolText,

           // Admin

           @Semantics.systemDate.createdAt: true
           plfh.datui                                                  as CreationDate,
           --
           @Semantics.user.createdBy: true
           cast(plfh.useri as vdm_createdbyuserid preserving type)     as CreatedByUser,
           @Semantics.systemDate.lastChangedAt: true
           plfh.datuc                                                  as LastChangeDate,
           --
           @Semantics.user.lastChangedBy: true
           cast(plfh.userc as vdm_lastchangedbyuserid preserving type) as LastChangedByUser,

           plfh.aennr                                                  as ChangeNumber,
           @Semantics.businessDate.from: true
           plfh.datuv                                                  as ValidityStartDate,
           @Semantics.businessDate.to: true
           plfh.valid_to                                               as ValidityEndDate,

           plfh.loekz                                                  as IsDeleted,
           plfh.loekz_inherited                                        as IsImplicitlyDeleted,

           plfh.mgeinh                                                 as ProdnRsceToolStdWorkQtyUnit,

           @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolStdWorkQtyUnit'
           plfh.mgvgw                                                  as ProdnRsceToolStandardWorkQty,

           plfh.mgform                                                 as ProdnRsceToolTotQtyCalcFormula,

           plfh.eweinh                                                 as ProdnRsceToolUsageQuantityUnit,

           @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolUsageQuantityUnit'
           plfh.ewvgw                                                  as ProdnRsceToolUsageQuantity,

           plfh.ewform                                                 as ProdnRsceToolUsageQtyCalcFmla,

           plfh.bzoffb                                                 as StartDateOffsetReferenceCode,

           plfh.ehoffb                                                 as StartDateOffsetDurationUnit,

           @Semantics.quantity.unitOfMeasure: 'StartDateOffsetDurationUnit'
           plfh.offstb                                                 as StartDateOffsetDuration,

           plfh.bzoffe                                                 as EndDateOffsetReferenceCode,

           plfh.ehoffe                                                 as EndDateOffsetDurationUnit,

           @Semantics.quantity.unitOfMeasure: 'EndDateOffsetDurationUnit'
           plfh.offste                                                 as EndDateOffsetDuration,

           // Associations

           _BillOfOperationsType,
           _BillOfOperationsGroup,
           _BOOOperationPRTInternalID

}
where
  plfh.plnty = 'N'

Learn More