I_InvgCsMLocRelatedPersnTP

TP view for ICM Relationship Location to Person | view: IINVGCSMLOCPERTP | 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
IsFemale Selection: Business partner is female 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
BusinessPartnerName null
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
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
  • Client
  • Academic Title: Key
  • I_INVGCSMLOCRELATEDPERSNTP.MANDT == TSAD2.CLIENT
  • I_INVGCSMLOCRELATEDPERSNTP.ACADEMICTITLE == TSAD2.TITLE_KEY
Address Number
  • Client
  • ?
  • ?
  • Address Number
  • I_INVGCSMLOCRELATEDPERSNTP.MANDT == ADRC.CLIENT
  • I_INVGCSMLOCRELATEDPERSNTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_INVGCSMLOCRELATEDPERSNTP.[column in domain "AD_NATION"] == ADRC.NATION
  • I_INVGCSMLOCRELATEDPERSNTP.ADDRESSID == ADRC.ADDRNUMBER
Business Partner Number
  • Client
  • Business Partner Number
  • I_INVGCSMLOCRELATEDPERSNTP.MANDT == BUT000.CLIENT
  • I_INVGCSMLOCRELATEDPERSNTP.BUSINESSPARTNER == BUT000.PARTNER
Country key
  • Client
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • I_INVGCSMLOCRELATEDPERSNTP.MANDT == T005.MANDT
  • I_INVGCSMLOCRELATEDPERSNTP.COUNTRY == T005.LAND1
  • I_INVGCSMLOCRELATEDPERSNTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • I_INVGCSMLOCRELATEDPERSNTP.MANDT == T005.MANDT
  • I_INVGCSMLOCRELATEDPERSNTP.COUNTRY == T005.LAND1
  • I_INVGCSMLOCRELATEDPERSNTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_INVGCSMLOCRELATEDPERSNTP.MANDT == TSAD3.CLIENT
  • I_INVGCSMLOCRELATEDPERSNTP.FORMOFADDRESS == TSAD3.TITLE
Sex of business partner (person) I_INVGCSMLOCRELATEDPERSNTP.GENDERCODENAME == TB995.GENDER
Relationship type id foreign key
  • Client
  • ICM Relationship Type ID
  • I_INVGCSMLOCRELATEDPERSNTP.MANDT == CRMC_ICM_REL.CLIENT
  • I_INVGCSMLOCRELATEDPERSNTP.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID
Region code
  • Client
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Region (State, Province, County)
  • I_INVGCSMLOCRELATEDPERSNTP.MANDT == T005S.MANDT
  • I_INVGCSMLOCRELATEDPERSNTP.COUNTRY == T005S.LAND1
  • I_INVGCSMLOCRELATEDPERSNTP.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_INVGCSMLOCRELATEDPERSNTP.REGION == T005S.BLAND