I_InvgCsMVisibleCase

DDL: I_INVGCSMVISIBLECASE SQL: IICMVISIBLECASE Type: view COMPOSITE
24 Fields 1 Data Sources 8 Associations

Nonhidden ICM Case

I_InvgCsMVisibleCase (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_InvgCsMVisibleCase is a Composite CDS View that provides data about "Nonhidden ICM Case" in SAP S/4HANA. It reads from 1 data source (I_InvgCsMCase) and exposes 24 fields with key field InvgCsMCaseID. It has 8 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentCRM-S4-IPS-ICM
CapabilitiesAssociation Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_InvgCsMCase I_InvgCsMCase from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_InvgCsMCaseLogInStaff _CaseLogIn $projection.InvgCsMCaseUUID = _CaseLogIn.InvgCsMCaseUUID
[0..*] I_InvgCsMCaseStaffAndUnit _StaffAndUnit $projection.InvgCsMCaseUUID = _StaffAndUnit.InvgCsMCaseUUID
[0..*] I_InvgCsMNoteKeyMapping _Note $projection.InvgCsMCaseUUID = _Note.ServiceDocumentCharUUID
[0..1] I_InvgCsMSecurityLevelText _ScrtyLvlTxt $projection.InvgCsMSecurityLevel = _ScrtyLvlTxt.InvgCsMAuthScopeCode and _ScrtyLvlTxt.InvgCsMLanguageCode = $session.system_language and _ScrtyLvlTxt.InvgCsMAuthDomainCode = 'ICM'
[1..1] I_InvgCsMCaseType _CaseType $projection.InvgCsMCaseType = _CaseType.CaseType
[0..*] I_InvgCsMCasePhaseText _PhaseText $projection.InvgCsMCaseStatusCode = _PhaseText.InvgCsMCaseStatusCode and _PhaseText.Language = $session.system_language
[0..*] I_DocInfoRecdBusObjAttachCntnt _Attachment $projection.InvgCsMCaseUUID = _Attachment.LinkedSAPObjectKey and _Attachment.LinkedSAPObject = 'ICM_CASE'
[0..*] I_InvgCsMInvstgvRecdMapping _RecDoc $projection.InvgCsMCaseUUID = _RecDoc.InvgCsMCaseUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IICMVISIBLECASE view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Nonhidden ICM Case view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMCaseID InvgCsMCaseID External key
InvgCsMCaseUUID InvgCsMCaseUUID Technical Case Key (Case GUID)
InvgCsMCaseType InvgCsMCaseType Usage Type
InvgCsMCaseTitle InvgCsMCaseTitle Case Title
InvgCsMCaseStatusCode InvgCsMCaseStatusCode Case: Status
InvgCsMStatPara InvgCsMStatPara Case: System Status
InvgCsMPriority InvgCsMPriority Workflow priority
InvgCsMEscalationReason InvgCsMEscalationReason Reason for Escalation
InvgCsMSecurityLevel InvgCsMSecurityLevel Investigative Case Management Security Level
InvgCsMIsHidden InvgCsMIsHidden ICM Case Hidden Checkbox
InvgCsMCategoryDesc InvgCsMCategoryDesc Category Description
InvgCsMCaseStartCrimeDateTime InvgCsMCaseStartCrimeDateTime ICM Date and Time Without Conversion Routine
InvgCsMCaseEndCrimeDateTime InvgCsMCaseEndCrimeDateTime ICM Date and Time Without Conversion Routine
InvgCsMCaseStartDateTime InvgCsMCaseStartDateTime ICM Date and Time Without Conversion Routine
InvgCsMCaseEndDateTime InvgCsMCaseEndDateTime ICM Date and Time Without Conversion Routine
BusinessUser _CaseLogIn BusinessUser User ID
InvgCsMProcessForCaseType _CaseType InvgCsMProcessForCaseType Permitted Process for Case Type
_StaffAndUnit _StaffAndUnit
_Note _Note
_ScrtyLvlTxt _ScrtyLvlTxt
_CaseType _CaseType
_PhaseText _PhaseText
_Attachment _Attachment
_RecDoc _RecDoc

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_InvgCsMVisibleCase.
-- 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: IICMVISIBLECASE

CREATE VIEW I_InvgCsMVisibleCase AS
SELECT
  InvgCsMCaseID,
  InvgCsMCaseUUID,
  InvgCsMCaseType,
  InvgCsMCaseTitle,
  InvgCsMCaseStatusCode,
  InvgCsMStatPara,
  InvgCsMPriority,
  InvgCsMEscalationReason,
  InvgCsMSecurityLevel,
  InvgCsMIsHidden,
  InvgCsMCategoryDesc,
  InvgCsMCaseStartCrimeDateTime,
  InvgCsMCaseEndCrimeDateTime,
  InvgCsMCaseStartDateTime,
  InvgCsMCaseEndDateTime,
  _CaseLogIn.BusinessUser AS BusinessUser,
  _CaseType.InvgCsMProcessForCaseType AS InvgCsMProcessForCaseType
FROM I_InvgCsMCase
LEFT OUTER JOIN I_InvgCsMCaseLogInStaff AS _CaseLogIn ON InvgCsMCaseUUID = _CaseLogIn.InvgCsMCaseUUID  -- association [0..1]
LEFT OUTER JOIN I_InvgCsMCaseStaffAndUnit AS _StaffAndUnit ON InvgCsMCaseUUID = _StaffAndUnit.InvgCsMCaseUUID  -- association [0..*]
LEFT OUTER JOIN I_InvgCsMNoteKeyMapping AS _Note ON InvgCsMCaseUUID = _Note.ServiceDocumentCharUUID  -- association [0..*]
LEFT OUTER JOIN I_InvgCsMSecurityLevelText AS _ScrtyLvlTxt ON InvgCsMSecurityLevel = _ScrtyLvlTxt.InvgCsMAuthScopeCode AND _ScrtyLvlTxt.InvgCsMLanguageCode = $session.system_language AND _ScrtyLvlTxt.InvgCsMAuthDomainCode = 'ICM'  -- association [0..1]
LEFT OUTER JOIN I_InvgCsMCaseType AS _CaseType ON InvgCsMCaseType = _CaseType.CaseType  -- association [1..1]
LEFT OUTER JOIN I_InvgCsMCasePhaseText AS _PhaseText ON InvgCsMCaseStatusCode = _PhaseText.InvgCsMCaseStatusCode AND _PhaseText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_DocInfoRecdBusObjAttachCntnt AS _Attachment ON InvgCsMCaseUUID = _Attachment.LinkedSAPObjectKey AND _Attachment.LinkedSAPObject = 'ICM_CASE'  -- association [0..*]
LEFT OUTER JOIN I_InvgCsMInvstgvRecdMapping AS _RecDoc ON InvgCsMCaseUUID = _RecDoc.InvgCsMCaseUUID  -- association [0..*]
;

Learn More