I_BusinessUserTP

Business User - Transactional Processing | view: IBUSINESSUSERTP | 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
IsMarkedForArchiving Central Archiving Flag Show values
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
PersonExternalID Identification Number CHAR60
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
UserName Internet user alias USALIAS
UserDescription User Description SUIDTECHDESC
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
FaxAreaCodeSubscriberNumber Fax number: dialling code+number CHAR30
FaxExtensionNumber Fax no.: Extension CHAR10
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
Master Data Relations Join Conditions
Second academic title (key)
  • Client
  • Second academic title (key)
  • I_BUSINESSUSERTP.MANDT == TSAD2.CLIENT
  • I_BUSINESSUSERTP.ACADEMICSECONDTITLE == TSAD2.TITLE_KEY
Academic Title: Key
  • Academic Title: Key
  • Client
  • I_BUSINESSUSERTP.ACADEMICTITLE == TSAD2.TITLE_KEY
  • I_BUSINESSUSERTP.MANDT == TSAD2.CLIENT
Authorization Group
  • ?
  • Authorization Group
  • Client
  • I_BUSINESSUSERTP.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_BUSINESSUSERTP.AUTHORIZATIONGROUP == TB037.AUGRP
  • I_BUSINESSUSERTP.MANDT == TB037.CLIENT
Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Client
  • I_BUSINESSUSERTP.BUSINESSPARTNERCOMPANYBUR028 == BUT000.PARTNER
  • I_BUSINESSUSERTP.BUSINESSPARTNERCOMPANYBUR025 == BUT000.PARTNER
  • I_BUSINESSUSERTP.MANDT == BUT000.CLIENT
Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Client
  • I_BUSINESSUSERTP.BUSINESSPARTNERCOMPANYBUR028 == BUT000.PARTNER
  • I_BUSINESSUSERTP.BUSINESSPARTNERCOMPANYBUR025 == BUT000.PARTNER
  • I_BUSINESSUSERTP.MANDT == BUT000.CLIENT
BP Role Category
  • BP Role Category
  • Client
  • I_BUSINESSUSERTP.BUSINESSPARTNERROLECATEGORY == TB003A.ROLECATEGORY
  • I_BUSINESSUSERTP.MANDT == TB003A.CLIENT
Correspondence Language I_BUSINESSUSERTP.CORRESPONDENCELANGUAGE == T002.SPRAS
Cost Rate/Revenue Rate for Project Costing
  • Cost Rate/Revenue Rate for Project Costing
  • Client
  • I_BUSINESSUSERTP.COSTREVENUERATECODE == DPR_RATES.RATE
  • I_BUSINESSUSERTP.MANDT == DPR_RATES.CLIENT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • I_BUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_BUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • I_BUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • I_BUSINESSUSERTP.MANDT == T005.MANDT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • I_BUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_BUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • I_BUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • I_BUSINESSUSERTP.MANDT == T005.MANDT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_BUSINESSUSERTP.MANDT == TSAD3.CLIENT
  • I_BUSINESSUSERTP.FORMOFADDRESS == TSAD3.TITLE
Name Prefix (Key)
  • Client
  • Name Prefix (Key)
  • I_BUSINESSUSERTP.MANDT == TSAD4.CLIENT
  • I_BUSINESSUSERTP.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
2nd name prefix (key)
  • 2nd name prefix (key)
  • Client
  • I_BUSINESSUSERTP.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
  • I_BUSINESSUSERTP.MANDT == TSAD4.CLIENT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • I_BUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_BUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • I_BUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • I_BUSINESSUSERTP.MANDT == T005.MANDT
Name supplement, e.g. noble title (key)
  • Name supplement, e.g. noble title (key)
  • Client
  • I_BUSINESSUSERTP.NAMESUPPLEMENT == TSAD5.TITLE_KEY
  • I_BUSINESSUSERTP.MANDT == TSAD5.CLIENT
Address key assignment to users
  • User ID
  • Client
  • I_BUSINESSUSERTP.USERID == USR02.BNAME
  • I_BUSINESSUSERTP.MANDT == USR02.MANDT