I_MaintenanceOrderConfTP

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 I_MaintenanceOrderConfTP.
-- 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: IMAINTORDCONFTP

CREATE VIEW I_MaintenanceOrderConfTP AS
SELECT
  Document.MaintOrderConf AS MaintOrderConf,
  Document.MaintOrderConfCntrValue AS MaintOrderConfCntrValue,
  Document.MaintOrderConf AS MaintOrderConfForEdit,
  Document.MaintOrderConfCntrValue AS MaintOrderConfCntrValueForEdit,
  Document.MaintOrderConfirmationEntryDte AS MaintOrderConfirmationEntryDte,
  Document.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  Document.EnteredByUser AS EnteredByUser,
  Document.LastChangeDate AS LastChangeDate,
  Document.LastChangedByUser AS LastChangedByUser,
  Document.PostingDate AS PostingDate,
  Document.WorkCenterInternalID AS WorkCenterInternalID,
  Document.ConfirmationText AS ConfirmationText,
  Document.Language AS Language,
  Document.LongTextExists AS LongTextExists,
  Document.ActualWorkQuantity AS ActualWorkQuantity,
  Document.ActualWorkQuantityUnit AS ActualWorkQuantityUnit,
  cast( 0 as ismnw_2 ) AS ActualWorkQtyInExternalUnit,
  ActualWorkExternalQuantityUnit,
  Document.ActivityType AS ActivityType,
  Document.ActualDuration AS ActualDuration,
  Document.ActualDurationUnit AS ActualDurationUnit,
  Document.EmployeeWageType AS EmployeeWageType,
  Document.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
  Document.ConfirmationScrapQuantity AS ConfirmationScrapQuantity,
  Document.ConfirmationUnit AS ConfirmationUnit,
  Document.VarianceReasonCode AS VarianceReasonCode,
  Document.PersonnelNumber AS PersonnelNumber,
  Document.OperationConfirmedStartDate AS OperationConfirmedStartDate,
  Document.OperationConfirmedStartTime AS OperationConfirmedStartTime,
  Document.MaintOrdOpWrkExecStartDateTime AS MaintOrdOpWrkExecStartDateTime,
  Document.OperationConfirmedEndDate AS OperationConfirmedEndDate,
  Document.OperationConfirmedEndTime AS OperationConfirmedEndTime,
  Document.MaintOrdOpWrkExecEndDateTime AS MaintOrdOpWrkExecEndDateTime,
  Document.ActyConfFcstdEndDate AS ActyConfFcstdEndDate,
  Document.ActyConfFcstdEndTime AS ActyConfFcstdEndTime,
  Document.MaintOrdOpFcstdEndDateTime AS MaintOrdOpFcstdEndDateTime,
  Document.AddressTimeZone AS AddressTimeZone,
  Document.UserEnteredTimeZone AS UserEnteredTimeZone,
  Document.PlantTimeZone AS PlantTimeZone,
  Document.IsFinalConfirmation AS IsFinalConfirmation,
  Document.OpenReservationsIsCleared AS OpenReservationsIsCleared,
  Document.MaintenanceOrder AS MaintenanceOrder,
  Document._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  Document.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  Document._MaintenanceOrderOperation.OperationDescription AS OperationDescription,
  Document.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  Document.RemainingWorkQuantity AS RemainingWorkQuantity,
  Document.RemainingWorkQuantityUnit AS RemainingWorkQuantityUnit,
  cast( 0 as remnw_2 ) AS RemainingWorkQtyInExternalUnit,
  RemainingWorkExtQuantityUnit,
  Document.NoFurtherWorkQuantityIsExpd AS NoFurtherWorkQuantityIsExpd,
  Document.IsReversed AS IsReversed,
  Document.IsReversal AS IsReversal,
  Document.ConfirmationReworkQuantity AS ConfirmationReworkQuantity,
  Document.MaintOrderConfirmationEntryTme AS MaintOrderConfirmationEntryTme,
  Document.AccountingIndicatorCode AS AccountingIndicatorCode,
  Document.EnteredByExternalUser AS EnteredByExternalUser,
  Document.ConfirmationExternalEntryDate AS ConfirmationExternalEntryDate,
  Document.ConfirmationExternalEntryTime AS ConfirmationExternalEntryTime,
  Document.Plant AS Plant,
  Document.FactoryCalendar AS FactoryCalendar,
  Document.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  Document._ActualWorkCenter.WorkCenter AS WorkCenter,
  cast ('' as abap.char( 10 )) AS MaintOrderConfUploadRowNumber,
  cast ('' as pm_source_appl ) AS MaintOrdConfSourceApplication,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS MaintOrdConfUploadUUID,
  cast ( '' as symsgty ) AS MaintOrderConfUploadMsgType,
  cast (0 as abap.int1) AS MaintOrdConfUploadMsgCritlty,
  MaintJobConfirmationScenario,
  MaintJobConfScenarioText,
  Document._MaintenanceOrder AS _MaintenanceOrder,
  Document._PersonnelName AS _PersonnelName
FROM I_MaintenanceOrderConfirmation AS Document
LEFT OUTER JOIN I_MaintOrdConfGoodsMovementTP AS _MaintOrdConfGoodsMovementTP ON _MaintOrdConfGoodsMovementTP.MaintOrderConf = MaintOrderConf AND _MaintOrdConfGoodsMovementTP.MaintOrderConfCntrValue = MaintOrderConfCntrValue  -- association [0..*]
LEFT OUTER JOIN I_WorkCenter AS _ActualWorkCenter ON _ActualWorkCenter.WorkCenterInternalID = WorkCenterInternalID AND _ActualWorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsReversed ON _IsReversed.IndicatorValue = IsReversed  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsReversal ON _IsReversal.IndicatorValue = IsReversal  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsFinalConfirmation ON _IsFinalConfirmation.IndicatorValue = IsFinalConfirmation  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _OpenReservationsIsCleared ON _OpenReservationsIsCleared.IndicatorValue = OpenReservationsIsCleared  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _NoFurtherWorkQuantityIsExpd ON _NoFurtherWorkQuantityIsExpd.IndicatorValue = NoFurtherWorkQuantityIsExpd  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _LongTextExists ON _LongTextExists.IndicatorValue = LongTextExists  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_User AS _EnteredByUser ON _EnteredByUser.UserID = EnteredByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangeByUser ON _LastChangeByUser.UserID = LastChangedByUser  -- association [0..1]
LEFT OUTER JOIN I_VarianceReason AS _VarianceReason ON Plant = _VarianceReason.Plant AND VarianceReasonCode = _VarianceReason.VarianceReasonCode  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON _Language.Language = Language  -- association [0..1]
LEFT OUTER JOIN I_MaintOrdConfMessageTP AS _MaintOrdConfMessageTP ON _MaintOrdConfMessageTP.MaintOrderConf = MaintOrderConf AND _MaintOrdConfMessageTP.MaintOrderConfCntrValue = MaintOrderConfCntrValue  -- association [1..*]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrderConfirmation AS _MaintOrdConfExtension ON Document.MaintOrderConf = _MaintOrdConfExtension.MaintOrderConf AND Document.MaintOrderConfCntrValue = _MaintOrdConfExtension.MaintOrderConfCntrValue  -- association [0..1]
;