C_MaintOrderComponentTP

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_MaintOrderComponentTP.
-- 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: CMAINTORDCOMPTP

CREATE VIEW C_MaintOrderComponentTP AS
SELECT
  I_MaintOrderComponentTP.MaintenanceOrder AS MaintenanceOrder,
  I_MaintOrderComponentTP.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  I_MaintOrderComponentTP.MaintOrderComponentInternalID AS MaintOrderComponentInternalID,
  I_MaintOrderComponentTP.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  I_MaintOrderComponentTP.MaintenanceOrderComponent AS MaintenanceOrderComponent,
  I_MaintOrderComponentTP.MaintOrderComponentForEdit AS MaintOrderComponentForEdit,
  I_MaintOrderComponentTP.Reservation AS Reservation,
  I_MaintOrderComponentTP.ReservationItem AS ReservationItem,
  I_MaintOrderComponentTP.ReservationType AS ReservationType,
  I_MaintOrderComponentTP.Material AS Material,
  I_MaintOrderComponentTP.ComponentDescription AS ComponentDescription,
  I_MaintOrderComponentTP.RequirementQuantityInBaseUnit AS RequirementQuantityInBaseUnit,
  I_MaintOrderComponentTP.BaseUnit AS BaseUnit,
  I_MaintOrderComponentTP.Plant AS Plant,
  I_MaintOrderComponentTP.StorageLocation AS StorageLocation,
  I_MaintOrderComponentTP.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  I_MaintOrderComponentTP.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  I_MaintOrderComponentTP.QuantityWithdrawnInBaseUnit AS QuantityWithdrawnInBaseUnit,
  cast( '' as w3conttype ) AS MaterialThumbnailMIMEType,
  cast('' as xfeld ) AS MaterialHasThumbnail,
  I_MaintOrderComponentTP._Material AS _Material,
  I_MaintOrderComponentTP._UnitOfMeasure AS _UnitOfMeasure,
  I_MaintOrderComponentTP._StorageLocation AS _StorageLocation,
  I_MaintOrderComponentTP._Plant AS _Plant
FROM I_MaintOrderComponentTP
LEFT OUTER JOIN C_MaintOrderTP AS _MaintOrderTP ON MaintenanceOrder = _MaintOrderTP.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN C_MaintOrderOperationTP AS _MaintOrderOperationTP ON MaintenanceOrder = _MaintOrderOperationTP.MaintenanceOrder AND MaintenanceOrderOperation = _MaintOrderOperationTP.MaintenanceOrderOperation  -- association [1..1]
LEFT OUTER JOIN C_StorageLocationVH AS _StorageLocationVH ON Material = _StorageLocationVH.Material AND Plant = _StorageLocationVH.Plant AND StorageLocation = _StorageLocationVH.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
;