C_CollaborationBusinessUserTP

External Resource Business User TP - Consumption View | view: CCOLLABBUSUSRTP | 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
CollaborationUserID 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
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_COLLABORATIONBUSINESSUSERTP.ACADEMICSECONDTITLE == TSAD2.TITLE_KEY
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == TSAD2.CLIENT
Academic Title: Key
  • Client
  • Academic Title: Key
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == TSAD2.CLIENT
  • C_COLLABORATIONBUSINESSUSERTP.ACADEMICTITLE == TSAD2.TITLE_KEY
Authorization Group
  • Authorization Group
  • ?
  • Client
  • C_COLLABORATIONBUSINESSUSERTP.AUTHORIZATIONGROUP == TB037.AUGRP
  • C_COLLABORATIONBUSINESSUSERTP.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == TB037.CLIENT
Business Partner Number
  • Business Partner Number
  • Client
  • C_COLLABORATIONBUSINESSUSERTP.BUSINESSPARTNERCOMPANYBUR028 == BUT000.PARTNER
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == BUT000.CLIENT
BP Role Category
  • BP Role Category
  • Client
  • C_COLLABORATIONBUSINESSUSERTP.BUSINESSPARTNERROLECATEGORY == TB003A.ROLECATEGORY
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == TB003A.CLIENT
Correspondence Language C_COLLABORATIONBUSINESSUSERTP.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_COLLABORATIONBUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • C_COLLABORATIONBUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_COLLABORATIONBUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • C_COLLABORATIONBUSINESSUSERTP.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_COLLABORATIONBUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • C_COLLABORATIONBUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_COLLABORATIONBUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == T005.MANDT
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • C_COLLABORATIONBUSINESSUSERTP.FORMOFADDRESS == TSAD3.TITLE
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == TSAD3.CLIENT
Name Prefix (Key)
  • Client
  • Name Prefix (Key)
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == TSAD4.CLIENT
  • C_COLLABORATIONBUSINESSUSERTP.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
2nd name prefix (key)
  • 2nd name prefix (key)
  • Client
  • C_COLLABORATIONBUSINESSUSERTP.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
  • C_COLLABORATIONBUSINESSUSERTP.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_COLLABORATIONBUSINESSUSERTP.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • C_COLLABORATIONBUSINESSUSERTP.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_COLLABORATIONBUSINESSUSERTP.FAXNUMBERCOUNTRY == T005.LAND1
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == T005.MANDT
Name supplement, e.g. noble title (key)
  • Name supplement, e.g. noble title (key)
  • Client
  • C_COLLABORATIONBUSINESSUSERTP.NAMESUPPLEMENT == TSAD5.TITLE_KEY
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == TSAD5.CLIENT
Address key assignment to users
  • User ID
  • Client
  • C_COLLABORATIONBUSINESSUSERTP.USERID == USR02.BNAME
  • C_COLLABORATIONBUSINESSUSERTP.MANDT == USR02.MANDT