P_MfgOrderOperHoldUnionBasic

DDL: P_MFGORDEROPERHOLDUNIONBASIC SQL: PMPEMFGOPRHLDUNB Type: view CONSUMPTION
17 Fields 3 Data Sources

P_MfgOrderOperHoldUnionBasic is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (P_MfgOrderHeaderHold, P_MfgOrderOperationHold, I_OrderOperationBasic) and exposes 17 fields with key field ProductionHold.

Data Sources (3)

SourceAliasJoin Type
P_MfgOrderHeaderHold MfgOrderHeaderHold from
P_MfgOrderOperationHold MfgOrderOperationHold union_all
I_OrderOperationBasic OrderOperationBasic inner

Annotations (10)

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

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProductionHold P_MfgOrderHeaderHold ProductionHold
ManufacturingOrder P_MfgOrderHeaderHold ManufacturingOrder Order
OrderInternalID I_OrderOperationBasic OrderInternalID Plan No.f.Oper.
OrderOperationInternalID I_OrderOperationBasic OrderOperationInternalID Plan No.f.Oper.
ProductionHoldObjectType P_MfgOrderHeaderHold ProductionHoldObjectType
ProductionPlant P_MfgOrderHeaderHold ProductionPlant Prod plnt
Material P_MfgOrderHeaderHold Material Vehicle Model
WorkCenterInternalID P_MfgOrderHeaderHold WorkCenterInternalID Work Center
ProductionHold
ManufacturingOrder P_MfgOrderOperationHold ManufacturingOrder Order
OrderInternalID P_MfgOrderOperationHold OrderInternalID Plan No.f.Oper.
OrderOperationInternalID P_MfgOrderOperationHold OrderOperationInternalID Plan No.f.Oper.
ProductionHoldObjectType P_MfgOrderOperationHold ProductionHoldObjectType
ProductionPlant P_MfgOrderOperationHold ProductionPlant Prod plnt
Material P_MfgOrderOperationHold Material Vehicle Model
WorkCenterInternalID P_MfgOrderOperationHold WorkCenterInternalID Work Center
WorkCenterTypeCode P_MfgOrderOperationHold WorkCenterTypeCode Object Type

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_MfgOrderOperHoldUnionBasic.
-- 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: PMPEMFGOPRHLDUNB

CREATE VIEW P_MfgOrderOperHoldUnionBasic AS
SELECT
  MfgOrderHeaderHold.ProductionHold AS ProductionHold,
  MfgOrderHeaderHold.ManufacturingOrder AS ManufacturingOrder,
  OrderOperationBasic.OrderInternalID AS OrderInternalID,
  OrderOperationBasic.OrderOperationInternalID AS OrderOperationInternalID,
  MfgOrderHeaderHold.ProductionHoldObjectType AS ProductionHoldObjectType,
  MfgOrderHeaderHold.ProductionPlant AS ProductionPlant,
  MfgOrderHeaderHold.Material AS Material,
  MfgOrderHeaderHold.WorkCenterInternalID AS WorkCenterInternalID,
  MfgOrderOperationHold.WorkCenterTypeCode AS WorkCenterTypeCode
FROM P_MfgOrderHeaderHold AS MfgOrderHeaderHold
INNER JOIN I_OrderOperationBasic AS OrderOperationBasic ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_MfgOrderOperationHold
;

Learn More