I_InvgCsMObjRelatedOrgTP

TP view for ICM Relationship Object to Org | view: IINVGCSMOBJORGTP | 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
OrganizationFoundationDate Date organization founded
OrganizationLiquidationDate Liquidation date of organization
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
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
OrganizationBPName1 Name 1 of organization 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
Address Number
  • ?
  • ?
  • Address Number
  • Client
  • I_INVGCSMOBJRELATEDORGTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_INVGCSMOBJRELATEDORGTP.[column in domain "AD_NATION"] == ADRC.NATION
  • I_INVGCSMOBJRELATEDORGTP.ADDRESSID == ADRC.ADDRNUMBER
  • I_INVGCSMOBJRELATEDORGTP.MANDT == ADRC.CLIENT
Business Partner Number
  • Business Partner Number
  • Client
  • I_INVGCSMOBJRELATEDORGTP.BUSINESSPARTNER == BUT000.PARTNER
  • I_INVGCSMOBJRELATEDORGTP.MANDT == BUT000.CLIENT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Client
  • I_INVGCSMOBJRELATEDORGTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_INVGCSMOBJRELATEDORGTP.COUNTRY == T005.LAND1
  • I_INVGCSMOBJRELATEDORGTP.MANDT == T005.MANDT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Client
  • I_INVGCSMOBJRELATEDORGTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_INVGCSMOBJRELATEDORGTP.COUNTRY == T005.LAND1
  • I_INVGCSMOBJRELATEDORGTP.MANDT == T005.MANDT
Relationship type id foreign key
  • Client
  • ICM Relationship Type ID
  • I_INVGCSMOBJRELATEDORGTP.MANDT == CRMC_ICM_REL.CLIENT
  • I_INVGCSMOBJRELATEDORGTP.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID
BP: Legal form of organization
  • BP: Legal form of organization
  • Client
  • I_INVGCSMOBJRELATEDORGTP.LEGALFORM == TB019.LEGAL_ENTY
  • I_INVGCSMOBJRELATEDORGTP.MANDT == TB019.CLIENT
Region code
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_INVGCSMOBJRELATEDORGTP.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_INVGCSMOBJRELATEDORGTP.COUNTRY == T005S.LAND1
  • I_INVGCSMOBJRELATEDORGTP.MANDT == T005S.MANDT
  • I_INVGCSMOBJRELATEDORGTP.REGION == T005S.BLAND