P_ShopFloorOrderInformation

DDL: P_SHOPFLOORORDERINFORMATION SQL: PMPESFOINFO Type: view CONSUMPTION Package: MPE_EXEC_COMMON
48 Fields 2 Data Sources 3 Associations

Shop Floor Order Header Data

P_ShopFloorOrderInformation is a Consumption CDS View that provides data about "Shop Floor Order Header Data" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrder, I_StatusObjectStatusBasic) and exposes 48 fields with key field ManufacturingOrder. It has 3 associations to related views. Part of development package MPE_EXEC_COMMON.

Data Sources (2)

SourceAliasJoin Type
I_MfgOrder ManufacturingOrder from
I_StatusObjectStatusBasic StatusObjectStatusBasic inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ProductionVersionBasic _ProductionVersionBasic $projection.Material = _ProductionVersionBasic.Product and $projection.ProductionPlant = _ProductionVersionBasic.Plant and $projection.ProductionVersion = _ProductionVersionBasic.ProductionVersion
[0..*] I_BillOfMaterialUsageText _BillOfMaterialUsageText $projection.BillOfMaterialVariantUsage = _BillOfMaterialUsageText.BillOfMaterialVariantUsage
[0..1] I_MfgOrder _MfgOrder $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMPESFOINFO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder
ForperformancereadingwhenaccessingJEST
Material I_MfgOrder Material Vehicle Model
ProductionPlant I_MfgOrder ProductionPlant Prod plnt
WBSDescription
MRPArea I_MfgOrder MRPArea MRP Area
MRPAreaText
MRPPlant I_MfgOrder MRPPlant Plant
MRPController I_MfgOrder MRPController MRP Controller
MRPControllerName
ProductionSupervisor I_MfgOrder ProductionSupervisor Prodn Supervisor
ProductionSupervisorName
ProdnProcgFlexibilityIndName
ProductionVersion I_MfgOrder ProductionVersion Version ID
ProductionVersionText _ProductionVersionBasic ProductionVersionText
ValidityStartDate _ProductionVersionBasic ValidityStartDate Validity Start Date
ValidityEndDate _ProductionVersionBasic ValidityEndDate ValidTo
BillOfOperationsTypeName
CreationDateTime BOOVersion1 CreationDateTime Timestamp
LastChangeDateTime BillOfOperationsVersion LastChangeDateTime Timestamp
BOOValidityStartDate I_MfgOrder BOOValidityStartDate
BOOExplosionDate I_MfgOrder BOOExplosionDate
BillOfMaterial
BillOfMaterialVariantUsage I_MfgOrder BillOfMaterialVariantUsage Usage
BillOfMaterialVariantUsageDesc
BillOfMaterialVersion I_MfgOrder BillOfMaterialVersion BOM Version
BOMExplosionDate I_MfgOrder BOMExplosionDate
MfgOrderScheduledStartDate
MfgOrderScheduledStartTime I_MfgOrder MfgOrderScheduledStartTime
MfgOrderScheduledEndDate
MfgOrderScheduledEndTime I_MfgOrder MfgOrderScheduledEndTime
MfgOrderActualStartDate
MfgOrderActualStartTime I_MfgOrder MfgOrderActualStartTime
MfgOrderConfirmedEndDate
MfgOrderConfirmedEndTime I_MfgOrder MfgOrderConfirmedEndTime
MfgOrderActualEndDate I_MfgOrder MfgOrderActualEndDate
MfgOrderPlannedTotalQty I_MfgOrder MfgOrderPlannedTotalQty
MfgOrderConfirmedYieldQty I_MfgOrder MfgOrderConfirmedYieldQty
MfgOrderConfirmedScrapQty I_MfgOrder MfgOrderConfirmedScrapQty
ActualDeliveredQuantity I_MfgOrder ActualDeliveredQuantity Delivered Quantity
ProductionUnit I_MfgOrder ProductionUnit
_BillOfMaterialUsageText _BillOfMaterialUsageText
_MfgOrder _MfgOrder
_Plant I_MfgOrder _Plant
_MRPArea I_MfgOrder _MRPArea
_MRPPlant I_MfgOrder _MRPPlant
_Material I_MfgOrder _Material
_ProductionVersion I_MfgOrder _ProductionVersion

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 P_ShopFloorOrderInformation.
-- 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: PMPESFOINFO

CREATE VIEW P_ShopFloorOrderInformation AS
SELECT
  cast( ManufacturingOrder.ManufacturingOrder as aufnr preserving type ) AS ManufacturingOrder,
  ManufacturingOrder.Material AS Material,
  ManufacturingOrder.ProductionPlant AS ProductionPlant,
  ManufacturingOrder._WBSElement.WBSDescription AS WBSDescription,
  ManufacturingOrder.MRPArea AS MRPArea,
  ManufacturingOrder._MRPArea.MRPAreaText AS MRPAreaText,
  ManufacturingOrder.MRPPlant AS MRPPlant,
  ManufacturingOrder.MRPController AS MRPController,
  ManufacturingOrder._MRPController.MRPControllerName AS MRPControllerName,
  ManufacturingOrder.ProductionSupervisor AS ProductionSupervisor,
  ManufacturingOrder._ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  ManufacturingOrder._ProdnProcgFlexibilityIndTxt[1: Language=$session.system_language].ProdnProcgFlexibilityIndName AS ProdnProcgFlexibilityIndName,
  ManufacturingOrder.ProductionVersion AS ProductionVersion,
  _ProductionVersionBasic.ProductionVersionText AS ProductionVersionText,
  _ProductionVersionBasic.ValidityStartDate AS ValidityStartDate,
  _ProductionVersionBasic.ValidityEndDate AS ValidityEndDate,
  BillOfOperationsType._Text[1: Language=$session.system_language].BillOfOperationsTypeName AS BillOfOperationsTypeName,
  BOOVersion1.CreationDateTime AS CreationDateTime,
  BillOfOperationsVersion.LastChangeDateTime AS LastChangeDateTime,
  ManufacturingOrder.BOOValidityStartDate AS BOOValidityStartDate,
  ManufacturingOrder.BOOExplosionDate AS BOOExplosionDate,
  cast( ManufacturingOrder.BillOfMaterial as mpe_exec_stnum preserving type ) AS BillOfMaterial,
  ManufacturingOrder.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _BillOfMaterialUsageText[1: Language=$session.system_language].BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  ManufacturingOrder.BillOfMaterialVersion AS BillOfMaterialVersion,
  ManufacturingOrder.BOMExplosionDate AS BOMExplosionDate,
  ManufacturingOrder.MfgOrderScheduledStartTime AS MfgOrderScheduledStartTime,
  ManufacturingOrder.MfgOrderScheduledEndTime AS MfgOrderScheduledEndTime,
  ManufacturingOrder.MfgOrderActualStartTime AS MfgOrderActualStartTime,
  ManufacturingOrder.MfgOrderConfirmedEndTime AS MfgOrderConfirmedEndTime,
  ManufacturingOrder.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  ManufacturingOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  ManufacturingOrder.MfgOrderConfirmedYieldQty AS MfgOrderConfirmedYieldQty,
  ManufacturingOrder.MfgOrderConfirmedScrapQty AS MfgOrderConfirmedScrapQty,
  ManufacturingOrder.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  ManufacturingOrder.ProductionUnit AS ProductionUnit,
  ManufacturingOrder._Plant AS _Plant,
  ManufacturingOrder._MRPArea AS _MRPArea,
  ManufacturingOrder._MRPPlant AS _MRPPlant,
  ManufacturingOrder._Material AS _Material,
  ManufacturingOrder._ProductionVersion AS _ProductionVersion
FROM I_MfgOrder AS ManufacturingOrder
INNER JOIN I_StatusObjectStatusBasic AS StatusObjectStatusBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionVersionBasic AS _ProductionVersionBasic ON Material = _ProductionVersionBasic.Product AND ProductionPlant = _ProductionVersionBasic.Plant AND ProductionVersion = _ProductionVersionBasic.ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsageText AS _BillOfMaterialUsageText ON BillOfMaterialVariantUsage = _BillOfMaterialUsageText.BillOfMaterialVariantUsage  -- association [0..*]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [0..1]
;

Learn More