P_OpActyAffectedByProdnHold

DDL: P_OPACTYAFFECTEDBYPRODNHOLD SQL: PMPESFIOAAFBPH Type: view COMPOSITE
9 Fields 5 Data Sources

P_OpActyAffectedByProdnHold is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (I_OpActyNtwkInstanceBasic, I_OperationActivityInstance, I_OrderItem, I_OrderOperationBasic, I_ProductionHoldBasic) and exposes 9 fields with key fields ProductionHold, OpActyNtwkInstance, OpActyNtwkElement.

Data Sources (5)

SourceAliasJoin Type
I_OpActyNtwkInstanceBasic OpActyNtwkInstanceBasic inner
I_OperationActivityInstance OperationActivityInstance from
I_OrderItem OrderItem inner
I_OrderOperationBasic OrderOperationBasic inner
I_ProductionHoldBasic ProductionHold inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPESFIOAAFBPH view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ProductionHold I_ProductionHoldBasic ProductionHold Hold ID
KEY OpActyNtwkInstance I_OpActyNtwkInstanceBasic OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OperationActivityInstance OpActyNtwkElement Element Number
ProductionHoldObjectType I_ProductionHoldBasic ProductionHoldObjectType Object Type
ManufacturingOrder I_OpActyNtwkInstanceBasic ManufacturingOrder Order
OrderInternalID I_ProductionHoldBasic OrderInternalID Plan No.f.Oper.
Material I_ProductionHoldBasic Material Vehicle Model
ProductionPlant I_ProductionHoldBasic ProductionPlant Prod plnt
WorkCenter

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_OpActyAffectedByProdnHold.
-- 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: PMPESFIOAAFBPH

CREATE VIEW P_OpActyAffectedByProdnHold AS
SELECT
  ProductionHold.ProductionHold AS ProductionHold,
  OpActyNtwkInstanceBasic.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActivityInstance.OpActyNtwkElement AS OpActyNtwkElement,
  ProductionHold.ProductionHoldObjectType AS ProductionHoldObjectType,
  OpActyNtwkInstanceBasic.ManufacturingOrder AS ManufacturingOrder,
  ProductionHold.OrderInternalID AS OrderInternalID,
  ProductionHold.Material AS Material,
  ProductionHold.ProductionPlant AS ProductionPlant,
  ProductionHold._WorkCenter.WorkCenter AS WorkCenter
FROM I_OperationActivityInstance AS OperationActivityInstance
INNER JOIN I_OpActyNtwkInstanceBasic AS OpActyNtwkInstanceBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationBasic AS OrderOperationBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderItem AS OrderItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductionHoldBasic AS ProductionHold ON /* join condition not captured in parsed metadata */
;

Learn More