C_MaintenanceOrderWrkflwInbox

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_MaintenanceOrderWrkflwInbox.
-- 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: CORDWFLINBOX

CREATE VIEW C_MaintenanceOrderWrkflwInbox AS
SELECT
  MaintenanceOrder,
  cast( MaintenanceOrder as abap.char( 12 ) ) AS MaintOrderWithLeadingZeros,
  MaintenanceOrderDesc,
  MaintenanceOrderInternalID,
  MaintenanceOrderType,
  MaintenanceNotification,
  _MaintenanceNotification.NotificationText AS NotificationText,
  MaintenancePlan,
  _MaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  MaintenanceItem,
  _MaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  _MaintenanceTaskList.TaskListDesc AS TaskListDesc,
  MaintOrdMainWorkCenter,
  WorkCenterInternalID,
  MaintOrdMainWorkCenterPlant,
  _MainWorkCenter._Plant.PlantName AS MainWorkCenterPlantName,
  MaintenancePlanningPlant,
  _MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
  MaintenancePlannerGroup,
  MaintOrdPersonResponsible,
  cast('' as eams_person_responsible_name) AS PersonResponsibleName,
  TechObjIsEquipOrFuncnlLoc,
  _OrderItem.Material AS Material,
  SerialNumber,
  Assembly,
  MaintOrdBasicStartDate,
  MaintOrdBasicStartTime,
  MaintOrdBasicEndDate,
  MaintOrdBasicEndTime,
  cast( '' as abap.sstring( 1333 ) ) AS MaintOrdTotalCost,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _LocationAccountAssignment.ControllingArea AS ControllingArea,
  _LocationAccountAssignment._ControllingArea.ControllingAreaName AS LocAcctAssgmtCtrlgAreaDesc,
  _LocationAccountAssignment.CostCenter AS LocAcctAssgmtCostCenter,
  _LocationAccountAssignment.SettlementOrder AS SettlementOrder,
  _WBSElement.WBSElement AS WBSElement,
  _WBSElement.WBSDescription AS WBSDescription,
  FunctionalLocation,
  Equipment,
  Currency,
  MaintObjectLocAcctAssgmtNmbr,
  _MaintOrderTypeControlParam.MaintOrderRespPartnerFunction AS MaintOrderRespPartnerFunction
FROM I_MaintOrderTechObj
LEFT OUTER JOIN I_OrderTypeText AS _OrderTypeText ON _OrderTypeText.OrderType = MaintenanceOrderType  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceItemBasic AS _MaintenanceItem ON _MaintenanceItem.MaintenanceItem = MaintenanceItem  -- association [0..1]
LEFT OUTER JOIN I_ProductionResourceText AS _MainWorkCenterText ON _MainWorkCenterText.ProductionResourceType = 'A' AND _MainWorkCenterText.ProductionResourceInternalID = WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = FunctionalLocation AND _FunctionalLocationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = Equipment AND _EquipmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _MaterialText ON _MaterialText.Product = material  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON _CostCenterText.ControllingArea = controllingarea AND _CostCenterText.CostCenter = LocAcctAssgmtCostCenter AND _CostCenterText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintOrderCost AS _MaintOrderCost ON _MaintOrderCost.MaintenanceOrderInternalID = MaintenanceOrderInternalID  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintOrderCostAggrgData AS _MaintOrderCostAggrg ON _MaintOrderCostAggrg.MaintenanceOrderInternalID = MaintenanceOrderInternalID  -- association [1..1]
;