C_InvgCsMLocRelatedCaseTP

Consumptional view for ICM Relationship Location to Case | view: CINVGCSMLOCCASET | 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
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
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
InvgCsMTargetID null
InvgCsMRlibtyMtrxInfoRlibtyID ICM Matrix: Information Reliability ID
InvgCsMReliabilityMatrixUUID ICM Matrix: Reliability Matrix GUID SYSUUID
InvgCsMRlibtyMtrxSrceRlibtyID ICM Matrix : Source Reliability ID
InvgCsMRlibtyMtrxRlibtyID ICM Matrix: Reliability ID
InvgCsMPartnerNumber Partner Number
InvgCsMCaseEmployeeName null
InvgCsMCaseGroupID Partner Number
InvgCsMCaseGroupName null
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
InvgCsMRelCreatedByOrgID ICM Relationship: Organizational Element
InvgCsMRelChangedByOrgID ICM Relationship: Organizational Element
InvgCsMCaseStartDateTime ICM Date and Time Without Conversion Routine
InvgCsMCaseEndDateTime ICM Date and Time Without Conversion Routine
InvgCsMCaseStartCrimeDateTime ICM Date and Time Without Conversion Routine
InvgCsMCaseEndCrimeDateTime ICM Date and Time Without Conversion Routine
Master Data Relations Join Conditions
Case: Status
  • Client
  • ?
  • Case: Status
  • C_INVGCSMLOCRELATEDCASETP.MANDT == SCMGSTATPROFS.CLIENT
  • C_INVGCSMLOCRELATEDCASETP.[column in domain "SCMGSTATUSPROFID"] == SCMGSTATPROFS.PROFILE_ID
  • C_INVGCSMLOCRELATEDCASETP.INVGCSMCASESTATUSCODE == SCMGSTATPROFS.STAT_ORDERNO
Case Type
  • Client
  • Case Type
  • C_INVGCSMLOCRELATEDCASETP.MANDT == SCMGCASETYPE.CLIENT
  • C_INVGCSMLOCRELATEDCASETP.INVGCSMCASETYPE == SCMGCASETYPE.CASE_TYPE
Reason for Escalation
  • Client
  • Reason for Escalation
Priority
  • Client
  • Priority
Relationship type id foreign key
  • Client
  • ICM Relationship Type ID
  • C_INVGCSMLOCRELATEDCASETP.MANDT == CRMC_ICM_REL.CLIENT
  • C_INVGCSMLOCRELATEDCASETP.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID
Case: System Status C_INVGCSMLOCRELATEDCASETP.INVGCSMSTATPARA == SCMGSTAT.STAT_PARA