I_ProdnRoutingMatlAssgmtTP

DDL: I_PRODNROUTINGMATLASSGMTTP SQL: IRTGMATLASSGMTTP Type: view_entity TRANSACTIONAL

Transaction View for Production Routing Material Assignment

I_ProdnRoutingMatlAssgmtTP is a Transactional CDS View that provides data about "Transaction View for Production Routing Material Assignment" in SAP S/4HANA. It reads from 1 data source (I_RoutingMaterialAssignment) and exposes 17 fields with key fields Product, Plant, ProductionRoutingGroup, ProductionRouting, ProductionRoutingMatlAssgmt. It has 2 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_RoutingMaterialAssignment I_RoutingMaterialAssignment from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_ProductionRoutingHeaderTP _Header $projection.ProductionRoutingGroup = _Header.ProductionRoutingGroup and $projection.ProductionRouting = _Header.ProductionRouting and $projection.ValidityEndDate >= _Header.ValidityStartDate and $projection.ValidityStartDate <= _Header.ValidityEndDate
[1..1] I_MaterialText _MaterialText $projection.Product = _MaterialText.Material and _MaterialText.Language = $session.system_language

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey ProductionRoutingMatlAssgmt view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transaction View for Production Routing Material Assignment view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Product Material Product
KEY Plant Plant
KEY ProductionRoutingGroup BillOfOperationsGroup
KEY ProductionRouting BillOfOperationsVariant
KEY ProductionRoutingMatlAssgmt BOOToMaterialInternalID
KEY ProductionRtgMatlAssgmtIntVers BOOMatlInternalVersionCounter
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
ValidityStartDate
ValidityEndDate
ChangeNumber ChangeNumber
ChangedDateTime _ProdnRtgTP ChangedDateTime
ProductName _MaterialText MaterialName
_ProdnRtgTP _ProdnRtgTP
_Header _Header 
//@AbapCatalog.sqlViewName: 'IRTGMATLASSGMTTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'ProductionRoutingMatlAssgmt'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Transaction View for Production Routing Material Assignment'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #M, dataClass: #MASTER}
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view entity I_ProdnRoutingMatlAssgmtTP
  as select from I_RoutingMaterialAssignment
  association [1..*] to I_ProductionRoutingHeaderTP       as _Header       on  $projection.ProductionRoutingGroup =  _Header.ProductionRoutingGroup
                                                                           and $projection.ProductionRouting      =  _Header.ProductionRouting
                                                                           and $projection.ValidityEndDate        >= _Header.ValidityStartDate
                                                                           and $projection.ValidityStartDate      <= _Header.ValidityEndDate
  association        to parent I_ProdnRtgNonHistoricHdrTP as _ProdnRtgTP   on  $projection.ProductionRoutingGroup = _ProdnRtgTP.ProductionRoutingGroup
                                                                           and $projection.ProductionRouting      = _ProdnRtgTP.ProductionRouting

  association [1..1] to I_MaterialText                    as _MaterialText on  $projection.Product    = _MaterialText.Material
                                                                           and _MaterialText.Language = $session.system_language

{
      //I_ProductionRoutingMaterialAssgmt

      @Consumption.valueHelpDefinition: [{entity:{ name: 'C_MassMaintCapProductVH', element: 'Product'} }]
      @EndUserText.label: 'Product'
  key Material                                              as Product,
  key Plant,
  key BillOfOperationsGroup                                 as ProductionRoutingGroup,
  key BillOfOperationsVariant                               as ProductionRouting,
  key BOOToMaterialInternalID                               as ProductionRoutingMatlAssgmt,
  key BOOMatlInternalVersionCounter                         as ProductionRtgMatlAssgmtIntVers,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      @Semantics.businessDate.from: true
      cast(ValidityStartDate  as pph_begda preserving type) as ValidityStartDate,
      //      ValidityStartDate,

      @Semantics.businessDate.to: true
      cast(ValidityEndDate  as pph_endda preserving type)   as ValidityEndDate,
      //      ValidityEndDate,

      ChangeNumber,
      _ProdnRtgTP.ChangedDateTime,
      _MaterialText.MaterialName                            as ProductName,

      /* Associations */
      //I_ProductionRoutingMaterialAssgmt

      _ProdnRtgTP,
      _Header
}
where
      IsDeleted           <> 'X'
  and IsImplicitlyDeleted <> 'X'

Learn More