C_EmployeeBusinessUser

Employee Business User - Consumption View | view: CEMPLBUSINESSUSR | Extraction: Not supported | Component: Business User Management
Tables used: ADCP, ADR2, ADR3, ADR6, BUT000, MOM052, USR01, USR02, USR21, USREFUS, ADRP, BUT000, BUT0ID, TB039A, BUT100, TB003, BUT100, BPU_ROLECAT_WHL, BPU_ROLECAT_WHL
Column Name Description
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
EmployeeFullNameMaintStatus Status of Field 'Full Name' NAME_TEXT Show values
DateFormatCode Date format Show values
DecimalFormatCode Decimal Format Show values
TimeFormatCode Time Format (12-/24-Hour Specification) Show values
IsMarkedForArchiving Central Archiving Flag Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
BusinessPartnerGUID Business Partner GUID SYSUUID
Employee Identification Number CHAR60
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
EmployeeFullName Full Name of Person TEXT80
MiddleName Middle name or second forename of a person BU_NAME
AdditionalLastName Other Last Name of a Person BU_NAME
BirthName Name at birth of business partner BU_NAME
NickName Nickname of Business Partner (Person) BU_NAME
Initials "Middle Initial" or personal initials CHAR10
ValidityStartDate Validity Start of a BP Role TZNTSTMPS
ValidityEndDate Validity End of a BP Role TZNTSTMPS
EmailAddress E-Mail Address AD_SMTPADR
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
Building Building (number or code) TEXT10
RoomNumber Room or Apartment Number TEXT10
Department Department TEXT40
FunctionalTitleName Function TEXT40
UserName Internet user alias USALIAS
LockedIndicator null
LogonLanguageCode Logon Language LANG
UserDescription User Description SUIDTECHDESC
CreatedByUser User who created the object USNAM
CreationDateTime null
LastChangedByUser Last user to change object USNAM
LastChangeDateTime null
Master Data Relations Join Conditions
Second academic title (key)
  • Client
  • Second academic title (key)
  • C_EMPLOYEEBUSINESSUSER.MANDT == TSAD2.CLIENT
  • C_EMPLOYEEBUSINESSUSER.ACADEMICSECONDTITLE == TSAD2.TITLE_KEY
Academic Title: Key
  • Academic Title: Key
  • Client
  • C_EMPLOYEEBUSINESSUSER.ACADEMICTITLE == TSAD2.TITLE_KEY
  • C_EMPLOYEEBUSINESSUSER.MANDT == TSAD2.CLIENT
Authorization Group
  • ?
  • Client
  • Authorization Group
  • C_EMPLOYEEBUSINESSUSER.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_EMPLOYEEBUSINESSUSER.MANDT == TB037.CLIENT
  • C_EMPLOYEEBUSINESSUSER.AUTHORIZATIONGROUP == TB037.AUGRP
Correspondence Language C_EMPLOYEEBUSINESSUSER.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • C_EMPLOYEEBUSINESSUSER.MANDT == T005.MANDT
  • C_EMPLOYEEBUSINESSUSER.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSER.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • C_EMPLOYEEBUSINESSUSER.MANDT == TSAD3.CLIENT
  • C_EMPLOYEEBUSINESSUSER.FORMOFADDRESS == TSAD3.TITLE
Name Prefix (Key)
  • Client
  • Name Prefix (Key)
  • C_EMPLOYEEBUSINESSUSER.MANDT == TSAD4.CLIENT
  • C_EMPLOYEEBUSINESSUSER.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
2nd name prefix (key)
  • 2nd name prefix (key)
  • Client
  • C_EMPLOYEEBUSINESSUSER.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
  • C_EMPLOYEEBUSINESSUSER.MANDT == TSAD4.CLIENT
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • C_EMPLOYEEBUSINESSUSER.MANDT == T005.MANDT
  • C_EMPLOYEEBUSINESSUSER.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSER.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Name supplement, e.g. noble title (key)
  • Client
  • Name supplement, e.g. noble title (key)
  • C_EMPLOYEEBUSINESSUSER.MANDT == TSAD5.CLIENT
  • C_EMPLOYEEBUSINESSUSER.NAMESUPPLEMENT == TSAD5.TITLE_KEY
Time Zone
  • Client
  • Time Zone
  • C_EMPLOYEEBUSINESSUSER.MANDT == TTZZ.CLIENT
  • C_EMPLOYEEBUSINESSUSER.TIMEZONECODE == TTZZ.TZONE
User group
  • Client
  • User group in user master maintenance
  • C_EMPLOYEEBUSINESSUSER.MANDT == USGRP.MANDT
  • C_EMPLOYEEBUSINESSUSER.USERGROUP == USGRP.USERGROUP
Address key assignment to users
  • User ID
  • Client
  • C_EMPLOYEEBUSINESSUSER.USERID == USR02.BNAME
  • C_EMPLOYEEBUSINESSUSER.MANDT == USR02.MANDT