CRMS4_IU_I_CON

Connection object | view: CRMS4IUVICON | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: EHAUISUTE130ADRCADCPADRCIFLOTT370FIFLOTXILOA
Column Name Description
FunctionalLocation Functional Location
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the object was created
LastChangeDate Date on which the object was last changed
Column Name Description
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
Column Name Description Domain name
NumberOfPremises null
NumberOfPoDs null
FunctionalLocationCategory Functional location category FLTYP
CreatedByUser Name of User Who Created the Object USNAM
LastChangedByUser Name of the user who last changed the object USNAM
UtilitiesCountyCode County Code COUNC
RegionalStructureGroup Regional structure grouping REGIOGROUP
PoliticalRegionalStructure Political regional structure element REGPOLIT
RegionalStructureGroupPermit Regional structure group for supply permit processing REGIOGROUP
FunctionalLocationName Description of functional location TEXT40
BusinessPartnerName1 Name 1 TEXT40
BusinessPartnerName2 Name 2 TEXT40
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
CareOfName c/o name TEXT40
CityName City TEXT40
District District TEXT40
HomeCityName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
POBox PO Box CHAR10
POBoxDeviatingCityName PO Box city TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
StreetPrefixName Street 2 TEXT40
StreetSuffixName Street 4 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
SearchTerm1 Search Term 1 CHAR20
SearchTerm2 Search Term 2 CHAR20
TaxJurisdiction Tax Jurisdiction AD_TXJCD
POBoxLobbyName PO Box Lobby TEXT40
DeliveryServiceNumber Number of Delivery Service CHAR10
CountyCode County code for county CNTY_CODE
County County TEXT40
CitySearch City name in Uppercase for Search Help CHAR25
StreetSearch Street Name in Uppercase for Search Help CHAR25
mc_name1 Name (Field NAME1) in Uppercase for Search Help CHAR25
mc_township Township name in upper case for search help CHAR25
mc_county County name in upper case for search help CHAR25
Master Data Relations | to Other Relations ↓ Join Conditions
Address Number
  • Address Number
  • Client
  • ?
  • ?
  • CRMS4_IU_I_CON.ADDRESSID == ADRC.ADDRNUMBER
  • CRMS4_IU_I_CON.MANDT == ADRC.CLIENT
  • CRMS4_IU_I_CON.[column in domain "AD_NATION"] == ADRC.NATION
  • CRMS4_IU_I_CON.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Address time zone
  • Client
  • Address time zone
  • CRMS4_IU_I_CON.MANDT == TTZZ.CLIENT
  • CRMS4_IU_I_CON.ADDRESSTIMEZONE == TTZZ.TZONE
Technical Object Authorization Group
  • Client
  • Technical Object Authorization Group
  • CRMS4_IU_I_CON.MANDT == T370B.MANDT
  • CRMS4_IU_I_CON.AUTHORIZATIONGROUP == T370B.BEGRU
City code for city/street file
  • Client
  • Country/Region Key
  • City code for city/street file
  • CRMS4_IU_I_CON.MANDT == ADRCITY.CLIENT
  • CRMS4_IU_I_CON.COUNTRY == ADRCITY.COUNTRY
  • CRMS4_IU_I_CON.CITYCODE == ADRCITY.CITY_CODE
Language key CRMS4_IU_I_CON.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • CRMS4_IU_I_CON.MANDT == T005.MANDT
  • CRMS4_IU_I_CON.COUNTRY == T005.LAND1
Address Delivery service type text table
  • Type of Delivery Service
  • ?
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • CRMS4_IU_I_CON.MANDT == TSAD3.CLIENT
  • CRMS4_IU_I_CON.FORMOFADDRESS == TSAD3.TITLE
Location of maintenance object
  • Client
  • Location of maintenance object
  • Maintenance Plant
  • CRMS4_IU_I_CON.MANDT == T499S.MANDT
  • CRMS4_IU_I_CON.MAINTENANCEOBJECTLOCATION == T499S.STAND
  • CRMS4_IU_I_CON.MAINTENANCEPLANT == T499S.WERKS
Maintenance Plant
  • Client
  • Maintenance Plant
  • CRMS4_IU_I_CON.MANDT == T001W.MANDT
  • CRMS4_IU_I_CON.MAINTENANCEPLANT == T001W.WERKS
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • CRMS4_IU_I_CON.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • CRMS4_IU_I_CON.MANDT == ILOA.MANDT
PO Box of Country/Region
  • Client
  • PO Box of Country/Region
  • CRMS4_IU_I_CON.MANDT == T005.MANDT
  • CRMS4_IU_I_CON.POBOXDEVIATINGCOUNTRY == T005.LAND1
Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • CRMS4_IU_I_CON.MANDT == T005S.MANDT
  • CRMS4_IU_I_CON.POBOXDEVIATINGREGION == T005S.BLAND
  • CRMS4_IU_I_CON.POBOXDEVIATINGCOUNTRY == T005S.LAND1
Communication Method CRMS4_IU_I_CON.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • CRMS4_IU_I_CON.MANDT == T005S.MANDT
  • CRMS4_IU_I_CON.COUNTRY == T005S.LAND1
  • CRMS4_IU_I_CON.REGION == T005S.BLAND
Transportation zone to or from which the goods are delivered
  • Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • CRMS4_IU_I_CON.TRANSPORTZONE == TZONE.ZONE1
  • CRMS4_IU_I_CON.MANDT == TZONE.MANDT
  • CRMS4_IU_I_CON.COUNTRY == TZONE.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • CRMS4_IU_I_CON.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • CRMS4_IU_I_CON.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • CRMS4_IU_I_CON.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • CRMS4_IU_I_CON.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • CRMS4_IU_I_CON.MANDT == T399I.MANDT