I_ProductionOrderQuickView

DDL: I_PRODUCTIONORDERQUICKVIEW SQL: IPRODNORDQV Type: view COMPOSITE

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
KEY ManufacturingOrderItem ManufacturingOrderItem
Material P_ProductionOrderQuickView Material
MRPPlant MRPPlant
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
ManufacturingOrderTypeName
MfgOrderReleasedCode MfgOrderReleasedCode
MfgOrderPlannedStartDate MfgOrderPlannedStartDate
MfgOrderScheduledReleaseDate MfgOrderScheduledReleaseDate
MfgOrderScheduledStartDate MfgOrderScheduledStartDate
MfgOrderScheduledEndDate MfgOrderScheduledEndDate
MfgOrderPlannedEndDate MfgOrderPlannedEndDate
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration
MfgOrderPlannedTotalQty MfgOrderPlannedTotalQty
ExpectedDeviationQuantity _MfgOrder ExpectedDeviationQuantity
MfgOrderPlannedScrapQty MfgOrderPlannedScrapQty
MfgOrderItemGoodsReceiptQty MfgOrderItemGoodsReceiptQty
MRPElementOpenQuantity MRPElementOpenQuantity
BaseUnit P_ProductionOrderQuickView BaseUnit
ProductionPlant ProductionPlant
ProductionPlantName ProductionPlantName
ProductionVersion ProductionVersion
ProductionVersionText _ProductionVersion ProductionVersionText
ProductionLine ProductionLine
ProductionLineText _ProductionLineText WorkCenterText
ManufacturingOrderImportance _MfgOrder ManufacturingOrderImportance
ProductionSupervisor ProductionSupervisor
ProductionSupervisorName _ProductionSupervisor ProductionSupervisorName
MRPController MRPController
MRPControllerName MRPControllerName
InternalContactPersonName InternalContactPersonName
InternalContactPhoneNumber InternalContactPhoneNumber
InternalContactEmailAddress InternalContactEmailAddress
Reservation Reservation
RequirementDate RequirementDate
OrderedQuantity OrderedQuantity
WithdrawnQuantity WithdrawnQuantity
OpenQuantity OpenQuantity
MaterialPlannedProductionDurn MaterialPlannedProductionDurn
TotalReplenishmentLeadDuration TotalReplenishmentLeadDuration
FixedLotSizeQuantity FixedLotSizeQuantity
MinimumLotSizeQuantity MinimumLotSizeQuantity
MaximumLotSizeQuantity MaximumLotSizeQuantity
LotSizeRoundingQuantity LotSizeRoundingQuantity
RoundingProfile RoundingProfile
MaterialRoundingProfileName MaterialRoundingProfileName
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
WBSElementInternalID WBSElementInternalID
WBSElement WBSElement
_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
@AbapCatalog.sqlViewName: 'IPRODNORDQV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Quick view data for Production Order'
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XXL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view I_ProductionOrderQuickView
  as select from    P_ProductionOrderQuickView          as ProductionOrderItem  
  association [0..1] to I_WorkCenterTextBySemanticKey as _ProductionLineText on $projection.MRPPlant = _ProductionLineText.Plant
                                                                           and _ProductionLineText.Language  = $session.system_language
                                                                            and $projection.ProductionLine = _ProductionLineText.WorkCenter
{
  key OrderID,
  key ManufacturingOrderItem,
      ProductionOrderItem.Material,
      MRPPlant,
      ManufacturingOrderCategory,

      //      // Distinguishing between different quick view categories

      //      case $parameters.P_MRPElementCategory

      //        when 'FE' then '031'

      //        when 'BR' then '033'

      //        when 'AR' then case ManufacturingOrderCategory

      //          when '10' then '032'

      //          when '40' then '034'

      //          else '000'

      //        end

      //        else '000'

      //      end                                                                                                                                             as QuickViewCategory,


      ManufacturingOrderType,
      _MfgOrderType._Text[1: Language = $session.system_language].ManufacturingOrderTypeName,
      MfgOrderReleasedCode,

      MfgOrderPlannedStartDate,
      MfgOrderScheduledReleaseDate,
      MfgOrderScheduledStartDate,
      MfgOrderScheduledEndDate,
      MfgOrderPlannedEndDate,
      MaterialGoodsReceiptDuration,

      MfgOrderPlannedTotalQty,
      _MfgOrder.ExpectedDeviationQuantity,
      MfgOrderPlannedScrapQty,
       MfgOrderItemGoodsReceiptQty,
      MRPElementOpenQuantity,
      ProductionOrderItem.BaseUnit,

      ProductionPlant,
      ProductionPlantName,
      ProductionVersion,
      _ProductionVersion.ProductionVersionText,
      ProductionLine,
      _ProductionLineText.WorkCenterText                      as ProductionLineText,
      _MfgOrder.ManufacturingOrderImportance,

      // Internal Contact Data

      ProductionSupervisor,
      _ProductionSupervisor.ProductionSupervisorName,
      MRPController,
      MRPControllerName,
      InternalContactPersonName,
      InternalContactPhoneNumber,
      InternalContactEmailAddress,

      // Requirement Data

      Reservation,
      RequirementDate,
      OrderedQuantity,
      WithdrawnQuantity,
      OpenQuantity,

      // Procurement Data

      MaterialPlannedProductionDurn,
      TotalReplenishmentLeadDuration,
      FixedLotSizeQuantity,
      MinimumLotSizeQuantity,
      MaximumLotSizeQuantity,
     LotSizeRoundingQuantity,
      RoundingProfile,
     MaterialRoundingProfileName,

      // Related Objects

      SalesOrder,
      SalesOrderItem,
      WBSElementInternalID,
      WBSElement,

      // Associations

      _MfgOrder,
      _MfgOrderCategory,
      _MfgOrderType,
      _ProductionPlant,
      _ProductionSupervisor,
      _MRPController,
      _MRPPlant,
      ProductionOrderItem._Material,
      _ProductionVersion,
      _WBSElement,
      _Order,
      _ProductionLineText
}