CRMS4_IU_C_PRMBP

Premise by Business Partner | view: CRMS4IUVCPRMBP | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: BUT000TFK001GT001TKA02FKKVKPEVEREANLEVBSTE102TE102T
Column Name Description
BU_PARTNER_NUMBER FK Business Partner Number
ContractAccount FK Contract Account
UtilitiesContract Contract
Column Name Description
Column Name Description
Column Name Description
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
Column Name Description
VS_LOEVM Deletion Indicator Show values
Column Name Description Domain name
BU_PARTNER_GUID Business Partner GUID SYSUUID
VSTELLE Premise VSTELLE
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_VBSART Type of premise VBSART
VS_VBSARTTXT Text for premise type TEXT40
VS_VSTELLE Premise VSTELLE
Master Data Relations Join Conditions
Business Partner Number
  • Client
  • Business Partner Number
  • CRMS4_IU_C_PRMBP.MANDT == BUT000.CLIENT
  • CRMS4_IU_C_PRMBP.BU_PARTNER_NUMBER == BUT000.PARTNER
Contract Account
  • Client
  • Contract Account
  • CRMS4_IU_C_PRMBP.MANDT == FKKVK.MANDT
  • CRMS4_IU_C_PRMBP.CONTRACTACCOUNT == FKKVK.VKONT
Premise
  • Client
  • Premise
  • Premise
  • Premise
  • CRMS4_IU_C_PRMBP.MANDT == EVBS.MANDT
  • CRMS4_IU_C_PRMBP.VS_VSTELLE == EVBS.VSTELLE
  • CRMS4_IU_C_PRMBP.VSTELLE == EVBS.VSTELLE
  • CRMS4_IU_C_PRMBP.UTILITIESPREMISE == EVBS.VSTELLE