I_WorkPermitOrder

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_WorkPermitOrder.
-- 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: IWORKPERMITOR

CREATE VIEW I_WorkPermitOrder AS
SELECT
  _WorkPermitOrderBasic.MaintenanceOrderInternalID AS MaintenanceOrderInternalID,
  _WorkPermitOrderBasic.WorkPermitInternalID AS WorkPermitInternalID,
  _WorkPermitBasic.WorkPermit AS WorkPermit,
  _WorkPermitBasic.WrkPermitDesc AS WrkPermitDesc,
  _MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  _MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  _MaintenanceOrder.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  _WorkPermitOrderBasic.WorkPermitOrderObjectType AS WorkPermitOrderObjectType,
  _WorkPermitOrderBasic.WorkPermitObjectType AS WorkPermitObjectType,
  _WorkPermitOrderBasic.WrkPmtProcessingContext AS WrkPmtProcessingContext,
  _WorkPermitOrderBasic.IsReferenceDocument AS IsReferenceDocument,
  cast ('' as vdm_j_system_status_concat_t) AS MaintOrdCnctntdActvSystSts
FROM I_WorkPermitOrderBasic AS _WorkPermitOrderBasic
INNER JOIN I_WorkPermitBasic AS _WorkPermitBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON MaintenanceOrderInternalID = _MaintenanceOrder.MaintenanceOrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_MaintenancePlanPlant AS _MaintenancePlanPlant ON maintenanceplanningplant = _MaintenancePlanPlant.MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_OrderType AS _MaintenanceOrderType ON maintenanceordertype = _MaintenanceOrderType.OrderType  -- association [1..1]
;