P_ProcOrdOpStatus

DDL: P_PROCORDOPSTATUS SQL: PPROCORDOPSTS Type: view COMPOSITE
23 Fields 2 Data Sources

P_ProcOrdOpStatus is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_OrderOperationBasic, I_MfgOrderBasic) and exposes 23 fields with key fields MfgOrderInternalID, OrderOperationInternalID.

Data Sources (2)

SourceAliasJoin Type
I_OrderOperationBasic afvc from
I_MfgOrderBasic aufv inner

Annotations (10)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY MfgOrderInternalID I_OrderOperationBasic OrderInternalID Plan No.f.Oper.
KEY OrderOperationInternalID I_OrderOperationBasic OrderOperationInternalID Plan No.f.Oper.
ManufacturingOrder I_MfgOrderBasic ManufacturingOrder Order
ManufacturingOrderCategory I_MfgOrderBasic ManufacturingOrderCategory Order Category
ProductionPlant I_MfgOrderBasic ProductionPlant Prod plnt
ProductionSupervisor I_MfgOrderBasic ProductionSupervisor Prodn Supervisor
Plant I_OrderOperationBasic Plant Valuation Area
ObjectInternalID I_OrderOperationBasic ObjectInternalID Object number
ManufacturingOrderOperation I_OrderOperationBasic Operation Transaction
MfgOrderOperationIsPhase I_OrderOperationBasic MfgOrderOperationIsPhase Ind.: Phase
ManufacturingOrderSequence I_OrderOperationBasic Sequence Visit Sequence
SuperiorOperationInternalID I_OrderOperationBasic SuperiorOperationInternalID Sup. Op. Node
OperationIsCreated
OperationIsReleased
OperationIsConfirmed
OperationIsPartiallyConfirmed
OperationIsPartiallyDelivered
OperationIsDelivered
OperationIsDeleted
OperationIsTechlyCompleted
OperationIsClosed
_OrderInternalID I_OrderOperationBasic _OrderInternalID
_MfgOrderCategory I_MfgOrderBasic _MfgOrderCategory

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_ProcOrdOpStatus.
-- 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: PPROCORDOPSTS

CREATE VIEW P_ProcOrdOpStatus AS
SELECT
  afvc.OrderInternalID AS MfgOrderInternalID,
  afvc.OrderOperationInternalID AS OrderOperationInternalID,
  aufv.ManufacturingOrder AS ManufacturingOrder,
  aufv.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  aufv.ProductionPlant AS ProductionPlant,
  aufv.ProductionSupervisor AS ProductionSupervisor,
  afvc.Plant AS Plant,
  afvc.ObjectInternalID AS ObjectInternalID,
  afvc.Operation AS ManufacturingOrderOperation,
  afvc.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  afvc.Sequence AS ManufacturingOrderSequence,
  afvc.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  case when _isCreated.StatusCode is null then '' else 'X' end AS OperationIsCreated,
  case when _isReleased.StatusCode is null then '' else 'X' end AS OperationIsReleased,
  case when _isConfirmed.StatusCode is null then '' else 'X' end AS OperationIsConfirmed,
  case when _isPartConf.StatusCode is null then '' else 'X' end AS OperationIsPartiallyConfirmed,
  case when _isPartDeliv.StatusCode is null then '' else 'X' end AS OperationIsPartiallyDelivered,
  case when _isDelivered.StatusCode is null then '' else 'X' end AS OperationIsDelivered,
  case when _isDeleted.StatusCode is null then '' else 'X' end AS OperationIsDeleted,
  case when _isTechCompl.StatusCode is null then '' else 'X' end AS OperationIsTechlyCompleted,
  case when _isClosed.StatusCode is null then '' else 'X' end AS OperationIsClosed,
  afvc._OrderInternalID AS _OrderInternalID,
  aufv._MfgOrderCategory AS _MfgOrderCategory
FROM I_OrderOperationBasic AS afvc
INNER JOIN I_MfgOrderBasic AS aufv ON /* join condition not captured in parsed metadata */
;

Learn More