I_MaintenanceOrderConfirmation

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_MaintenanceOrderConfirmation.
-- 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: IMAINTORDCONF

CREATE VIEW I_MaintenanceOrderConfirmation AS
SELECT
  P_MaintenanceOrderConfirmation.MaintOrderConf AS MaintOrderConf,
  P_MaintenanceOrderConfirmation.MaintOrderConfCntrValue AS MaintOrderConfCntrValue,
  P_MaintenanceOrderConfirmation.MaintOrderConfirmationEntryDte AS MaintOrderConfirmationEntryDte,
  P_MaintenanceOrderConfirmation.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  P_MaintenanceOrderConfirmation.EnteredByUser AS EnteredByUser,
  P_MaintenanceOrderConfirmation.LastChangeDate AS LastChangeDate,
  P_MaintenanceOrderConfirmation.LastChangedByUser AS LastChangedByUser,
  P_MaintenanceOrderConfirmation.PostingDate AS PostingDate,
  P_MaintenanceOrderConfirmation.WorkCenterInternalID AS WorkCenterInternalID,
  P_MaintenanceOrderConfirmation.ConfirmationText AS ConfirmationText,
  P_MaintenanceOrderConfirmation.Language AS Language,
  P_MaintenanceOrderConfirmation.LongTextExists AS LongTextExists,
  P_MaintenanceOrderConfirmation.ActualWorkQuantity AS ActualWorkQuantity,
  P_MaintenanceOrderConfirmation.ActualWorkQuantityUnit AS ActualWorkQuantityUnit,
  P_MaintenanceOrderConfirmation.ActivityType AS ActivityType,
  P_MaintenanceOrderConfirmation.ActualDuration AS ActualDuration,
  P_MaintenanceOrderConfirmation.ActualDurationUnit AS ActualDurationUnit,
  P_MaintenanceOrderConfirmation.EmployeeWageType AS EmployeeWageType,
  P_MaintenanceOrderConfirmation.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
  P_MaintenanceOrderConfirmation.ConfirmationScrapQuantity AS ConfirmationScrapQuantity,
  P_MaintenanceOrderConfirmation.ConfirmationUnit AS ConfirmationUnit,
  P_MaintenanceOrderConfirmation.VarianceReasonCode AS VarianceReasonCode,
  P_MaintenanceOrderConfirmation.PersonnelNumber AS PersonnelNumber,
  P_MaintenanceOrderConfirmation.OperationConfirmedStartDate AS OperationConfirmedStartDate,
  P_MaintenanceOrderConfirmation.OperationConfirmedStartTime AS OperationConfirmedStartTime,
  P_MaintenanceOrderConfirmation.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  P_MaintenanceOrderConfirmation.OperationConfirmedEndDate AS OperationConfirmedEndDate,
  P_MaintenanceOrderConfirmation.OperationConfirmedEndTime AS OperationConfirmedEndTime,
  dats_tims_to_tstmp( P_MaintenanceOrderConfirmation.OperationConfirmedEndDate, P_MaintenanceOrderConfirmation.OperationConfirmedEndTime, AddressTimeZone, $session.client, 'NULL' ) as MaintOrdOpWrkExecEndDateTime AS clientNULLasMaintOrdOpWrkExecEndDateTime,
  P_MaintenanceOrderConfirmation.ActyConfFcstdEndDate AS ActyConfFcstdEndDate,
  P_MaintenanceOrderConfirmation.ActyConfFcstdEndTime AS ActyConfFcstdEndTime,
  dats_tims_to_tstmp( P_MaintenanceOrderConfirmation.ActyConfFcstdEndDate, P_MaintenanceOrderConfirmation.ActyConfFcstdEndTime, AddressTimeZone, $session.client, 'NULL' ) as MaintOrdOpFcstdEndDateTime AS clientNULLasMaintOrdOpFcstdEndDateTime,
  P_MaintenanceOrderConfirmation.IsFinalConfirmation AS IsFinalConfirmation,
  P_MaintenanceOrderConfirmation.OpenReservationsIsCleared AS OpenReservationsIsCleared,
  P_MaintenanceOrderConfirmation.MaintenanceOrder AS MaintenanceOrder,
  P_MaintenanceOrderConfirmation.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  P_MaintenanceOrderConfirmation.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  P_MaintenanceOrderConfirmation.RemainingWorkQuantity AS RemainingWorkQuantity,
  P_MaintenanceOrderConfirmation.RemainingWorkQuantityUnit AS RemainingWorkQuantityUnit,
  P_MaintenanceOrderConfirmation.NoFurtherWorkQuantityIsExpd AS NoFurtherWorkQuantityIsExpd,
  P_MaintenanceOrderConfirmation.IsReversed AS IsReversed,
  P_MaintenanceOrderConfirmation.IsReversal AS IsReversal,
  P_MaintenanceOrderConfirmation.CancldMaintOrderConfCntrValue AS CancldMaintOrderConfCntrValue,
  P_MaintenanceOrderConfirmation.ConfirmationReworkQuantity AS ConfirmationReworkQuantity,
  P_MaintenanceOrderConfirmation.MaintOrderConfirmationEntryTme AS MaintOrderConfirmationEntryTme,
  P_MaintenanceOrderConfirmation.AccountingIndicatorCode AS AccountingIndicatorCode,
  P_MaintenanceOrderConfirmation.EnteredByExternalUser AS EnteredByExternalUser,
  P_MaintenanceOrderConfirmation.ConfirmationExternalEntryDate AS ConfirmationExternalEntryDate,
  P_MaintenanceOrderConfirmation.ConfirmationExternalEntryTime AS ConfirmationExternalEntryTime,
  ActualWorkExternalQuantityUnit,
  RemainingWorkExtQuantityUnit,
  P_MaintenanceOrderConfirmation.Plant AS Plant,
  P_MaintenanceOrderConfirmation._Plant.FactoryCalendar AS FactoryCalendar,
  P_MaintenanceOrderConfirmation.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  P_MaintenanceOrderConfirmation.CapacityInternalID AS CapacityInternalID,
  P_MaintenanceOrderConfirmation.EmployeeWageGroup AS EmployeeWageGroup,
  P_MaintenanceOrderConfirmation.NmbrOfMaintTechnicianCapSplits AS NmbrOfMaintTechnicianCapSplits,
  P_MaintenanceOrderConfirmation.MaterialDocument AS MaterialDocument,
  AddressTimeZone,
  cast( abap_user_timezone( $session.user,$session.client,'NULL' ) as tzonso preserving type ) AS UserEnteredTimeZone,
  _Plant._OrganizationAddress[1:AddressRepresentationCode = ''].AddressTimeZone AS PlantTimeZone
FROM P_MaintenanceOrderConfirmation
LEFT OUTER JOIN I_MaintOrderConfGoodsMovement AS _MaintOrderConfGoodsMovement ON _MaintOrderConfGoodsMovement.MaintOrderConf = MaintOrderConf AND _MaintOrderConfGoodsMovement.MaintOrderConfCntrValue = MaintOrderConfCntrValue  -- association [0..*]
LEFT OUTER JOIN I_WorkCenter AS _ActualWorkCenter ON WorkCenterInternalID = _ActualWorkCenter.WorkCenterInternalID AND _ActualWorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_ConfirmationGroup AS _ConfirmationGroup ON _ConfirmationGroup.ConfirmationGroup = MaintOrderConf  -- 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_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_VarianceReason AS _VarianceReason ON Plant = _VarianceReason.Plant AND VarianceReasonCode = _VarianceReason.VarianceReasonCode  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _PersonnelName ON PersonnelNumber = _PersonnelName.PersonExternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonResponsible ON PersonnelNumber = _PersonResponsible.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON _MaintenanceOrderOperation.MaintenanceOrder = MaintenanceOrder AND _MaintenanceOrderOperation.MaintOrderOperationCounter = MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ActualWorkExtQuantityUnit ON _ActualWorkExtQuantityUnit.UnitOfMeasure = ActualWorkExternalQuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RemainingWorkExtQuantityUnit ON _RemainingWorkExtQuantityUnit.UnitOfMeasure = RemainingWorkExtQuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_OrderConfLongText AS _OrderConfLongText ON _OrderConfLongText.ConfirmationGroup = MaintOrderConf AND _OrderConfLongText.OrderConfirmation = MaintOrderConfCntrValue  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrderConfirmation AS _MaintOrdConfExtension ON MaintOrderConf = _MaintOrdConfExtension.MaintOrderConf AND MaintOrderConfCntrValue = _MaintOrdConfExtension.MaintOrderConfCntrValue  -- association [0..1]
;