I_InvgCsMLocRelatedLocTP

TP view for ICM Relationship Location to Location | view: IINVGCSMLOCLOCTP | 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
POBoxIsWithoutNumber Flag: PO Box Without Number 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
InvgCsMTgtLocationCategoryUUID Character field, length 32 CHAR32
InvgCsMTargetLocationID ICM Location ID CRMS4_ICM_ID
InvgCsMTargetLocationName Location Name CRMS4_ICM_NAME
InvgCsMCategoryID Character field of length 40 CHAR40
AddressID Address Number AD_ADDRNUM
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
POBoxLobbyName PO Box Lobby TEXT40
CityName City TEXT40
District District TEXT40
HomeCityName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
StreetName Street TEXT60
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
HouseNumber House Number TEXT10
County County TEXT40
CountyCode County code for county CNTY_CODE
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
InvgCsMTextContent String
InvgCsMTextObjectID null
InvgCsMTextObjectType Texts: application object TDOBJECT
InvgCsMTextTypeCode Text ID TDID
InvgCsMTextLanguageCode Language Key SPRAS
Master Data Relations Join Conditions
City code for city/street file
  • City code for city/street file
  • Country/Region Key
  • Client
  • I_INVGCSMLOCRELATEDLOCTP.CITYCODE == ADRCITY.CITY_CODE
  • I_INVGCSMLOCRELATEDLOCTP.COUNTRY == ADRCITY.COUNTRY
  • I_INVGCSMLOCRELATEDLOCTP.MANDT == ADRCITY.CLIENT
Country key
  • Country/Region Key
  • Client
  • I_INVGCSMLOCRELATEDLOCTP.COUNTRY == T005.LAND1
  • I_INVGCSMLOCRELATEDLOCTP.MANDT == T005.MANDT
Relationship type id foreign key
  • Client
  • ICM Relationship Type ID
  • I_INVGCSMLOCRELATEDLOCTP.MANDT == CRMC_ICM_REL.CLIENT
  • I_INVGCSMLOCRELATEDLOCTP.INVGCSMRELATIONSHIPTYPEID == CRMC_ICM_REL.REL_TYPE_ID
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_INVGCSMLOCRELATEDLOCTP.COUNTRY == T005S.LAND1
  • I_INVGCSMLOCRELATEDLOCTP.MANDT == T005S.MANDT
  • I_INVGCSMLOCRELATEDLOCTP.REGION == T005S.BLAND