I_InvgCsMLocReltdObjectTP

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_InvgCsMLocReltdObjectTP.
-- 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: IINVGCSMLOCOBJTP

CREATE VIEW I_InvgCsMLocReltdObjectTP AS
SELECT
  InvgCsMRelationshipUUID,
  InvgCsMRelationshipSourceUUID,
  InvgCsMRelationshipTargetUUID,
  InvgCsMRelSourceTypeID,
  InvgCsMRelTargetTypeID,
  InvgCsMRelationshipTypeID,
  InvgCsMRelSecurityLevel,
  InvgCsMRelationshipExpungeDate,
  InvgCsMRelValidFromDate,
  InvgCsMRelationshipValidToDate,
  InvgCsMRelationshipIsDeleted,
  InvgCsMRelArchiveStatusCode,
  InvgCsMRelEntitiesHash,
  InvgCsMRelCreatedDateTime,
  CreatedByUser,
  InvgCsMRelChangedDateTime,
  LastChangedByUser,
  InvgCsMRelCreatedByOrgID,
  InvgCsMRelChangedByOrgID,
  InvgCsMRelIsHidden,
  _targetobject.InvgCsMObjectID AS InvgCsMTargetObjectID,
  _targetobject.InvgCsMObjectName AS InvgCsMTargetObjectName,
  cast ( bintohex(_targetobject.InvgCsMObjectCategoryUUID ) as char32) AS InvgCsMTgtObjectCategoryUUID,
  _targetobject.InvgCsMCategoryID AS InvgCsMCategoryID,
  _targetobject.InvgCsMObjectIsMissing AS InvgCsMTargetObjectIsMissing,
  _targetobject.InvgCsMObjectSecurityLevel AS InvgCsMObjectSecurityLevel,
  InvgCsMReliabilityMatrixUUID,
  InvgCsMRlibtyMtrxRefObjID,
  InvgCsMRlibtyMtrxRefTypeCode,
  InvgCsMRlibtyMtrxRefSetTypeID,
  InvgCsMRlibtyMtrxRefLogSystID,
  InvgCsMRlibtyMtrxSrceRlibtyID,
  InvgCsMRlibtyMtrxInfoRlibtyID,
  InvgCsMRlibtyMtrxHndlgCodeID,
  InvgCsMRlibtyMtrxIsDeleted,
  InvgCsMRlibtyMtrxArchiveSts,
  cast('' as crm_icm_mat_reliability_id ) AS InvgCsMRlibtyMtrxRlibtyID,
  cast('' as boolean) AS InvgCsMIsNewEntity,
  cast('' as boolean) AS InvgCsMIsDeleteAllowed,
  _RelNote.InvgCsMTextContent AS InvgCsMTextContent,
  _RelNote.InvgCsMTextObjectID AS InvgCsMTextObjectID,
  _RelNote.InvgCsMTextObjectType AS InvgCsMTextObjectType,
  _RelNote.InvgCsMTextTypeCode AS InvgCsMTextTypeCode,
  _RelNote.InvgCsMTextLanguageCode AS InvgCsMTextLanguageCode,
  _location.InvgCsMLocationID AS InvgCsMLocationID,
  _location.InvgCsMLocationName AS InvgCsMLocationName
FROM I_InvgCsMLocVisibleReltdObj
LEFT OUTER JOIN I_InvgCsMVisibleObject AS _targetobject ON InvgCsMRelationshipTargetUUID = _targetobject.InvgCsMObjectID  -- association [0..1]
LEFT OUTER JOIN I_InvgCsMLocationTP AS _location ON InvgCsMRelationshipSourceUUID = _location.InvgCsMLocationID  -- association [1..1]
LEFT OUTER JOIN I_InvgCsMRelationshipNote AS _RelNote ON InvgCsMRelationshipUUID = _RelNote.InvgCsMTextObjectID AND _RelNote.InvgCsMTextObjectType = 'ICM_REL' AND _RelNote.InvgCsMTextTypeCode = 'NOTE' AND _RelNote.InvgCsMTextLanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_InvgCsMRelationship AS _RelationExtension ON InvgCsMRelationshipUUID = _RelationExtension.InvgCsMRelationshipUUID  -- association [1..1]
LEFT OUTER JOIN E_InvgCsMReliabilityMatrix AS _RelMatExtension ON InvgCsMReliabilityMatrixUUID = _RelMatExtension.InvgCsMReliabilityMatrixUUID  -- association [1..1]
;