P_ShopFloorOrderInformation

DDL: P_SHOPFLOORORDERINFORMATION SQL: PMPESFOINFO Type: view CONSUMPTION
55 Fields 2 Data Sources 3 Associations

P_ShopFloorOrderInformation is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_MfgOrder, I_StatusObjectStatusBasic) and exposes 55 fields with key field ManufacturingOrder. It has 3 associations to related views.

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 (55)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder
ForperformancereadingwhenaccessingJEST
Material I_MfgOrder Material Vehicle Model
ProductionPlant I_MfgOrder ProductionPlant Prod plnt
ManufacturingOrderType I_MfgOrder ManufacturingOrderType
ManufacturingOrderTypeName
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
ExtdQualityCheckIsRequired I_MfgOrder ExtdQualityCheckIsRequired
ExtdQualityCheckIndName
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
_MfgOrderType I_MfgOrder _MfgOrderType
_MRPArea I_MfgOrder _MRPArea
_MRPPlant I_MfgOrder _MRPPlant
_Material I_MfgOrder _Material
_MRPController I_MfgOrder _MRPController
_ProductionSupervisor I_MfgOrder _ProductionSupervisor
_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.ManufacturingOrderType AS ManufacturingOrderType,
  ManufacturingOrder._MfgOrderType._Text[1: Language=$session.system_language].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  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.ExtdQualityCheckIsRequired AS ExtdQualityCheckIsRequired,
  ManufacturingOrder._ExtendedQualityCheckIndTxt[1: Language=$session.system_language].ExtdQualityCheckIndName AS ExtdQualityCheckIndName,
  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._MfgOrderType AS _MfgOrderType,
  ManufacturingOrder._MRPArea AS _MRPArea,
  ManufacturingOrder._MRPPlant AS _MRPPlant,
  ManufacturingOrder._Material AS _Material,
  ManufacturingOrder._MRPController AS _MRPController,
  ManufacturingOrder._ProductionSupervisor AS _ProductionSupervisor,
  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