P_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 P_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: PMAINTORDCONF

CREATE VIEW P_MaintenanceOrderConfirmation AS
SELECT
  afru.rueck AS MaintOrderConf,
  afru.rmzhl AS MaintOrderConfCntrValue,
  cast(afru.ersda as ru_ersda) AS MaintOrderConfirmationEntryDte,
  cast(afru.ernam as ru_ernam) AS EnteredByUser,
  afru.laeda AS LastChangeDate,
  afru.aenam AS LastChangedByUser,
  cast(afru.budat as pph_budat) AS PostingDate,
  afru.arbid AS WorkCenterInternalID,
  afru.werks AS Plant,
  afru.ltxa1 AS ConfirmationText,
  cast(afru.txtsp as spras) AS Language,
  afru.ismnw AS ActualWorkQuantity,
  afru.ismne AS ActualWorkQuantityUnit,
  afru.learr AS ActivityType,
  afru.idaur AS ActualDuration,
  afru.idaue AS ActualDurationUnit,
  afru.loart AS EmployeeWageType,
  afru.logrp AS EmployeeWageGroup,
  afru.lmnga AS ConfirmationYieldQuantity,
  afru.xmnga AS ConfirmationScrapQuantity,
  afru.meinh AS ConfirmationUnit,
  cast(afru.grund as pph_agrnd) AS VarianceReasonCode,
  afru.pernr AS PersonnelNumber,
  afru.isdd AS OperationConfirmedStartDate,
  afru.isdz AS OperationConfirmedStartTime,
  afru.iedd AS OperationConfirmedEndDate,
  afru.iedz AS OperationConfirmedEndTime,
  afru.pedd AS ActyConfFcstdEndDate,
  afru.pedz AS ActyConfFcstdEndTime,
  afru.wablnr AS MaterialDocument,
  afru.ausor AS OpenReservationsIsCleared,
  afru.aufpl AS MaintOrderRoutingNumber,
  afru.aplzl AS MaintOrderOperationCounter,
  afru.aufnr AS MaintenanceOrder,
  afru.ofmnw AS RemainingWorkQuantity,
  afru.ofmne AS RemainingWorkQuantityUnit,
  afru.leknw AS NoFurtherWorkQuantityIsExpd,
  afru.stokz AS IsReversed,
  afru.stzhl AS CancldMaintOrderConfCntrValue,
  afru.kapid AS CapacityInternalID,
  afru.split AS NmbrOfMaintTechnicianCapSplits,
  afru.rmnga AS ConfirmationReworkQuantity,
  cast(afru.erzet as ru_erzet) AS MaintOrderConfirmationEntryTme,
  afru.bemot AS AccountingIndicatorCode,
  afru.exnam AS EnteredByExternalUser,
  cast(afru.exerd as ru_exerd) AS ConfirmationExternalEntryDate,
  cast(afru.exerz as ru_exerz) AS ConfirmationExternalEntryTime,
  afru.ismnu AS ActualWorkExternalQuantityUnit,
  afru.ofmnu AS RemainingWorkExtQuantityUnit,
  afvc.objnr AS MaintOrderOperationInternalID
FROM afru
LEFT OUTER JOIN afvc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN afvc AS afvc_sub ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN tz1appl AS _TimeZoneConfig ON _TimeZoneConfig.appl = 'PM_WOC'  -- association [0..1]
;