C_EmployeeBusinessUserTP

Employee Business User TP - Consumption View | view: CEMPLBUSUSERTP | Extraction: Not supported | Component: Business User Management
Column Name Description
BusinessPartnerUUID Business Partner GUID
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerRole BP Role BU_ROLE
PersonNumber Person Number AD_PERSNUM
EmployeeExternalID Identification Number
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
ValidityStartDate Validity Start of a BP Role TZNTSTMPS
ValidityEndDate Validity End of a BP Role TZNTSTMPS
IsMarkedForArchiving Central Archiving Flag
UserName Internet user alias
UserDescription User Description
EmailAddress E-Mail Address AD_SMTPADR
PhoneNumber Telephone no.: dialling code+number
PhoneNumberExtension Telephone no.: Extension
MobilePhoneNumber Telephone no.: dialling code+number
FaxAreaCodeSubscriberNumber Fax number: dialling code+number
FaxExtensionNumber Fax no.: Extension
Building Building (number or code) TEXT10
RoomNumber Room or Apartment Number TEXT10
Department Department TEXT40
FunctionalTitleName Function TEXT40
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
MiddleName Middle name or second forename of a person BU_NAME
Initials "Middle Initial" or personal initials CHAR10
PersonFullName Full Name of Person TEXT80
CreationDateTime null
CreatedByUser User who created the object USNAM
LastChangeDateTime null
LastChangedByUser Last user to change object USNAM
BPAddressChangeDocObject null
Master Data Relations Join Conditions
Second academic title (key)
  • Second academic title (key)
  • Client
  • C_EMPLOYEEBUSINESSUSERTP.ACADEMICSECONDTITLE == TSAD2.TITLE_KEY
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == TSAD2.CLIENT
Academic Title: Key
  • Academic Title: Key
  • Client
  • C_EMPLOYEEBUSINESSUSERTP.ACADEMICTITLE == TSAD2.TITLE_KEY
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == TSAD2.CLIENT
Authorization Group
  • ?
  • Authorization Group
  • Client
  • C_EMPLOYEEBUSINESSUSERTP.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_EMPLOYEEBUSINESSUSERTP.AUTHORIZATIONGROUP == TB037.AUGRP
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == TB037.CLIENT
BP Role Category
  • BP Role Category
  • Client
  • C_EMPLOYEEBUSINESSUSERTP.BUSINESSPARTNERROLECATEGORY == TB003A.ROLECATEGORY
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == TB003A.CLIENT
Correspondence Language C_EMPLOYEEBUSINESSUSERTP.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • C_EMPLOYEEBUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == T005.MANDT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • C_EMPLOYEEBUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == T005.MANDT
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • C_EMPLOYEEBUSINESSUSERTP.FORMOFADDRESS == TSAD3.TITLE
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == TSAD3.CLIENT
Name Prefix (Key)
  • Client
  • Name Prefix (Key)
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == TSAD4.CLIENT
  • C_EMPLOYEEBUSINESSUSERTP.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
2nd name prefix (key)
  • 2nd name prefix (key)
  • Client
  • C_EMPLOYEEBUSINESSUSERTP.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == TSAD4.CLIENT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • C_EMPLOYEEBUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == T005.MANDT
Name supplement, e.g. noble title (key)
  • Client
  • Name supplement, e.g. noble title (key)
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == TSAD5.CLIENT
  • C_EMPLOYEEBUSINESSUSERTP.NAMESUPPLEMENT == TSAD5.TITLE_KEY
Address key assignment to users
  • User ID
  • Client
  • C_EMPLOYEEBUSINESSUSERTP.USERID == USR02.BNAME
  • C_EMPLOYEEBUSINESSUSERTP.MANDT == USR02.MANDT