I_MaintenanceObjectLink

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 I_MaintenanceObjectLink.
-- 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: IMAINTOBJLINK

CREATE VIEW I_MaintenanceObjectLink AS
SELECT
  kante AS ObjectLink,
  mlang AS Language,
  netid AS ObjectNetwork,
  kantyp AS ObjectLinkIsEquipOrFuncnlLoc,
  tpvon AS ObjLinkFromFunctionalLocation,
  eqvon AS ObjectLinkFromEquipment,
  tpnach AS ObjectLinkToFunctionalLocation,
  eqnach AS ObjectLinkToEquipment,
  lfdknr AS NumberOfParallelLinks,
  datva AS ObjectLinkValidityStartDate,
  zeitva AS ObjectLinkValidityStartTime,
  datvb AS ObjectLinkValidityEndDate,
  zeitvb AS ObjectLinkValidityEndTime,
  status AS MaintObjectInternalID,
  tpkant AS ObjectLinkIsFunctionalLocation,
  eqkant AS ObjectLinkIsEquipment,
  mediu AS ObjectLinkMedium,
  bezarp AS MaintObjLinkPossibleRelshpType,
  bezarl AS MaintObjLinkUsedRelshpType,
  erdat AS CreationDate,
  aedat AS LastChangeDate,
  ernam AS CreatedByUser,
  aenam AS LastChangedByUser,
  begru AS AuthorizationGroup,
  lvorm AS ObjectLinkIsMarkedForDeletion,
  netyp AS ObjectLinkCategory,
  matnr AS Product
FROM inet
LEFT OUTER JOIN I_Language AS _Language ON _Language.Language = Language  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _LinkFromEquipment ON ObjectLinkFromEquipment = _LinkFromEquipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _LinkToEquipment ON ObjectLinkToEquipment = _LinkToEquipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _LinkFromFunctionalLocation ON ObjLinkFromFunctionalLocation = _LinkFromFunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _LinkToFunctionalLocation ON ObjectLinkToFunctionalLocation = _LinkToFunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceObjectLinkText AS _LinkText ON _LinkText.ObjectLink = ObjectLink  -- association [0..*]
;