I_InvgCsMRelationship

Basic View for ICM Relationship | view: IINVGCSMREL | TRAN | Extraction: Not supported | Component: S4CRM: Investigative Case Mgt
Column Name Description
InvgCsMRelationshipUUID ICM Relationship: Relationship GUID
InvgCsMRelationshipSourceUUID Char 20
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
InvgCsMRlibtyMtrxIsDeleted ICM Matrix: Reliability Matrix Indicator Show values
InvgCsMRlibtyMtrxArchiveSts ICM Reliability Matrix Archive Status Show values
Column Name Description Domain name
InvgCsMRelationshipTargetUUID 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
InvgCsMReliabilityMatrixUUID ICM Matrix: Reliability Matrix GUID SYSUUID
InvgCsMRlibtyMtrxRefObjID null
InvgCsMRlibtyMtrxRefTypeCode ICM Matrix: Reliability Matrix Reference Object Type OJ_NAME
InvgCsMRlibtyMtrxRefSetTypeID ICM Matrix: Reliability Matrix Reference Object Set Type CHAR32
InvgCsMRlibtyMtrxRefLogSystID ICM Reliability: Reliability Reference Logical System LOGSYS
InvgCsMRlibtyMtrxSrceRlibtyID ICM Matrix : Source Reliability ID CHAR3
InvgCsMRlibtyMtrxInfoRlibtyID ICM Matrix: Information Reliability ID CHAR3
InvgCsMRlibtyMtrxHndlgCodeID ICM Matrix: Reliability Matrix Handling Code ID CHAR3
Master Data Relations Join Conditions
Relationship type id foreign key
  • Client
  • ICM Relationship Type ID
  • I_INVGCSMRELATIONSHIP.MANDT == CRMC_ICM_REL.CLIENT
  • I_INVGCSMRELATIONSHIP.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID