CRMS4_IU_C_PRMFTS

Premise by free text | view: CRMS4IUVCPRMFTS | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: EUIHEADEUITRANSEHAUISUTE130ADRCADCPADRCBUT000TFK001GT001TKA02FKKVKPIFLOTT370FIFLOTXILOAEVEREANLEVBS
Column Name Description
VSTELLE Premise
Column Name Description
Column Name Description
Column Name Description
Column Name Description
VS_LOEVM Deletion Indicator Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
HAUS Connection Object CHAR30
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
VS_VSTELLE Premise VSTELLE
CityName City TEXT40
StreetName Street TEXT60
PostalCode City postal code CHAR10
HouseNumber House Number TEXT10
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
PersonFullName Full Name TEXT80
ext_ui Point of Delivery ID EXT_UI
Master Data Relations Join Conditions
Address Number
  • ?
  • ?
  • Address Number
  • Client
  • CRMS4_IU_C_PRMFTS.[column in domain "AD_NATION"] == ADRC.NATION
  • CRMS4_IU_C_PRMFTS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • CRMS4_IU_C_PRMFTS.ADDRESSID == ADRC.ADDRNUMBER
  • CRMS4_IU_C_PRMFTS.MANDT == ADRC.CLIENT
Authorization Group
  • Client
  • ?
  • Authorization Group
  • CRMS4_IU_C_PRMFTS.MANDT == TB037.CLIENT
  • CRMS4_IU_C_PRMFTS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • CRMS4_IU_C_PRMFTS.AUTHORIZATIONGROUP == TB037.AUGRP
Business Partner Number
  • Business Partner Number
  • Client
  • CRMS4_IU_C_PRMFTS.BUSINESSPARTNER == BUT000.PARTNER
  • CRMS4_IU_C_PRMFTS.MANDT == BUT000.CLIENT
Contract Account
  • Client
  • Contract Account
  • CRMS4_IU_C_PRMFTS.MANDT == FKKVK.MANDT
  • CRMS4_IU_C_PRMFTS.CONTRACTACCOUNT == FKKVK.VKONT
Country key
  • Client
  • Country/Region Key
  • CRMS4_IU_C_PRMFTS.MANDT == T005.MANDT
  • CRMS4_IU_C_PRMFTS.COUNTRY == T005.LAND1
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • CRMS4_IU_C_PRMFTS.MANDT == T005S.MANDT
  • CRMS4_IU_C_PRMFTS.REGION == T005S.BLAND
  • CRMS4_IU_C_PRMFTS.COUNTRY == T005S.LAND1