I_InvgCsMObjRelatedLeadTP

TP view for ICM Relationship Object to Lead | view: IINVGCSMOBJLEADT | 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
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 SCMG_EXT_KEY
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
InvgCsMRlibtyMtrxRlibtyID ICM Matrix: Reliability ID CHAR6
InvgCsMTargetID null
InvgCsMCaseTitle Case Title TEXT80
InvgCsMCaseEndCrimeDateTime ICM Date and Time Without Conversion Routine CRMS4_ICM_TIMESTAMP
InvgCsMCaseEndDateTime ICM Date and Time Without Conversion Routine CRMS4_ICM_TIMESTAMP
InvgCsMCaseStartCrimeDateTime ICM Date and Time Without Conversion Routine CRMS4_ICM_TIMESTAMP
InvgCsMCaseStartDateTime ICM Date and Time Without Conversion Routine CRMS4_ICM_TIMESTAMP
InvgCsMCategoryDesc Category Description TEXT80
InvgCsMCaseGroupID Partner Number CRM_PARTNER_NO
InvgCsMPartnerNumber Partner Number CRM_PARTNER_NO
InvgCsMTextContent String
InvgCsMTextObjectID null
InvgCsMTextObjectType Texts: application object TDOBJECT
InvgCsMTextTypeCode Text ID TDID
InvgCsMTextLanguageCode Language Key SPRAS
Master Data Relations Join Conditions
Case: Status
  • Client
  • ?
  • Case: Status
  • I_INVGCSMOBJRELATEDLEADTP.MANDT == SCMGSTATPROFS.CLIENT
  • I_INVGCSMOBJRELATEDLEADTP.[column in domain "SCMGSTATUSPROFID"] == SCMGSTATPROFS.PROFILE_ID
  • I_INVGCSMOBJRELATEDLEADTP.INVGCSMCASESTATUSCODE == SCMGSTATPROFS.STAT_ORDERNO
Case Type
  • Client
  • Case Type
  • I_INVGCSMOBJRELATEDLEADTP.MANDT == SCMGCASETYPE.CLIENT
  • I_INVGCSMOBJRELATEDLEADTP.INVGCSMCASETYPE == SCMGCASETYPE.CASE_TYPE
Reason for Escalation
  • Client
  • Reason for Escalation
Priority
  • Client
  • Priority
Relationship type id foreign key
  • Client
  • ICM Relationship Type ID
  • I_INVGCSMOBJRELATEDLEADTP.MANDT == CRMC_ICM_REL.CLIENT
  • I_INVGCSMOBJRELATEDLEADTP.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID
Case: System Status I_INVGCSMOBJRELATEDLEADTP.INVGCSMSTATPARA == SCMGSTAT.STAT_PARA