P_ObjectLinkSearch

DDL: P_OBJECTLINKSEARCH SQL: POBJLINKSRCH Type: view BASIC
37 Fields 1 Data Sources 1 Associations

P_ObjectLinkSearch is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_MaintenanceObjectLink) and exposes 37 fields with key field ObjectLink. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceObjectLink _ObjLink from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TextObjectPlainLongText _LongText $projection.ObjectLink = _LongText.TextObjectKey and _LongText.TextObjectCategory = 'INET' and _LongText.TextObjectType = 'LTXT'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName POBJLINKSRCH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey ObjectLink view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY ObjectLink ObjectLink Path
Language Language Report Text Language
ObjectNetwork ObjectNetwork Production Flow NW
ObjectLinkIsEquipOrFuncnlLoc ObjectLinkIsEquipOrFuncnlLoc Link category
ObjLinkFromFunctionalLocation ObjLinkFromFunctionalLocation Link frm FLoc.
ObjectLinkFromEquipment ObjectLinkFromEquipment Link frm equip.
ObjectLinkToFunctionalLocation ObjectLinkToFunctionalLocation Link to FLoc.
ObjectLinkToEquipment ObjectLinkToEquipment Link to equip.
NumberOfParallelLinks NumberOfParallelLinks Number
ObjectLinkValidityStartDate ObjectLinkValidityStartDate Valid frm
ObjectLinkValidityStartTime ObjectLinkValidityStartTime Time
ObjectLinkValidityEndDate ObjectLinkValidityEndDate Valid to
ObjectLinkValidityEndTime ObjectLinkValidityEndTime Time
MaintObjectInternalID MaintObjectInternalID Object number
ObjectLinkIsFunctionalLocation ObjectLinkIsFunctionalLocation FL LinkObjct
ObjectLinkIsEquipment ObjectLinkIsEquipment EQ LinkObjct
ObjectLinkMedium ObjectLinkMedium Medium
MaintObjLinkPossibleRelshpType MaintObjLinkPossibleRelshpType RelTypePoss.
MaintObjLinkUsedRelshpType MaintObjLinkUsedRelshpType RelTypeUsed
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
AuthorizationGroup AuthorizationGroup AuthorizGroup
ObjectLinkIsMarkedForDeletion ObjectLinkIsMarkedForDeletion Stock del. flag
ObjectLinkCategory ObjectLinkCategory Link category
Product Product Product Sold
_CreatedByUser _CreatedByUser
_Language _Language
_LastChangedByUser _LastChangedByUser
_LinkFromEquipment _LinkFromEquipment
_LinkFromFunctionalLocation _LinkFromFunctionalLocation
_LinkText _LinkText
_LinkToEquipment _LinkToEquipment
_LinkToFunctionalLocation _LinkToFunctionalLocation
_Product _Product
_LongText _LongText

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 P_ObjectLinkSearch.
-- 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: POBJLINKSRCH

CREATE VIEW P_ObjectLinkSearch AS
SELECT
  ObjectLink,
  Language,
  ObjectNetwork,
  ObjectLinkIsEquipOrFuncnlLoc,
  ObjLinkFromFunctionalLocation,
  ObjectLinkFromEquipment,
  ObjectLinkToFunctionalLocation,
  ObjectLinkToEquipment,
  NumberOfParallelLinks,
  ObjectLinkValidityStartDate,
  ObjectLinkValidityStartTime,
  ObjectLinkValidityEndDate,
  ObjectLinkValidityEndTime,
  MaintObjectInternalID,
  ObjectLinkIsFunctionalLocation,
  ObjectLinkIsEquipment,
  ObjectLinkMedium,
  MaintObjLinkPossibleRelshpType,
  MaintObjLinkUsedRelshpType,
  CreationDate,
  LastChangeDate,
  CreatedByUser,
  LastChangedByUser,
  AuthorizationGroup,
  ObjectLinkIsMarkedForDeletion,
  ObjectLinkCategory,
  Product
FROM I_MaintenanceObjectLink AS _ObjLink
LEFT OUTER JOIN I_TextObjectPlainLongText AS _LongText ON ObjectLink = _LongText.TextObjectKey AND _LongText.TextObjectCategory = 'INET' AND _LongText.TextObjectType = 'LTXT'  -- association [0..*]
;

Learn More