I_ProductionOrderQuickView

DDL: I_PRODUCTIONORDERQUICKVIEW SQL: IPRODNORDQV Type: view COMPOSITE
63 Fields 1 Data Sources 1 Associations

Quick view data for Production Order

I_ProductionOrderQuickView is a Composite CDS View that provides data about "Quick view data for Production Order" in SAP S/4HANA. It reads from 1 data source (P_ProductionOrderQuickView) and exposes 63 fields with key fields OrderID, ManufacturingOrderItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProductionOrderQuickView ProductionOrderItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WorkCenterTextBySemanticKey _ProductionLineText $projection.MRPPlant = _ProductionLineText.Plant and _ProductionLineText.Language = $session.system_language and $projection.ProductionLine = _ProductionLineText.WorkCenter

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPRODNORDQV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quick view data for Production Order view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY OrderID OrderID Order ID
KEY ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
Material P_ProductionOrderQuickView Material Vehicle Model
MRPPlant MRPPlant Plant
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
ManufacturingOrderTypeName
MfgOrderReleasedCode MfgOrderReleasedCode
MfgOrderPlannedStartDate MfgOrderPlannedStartDate
MfgOrderScheduledReleaseDate MfgOrderScheduledReleaseDate
MfgOrderScheduledStartDate MfgOrderScheduledStartDate
MfgOrderScheduledEndDate MfgOrderScheduledEndDate
MfgOrderPlannedEndDate MfgOrderPlannedEndDate
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
MfgOrderPlannedTotalQty MfgOrderPlannedTotalQty
ExpectedDeviationQuantity _MfgOrder ExpectedDeviationQuantity
MfgOrderPlannedScrapQty MfgOrderPlannedScrapQty
MfgOrderItemGoodsReceiptQty MfgOrderItemGoodsReceiptQty Delivered Quantity
MRPElementOpenQuantity MRPElementOpenQuantity Rec./reqd qty
BaseUnit P_ProductionOrderQuickView BaseUnit Unit of Measure
ProductionPlant ProductionPlant Prod plnt
ProductionPlantName ProductionPlantName
ProductionVersion ProductionVersion Version ID
ProductionVersionText _ProductionVersion ProductionVersionText
ProductionLine ProductionLine Production Line
ProductionLineText _ProductionLineText WorkCenterText Work Center Text
ManufacturingOrderImportance _MfgOrder ManufacturingOrderImportance
ProductionSupervisor ProductionSupervisor Prodn Supervisor
ProductionSupervisorName _ProductionSupervisor ProductionSupervisorName
MRPController MRPController MRP Controller
MRPControllerName MRPControllerName Controller name
InternalContactPersonName InternalContactPersonName
InternalContactPhoneNumber InternalContactPhoneNumber Telephone no.
InternalContactEmailAddress InternalContactEmailAddress E-Mail Address
Reservation Reservation Reservation
RequirementDate RequirementDate Requirement Date
OrderedQuantity OrderedQuantity Quantity
WithdrawnQuantity WithdrawnQuantity Withdrawn Quantity
OpenQuantity OpenQuantity PBE Entry Open Qty
MaterialPlannedProductionDurn MaterialPlannedProductionDurn InhseProdTime
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration Total RL time
FixedLotSizeQuantity FixedLotSizeQuantity Fixed lot size
MinimumLotSizeQuantity MinimumLotSizeQuantity Min. Lot Size
MaximumLotSizeQuantity MaximumLotSizeQuantity Max. Lot Size
LotSizeRoundingQuantity LotSizeRoundingQuantity Rounding value
RoundingProfile RoundingProfile Rnding Profile
MaterialRoundingProfileName MaterialRoundingProfileName
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElement WBSElement WBS Internal ID
_MfgOrder _MfgOrder
_MfgOrderCategory _MfgOrderCategory
_MfgOrderType _MfgOrderType
_ProductionPlant _ProductionPlant
_ProductionSupervisor _ProductionSupervisor
_MRPController _MRPController
_MRPPlant _MRPPlant
_Material P_ProductionOrderQuickView _Material
_ProductionVersion _ProductionVersion
_WBSElement _WBSElement
_Order _Order
_ProductionLineText _ProductionLineText

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProductionOrderQuickView.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPRODNORDQV

CREATE VIEW I_ProductionOrderQuickView AS
SELECT
  OrderID,
  ManufacturingOrderItem,
  ProductionOrderItem.Material AS Material,
  MRPPlant,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  _MfgOrderType._Text[1: Language = $session.system_language].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  MfgOrderReleasedCode,
  MfgOrderPlannedStartDate,
  MfgOrderScheduledReleaseDate,
  MfgOrderScheduledStartDate,
  MfgOrderScheduledEndDate,
  MfgOrderPlannedEndDate,
  MaterialGoodsReceiptDuration,
  MfgOrderPlannedTotalQty,
  _MfgOrder.ExpectedDeviationQuantity AS ExpectedDeviationQuantity,
  MfgOrderPlannedScrapQty,
  MfgOrderItemGoodsReceiptQty,
  MRPElementOpenQuantity,
  ProductionOrderItem.BaseUnit AS BaseUnit,
  ProductionPlant,
  ProductionPlantName,
  ProductionVersion,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  ProductionLine,
  _ProductionLineText.WorkCenterText AS ProductionLineText,
  _MfgOrder.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  ProductionSupervisor,
  _ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  MRPController,
  MRPControllerName,
  InternalContactPersonName,
  InternalContactPhoneNumber,
  InternalContactEmailAddress,
  Reservation,
  RequirementDate,
  OrderedQuantity,
  WithdrawnQuantity,
  OpenQuantity,
  MaterialPlannedProductionDurn,
  TotalReplenishmentLeadDuration,
  FixedLotSizeQuantity,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  LotSizeRoundingQuantity,
  RoundingProfile,
  MaterialRoundingProfileName,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  WBSElement,
  ProductionOrderItem._Material AS _Material
FROM P_ProductionOrderQuickView AS ProductionOrderItem
LEFT OUTER JOIN I_WorkCenterTextBySemanticKey AS _ProductionLineText ON MRPPlant = _ProductionLineText.Plant AND _ProductionLineText.Language = $session.system_language AND ProductionLine = _ProductionLineText.WorkCenter  -- association [0..1]
;

Learn More