P_LATESTPRODUCTIONROUTINGVERS
P_LATESTPRODUCTIONROUTINGVERS is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MfgOrderSpecificRouting | view | inner | COMPOSITE | Manufacturing Order Specific Routing |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
// used in I_MfgOrderSpecificRouting to get latest routing version and not all versions
define view entity P_LatestProductionRoutingVers as
select from I_BillOfOperationsVersion as ProdnRtgVersion
{
key ProdnRtgVersion.BillOfOperationsType,
key ProdnRtgVersion.BillOfOperationsGroup,
key ProdnRtgVersion.BillOfOperationsVariant,
max(ProdnRtgVersion.CreationDateTime) as CreationDateTime
}
where ProdnRtgVersion.OrderID <> ''
group by ProdnRtgVersion.BillOfOperationsType,
ProdnRtgVersion.BillOfOperationsGroup,
ProdnRtgVersion.BillOfOperationsVariant;