I_InvgCsMLocation

ICM Location | view: IINVGCSMLOCATION | Extraction: Not supported | Component: S4CRM: Investigative Case Mgt
Tables used: ADCPADRCCRMS4D_ICM_LOC
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
IsActiveEntity Draft - Indicator - Is active document Show values
ArchivingStatus ICM Archiving Status Show values
Column Name Description Domain name
InvgCsMLocationName Location Name CRMS4_ICM_NAME
InvgCsMLocationCategoryUUID ICM Category GUID
InvgCsMLocationSecurityLevel Investigative Case Management Security Level CRM_ICM_AUT_SEC_LVL
AddressID Address Number AD_ADDRNUM
InvgCsMLocationCreatedBy Created By UNAME
InvgCsMLocationChangedBy Changed By UNAME
InvgCsMCategoryID Character field of length 40 CHAR40
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
InvgCsMGeoLocationLatitude ICM Location Latitude GEOLONLAT
InvgCsMGeoLocationLongitude ICM Location Longitude 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_INVGCSMLOCATION.COUNTRY == ADRCITY.COUNTRY
  • I_INVGCSMLOCATION.CITYCODE == ADRCITY.CITY_CODE
  • I_INVGCSMLOCATION.MANDT == ADRCITY.CLIENT
Country key
  • Country/Region Key
  • Client
  • I_INVGCSMLOCATION.COUNTRY == T005.LAND1
  • I_INVGCSMLOCATION.MANDT == T005.MANDT
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_INVGCSMLOCATION.COUNTRY == T005S.LAND1
  • I_INVGCSMLOCATION.MANDT == T005S.MANDT
  • I_INVGCSMLOCATION.REGION == T005S.BLAND