CRMS4_IU_C_CONPA

Connection object by partner | view: CRMS4IUVCCONPA | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: EHAUISU, TE130, ADRC, ADCP, TFK001G, T001, TKA02, FKKVKP, IFLOT, T370F, IFLOTX, ILOA, IHPA, EVER, EANL, EVBS, TPAUM
Column Name Description
UtilitiesConnectionObject Connection Object
PARTNER_FCT Partner Function (Language-Dependent Code)
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
HAUS Functional Location TPLNR
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
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 Join Conditions
Address Number
  • Client
  • ?
  • ?
  • Address Number
  • CRMS4_IU_C_CONPA.MANDT == ADRC.CLIENT
  • CRMS4_IU_C_CONPA.[column in domain "AD_NATION"] == ADRC.NATION
  • CRMS4_IU_C_CONPA.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • CRMS4_IU_C_CONPA.ADDRESSID == ADRC.ADDRNUMBER
City code for city/street file
  • Country/Region Key
  • Client
  • City code for city/street file
  • CRMS4_IU_C_CONPA.COUNTRY == ADRCITY.COUNTRY
  • CRMS4_IU_C_CONPA.MANDT == ADRCITY.CLIENT
  • CRMS4_IU_C_CONPA.CITY_CODE == ADRCITY.CITY_CODE
Country key
  • Country/Region Key
  • Client
  • CRMS4_IU_C_CONPA.COUNTRY == T005.LAND1
  • CRMS4_IU_C_CONPA.MANDT == T005.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • CRMS4_IU_C_CONPA.CO_BEGRU == T370B.BEGRU
  • CRMS4_IU_C_CONPA.MANDT == T370B.MANDT
Maintenance Plant
  • Client
  • Maintenance Plant
  • CRMS4_IU_C_CONPA.MANDT == T001W.MANDT
  • CRMS4_IU_C_CONPA.CO_SWERK == T001W.WERKS
Communication Method CRMS4_IU_C_CONPA.DEFLT_COMM == TSAC.COMM_TYPE
Address Delivery service type text table
  • ?
  • Type of Delivery Service
Language key CRMS4_IU_C_CONPA.LANGU == T002.SPRAS
Partner Function
  • Client
  • Partner Function
  • CRMS4_IU_C_CONPA.MANDT == TPAR.MANDT
  • CRMS4_IU_C_CONPA.PARTNERFUNCTION == TPAR.PARVW
Business Partner Number
  • Business Partner Number
  • Client
  • CRMS4_IU_C_CONPA.PARTNER_NO == BUT000.PARTNER
  • CRMS4_IU_C_CONPA.MANDT == BUT000.CLIENT
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • CRMS4_IU_C_CONPA.PO_BOX_CTY == T005.LAND1
  • CRMS4_IU_C_CONPA.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • CRMS4_IU_C_CONPA.PO_BOX_CTY == T005S.LAND1
  • CRMS4_IU_C_CONPA.PO_BOX_REG == T005S.BLAND
  • CRMS4_IU_C_CONPA.MANDT == T005S.MANDT
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • CRMS4_IU_C_CONPA.COUNTRY == T005S.LAND1
  • CRMS4_IU_C_CONPA.MANDT == T005S.MANDT
  • CRMS4_IU_C_CONPA.REGION == T005S.BLAND
Address time zone
  • Client
  • Address time zone
  • CRMS4_IU_C_CONPA.MANDT == TTZZ.CLIENT
  • CRMS4_IU_C_CONPA.TIME_ZONE == TTZZ.TZONE
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • CRMS4_IU_C_CONPA.TITLE == TSAD3.TITLE
  • CRMS4_IU_C_CONPA.MANDT == TSAD3.CLIENT
Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Transportation zone to or from which the goods are delivered
  • Client
  • CRMS4_IU_C_CONPA.COUNTRY == TZONE.LAND1
  • CRMS4_IU_C_CONPA.TRANSPZONE == TZONE.ZONE1
  • CRMS4_IU_C_CONPA.MANDT == TZONE.MANDT