I_InvgCsMObjRelatedPersnTP

TP view for ICM Relationship Object to Person | view: IINVGCSMOBJPERTP | TRAN | Extraction: Not supported | Component: S4CRM: Investigative Case Mgt
Tables used: CRMD_ICM_REL, ADCP, ADRC, ADR6, ADR3, ADR2, BUT020, BUT021_FS, BUT050, 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
InvgCsMRelationshipExpungeDate ICM Relationship: Dates
InvgCsMRelValidFromDate ICM Relationship: Dates
InvgCsMRelationshipValidToDate ICM Relationship: Dates
BirthDate Date of Birth of Business Partner
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
BusinessPartnerCategory Business Partner Category Show values
InvgCsMIsUnknownPerson ICM BP Flag 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
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
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
BusinessPartnerName null
StreetName Street TEXT60
HouseNumber House Number TEXT10
PostalCode City postal code CHAR10
CityName City TEXT40
CountyCode County code for county CNTY_CODE
District District TEXT40
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
EmailAddress E-Mail Address AD_SMTPADR
FaxNumber Fax number: dialling code+number CHAR30
FaxNumberExtension Fax no.: Extension CHAR10
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
InvgCsMTextContent String
InvgCsMTextObjectID null
InvgCsMTextObjectType Texts: application object TDOBJECT
InvgCsMTextTypeCode Text ID TDID
InvgCsMTextLanguageCode Language Key SPRAS
Master Data Relations Join Conditions
Academic Title: Key
  • Academic Title: Key
  • Client
  • I_INVGCSMOBJRELATEDPERSNTP.ACADEMICTITLE == TSAD2.TITLE_KEY
  • I_INVGCSMOBJRELATEDPERSNTP.MANDT == TSAD2.CLIENT
Address Number
  • ?
  • Address Number
  • Client
  • ?
  • I_INVGCSMOBJRELATEDPERSNTP.[column in domain "AD_NATION"] == ADRC.NATION
  • I_INVGCSMOBJRELATEDPERSNTP.ADDRESSID == ADRC.ADDRNUMBER
  • I_INVGCSMOBJRELATEDPERSNTP.MANDT == ADRC.CLIENT
  • I_INVGCSMOBJRELATEDPERSNTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Business Partner Number
  • Business Partner Number
  • Client
  • I_INVGCSMOBJRELATEDPERSNTP.BUSINESSPARTNER == BUT000.PARTNER
  • I_INVGCSMOBJRELATEDPERSNTP.MANDT == BUT000.CLIENT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Client
  • I_INVGCSMOBJRELATEDPERSNTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_INVGCSMOBJRELATEDPERSNTP.COUNTRY == T005.LAND1
  • I_INVGCSMOBJRELATEDPERSNTP.MANDT == T005.MANDT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Client
  • I_INVGCSMOBJRELATEDPERSNTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_INVGCSMOBJRELATEDPERSNTP.COUNTRY == T005.LAND1
  • I_INVGCSMOBJRELATEDPERSNTP.MANDT == T005.MANDT
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • I_INVGCSMOBJRELATEDPERSNTP.FORMOFADDRESS == TSAD3.TITLE
  • I_INVGCSMOBJRELATEDPERSNTP.MANDT == TSAD3.CLIENT
Sex of business partner (person) I_INVGCSMOBJRELATEDPERSNTP.GENDERCODENAME == TB995.GENDER
Relationship type id foreign key
  • ICM Relationship Type ID
  • Client
  • I_INVGCSMOBJRELATEDPERSNTP.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID
  • I_INVGCSMOBJRELATEDPERSNTP.MANDT == CRMC_ICM_REL.CLIENT
Region code
  • Region (State, Province, County)
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Client
  • I_INVGCSMOBJRELATEDPERSNTP.REGION == T005S.BLAND
  • I_INVGCSMOBJRELATEDPERSNTP.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_INVGCSMOBJRELATEDPERSNTP.COUNTRY == T005S.LAND1
  • I_INVGCSMOBJRELATEDPERSNTP.MANDT == T005S.MANDT