I_InvgCsMObjRelatedCaseTP

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_InvgCsMObjRelatedCaseTP.
-- 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: IINVGCSMOBJCASET

CREATE VIEW I_InvgCsMObjRelatedCaseTP AS
SELECT
  InvgCsMRelationshipUUID,
  InvgCsMRelationshipSourceUUID,
  InvgCsMRelationshipTargetUUID,
  _case.InvgCsMCaseID AS InvgCsMCaseID,
  InvgCsMRelSourceTypeID,
  InvgCsMRelTargetTypeID,
  InvgCsMRelationshipTypeID,
  InvgCsMRelSecurityLevel,
  InvgCsMRelationshipExpungeDate,
  InvgCsMRelValidFromDate,
  InvgCsMRelationshipValidToDate,
  InvgCsMRelationshipIsDeleted,
  InvgCsMRelArchiveStatusCode,
  InvgCsMRelEntitiesHash,
  InvgCsMRelCreatedDateTime,
  CreatedByUser,
  InvgCsMRelChangedDateTime,
  LastChangedByUser,
  InvgCsMRelCreatedByOrgID,
  InvgCsMRelChangedByOrgID,
  InvgCsMRelIsHidden,
  InvgCsMReliabilityMatrixUUID,
  InvgCsMRlibtyMtrxRefObjID,
  InvgCsMRlibtyMtrxRefTypeCode,
  InvgCsMRlibtyMtrxRefSetTypeID,
  InvgCsMRlibtyMtrxRefLogSystID,
  InvgCsMRlibtyMtrxSrceRlibtyID,
  InvgCsMRlibtyMtrxInfoRlibtyID,
  InvgCsMRlibtyMtrxHndlgCodeID,
  InvgCsMRlibtyMtrxIsDeleted,
  InvgCsMRlibtyMtrxArchiveSts,
  _case.InvgCsMCaseType AS InvgCsMCaseType,
  _case.InvgCsMCaseTitle AS InvgCsMCaseTitle,
  _case.InvgCsMCaseEndCrimeDateTime AS InvgCsMCaseEndCrimeDateTime,
  _case.InvgCsMCaseEndDateTime AS InvgCsMCaseEndDateTime,
  _case.InvgCsMCaseStartCrimeDateTime AS InvgCsMCaseStartCrimeDateTime,
  _case.InvgCsMCaseStartDateTime AS InvgCsMCaseStartDateTime,
  _case.InvgCsMCaseStatusCode AS InvgCsMCaseStatusCode,
  _case.InvgCsMEscalationReason AS InvgCsMEscalationReason,
  _case.InvgCsMStatPara AS InvgCsMStatPara,
  _case.InvgCsMPriority AS InvgCsMPriority,
  _case.InvgCsMCategoryDesc AS InvgCsMCategoryDesc,
  _case.InvgCsMSecurityLevel AS InvgCsMSecurityLevel,
  cast('' as crm_icm_mat_reliability_id ) AS InvgCsMRlibtyMtrxRlibtyID,
  cast( 'TICM-CSDSP' as abap.char( 20 ) ) AS InvgCsMTargetID,
  cast(' ' as boolean ) AS InvgCsMIsNewEntity,
  cast('' as boolean) AS InvgCsMIsDeleteAllowed,
  cast(' ' as bu_partner ) AS InvgCsMCaseGroupID,
  _casestaff.InvgCsMPartnerNumber AS InvgCsMPartnerNumber,
  _RelNote.InvgCsMTextContent AS InvgCsMTextContent,
  _RelNote.InvgCsMTextObjectID AS InvgCsMTextObjectID,
  _RelNote.InvgCsMTextObjectType AS InvgCsMTextObjectType,
  _RelNote.InvgCsMTextTypeCode AS InvgCsMTextTypeCode,
  _RelNote.InvgCsMTextLanguageCode AS InvgCsMTextLanguageCode
FROM I_InvgCsMObjVisibleReltdCase
LEFT OUTER JOIN I_InvgCsMObjectTP AS _object ON InvgCsMRelationshipSourceUUID = _object.InvgCsMObjectID  -- association [1..1]
LEFT OUTER JOIN I_InvgCsMCase AS _case ON InvgCsMRelationshipTargetUUID = _case.InvgCsMCaseUUID  -- association [0..1]
LEFT OUTER JOIN I_InvgCsMCaseStaffAndUnit AS _casegroup ON InvgCsMRelationshipTargetUUID = _casegroup.InvgCsMCaseUUID AND _casegroup.InvgCsMPartnerFunction = '00000099'  -- association [1..1]
LEFT OUTER JOIN I_InvgCsMCaseStaffAndUnit AS _casestaff ON InvgCsMRelationshipTargetUUID = _casestaff.InvgCsMCaseUUID AND _casestaff.InvgCsMPartnerFunction = '00000014' AND _casestaff.InvgCsMIsCaseMainPartner = 'X'  -- 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]
;