CRMS4_IU_C_CON

Connection object | view: CRMS4IUVCCON | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: EHAUISU, TE130, ADRC, ADCP, ADRC, IFLOT, T370F, IFLOTX, ILOA
Column Name Description
HAUS Functional Location
Column Name Description
Column Name Description
Column Name Description
CO_ERDAT Date on which the object was created
CO_AEDAT Date on which the object was last changed
Column Name Description
PO_BOX_NUM Flag: PO Box Without Number Show values
Column Name Description Domain name
CO_TPLNR Functional Location TPLNR
CO_FLTYP Functional location category FLTYP
CO_SHTXT Description of functional location TEXT40
CO_ERNAM Name of User Who Created the Object USNAM
CO_AENAM Name of the user who last changed the object USNAM
NAME1 Name 1 TEXT40
NAME2 Name 2 TEXT40
NAME3 Name 3 TEXT40
NAME4 Name 4 TEXT40
NAME_CO c/o name TEXT40
CITY1 City TEXT40
CITY2 District TEXT40
HOME_CITY City (different from postal city) TEXT40
CO_COUNC County Code COUNC
REGIOGROUP Regional structure grouping REGIOGROUP
CO_REGPOLIT Political regional structure element REGPOLIT
REGIOGROUP_PERM Regional structure group for supply permit processing REGIOGROUP
POST_CODE1 City postal code CHAR10
POST_CODE2 PO Box Postal Code CHAR10
POST_CODE3 Company Postal Code (for Large Customers) CHAR10
PO_BOX PO Box CHAR10
PO_BOX_LOC PO Box city TEXT40
STREET Street TEXT60
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
STR_SUPPL1 Street 2 TEXT40
STR_SUPPL2 Street 3 TEXT40
STR_SUPPL3 Street 4 TEXT40
LOCATION Street 5 TEXT40
BUILDING Building (Number or Code) TEXT20
FLOOR Floor in building TEXT10
ROOMNUMBER Room or Apartment Number TEXT10
SORT1 Search Term 1 CHAR20
SORT2 Search Term 2 CHAR20
TAXJURCODE Tax Jurisdiction AD_TXJCD
PO_BOX_LOBBY PO Box Lobby TEXT40
DELI_SERV_TYPE Number of Delivery Service CHAR10
COUNTY_CODE County code for county CNTY_CODE
COUNTY County TEXT40
MC_CITY1 City name in Uppercase for Search Help CHAR25
MC_STREET Street Name in Uppercase for Search Help CHAR25
MC_NAME1 Name (Field NAME1) in Uppercase for Search Help CHAR25
MC_COUNTY County name in upper case for search help CHAR25
MC_TOWNSHIP Township name in upper case for search help CHAR25
NUMBER_PRM null
NUMBER_POD null
Master Data Relations | to Other Relations ↓ Join Conditions
Address Number
  • ?
  • ?
  • Address Number
  • Client
  • CRMS4_IU_C_CON.[column in domain "AD_NATION"] == ADRC.NATION
  • CRMS4_IU_C_CON.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • CRMS4_IU_C_CON.ADDRESSID == ADRC.ADDRNUMBER
  • CRMS4_IU_C_CON.MANDT == ADRC.CLIENT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • CRMS4_IU_C_CON.AUTHORIZATIONGROUP == T370B.BEGRU
  • CRMS4_IU_C_CON.CO_BEGRU == T370B.BEGRU
  • CRMS4_IU_C_CON.MANDT == T370B.MANDT
City code for city/street file
  • Client
  • Country/Region Key
  • City code for city/street file
  • CRMS4_IU_C_CON.MANDT == ADRCITY.CLIENT
  • CRMS4_IU_C_CON.COUNTRY == ADRCITY.COUNTRY
  • CRMS4_IU_C_CON.CITY_CODE == ADRCITY.CITY_CODE
Country key
  • Client
  • Country/Region Key
  • CRMS4_IU_C_CON.MANDT == T005.MANDT
  • CRMS4_IU_C_CON.COUNTRY == T005.LAND1
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • CRMS4_IU_C_CON.AUTHORIZATIONGROUP == T370B.BEGRU
  • CRMS4_IU_C_CON.CO_BEGRU == T370B.BEGRU
  • CRMS4_IU_C_CON.MANDT == T370B.MANDT
Maintenance Plant
  • Maintenance Plant
  • Maintenance Plant
  • Client
  • CRMS4_IU_C_CON.MAINTENANCEPLANT == T001W.WERKS
  • CRMS4_IU_C_CON.CO_SWERK == T001W.WERKS
  • CRMS4_IU_C_CON.MANDT == T001W.MANDT
Communication Method CRMS4_IU_C_CON.DEFLT_COMM == TSAC.COMM_TYPE
Address Delivery service type text table
  • ?
  • Type of Delivery Service
Language key CRMS4_IU_C_CON.LANGU == T002.SPRAS
Maintenance Plant
  • Maintenance Plant
  • Maintenance Plant
  • Client
  • CRMS4_IU_C_CON.MAINTENANCEPLANT == T001W.WERKS
  • CRMS4_IU_C_CON.CO_SWERK == T001W.WERKS
  • CRMS4_IU_C_CON.MANDT == T001W.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • CRMS4_IU_C_CON.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • CRMS4_IU_C_CON.MANDT == ILOA.MANDT
PO Box of Country/Region
  • Client
  • PO Box of Country/Region
  • CRMS4_IU_C_CON.MANDT == T005.MANDT
  • CRMS4_IU_C_CON.PO_BOX_CTY == T005.LAND1
Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • CRMS4_IU_C_CON.MANDT == T005S.MANDT
  • CRMS4_IU_C_CON.PO_BOX_CTY == T005S.LAND1
  • CRMS4_IU_C_CON.PO_BOX_REG == T005S.BLAND
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • CRMS4_IU_C_CON.MANDT == T005S.MANDT
  • CRMS4_IU_C_CON.COUNTRY == T005S.LAND1
  • CRMS4_IU_C_CON.REGION == T005S.BLAND
Address time zone
  • Client
  • Address time zone
  • CRMS4_IU_C_CON.MANDT == TTZZ.CLIENT
  • CRMS4_IU_C_CON.TIME_ZONE == TTZZ.TZONE
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • CRMS4_IU_C_CON.MANDT == TSAD3.CLIENT
  • CRMS4_IU_C_CON.TITLE == TSAD3.TITLE
Transportation zone to or from which the goods are delivered
  • Client
  • Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • CRMS4_IU_C_CON.MANDT == TZONE.MANDT
  • CRMS4_IU_C_CON.TRANSPZONE == TZONE.ZONE1
  • CRMS4_IU_C_CON.COUNTRY == TZONE.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • CRMS4_IU_C_CON.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • CRMS4_IU_C_CON.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • CRMS4_IU_C_CON.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • CRMS4_IU_C_CON.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • CRMS4_IU_C_CON.MANDT == T399I.MANDT