CRMS4_IU_C_PRMADDR

Premise by Address | view: CRMS4IUVCPRMADDR | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: ADRCEVBSIFLOTILOA
Column Name Description
vstelle Premise
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
VS_FLOOR Floor in building TEXT10
VS_ROOMNUMBER Room or Apartment Number TEXT10
VS_STR_SUPPL1 Street 3 TEXT40
VS_STR_SUPPL3 Street 5 TEXT40
VS_HOUSE_NUM2 House number supplement TEXT10
VS_ANZPERS Number of persons ANZ_PERS
VS_LGZUSATZ Additional Information on Location LGZUSATZ
begru Authorization Group BEGRU
city1 City TEXT40
city2 District 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_loc PO Box city TEXT40
street Street TEXT60
str_suppl1 Street 2 TEXT40
str_suppl2 Street 3 TEXT40
str_suppl3 Street 4 TEXT40
house_num1 House Number TEXT10
house_num2 House number supplement TEXT10
sort1 Search Term 1 CHAR20
sort2 Search Term 2 CHAR20
po_box_lobby PO Box Lobby TEXT40
deli_serv_number Number of Delivery Service CHAR10
county County TEXT40
ADDRNUMBER (Not supported) Physical address ID AD_ADDR_ID
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
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • CRMS4_IU_C_PRMADDR.MANDT == T005.MANDT
  • CRMS4_IU_C_PRMADDR.COUNTRY == T005.LAND1
Address Delivery service type text table
  • ?
  • Type of Delivery Service
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • CRMS4_IU_C_PRMADDR.MANDT == T005S.MANDT
  • CRMS4_IU_C_PRMADDR.COUNTRY == T005S.LAND1
  • CRMS4_IU_C_PRMADDR.REGION == T005S.BLAND
Type of premise
  • Type of premise
  • Client
  • CRMS4_IU_C_PRMADDR.VS_VBSART == TE102.VBSART
  • CRMS4_IU_C_PRMADDR.MANDT == TE102.MANDT