I_InvgCsMRelationshipView

ICM Relationship | view: IINVGCSMRELSHPV | TRAN | Extraction: Not supported | Component: S4CRM: Investigative Case Mgt
Tables used: CRMD_ICM_REL
Column Name Description
InvgCsMRelationshipUUID ICM Relationship: Relationship GUID
InvgCsMRelationshipSourceUUID ICM Relationship: Relationship DB Table Entity GUID
InvgCsMRelationshipTargetUUID ICM Relationship: Relationship DB Table Entity GUID
Column Name Description
Column Name Description
Column Name Description
InvgCsMRelationshipExpungeDate ICM Relationship: Dates
InvgCsMRelValidFromDate ICM Relationship: Dates
InvgCsMRelationshipValidToDate ICM Relationship: Dates
Column Name Description
InvgCsMRelSourceTypeID ICM Relationship, Entity Type ID Show values
InvgCsMRelTargetTypeID ICM Relationship, Entity Type ID Show values
InvgCsMRelationshipIsDeleted ICM Relationship: Delete Flag Show values
InvgCsMRelArchiveStatusCode ICM Relationship Archive Status Show values
InvgCsMRelIsHidden ICM Case Hidden Checkbox Show values
Column Name Description Domain name
InvgCsMRelSecurityLevel Investigative Case Management Security Level CRM_ICM_AUT_SEC_LVL
InvgCsMRelEntitiesHash ICM Relationship: Entities Hash
InvgCsMRelCreatedDateTime ICM Relationship: Administration Date TZNTSTMPS
CreatedByUser ICM Relationship: User Name SYCHAR12
InvgCsMRelChangedDateTime ICM Relationship: Administration Date TZNTSTMPS
LastChangedByUser ICM Relationship: User Name SYCHAR12
InvgCsMRelCreatedByOrgID ICM Relationship: Organizational Element BU_PARTNER
InvgCsMRelChangedByOrgID ICM Relationship: Organizational Element BU_PARTNER
Master Data Relations Join Conditions
Relationship type id foreign key
  • Client
  • ICM Relationship Type ID
  • I_INVGCSMRELATIONSHIPVIEW.MANDT == CRMC_ICM_REL.CLIENT
  • I_INVGCSMRELATIONSHIPVIEW.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID