P_ProdnRoutingDocPRTAssgmtDEX

DDL: P_PRODNROUTINGDOCPRTASSGMTDEX Type: view_entity BASIC Package: VDM_PP_MD_RTG

Production Routing Document PRT

P_ProdnRoutingDocPRTAssgmtDEX is a Basic CDS View that provides data about "Production Routing Document PRT" in SAP S/4HANA. It reads from 2 data sources (crvd_a, plfh) and exposes 41 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) 41 fields

Data Sources (2)

SourceAliasJoin Type
crvd_a crvd_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 (41)

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
DocumentType crvd_a dokar
DocumentInfoRecord crvd_a doknr
DocumentVersion crvd_a dokvr
DocumentPart crvd_a doktl
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_ProdnRoutingDocPRTAssgmtDEX
  as select from plfh
    inner join   crvd_a on  plfh.objty = crvd_a.objty
                        and plfh.objid = crvd_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,
           
           crvd_a.dokar as DocumentType,
      
           crvd_a.doknr as DocumentInfoRecord,
      
           crvd_a.dokvr as DocumentVersion,
      
           crvd_a.doktl as DocumentPart,
           
           'D' 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