C_InvgCsMLocationTP

Consumptional View for ICM Location | view: CINVGCSMLOCTP | 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
Column Name Description Domain name
InvgCsMLocationIDForEdit ICM Location ID CRMS4_ICM_ID
InvgCsMLocationName Location Name
InvgCsMLocationCategoryUUID Character field, length 32
AddressID Address Number AD_ADDRNUM
InvgCsMCategoryID Character field of length 40
InvgCsMLocationSecurityLevel Investigative Case Management Security Level
InvgCsMLocationCreatedBy Created By
InvgCsMLocationChangedBy Changed By
ArchivingStatus ICM Archiving Status
CreatedByUser User Description SUIDTECHDESC
LastChangedByUser User Description SUIDTECHDESC
CityName City TEXT40
PostalCode City postal code CHAR10
StreetName Street TEXT60
CountyCode County code for county CNTY_CODE
InvgCsMGeoLocationLongitude ICM Location Longitude
InvgCsMGeogrlLocLonDrctn Direction: Longitude
InvgCsMGeogrlLocLonDeg Input/Output Longitude, Degrees
InvgCsMGeogrlLocLonMins Input/Output Minutes for Geodata
InvgCsMGeogrlLocLonSecs Input/Output Seconds for Geodata
InvgCsMGeoLocationLatitude ICM Location Latitude
InvgCsMGeogrlLocLatDrctn Direction: Latitude
InvgCsMGeogrlLocLatDeg Input/Output Latitude, Degree
InvgCsMGeogrlLocLatMins Input/Output Minutes for Geodata
InvgCsMGeogrlLocLatSecs Input/Output Seconds for Geodata
InvgCsMImageFileID ID for documents and relations SDOK_DOCID
InvgCsMImageURL Image URL
BusinessUser User ID XUBNAME
Master Data Relations Join Conditions
City code for city/street file
  • City code for city/street file
  • Client
  • Country/Region Key
  • C_INVGCSMLOCATIONTP.CITYCODE == ADRCITY.CITY_CODE
  • C_INVGCSMLOCATIONTP.MANDT == ADRCITY.CLIENT
  • C_INVGCSMLOCATIONTP.COUNTRY == ADRCITY.COUNTRY
Country key
  • Client
  • Country/Region Key
  • C_INVGCSMLOCATIONTP.MANDT == T005.MANDT
  • C_INVGCSMLOCATIONTP.COUNTRY == T005.LAND1
Region code
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • C_INVGCSMLOCATIONTP.REGION == T005S.BLAND
  • C_INVGCSMLOCATIONTP.MANDT == T005S.MANDT
  • C_INVGCSMLOCATIONTP.COUNTRY == T005S.LAND1