C_InvgCsMObjRelatedCaseTP

Consumptional view for ICM Relationship Object to Case | view: CINVGCSMOBJCASET | TRAN | Extraction: Not supported | Component: S4CRM: Investigative Case Mgt
Tables used: CRMD_CMG_CASE_AT, CRMD_ICM_CMG_ATT, SCMG_T_CASE_ATTR, CRMD_ICM_REL, BUT000, BUT100, CRMM_ICM_BP_H_EX, CRMD_CASE_INDEX, SCMGCASETYPE, CRMD_ICM_MAT, CRMC_ICM_MAT_RL, CRMS4D_ICM_STAFF, USR21
Column Name Description
InvgCsMRelationshipUUID ICM Relationship: Relationship GUID
InvgCsMRelationshipSourceUUID Char 20
Column Name Description
Column Name Description
Column Name Description
InvgCsMRelValidFromDate ICM Relationship: Dates
InvgCsMRelationshipValidToDate ICM Relationship: Dates
InvgCsMRelationshipExpungeDate ICM Relationship: Dates
Column Name Description
InvgCsMRelSourceTypeID ICM Relationship, Entity Type ID Show values
InvgCsMRelTargetTypeID ICM Relationship, Entity Type ID Show values
InvgCsMIsNewEntity Boolean Variable (X = True, - = False, Space = Unknown) Show values
InvgCsMIsDeleteAllowed Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
InvgCsMRelationshipTargetUUID ICM Relationship: Relationship DB Table Entity GUID CHAR45
InvgCsMCaseID Case ID
InvgCsMTextContent String
InvgCsMTextObjectID null
InvgCsMTextObjectType Texts: application object TDOBJECT
InvgCsMTextTypeCode Text ID TDID
InvgCsMTextLanguageCode Language Key SPRAS
InvgCsMTextLog String
InvgCsMCaseTitle Case Title
InvgCsMRelSecurityLevel Investigative Case Management Security Level
InvgCsMRelIsHidden ICM Case Hidden Checkbox
InvgCsMCategoryDesc Category Description
InvgCsMRlibtyMtrxInfoRlibtyID ICM Matrix: Information Reliability ID
InvgCsMRlibtyMtrxSrceRlibtyID ICM Matrix : Source Reliability ID
InvgCsMRlibtyMtrxRlibtyID ICM Matrix: Reliability ID
InvgCsMReliabilityMatrixUUID ICM Matrix: Reliability Matrix GUID SYSUUID
InvgCsMTargetID null
InvgCsMCaseEndCrimeDateTime ICM Date and Time Without Conversion Routine
InvgCsMCaseEndDateTime ICM Date and Time Without Conversion Routine
InvgCsMCaseStartCrimeDateTime ICM Date and Time Without Conversion Routine
InvgCsMCaseStartDateTime ICM Date and Time Without Conversion Routine
InvgCsMRelChangedByOrgID ICM Relationship: Organizational Element
InvgCsMRelCreatedByOrgID ICM Relationship: Organizational Element
CreatedByUser ICM Relationship: User Name
CreatedByUserDescription User Description SUIDTECHDESC
InvgCsMRelCreatedDateTime ICM Relationship: Administration Date
LastChangedByUser ICM Relationship: User Name
LastChangedByUserDescription User Description SUIDTECHDESC
InvgCsMRelChangedDateTime ICM Relationship: Administration Date
InvgCsMCaseGroupID Business Partner Number
InvgCsMCaseGroupName null
InvgCsMPartnerNumber Partner Number
InvgCsMCaseEmployeeName null
Master Data Relations Join Conditions
Case: Status
  • Client
  • ?
  • Case: Status
  • C_INVGCSMOBJRELATEDCASETP.MANDT == SCMGSTATPROFS.CLIENT
  • C_INVGCSMOBJRELATEDCASETP.[column in domain "SCMGSTATUSPROFID"] == SCMGSTATPROFS.PROFILE_ID
  • C_INVGCSMOBJRELATEDCASETP.INVGCSMCASESTATUSCODE == SCMGSTATPROFS.STAT_ORDERNO
Case Type
  • Client
  • Case Type
  • C_INVGCSMOBJRELATEDCASETP.MANDT == SCMGCASETYPE.CLIENT
  • C_INVGCSMOBJRELATEDCASETP.INVGCSMCASETYPE == SCMGCASETYPE.CASE_TYPE
Reason for Escalation
  • Reason for Escalation
  • Client
Priority
  • Client
  • Priority
Relationship type id foreign key
  • ICM Relationship Type ID
  • Client
  • C_INVGCSMOBJRELATEDCASETP.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID
  • C_INVGCSMOBJRELATEDCASETP.MANDT == CRMC_ICM_REL.CLIENT
Case: System Status C_INVGCSMOBJRELATEDCASETP.INVGCSMSTATPARA == SCMGSTAT.STAT_PARA