P_PRODUCTIONORDERQUICKVIEW
P view for Production Order
P_PRODUCTIONORDERQUICKVIEW is a CDS View in S/4HANA. P view for Production Order. It contains 3 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProductionOrderQuickView | view | from | COMPOSITE | Quick view data for Production Order |
Fields (3)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| _Material | _Material | 1 | |
| BaseUnit | BaseUnit | 1 | |
| Material | Material | 1 |
@AbapCatalog.sqlViewName: 'PPRODNORDQV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'P view for Production Order'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XL, dataClass: #MASTER}
@VDM.private: true
@VDM.viewType: #BASIC
define view P_ProductionOrderQuickView
as select from I_MfgOrderItem as ProductionOrderItem
left outer to one join I_ProductSupplyPlanning as _ProductSupplyPlanning on ProductionOrderItem.Material = _ProductSupplyPlanning.Product
and MRPPlant = _ProductSupplyPlanning.Plant
association [0..1] to I_ReservationItem as _ReservationItem on $projection.Reservation = _ReservationItem.Reservation
and $projection.ManufacturingOrderItem = _ReservationItem.ReservationItem
association [0..1] to P_DDMRPController as _MRPCtrlr on $projection.MRPPlant = _MRPCtrlr.Plant
and $projection.MRPController = _MRPCtrlr.MRPController
association [0..1] to I_RoundingPrfText as _RoundingProfile on $projection.RoundingProfile = _RoundingProfile.MaterialRoundingProfile
and $projection.MRPPlant = _RoundingProfile.Plant
association [0..1] to I_Order as _Order on $projection.OrderID = _Order.OrderID
{
key ManufacturingOrder as OrderID,
key ManufacturingOrderItem,
ProductionOrderItem.Material,
MRPPlant,
ManufacturingOrderCategory,
ManufacturingOrderType,
_MfgOrderType._Text[1: Language = $session.system_language].ManufacturingOrderTypeName,
MfgOrderReleasedCode,
MfgOrderPlannedStartDate,
MfgOrderScheduledReleaseDate,
MfgOrderScheduledStartDate,
MfgOrderScheduledEndDate,
MfgOrderPlannedEndDate,
MaterialGoodsReceiptDuration,
MfgOrderPlannedTotalQty,
_MfgOrder.ExpectedDeviationQuantity,
MfgOrderPlannedScrapQty,
_MfgOrder.ActualDeliveredQuantity as MfgOrderItemGoodsReceiptQty,
(MfgOrderPlannedTotalQty - _MfgOrder.ExpectedDeviationQuantity - MfgOrderPlannedScrapQty - _MfgOrder.ActualDeliveredQuantity) as MRPElementOpenQuantity,
ProductionOrderItem.BaseUnit,
ProductionPlant,
_MfgOrder._Plant.PlantName as ProductionPlantName,
ProductionVersion,
_ProductionVersion.ProductionVersionText,
_ProductionVersion.ProductionLine as ProductionLine,
// _ProductionVersion._ProductionLine._WorkCenterTextBySemanticKey[ 1: Language = $session.system_language ].WorkCenterText as ProductionLineText,
_MfgOrder.ManufacturingOrderImportance,
// Internal Contact Data
ProductionSupervisor,
_ProductionSupervisor.ProductionSupervisorName,
MRPController,
_MRPCtrlr.MRPControllerName as MRPControllerName,
_MRPCtrlr.InternalContactName as InternalContactPersonName,
_MRPCtrlr.PhoneNumber as InternalContactPhoneNumber,
_MRPCtrlr.EmailAddress as InternalContactEmailAddress,
// Requirement Data
Reservation,
_ReservationItem.MatlCompRequirementDate as RequirementDate,
_ReservationItem.ResvnItmRequiredQtyInBaseUnit as OrderedQuantity,
_ReservationItem.ResvnItmWithdrawnQtyInBaseUnit as WithdrawnQuantity,
(_ReservationItem.ResvnItmRequiredQtyInBaseUnit - _ReservationItem.ResvnItmWithdrawnQtyInBaseUnit) as OpenQuantity,
// Procurement Data
_ProductSupplyPlanning.InHouseProductionTime as MaterialPlannedProductionDurn,
_ProductSupplyPlanning.TotalReplenishmentLeadTime as TotalReplenishmentLeadDuration,
_ProductSupplyPlanning.FixedLotSizeQuantity as FixedLotSizeQuantity,
_ProductSupplyPlanning.MinimumLotSizeQuantity as MinimumLotSizeQuantity,
_ProductSupplyPlanning.MaximumLotSizeQuantity as MaximumLotSizeQuantity,
_ProductSupplyPlanning.LotSizeRoundingQuantity as LotSizeRoundingQuantity,
_ProductSupplyPlanning.RoundingProfile as RoundingProfile,
_RoundingProfile[ 1: Language = $session.system_language ].MaterialRoundingProfileName as MaterialRoundingProfileName,
// Related Objects
SalesOrder,
SalesOrderItem,
WBSElementInternalID,
_WBSElement.WBSElement as WBSElement,
// Associations
_MfgOrder,
_MfgOrderCategory,
_MfgOrderType,
_ProductionPlant,
_ProductionSupervisor,
_MRPController,
_MRPPlant,
ProductionOrderItem._Material,
_ProductionVersion,
_WBSElement,
_Order
}