I_InvgCsMLocationTP

TP View for ICM Location | view: IINVGCSMLOCTP | Extraction: Not supported | Component: S4CRM: Investigative Case Mgt
Column Name Description
InvgCsMLocationID ICM Location ID
Column Name Description
Column Name Description
Column Name Description
InvgCsMLocationCreatedOnDate Created On
InvgCsMLocationChangedOnDate Changed On
Column Name Description
InvgCsMLocationIsHidden ICM Case Hidden Checkbox Show values
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
ArchivingStatus ICM Archiving Status Show values
InvgCsMGeogrlLocLonDrctn Direction: Longitude Show values
InvgCsMGeogrlLocLonDeg Input/Output Longitude, Degrees Show values
InvgCsMGeogrlLocLonMins Input/Output Minutes for Geodata Show values
InvgCsMGeogrlLocLonSecs Input/Output Seconds for Geodata Show values
InvgCsMGeogrlLocLatDrctn Direction: Latitude Show values
InvgCsMGeogrlLocLatDeg Input/Output Latitude, Degree Show values
InvgCsMGeogrlLocLatMins Input/Output Minutes for Geodata Show values
InvgCsMGeogrlLocLatSecs Input/Output Seconds for Geodata Show values
Column Name Description Domain name
InvgCsMLocationIDForEdit ICM Location ID CRMS4_ICM_ID
InvgCsMLocationName Location Name CRMS4_ICM_NAME
InvgCsMLocationCategoryUUID Character field, length 32 CHAR32
InvgCsMCategoryID Character field of length 40 CHAR40
InvgCsMLocationSecurityLevel Investigative Case Management Security Level CRM_ICM_AUT_SEC_LVL
AddressID Address Number AD_ADDRNUM
InvgCsMLocationCreatedBy Created By UNAME
InvgCsMLocationChangedBy Changed By UNAME
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
POBoxLobbyName PO Box Lobby TEXT40
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
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
InvgCsMImageFileID ID for documents and relations SDOK_DOCID
BusinessUser User ID XUBNAME
InvgCsMGeoLocationLongitude ICM Location Longitude GEOLONLAT
InvgCsMGeoLocationLatitude ICM Location Latitude GEOLONLAT
InvgCsMGeoLocationAltitude ICM Location Altitude GEOALT
Master Data Relations Join Conditions
City code for city/street file
  • Country/Region Key
  • City code for city/street file
  • Client
  • I_INVGCSMLOCATIONTP.COUNTRY == ADRCITY.COUNTRY
  • I_INVGCSMLOCATIONTP.CITYCODE == ADRCITY.CITY_CODE
  • I_INVGCSMLOCATIONTP.MANDT == ADRCITY.CLIENT
Country key
  • Country/Region Key
  • Client
  • I_INVGCSMLOCATIONTP.COUNTRY == T005.LAND1
  • I_INVGCSMLOCATIONTP.MANDT == T005.MANDT
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_INVGCSMLOCATIONTP.COUNTRY == T005S.LAND1
  • I_INVGCSMLOCATIONTP.MANDT == T005S.MANDT
  • I_INVGCSMLOCATIONTP.REGION == T005S.BLAND