I_ProcurementBusinessUser

Businessuser in procurement | view: IPROCBUSUSER | Extraction: Not supported | Component: Purchasing
Tables used: BUT000BUT100USR21
Column Name Description
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the object was created
CreationTime Time at which the object was created
LastChangeDate Date when object was last changed
LastChangeTime Time at which object was last changed
OrganizationFoundationDate Date organization founded
OrganizationLiquidationDate Liquidation date of organization
BirthDate Date of Birth of Business Partner
Column Name Description
BusinessPartnerCategory Business Partner Category Show values
BusinessPartnerIsBlocked Central Block for Business Partner Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
IsNaturalPerson Business Partner Is a Natural Person Under the Tax Laws Show values
IsActiveEntity Draft - Indicator - Is active document Show values
IsMarkedForArchiving Central Archiving Flag Show values
ContactPermission Business Partner: Contact Permission Show values
TrdCmplncLicenseIsMilitarySctr ID for mainly military use Show values
TrdCmplncLicenseIsNuclearSctr Nuclear Sector (Indicator) Show values
BusinessPartnerPrintFormat Business Partner Print Format Show values
BusinessPartnerIsNotReleased Indicator: Not Released Show values
Column Name Description Domain name
BusinessPartnerUUID Business Partner GUID SYSUUID
PersonNumber Person Number AD_PERSNUM
ETag null
BusinessPartnerName null
BusinessPartnerFullName null
CreatedByUser User who created the object USNAM
LastChangedByUser Last user to change object USNAM
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
PersonFullName Full Name TEXT80
OrganizationBPName1 Name 1 of organization BU_NAME
OrganizationBPName2 Name 2 of organization BU_NAME
OrganizationBPName3 Name 3 of organization BU_NAME
OrganizationBPName4 Name 4 of organization BU_NAME
InternationalLocationNumber1 International location number (part 1) NUM07
InternationalLocationNumber2 International location number (Part 2) NUM05
InternationalLocationNumber3 Check digit for the international location number NUM01
MiddleName Middle name or second forename of a person BU_NAME
AdditionalLastName Other Last Name of a Person BU_NAME
GroupBusinessPartnerName1 Name 1 (group) BU_NAME
GroupBusinessPartnerName2 Name 2 (group) BU_NAME
SearchTerm1 Search Term 1 for Business Partner BU_SORT1
SearchTerm2 Search Term 2 for Business Partner BU_SORT1
BPLastNameSearchHelp Search Help Field 1 (Name 1/Last Name) CHAR35
BPFirstNameSearchHelp Search Help Field 2 (Name 2/First Name) CHAR35
IndependentAddressID Address Number AD_ADDRNUM
BusinessPartnerIDByExtSystem Business Partner Number in External System CHAR20
UserDescription User Description SUIDTECHDESC
IsTechnicalUser null
Master Data Relations Join Conditions
Academic Title: Key
  • Client
  • Academic Title: Key
  • I_PROCUREMENTBUSINESSUSER.MANDT == TSAD2.CLIENT
  • I_PROCUREMENTBUSINESSUSER.ACADEMICTITLE == TSAD2.TITLE_KEY
Authorization Group
  • ?
  • Authorization Group
  • Client
  • I_PROCUREMENTBUSINESSUSER.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_PROCUREMENTBUSINESSUSER.AUTHORIZATIONGROUP == TB037.AUGRP
  • I_PROCUREMENTBUSINESSUSER.MANDT == TB037.CLIENT
Data Origin Types
  • Client
  • Data Origin Types
  • I_PROCUREMENTBUSINESSUSER.MANDT == TB005.CLIENT
  • I_PROCUREMENTBUSINESSUSER.BUSINESSPARTNERDATAORIGINTYPE == TB005.SOURCE
Business Partner Grouping
  • Client
  • Business Partner Grouping
  • I_PROCUREMENTBUSINESSUSER.MANDT == TB001.MANDT
  • I_PROCUREMENTBUSINESSUSER.BUSINESSPARTNERGROUPING == TB001.BU_GROUP
Business Partner Type
  • Business Partner Type
  • Client
  • I_PROCUREMENTBUSINESSUSER.BUSINESSPARTNERTYPE == TB004.BPKIND
  • I_PROCUREMENTBUSINESSUSER.MANDT == TB004.CLIENT
Correspondence Language I_PROCUREMENTBUSINESSUSER.CORRESPONDENCELANGUAGE == T002.SPRAS
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_PROCUREMENTBUSINESSUSER.MANDT == TSAD3.CLIENT
  • I_PROCUREMENTBUSINESSUSER.FORMOFADDRESS == TSAD3.TITLE
Language I_PROCUREMENTBUSINESSUSER.LANGUAGE == T002.SPRAS
Legal Entity of Organization
  • Client
  • Legal Entity of Organization
  • I_PROCUREMENTBUSINESSUSER.MANDT == TB032.CLIENT
  • I_PROCUREMENTBUSINESSUSER.LEGALENTITYOFORGANIZATION == TB032.LEGAL_ORG
BP: Legal form of organization
  • Client
  • BP: Legal form of organization
  • I_PROCUREMENTBUSINESSUSER.MANDT == TB019.CLIENT
  • I_PROCUREMENTBUSINESSUSER.LEGALFORM == TB019.LEGAL_ENTY
Country/Region for Name Format Rule
  • Country/Region for Name Format Rule
  • Client
  • I_PROCUREMENTBUSINESSUSER.NAMECOUNTRY == T005.LAND1
  • I_PROCUREMENTBUSINESSUSER.MANDT == T005.MANDT
Address key assignment to users
  • User ID
  • Client
  • I_PROCUREMENTBUSINESSUSER.USERID == USR02.BNAME
  • I_PROCUREMENTBUSINESSUSER.MANDT == USR02.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Country/Region for Name Format Rule
  • Name format
  • Client
  • I_PROCUREMENTBUSINESSUSER.NAMECOUNTRY == T005N.LAND1
  • I_PROCUREMENTBUSINESSUSER.NAMEFORMAT == T005N.NAMEFORMAT
  • I_PROCUREMENTBUSINESSUSER.MANDT == T005N.MANDT