R_MaintItemObjectListItemTP

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 R_MaintItemObjectListItemTP.
-- 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.

CREATE VIEW R_MaintItemObjectListItemTP AS
SELECT
  MaintenanceItem,
  MaintenanceItemObjectList,
  MaintenanceObjectListItem,
  MaintenanceObjectListUsageCode,
  Equipment,
  FunctionalLocation,
  _FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  MaintenanceNotification,
  Assembly,
  MaintObjectLocAcctAssgmtNmbr,
  Material,
  SerialNumber,
  UniqueItemIdentifier,
  CreationDate,
  MaintObjectListItemSequence,
  MaintObjListEntryIsProcessed,
  MaintenancePlanCallObject,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintenancePlant,
  I_MaintItemObjectListItem.ControllingArea AS ControllingArea,
  I_MaintItemObjectListItem.CostCenter AS CostCenter,
  I_MaintItemObjectListItem._FunctionalLocation AS _FunctionalLocation
FROM I_MaintItemObjectListItem
LEFT OUTER JOIN R_MaintenanceItemTP AS _MaintenanceItem ON MaintenanceItem = _MaintenanceItem.MaintenanceItem  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON FunctionalLocation = _FunctionalLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLocT AS _TechObjIsEquipOrFuncnlLocDesc ON TechObjIsEquipOrFuncnlLoc = _TechObjIsEquipOrFuncnlLocDesc.TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON Equipment = _EquipmentText.Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON FunctionalLocation = _FunctionalLocationText.FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_MaintItemRefObjectTypeText AS _ReferenceObjectTypeText ON MaintItemReferenceObjectType = _ReferenceObjectTypeText.MaintItemReferenceObjectType  -- association [0..*]
LEFT OUTER JOIN I_MaintItmRefObjTypeForSrvcTxt AS _RefObjectTypeForSrvcText ON MaintItemRefObjTypeForService = _RefObjectTypeForSrvcText.MaintItemReferenceObjectType  -- association [0..*]
;