C_ExtResourceBusinessUserTP

External Resource Business User TP - Consumption View | view: CEXTRESBUSUSERTP | 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
ExternalResourceID 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)
  • Client
  • Second academic title (key)
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == TSAD2.CLIENT
  • C_EXTRESOURCEBUSINESSUSERTP.ACADEMICSECONDTITLE == TSAD2.TITLE_KEY
Academic Title: Key
  • Client
  • Academic Title: Key
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == TSAD2.CLIENT
  • C_EXTRESOURCEBUSINESSUSERTP.ACADEMICTITLE == TSAD2.TITLE_KEY
Authorization Group
  • ?
  • Authorization Group
  • Client
  • C_EXTRESOURCEBUSINESSUSERTP.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_EXTRESOURCEBUSINESSUSERTP.AUTHORIZATIONGROUP == TB037.AUGRP
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == TB037.CLIENT
Business Partner Number
  • Client
  • Business Partner Number
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == BUT000.CLIENT
  • C_EXTRESOURCEBUSINESSUSERTP.BUSINESSPARTNERCOMPANYBUR025 == BUT000.PARTNER
BP Role Category
  • Client
  • BP Role Category
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == TB003A.CLIENT
  • C_EXTRESOURCEBUSINESSUSERTP.BUSINESSPARTNERROLECATEGORY == TB003A.ROLECATEGORY
Correspondence Language C_EXTRESOURCEBUSINESSUSERTP.CORRESPONDENCELANGUAGE == T002.SPRAS
Cost Rate/Revenue Rate for Project Costing
  • Client
  • Cost Rate/Revenue Rate for Project Costing
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == DPR_RATES.CLIENT
  • C_EXTRESOURCEBUSINESSUSERTP.COSTREVENUERATECODE == DPR_RATES.RATE
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == T005.MANDT
  • C_EXTRESOURCEBUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • C_EXTRESOURCEBUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_EXTRESOURCEBUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == T005.MANDT
  • C_EXTRESOURCEBUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • C_EXTRESOURCEBUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_EXTRESOURCEBUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == TSAD3.CLIENT
  • C_EXTRESOURCEBUSINESSUSERTP.FORMOFADDRESS == TSAD3.TITLE
Name Prefix (Key)
  • Client
  • Name Prefix (Key)
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == TSAD4.CLIENT
  • C_EXTRESOURCEBUSINESSUSERTP.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
2nd name prefix (key)
  • Client
  • 2nd name prefix (key)
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == TSAD4.CLIENT
  • C_EXTRESOURCEBUSINESSUSERTP.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == T005.MANDT
  • C_EXTRESOURCEBUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • C_EXTRESOURCEBUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_EXTRESOURCEBUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Name supplement, e.g. noble title (key)
  • Client
  • Name supplement, e.g. noble title (key)
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == TSAD5.CLIENT
  • C_EXTRESOURCEBUSINESSUSERTP.NAMESUPPLEMENT == TSAD5.TITLE_KEY
Address key assignment to users
  • Client
  • User ID
  • C_EXTRESOURCEBUSINESSUSERTP.MANDT == USR02.MANDT
  • C_EXTRESOURCEBUSINESSUSERTP.USERID == USR02.BNAME