C_InvgCsMLocReltdActvtTP

Consumptional view for ICM Relationship Location to Activity | view: CINVGCSMLOCACTTP | TRAN | Extraction: Not supported | Component: S4CRM: Investigative Case Mgt
Tables used: CRMS4D_ACTV_H, CRMS4D_PARTNER, CRMD_ICM_REL, ADCP, ADRC, ADR6, ADR2, BUT020, BUT021_FS, BUT000, BUT100, CRMM_ICM_BP_H_EX, CRMD_ICM_MAT, CRMC_ICM_MAT_RL, CRMS4D_ICM_STAFF, BUT021_FS, TB008S, TB008U
Column Name Description
InvgCsMRelationshipUUID ICM Relationship: Relationship GUID
InvgCsMRelationshipSourceUUID Char 20
Column Name Description
Column Name Description
Column Name Description
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
InvgCsMOrderID Transaction ID
InvgCsMTextContent String
InvgCsMTextObjectID null
InvgCsMTextObjectType Texts: application object TDOBJECT
InvgCsMTextTypeCode Text ID TDID
InvgCsMTextLanguageCode Language Key SPRAS
InvgCsMTextLog String
InvgCsMOrderDescription Transaction Description
InvgCsMActivityLocationDesc Location
InvgCsMMainEmployeeName null
CreatedByUser ICM Relationship: User Name
InvgCsMRelCreatedDateTime ICM Relationship: Administration Date
LastChangedByUser ICM Relationship: User Name
InvgCsMRelChangedDateTime ICM Relationship: Administration Date
InvgCsMRelSecurityLevel Investigative Case Management Security Level
InvgCsMRelIsHidden ICM Case Hidden Checkbox
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
InvgCsMActivityMainPtyName null
Master Data Relations Join Conditions
Business Partner Number
  • Client
  • Business Partner Number
  • C_INVGCSMLOCRELTDACTVTTP.MANDT == BUT000.CLIENT
  • C_INVGCSMLOCRELTDACTVTTP.BUSINESSPARTNER == BUT000.PARTNER
Activity Priority
  • Client
  • Activity Priority
  • C_INVGCSMLOCRELTDACTVTTP.MANDT == SCPRIO.CLIENT
  • C_INVGCSMLOCRELTDACTVTTP.INVGCSMACTIVITYPRIORITYCODE == SCPRIO.PRIORITY
Business Transaction Type
  • Client
  • Business Transaction Type
  • C_INVGCSMLOCRELTDACTVTTP.MANDT == CRMC_PROC_TYPE.CLIENT
  • C_INVGCSMLOCRELTDACTVTTP.INVGCSMACTIVITYPROCESSTYPECODE == CRMC_PROC_TYPE.PROCESS_TYPE
Status of Agent Inbox Item
  • Status of Agent Inbox Item
  • Client
Business Partner Number
  • Client
  • Business Partner Number
  • C_INVGCSMLOCRELTDACTVTTP.MANDT == BUT000.CLIENT
  • C_INVGCSMLOCRELTDACTVTTP.INVGCSMMAINEMPLOYEERESPID == BUT000.PARTNER
Activity Category (Communication Type)
  • Client
  • Activity Category (Communication Type)
Relationship type id foreign key
  • Client
  • ICM Relationship Type ID
  • C_INVGCSMLOCRELTDACTVTTP.MANDT == CRMC_ICM_REL.CLIENT
  • C_INVGCSMLOCRELTDACTVTTP.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID