C_InvgCsMObjRelatedPersnTP

Consumptional view for ICM Relationship Object to Person | view: CINVGCSMOBJPERTP | 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
BirthDate Date of Birth of Business Partner
InvgCsMRelValidFromDate ICM Relationship: Dates
InvgCsMRelationshipValidToDate ICM Relationship: Dates
InvgCsMRelationshipExpungeDate ICM Relationship: Dates
Column Name Description
InvgCsMRelSourceTypeID ICM Relationship, Entity Type ID Show values
InvgCsMRelTargetTypeID ICM Relationship, Entity Type ID Show values
BusinessPartnerCategory Business Partner Category 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
InvgCsMTextContent String
InvgCsMTextObjectID null
InvgCsMTextObjectType Texts: application object TDOBJECT
InvgCsMTextTypeCode Text ID TDID
InvgCsMTextLanguageCode Language Key SPRAS
InvgCsMTextLog String
BusinessPartnerName null
InvgCsMRelSecurityLevel Investigative Case Management Security Level
InvgCsMRelIsHidden ICM Case Hidden Checkbox
InvgCsMTargetID null
InvgCsMRlibtyMtrxInfoRlibtyID ICM Matrix: Information Reliability ID
InvgCsMRlibtyMtrxSrceRlibtyID ICM Matrix : Source Reliability ID
InvgCsMRlibtyMtrxRlibtyID ICM Matrix: Reliability ID
InvgCsMReliabilityMatrixUUID ICM Matrix: Reliability Matrix GUID SYSUUID
CreatedByUser ICM Relationship: User Name
InvgCsMRelCreatedDateTime ICM Relationship: Administration Date
LastChangedByUser ICM Relationship: User Name
InvgCsMRelChangedDateTime ICM Relationship: Administration Date
FirstName First name of business partner (person)
LastName Last name of business partner (person)
InvgCsMIsUnknownPerson ICM BP Flag
StreetName Street
HouseNumber House Number
PostalCode City postal code
CityName City
PhoneNumber Telephone no.: dialling code+number
PhoneNumberExtension Telephone no.: Extension
District District
FaxNumber Fax number: dialling code+number
FaxNumberExtension Fax no.: Extension
EmailAddress E-Mail Address
Master Data Relations Join Conditions
Business Partner Number
  • Business Partner Number
  • Client
  • C_INVGCSMOBJRELATEDPERSNTP.BUSINESSPARTNER == BUT000.PARTNER
  • C_INVGCSMOBJRELATEDPERSNTP.MANDT == BUT000.CLIENT
Country key
  • Client
  • Country/Region Key
  • C_INVGCSMOBJRELATEDPERSNTP.MANDT == T005.MANDT
  • C_INVGCSMOBJRELATEDPERSNTP.COUNTRY == T005.LAND1
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • C_INVGCSMOBJRELATEDPERSNTP.MANDT == TSAD3.CLIENT
  • C_INVGCSMOBJRELATEDPERSNTP.FORMOFADDRESS == TSAD3.TITLE
Sex of business partner (person) C_INVGCSMOBJRELATEDPERSNTP.GENDERCODENAME == TB995.GENDER
Relationship type id foreign key
  • Client
  • ICM Relationship Type ID
  • C_INVGCSMOBJRELATEDPERSNTP.MANDT == CRMC_ICM_REL.CLIENT
  • C_INVGCSMOBJRELATEDPERSNTP.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_INVGCSMOBJRELATEDPERSNTP.MANDT == T005S.MANDT
  • C_INVGCSMOBJRELATEDPERSNTP.COUNTRY == T005S.LAND1
  • C_INVGCSMOBJRELATEDPERSNTP.REGION == T005S.BLAND