P_ProdnHoldAffcdSFIAtOpActy

DDL: P_PRODNHOLDAFFCDSFIATOPACTY SQL: PMPEHLDSFIATOA Type: view CONSUMPTION Package: MPE_EXEC_SFI
37 Fields 2 Data Sources 1 Associations

SFI at an OA affected when a production hold was applied

P_ProdnHoldAffcdSFIAtOpActy is a Consumption CDS View that provides data about "SFI at an OA affected when a production hold was applied" in SAP S/4HANA. It reads from 2 data sources (I_OpActyInstceNtwkElmntBasic, I_ProdnHoldAffcdSFIAtOpActy) and exposes 37 fields with key fields ProductionHold, ShopFloorItem, OpActyNtwkInstance, OpActyNtwkElement. It has 1 association to related views. Part of development package MPE_EXEC_SFI.

Data Sources (2)

SourceAliasJoin Type
I_OpActyInstceNtwkElmntBasic OpActyInstceOpActyNtwkElmnt inner
I_ProdnHoldAffcdSFIAtOpActy ProdnHoldAffcdSFIAtOpActy from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_OrderOperationBasic _OrderOperationBasic $projection.OrderInternalID = _OrderOperationBasic.OrderInternalID and $projection.OrderOperationInternalID = _OrderOperationBasic.OrderOperationInternalID

Annotations (10)

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

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY ProductionHold I_ProdnHoldAffcdSFIAtOpActy ProductionHold Hold ID
KEY ShopFloorItem I_ProdnHoldAffcdSFIAtOpActy ShopFloorItem Serial.Mat. ID
KEY OpActyNtwkInstance I_ProdnHoldAffcdSFIAtOpActy OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_ProdnHoldAffcdSFIAtOpActy OpActyNtwkElement Element Number
StatusAndActionSchema I_ProdnHoldAffcdSFIAtOpActy StatusAndActionSchema Status Action Schema
StatusAndActionSchemaStatus I_ProdnHoldAffcdSFIAtOpActy StatusAndActionSchemaStatus Status
SerialNumber
Material
ProductionPlant
OpActyNtwkElementElement
OpActyNtwkElementElmntVersCntr I_OpActyInstceNtwkElmntBasic OpActyNtwkElementElmntVersCntr OA Version
OpActyNtwkElementExternalID
ManufacturingOrder I_OpActyInstceNtwkElmntBasic ManufacturingOrder Order
OrderInternalID I_OpActyInstceNtwkElmntBasic OrderInternalID Plan No.f.Oper.
OrderOperationInternalID I_OpActyInstceNtwkElmntBasic OrderOperationInternalID
ManufacturingOrderOperation
MfgOrderOperationText
ProductionHoldObjectType
ProductionHoldStartDateTime
ProductionHoldEndDateTime
ProductionHoldStatus
DefectInternalID
Notification
NotificationItem
_ProductionHoldBasic I_ProdnHoldAffcdSFIAtOpActy _ProductionHoldBasic
_Defect
_Notification
_NotificationItem
_ShopFloorItem I_ProdnHoldAffcdSFIAtOpActy _ShopFloorItem
_MfgOrder I_OpActyInstceNtwkElmntBasic _MfgOrder
_MfgOrderOperation I_OpActyInstceNtwkElmntBasic _MfgOrderOperation
_OpActyNtwkInstance I_ProdnHoldAffcdSFIAtOpActy _OpActyNtwkInstance
_OperationActivityInstance I_ProdnHoldAffcdSFIAtOpActy _OperationActivityInstance
_OpActyInstceOpActyNtwkElmnt I_ProdnHoldAffcdSFIAtOpActy _OpActyInstceOpActyNtwkElmnt
_SASSchema I_ProdnHoldAffcdSFIAtOpActy _SASSchema
_SASStatus I_ProdnHoldAffcdSFIAtOpActy _SASStatus
_OperationActivityText I_OpActyInstceNtwkElmntBasic _OperationActivityText

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_ProdnHoldAffcdSFIAtOpActy.
-- 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: PMPEHLDSFIATOA

CREATE VIEW P_ProdnHoldAffcdSFIAtOpActy AS
SELECT
  ProdnHoldAffcdSFIAtOpActy.ProductionHold AS ProductionHold,
  ProdnHoldAffcdSFIAtOpActy.ShopFloorItem AS ShopFloorItem,
  ProdnHoldAffcdSFIAtOpActy.OpActyNtwkInstance AS OpActyNtwkInstance,
  ProdnHoldAffcdSFIAtOpActy.OpActyNtwkElement AS OpActyNtwkElement,
  ProdnHoldAffcdSFIAtOpActy.StatusAndActionSchema AS StatusAndActionSchema,
  ProdnHoldAffcdSFIAtOpActy.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  ProdnHoldAffcdSFIAtOpActy._ShopFloorItem.Material AS Material,
  ProdnHoldAffcdSFIAtOpActy._ShopFloorItem._MfgOrder.ProductionPlant AS ProductionPlant,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  cast(OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementExternalID as mpe_oa_number_at_hold preserving type) AS OpActyNtwkElementExternalID,
  OpActyInstceOpActyNtwkElmnt.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstceOpActyNtwkElmnt.OrderInternalID AS OrderInternalID,
  OpActyInstceOpActyNtwkElmnt.OrderOperationInternalID AS OrderOperationInternalID,
  cast(_OrderOperationBasic.Operation as mpe_oper_at_hold preserving type) AS ManufacturingOrderOperation,
  cast(_OrderOperationBasic.OperationText as mfgorderoperationtext preserving type) AS MfgOrderOperationText,
  ProdnHoldAffcdSFIAtOpActy._ProductionHoldBasic.ProductionHoldStartDateTime AS ProductionHoldStartDateTime,
  ProdnHoldAffcdSFIAtOpActy._ProductionHoldBasic.ProductionHoldEndDateTime AS ProductionHoldEndDateTime,
  ProdnHoldAffcdSFIAtOpActy._ProductionHoldBasic.ProductionHoldStatus AS ProductionHoldStatus,
  ProdnHoldAffcdSFIAtOpActy._ProductionHoldBasic.DefectInternalID AS DefectInternalID,
  ProdnHoldAffcdSFIAtOpActy._ProductionHoldBasic.Notification AS Notification,
  ProdnHoldAffcdSFIAtOpActy._ProductionHoldBasic.NotificationItem AS NotificationItem,
  ProdnHoldAffcdSFIAtOpActy._ProductionHoldBasic AS _ProductionHoldBasic,
  ProdnHoldAffcdSFIAtOpActy._ProductionHoldBasic._Defect AS _Defect,
  ProdnHoldAffcdSFIAtOpActy._ProductionHoldBasic._Notification AS _Notification,
  ProdnHoldAffcdSFIAtOpActy._ProductionHoldBasic._NotificationItem AS _NotificationItem,
  ProdnHoldAffcdSFIAtOpActy._ShopFloorItem AS _ShopFloorItem,
  OpActyInstceOpActyNtwkElmnt._MfgOrder AS _MfgOrder,
  OpActyInstceOpActyNtwkElmnt._MfgOrderOperation AS _MfgOrderOperation,
  ProdnHoldAffcdSFIAtOpActy._OpActyNtwkInstance AS _OpActyNtwkInstance,
  ProdnHoldAffcdSFIAtOpActy._OperationActivityInstance AS _OperationActivityInstance,
  ProdnHoldAffcdSFIAtOpActy._OpActyInstceOpActyNtwkElmnt AS _OpActyInstceOpActyNtwkElmnt,
  ProdnHoldAffcdSFIAtOpActy._SASSchema AS _SASSchema,
  ProdnHoldAffcdSFIAtOpActy._SASStatus AS _SASStatus,
  OpActyInstceOpActyNtwkElmnt._OperationActivityText AS _OperationActivityText
FROM I_ProdnHoldAffcdSFIAtOpActy AS ProdnHoldAffcdSFIAtOpActy
INNER JOIN I_OpActyInstceNtwkElmntBasic AS OpActyInstceOpActyNtwkElmnt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrderOperationBasic AS _OrderOperationBasic ON OrderInternalID = _OrderOperationBasic.OrderInternalID AND OrderOperationInternalID = _OrderOperationBasic.OrderOperationInternalID  -- association [0..1]
;

Learn More