I_InvgCsMRelationshipVH

ICM Relationship | view: IINVGCSMRELVH | TRAN | Extraction: Not supported | Component: S4CRM: Investigative Case Mgt
Tables used: CRMD_ICM_REL
Column Name Description
InvgCsMRelationshipUUID ICM Relationship: Relationship 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
InvgCsMRelationshipSourceID ICM Relationship: Relationship DB Table Entity GUID CHAR45
InvgCsMRelationshipTargetID ICM Relationship: Relationship DB Table Entity GUID CHAR45
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_INVGCSMRELATIONSHIPVH.MANDT == CRMC_ICM_REL.CLIENT
  • I_INVGCSMRELATIONSHIPVH.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID