CRMS4_IU_C_CONPOD

Connection Object by Internal PoD ID | view: CRMS4IUVCCONPOD | Extraction: Not supported | Component: S4CRM: Utilities Industry
Column Name Description
INT_UI Internal key for point of delivery
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
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
UtilitiesConnectionObject Connection Object CHAR30
Master Data Relations Join Conditions
City code for city/street file
  • Country/Region Key
  • Client
  • City code for city/street file
  • CRMS4_IU_C_CONPOD.COUNTRY == ADRCITY.COUNTRY
  • CRMS4_IU_C_CONPOD.MANDT == ADRCITY.CLIENT
  • CRMS4_IU_C_CONPOD.CITY_CODE == ADRCITY.CITY_CODE
Country key
  • Country/Region Key
  • Client
  • CRMS4_IU_C_CONPOD.COUNTRY == T005.LAND1
  • CRMS4_IU_C_CONPOD.MANDT == T005.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • CRMS4_IU_C_CONPOD.CO_BEGRU == T370B.BEGRU
  • CRMS4_IU_C_CONPOD.MANDT == T370B.MANDT
Maintenance Plant
  • Maintenance Plant
  • Client
  • CRMS4_IU_C_CONPOD.CO_SWERK == T001W.WERKS
  • CRMS4_IU_C_CONPOD.MANDT == T001W.MANDT
Communication Method CRMS4_IU_C_CONPOD.DEFLT_COMM == TSAC.COMM_TYPE
Address Delivery service type text table
  • ?
  • Type of Delivery Service
Language key CRMS4_IU_C_CONPOD.LANGU == T002.SPRAS
PO Box of Country/Region
  • Client
  • PO Box of Country/Region
  • CRMS4_IU_C_CONPOD.MANDT == T005.MANDT
  • CRMS4_IU_C_CONPOD.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_CONPOD.MANDT == T005S.MANDT
  • CRMS4_IU_C_CONPOD.PO_BOX_CTY == T005S.LAND1
  • CRMS4_IU_C_CONPOD.PO_BOX_REG == T005S.BLAND
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • CRMS4_IU_C_CONPOD.COUNTRY == T005S.LAND1
  • CRMS4_IU_C_CONPOD.MANDT == T005S.MANDT
  • CRMS4_IU_C_CONPOD.REGION == T005S.BLAND
Address time zone
  • Client
  • Address time zone
  • CRMS4_IU_C_CONPOD.MANDT == TTZZ.CLIENT
  • CRMS4_IU_C_CONPOD.TIME_ZONE == TTZZ.TZONE
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • CRMS4_IU_C_CONPOD.MANDT == TSAD3.CLIENT
  • CRMS4_IU_C_CONPOD.TITLE == TSAD3.TITLE
Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • CRMS4_IU_C_CONPOD.COUNTRY == TZONE.LAND1
  • CRMS4_IU_C_CONPOD.MANDT == TZONE.MANDT
  • CRMS4_IU_C_CONPOD.TRANSPZONE == TZONE.ZONE1