C_MaintenanceItemObjPg

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_MaintenanceItemObjPg.
-- 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: CMAINTITEMOBJPG

CREATE VIEW C_MaintenanceItemObjPg AS
SELECT
  MaintenanceItem,
  MaintenanceItemDescription,
  cast ('' as eams_ltext ) AS MaintenanceItemLongText,
  Equipment,
  _EquipmentText[1:Language = $session.system_language].EquipmentName AS EquipmentName,
  FunctionalLocation,
  _FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS OpFunctionalLocationLabelName,
  _FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  $session.system_date AS TaskListKeyDate,
  TaskList,
  _MaintTaskListForKeyDate(P_KeyDate:$session.system_date).TaskListDesc AS TaskListDesc,
  MaintenancePlan,
  MaintenancePlanCategory,
  MaintenanceStrategy,
  MaintPriorityType,
  MaintPriority,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  BusinessArea,
  Assembly,
  _Assembly._Text[1:Language = $session.system_language].MaterialName AS AssemblyName,
  MaintenanceActivityType,
  MaintenanceOrderType,
  Material,
  SerialNumber,
  MaintenanceItemObjectList,
  ImmediateReleaseIsBlocked,
  MaintObjectLocAcctAssgmtNmbr,
  _ServiceDocumentTypeText[1:Language = $session.system_language].ServiceDocumentTypeShortName AS ServiceDocumentTypeName,
  ServiceDocumentType,
  ServiceContract,
  ServiceContractItem,
  ServiceOrderTemplate,
  _ServiceDocumentPriorityText[1:Language = $session.system_language].ServiceDocumentPriorityName AS ServiceDocumentPriorityName,
  ServiceDocumentPriority,
  Product,
  OperationSystemCondition,
  _MaintOperationSystCondition._Text[1:Language = $session.system_language ].OperationSystemConditionText AS OperationSystemConditionText,
  NumberOfTaskListExecutions,
  _Product._Text[1:Language = $session.system_language].ProductName AS ProductName,
  _LocationAccountAssignment._Location.Location AS Location,
  _LocationAccountAssignment._Location.LocationName AS LocationName,
  _LocationAccountAssignment._WorkCenter.Plant AS Plant,
  _LocationAccountAssignment._WorkCenter.WorkCenter AS WorkCenter,
  _LocationAccountAssignment._WBSElementBasicData.WBSElement AS WBSElement,
  _LocationAccountAssignment._WBSElementBasicData.WBSDescription AS WBSDescription,
  NotificationType,
  MaintNotifTskIsAutomlyDtmnd,
  AdditionalDeviceData,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  _LocationAccountAssignment._CostCenter[1:ValidityEndDate = '99991231'] AS _CostCenter,
  _LocationAccountAssignment._WorkCenter._WorkCenter AS _WorkCenter,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  _FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _LastChangedByUser.UserDescription AS LastChangedByUserDescription,
  _LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  _LocationAccountAssignment.AssetLocation AS AssetLocation,
  _LocationAccountAssignment.AssetRoom AS AssetRoom,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  _LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  _LocationAccountAssignment.CompanyCode AS CompanyCode,
  _LocationAccountAssignment.CostCenter AS CostCenter,
  _LocationAccountAssignment.FixedAsset AS FixedAsset,
  _LocationAccountAssignment.MasterFixedAsset AS MasterFixedAsset,
  _LocationAccountAssignment.BusinessArea AS LocAcctAssgmtBusinessArea,
  _LocationAccountAssignment.ControllingArea AS ControllingArea,
  _LocationAccountAssignment.StandingOrderNumber AS StandingOrderNumber,
  _LocationAccountAssignment.SettlementOrder AS SettlementOrder,
  _LocationAccountAssignment._ABCIndicator AS _ABCIndicator,
  _LocationAccountAssignment._BusinessArea AS _LocAcctAssgmtBusinessArea,
  _LocationAccountAssignment._CompanyCode AS _CompanyCode,
  _LocationAccountAssignment._ControllingArea AS _ControllingArea,
  _LocationAccountAssignment._FixedAsset AS _FixedAsset,
  _LocationAccountAssignment._Location AS _Location,
  _LocationAccountAssignment._MaintenancePlant AS _MaintenancePlant,
  _LocationAccountAssignment._PlantSection AS _PlantSection,
  _LocationAccountAssignment._SettlementOrder AS _SettlementOrder,
  _LocationAccountAssignment._StandingOrderNumber AS _StandingOrderNumber,
  _MaintenancePlanCatParam.MaintenancePlanCallObject AS MaintenancePlanCallObject,
  _MainWorkCenter.WorkCenter AS MainWorkCenter,
  _MainWorkCenter.Plant AS MainWorkCenterPlant,
  _MainWorkCenter._WorkCenter AS _MainWorkCenter,
  _MainWorkCenter._Plant AS _MainWorkCenterPlant,
  _ServiceContract.ServiceDocumentDescription AS ServiceContractDescription,
  _ServiceContractItem.ServiceDocumentItemDescription AS ServiceContractItemDescription,
  _ServiceTemplate.ServiceDocumentDescription AS ServiceDocumentDescription
FROM I_MaintenanceItemTP AS _MaintenanceItemTP
LEFT OUTER JOIN C_MaintItemObjPgObjectList AS _MaintItemObjectList ON _MaintItemObjectList.MaintenanceItemObjectList = MaintenanceItemObjectList  -- association [1..*]
LEFT OUTER JOIN I_Indicator AS _MaintItemHasObjectList ON _MaintItemHasObjectList.IndicatorValue = MaintItemHasObjectList  -- association [0..1]
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  -- association [0..*]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = Equipment  -- association [0..*]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectLabelVH AS _TechnicalObjectLabelVH ON _TechnicalObjectLabelVH.TechnicalObjectLabel = TechnicalObjectLabel AND _TechnicalObjectLabelVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjectLabelVH.TechnicalObject = TechnicalObject  -- association [0..1]
LEFT OUTER JOIN C_EAMProductQuickVw AS _EAMProductQuickVw ON _EAMProductQuickVw.Material = Assembly  -- association [0..1]
LEFT OUTER JOIN C_MaintenancePlanQuickVw AS _MaintenancePlanQuickVw ON _MaintenancePlanQuickVw.MaintenancePlan = MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN C_MaintTaskListQuickVw AS _MaintTaskListQuickVw ON _MaintTaskListQuickVw.TaskList = TaskList AND _MaintTaskListQuickVw.TaskListType = TaskListType AND _MaintTaskListQuickVw.TaskListGroup = TaskListGroup AND _MaintTaskListQuickVw.TaskListGroupCounter = TaskListGroupCounter  -- association [0..1]
LEFT OUTER JOIN C_TechObjQuickVw AS _TechnicalObjQuickVw ON _TechnicalObjQuickVw.TechnicalObject = TechnicalObject AND _TechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjQuickVw.TechnicalObjectLabel = TechnicalObjectLabel  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentTypeText AS _ServiceDocumentTypeText ON ServiceDocumentType = _ServiceDocumentTypeText.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentTypeStdVH AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceOrderType ON ServiceDocumentType = _ServiceOrderType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN C_MaintItemServiceContractVH AS _ServiceContract ON ServiceContract = _ServiceContract.ServiceDocument AND _ServiceContract.ServiceObjectType = 'BUS2000112'  -- association [0..1]
LEFT OUTER JOIN C_MaintItemSrvcOrderTemplateVH AS _ServiceTemplate ON ServiceOrderTemplate = _ServiceTemplate.ServiceDocument AND _ServiceTemplate.ServiceObjectType = 'BUS2000116'  -- association [0..1]
LEFT OUTER JOIN C_EAMProductQuickVw AS _ServiceProduct ON Product = _ServiceProduct.Material  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentPriorityText AS _ServiceDocumentPriorityText ON ServiceDocumentPriority = _ServiceDocumentPriorityText.ServiceDocumentPriority  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceItemBasic AS _MaintenanceItemExtension ON _MaintenanceItemExtension.MaintenanceItem = MaintenanceItem  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;