C_ObjPgMaintOrderOpMaterial

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_ObjPgMaintOrderOpMaterial.
-- 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: COPMORDOPMATL

CREATE VIEW C_ObjPgMaintOrderOpMaterial AS
SELECT
  I_MaintOrderOperComp.MaintenanceOrder AS MaintenanceOrder,
  I_MaintOrderOperComp.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  I_MaintOrderOperComp.MaintOrderComponentInternalID AS MaintOrderComponentInternalID,
  I_MaintOrderOperComp.MaintenanceOrderComponent AS MaintenanceOrderComponent,
  I_MaintOrderOperComp.Reservation AS Reservation,
  I_MaintOrderOperComp.ReservationItem AS ReservationItem,
  I_MaintOrderOperComp.Material AS Material,
  I_MaintOrderOperComp.ItemCategory AS ItemCategory,
  I_MaintOrderOperComp._ItemCategoryText[1:Language=$session.system_language].MaintComponentItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  I_MaintOrderOperComp.MaintOrderCompDebitCreditCode AS MaintOrderCompDebitCreditCode,
  I_MaintOrderOperComp.RequirementQuantityInBaseUnit AS AbsoluteQuantity,
  I_MaintOrderOperComp.BaseUnit AS BaseUnit,
  I_MaintOrderOperComp.StorageLocation AS StorageLocation,
  I_MaintOrderOperComp._StorageLocation.StorageLocationName AS StorageLocationName,
  I_MaintOrderOperComp.MaterialGroup AS MaterialGroup,
  I_MaintOrderOperComp._MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  I_MaintOrderOperComp.PurchaseRequisition AS PurchaseRequisition,
  I_MaintOrderOperComp.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_MaintOrderOperComp.PurReqnOrResvnGeneration AS PurReqnOrResvnGeneration,
  I_MaintOrderOperComp.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_MaintOrderOperComp.PerformancePeriodStartTime AS PerformancePeriodStartTime,
  I_MaintOrderOperComp.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_MaintOrderOperComp.PerformancePeriodEndTime AS PerformancePeriodEndTime,
  I_MaintOrderOperComp.LeanServiceDuration AS LeanServiceDuration,
  I_MaintOrderOperComp.LeanServiceDurationUnit AS LeanServiceDurationUnit,
  I_MaintOrderOperComp.MaintOrdCompDeliveryDateAdjmt AS MaintOrdCompDeliveryDateAdjmt,
  _MaintOrdCompDelivDateAdjmtT[1:Language = $session.system_language].MaintOrdCompDelivDateAdjmtText AS MaintOrdCompDelivDateAdjmtText,
  I_MaintOrderOperComp.SrvcSchedgIsAlignedWthOpWrkCtr AS SrvcSchedgIsAlignedWthOpWrkCtr,
  I_MaintOrderOperComp.MaintOrdOpComponentCurrency AS MaintOrdOpComponentCurrency,
  I_MaintOrderOperComp.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  I_MaintOrderOperComp.OverallLimitAmount AS OverallLimitAmount,
  FldLogsDelivIsHeldOnShore,
  FldLogsSupplyProcess
FROM I_MaintOrderOperComp
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN C_EAMProductQuickVw AS _EAMProductQuickVw ON _EAMProductQuickVw.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSupplyProcessText AS _FldLogsSupplyProcessText ON _FldLogsSupplyProcessText.FldLogsSupplyProcess = FldLogsSupplyProcess  -- association [0..*]
LEFT OUTER JOIN I_MaintOrdCompDelivDateAdjmtT AS _MaintOrdCompDelivDateAdjmtT ON _MaintOrdCompDelivDateAdjmtT.MaintOrdCompDeliveryDateAdjmt = MaintOrdCompDeliveryDateAdjmt  -- association [0..*]
LEFT OUTER JOIN P_EAMServiceFeature AS _EAMServiceFeature ON _EAMServiceFeature.BusinessFeatureID = '01'  -- association [0..1]
;