P_BPUsrAssignment

Business User - User Assignment | view: PBPUSRASSIGN | Extraction: Not supported | Component: Business User Management
Tables used: ADR6ADRPUSR02USR21
Column Name Description
UserID User ID
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Firstname First name TEXT40
Lastname Last name TEXT40
UserDescription User Description SUIDTECHDESC
DefaultEmailAddress E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Address number of a user
  • Address Number
  • ?
  • ?
  • Client
  • P_BPUSRASSIGNMENT.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • P_BPUSRASSIGNMENT.[column in domain "AD_NATION"] == ADRC.NATION
  • P_BPUSRASSIGNMENT.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • P_BPUSRASSIGNMENT.MANDT == ADRC.CLIENT
Address number of a user
  • Person Number
  • ?
  • ?
  • Client
  • P_BPUSRASSIGNMENT.PERSONNUMBER == ADRP.PERSNUMBER
  • P_BPUSRASSIGNMENT.[column in domain "AD_NATION"] == ADRP.NATION
  • P_BPUSRASSIGNMENT.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • P_BPUSRASSIGNMENT.MANDT == ADRP.CLIENT
User group
  • User group in user master maintenance
  • Client
  • P_BPUSRASSIGNMENT.USERGROUP == USGRP.USERGROUP
  • P_BPUSRASSIGNMENT.MANDT == USGRP.MANDT