I_ProcOrdMgmtIssues

DDL: I_PROCORDMGMTISSUES SQL: IPROCORDMGMTISS Type: view COMPOSITE Package: VDM_PP_PROC_ORD_MNG
14 Fields 1 Data Sources 3 Associations

Process Order Management Issues

I_ProcOrdMgmtIssues is a Composite CDS View that provides data about "Process Order Management Issues" in SAP S/4HANA. It reads from 1 data source (P_ProcOrdMgmtBasic) and exposes 14 fields with key field ProcessOrder. It has 3 associations to related views. Part of development package VDM_PP_PROC_ORD_MNG.

Data Sources (1)

SourceAliasJoin Type
P_ProcOrdMgmtBasic ord from

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_NmbrOfProcOrdOpsWithDelay _NumbrProcOpWithDelay $projection.OrderInternalBillOfOperations = _NumbrProcOpWithDelay.OrderInternalBillOfOperations and $projection.ProcessOrder = _NumbrProcOpWithDelay.ProcessOrder and $projection.ProductionPlant = _NumbrProcOpWithDelay.ProductionPlant and $projection.ProductionSupervisor = _NumbrProcOpWithDelay.ProductionSupervisor
[0..1] P_NmbrOfProcOrdOpsWithQtyIss _NumbrProcOpWithQtyIss $projection.OrderInternalBillOfOperations = _NumbrProcOpWithQtyIss.OrderInternalBillOfOperations and $projection.ProcessOrder = _NumbrProcOpWithQtyIss.ProcessOrder and $projection.ProductionPlant = _NumbrProcOpWithQtyIss.ProductionPlant and $projection.ProductionSupervisor = _NumbrProcOpWithQtyIss.ProductionSupervisor
[0..1] P_NmbrOfProcOrdOpsWithQltyIss _NumbrProcOpWithQltyIss $projection.OrderInternalBillOfOperations = _NumbrProcOpWithQltyIss.OrderInternalBillOfOperations and $projection.ProcessOrder = _NumbrProcOpWithQltyIss.ProcessOrder and $projection.ProductionPlant = _NumbrProcOpWithQltyIss.ProductionPlant and $projection.ProductionSupervisor = _NumbrProcOpWithQltyIss.ProductionSupervisor

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPROCORDMGMTISS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Process Order Management Issues view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey ProcessOrder view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value ProcessOrder view
UI.headerInfo.typeName Process Order view
UI.headerInfo.typeNamePlural Process Orders view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProcessOrder ManufacturingOrder Order
ManufacturingOrderCategory ManufacturingOrderCategory Order Category
ManufacturingOrderType ManufacturingOrderType
ManufacturingOrderText ManufacturingOrderText
ProductionPlant ProductionPlant Prod plnt
ProductionSupervisor ProductionSupervisor Prodn Supervisor
OrderInternalBillOfOperations MfgOrderInternalID
NmbrOfProcOrdOpsWithDelay _NumbrProcOpWithDelay NmbrOfProcOrdOpsWithDelay
NmbrOfProcOrdOpsWithQtyIss _NumbrProcOpWithQtyIss NmbrOfProcOrdOpsWithQtyIss
NmbrOfProcOrdOpsWithQltyIss _NumbrProcOpWithQltyIss NmbrOfProcOrdOpsWithQltyIss
_MfgOrderCategory _MfgOrderCategory
_MfgOrderType _MfgOrderType
_ProductionPlant _ProductionPlant
_ProcOrd _ProcOrd

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_ProcOrdMgmtIssues.
-- 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: IPROCORDMGMTISS

CREATE VIEW I_ProcOrdMgmtIssues AS
SELECT
  ManufacturingOrder AS ProcessOrder,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ManufacturingOrderText,
  ProductionPlant,
  ProductionSupervisor,
  MfgOrderInternalID AS OrderInternalBillOfOperations,
  _NumbrProcOpWithDelay.NmbrOfProcOrdOpsWithDelay AS NmbrOfProcOrdOpsWithDelay,
  _NumbrProcOpWithQtyIss.NmbrOfProcOrdOpsWithQtyIss AS NmbrOfProcOrdOpsWithQtyIss,
  _NumbrProcOpWithQltyIss.NmbrOfProcOrdOpsWithQltyIss AS NmbrOfProcOrdOpsWithQltyIss
FROM P_ProcOrdMgmtBasic AS ord
LEFT OUTER JOIN P_NmbrOfProcOrdOpsWithDelay AS _NumbrProcOpWithDelay ON OrderInternalBillOfOperations = _NumbrProcOpWithDelay.OrderInternalBillOfOperations AND ProcessOrder = _NumbrProcOpWithDelay.ProcessOrder AND ProductionPlant = _NumbrProcOpWithDelay.ProductionPlant AND ProductionSupervisor = _NumbrProcOpWithDelay.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN P_NmbrOfProcOrdOpsWithQtyIss AS _NumbrProcOpWithQtyIss ON OrderInternalBillOfOperations = _NumbrProcOpWithQtyIss.OrderInternalBillOfOperations AND ProcessOrder = _NumbrProcOpWithQtyIss.ProcessOrder AND ProductionPlant = _NumbrProcOpWithQtyIss.ProductionPlant AND ProductionSupervisor = _NumbrProcOpWithQtyIss.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN P_NmbrOfProcOrdOpsWithQltyIss AS _NumbrProcOpWithQltyIss ON OrderInternalBillOfOperations = _NumbrProcOpWithQltyIss.OrderInternalBillOfOperations AND ProcessOrder = _NumbrProcOpWithQltyIss.ProcessOrder AND ProductionPlant = _NumbrProcOpWithQltyIss.ProductionPlant AND ProductionSupervisor = _NumbrProcOpWithQltyIss.ProductionSupervisor  -- association [0..1]
;

Learn More