C_ProdOrdConfObjPg

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 C_ProdOrdConfObjPg.
-- 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: CPRDORDOBJPGCONF

CREATE VIEW C_ProdOrdConfObjPg AS
SELECT
  MfgOrderConfirmation AS ProductionOrderConfirmation,
  MfgOrderConfirmationCount AS OperationConfirmationCount,
  ManufacturingOrder AS ProductionOrder,
  ManufacturingOrderType,
  _MfgOrder.Material AS Material,
  _MfgOrder._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  _MfgOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  _MfgOrder.ProductionUnit AS ProductionUnit,
  ManufacturingOrderOperation,
  ManufacturingOrderSequence,
  cast(CapacityRequirementSplit as cy_split) AS CapacityRequirementSplit,
  cast(WorkCenter as cbgle_arbpl ) AS WorkCenter,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  _WorkCenterName[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  ProductionPlant,
  _MfgOrder.StockSegment AS StockSegment,
  cast(IsFinalConfirmation as endru) AS IsFinalConfirmation,
  PostingDate,
  cast(_ProductionPlant._StandardOrganizationAddress.AddressTimeZone as co_plant_timezone ) AS AddressTimeZone,
  IsReversed,
  cast(EnteredByExternalUser as clms_tm_created_by preserving type ) AS EnteredByExternalUser,
  _CreatedByUser.PersonFullName AS IsCurrentUser,
  cast(LastChangedByUser as bapi_wfm_changed_by preserving type) AS LastChangedByUser,
  _ChangedBy.PersonFullName AS ChangedBy,
  cast(EnteredByUser as tmf_enteredby preserving type) AS EnteredByUser,
  _ExtUser.PersonFullName AS CreatedByUser,
  ConfirmationYieldQuantity,
  ConfirmationScrapQuantity,
  ConfirmationReworkQuantity,
  ConfirmationUnit,
  _YesNo.DomainText AS DomainText,
  ConfirmationText,
  _LongText.PlainLongText AS PlainLongText,
  _MfgOrder._Material AS _Material
FROM I_MfgOrderObjPgConfAll
LEFT OUTER JOIN P_MfgOrdHeaderConfObjPgQtSum AS _ConfHeaderSum ON ProductionOrderConfirmation = _ConfHeaderSum.MfgOrderConfirmation  -- association [0..1]
LEFT OUTER JOIN P_MfgOrdOperConfObjPgQtSum AS _ConfOperationSum ON ProductionOrderConfirmation = _ConfOperationSum.MfgOrderConfirmation  -- association [0..1]
LEFT OUTER JOIN P_MfgConfCreatedBy AS _CreatedByUser ON ProductionOrderConfirmation = _CreatedByUser.ProductionOrderConfirmation AND OperationConfirmationCount = _CreatedByUser.OperationConfirmationCount  -- association [0..1]
LEFT OUTER JOIN P_MfgConfExternalUser AS _ExtUser ON ProductionOrderConfirmation = _ExtUser.ProductionOrderConfirmation AND OperationConfirmationCount = _ExtUser.OperationConfirmationCount  -- association [0..1]
LEFT OUTER JOIN P_MfgConfChangedBy AS _ChangedBy ON ProductionOrderConfirmation = _ChangedBy.ProductionOrderConfirmation AND OperationConfirmationCount = _ChangedBy.OperationConfirmationCount  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardUser AS _User ON EnteredByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardUser AS _ContCardExtUser ON EnteredByExternalUser = _ContCardExtUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_BR_Domain AS _ConfStatusText ON _ConfStatusText.Name = 'AUERU_VS' AND _ConfStatusText.Language = $session.system_language AND _ConfStatusText.DomainValue = IsFinalConfirmation  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterName ON WorkCenterInternalID = _WorkCenterName.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterName.WorkCenterTypeCode  -- association [0..*]
LEFT OUTER JOIN I_BR_Domain AS _YesNo ON _YesNo.Name = 'LOGBR_YESNO' AND _YesNo.Language = $session.system_language AND _YesNo.DomainValue = IsReversal  -- association [1..1]
;