P_BPUsrPerson

Business Partner of Type Person - BUM | view: PBPUPERSON | Extraction: Not supported | Component: Business User Management - Foundation
Tables used: ADRPBUT000TB003BUT100BPU_ROLECAT_WHL
Column Name Description
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
BirthDate Date of Birth of Business Partner
BusinessPartnerDeathDate Date of death of business partner
Column Name Description
PersonFullNameMaintStatus Status of Field 'Full Name' NAME_TEXT Show values
IsMarkedForArchiving Central Archiving Flag Show values
BusinessPartnerIsBlocked Central Block for Business Partner Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
BusinessPartnerUUID Business Partner GUID SYSUUID
PersonNumber Person Number AD_PERSNUM
LastName Last name of business partner (person) BU_NAME
FirstName First name of business partner (person) BU_NAME
PersonFullName Full Name of Person TEXT80
MiddleName Middle name or second forename of a person BU_NAME
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
Initials "Middle Initial" or personal initials CHAR10
BusinessPartnerBirthplaceName Birthplace of business partner TEXT40
SearchTerm1 Search Term 1 for Business Partner BU_SORT1
SearchTerm2 Search Term 2 for Business Partner BU_SORT1
CreatedByUser User who created the object USNAM
CreationDateTime null
LastChangedByUser Last user to change object USNAM
LastChangeDateTime null
Master Data Relations Join Conditions
Second academic title (key)
  • Second academic title (key)
  • Client
  • P_BPUSRPERSON.ACADEMICSECONDTITLE == TSAD2.TITLE_KEY
  • P_BPUSRPERSON.MANDT == TSAD2.CLIENT
Academic Title: Key
  • Client
  • Academic Title: Key
  • P_BPUSRPERSON.MANDT == TSAD2.CLIENT
  • P_BPUSRPERSON.ACADEMICTITLE == TSAD2.TITLE_KEY
Authorization Group
  • ?
  • Authorization Group
  • Client
  • P_BPUSRPERSON.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • P_BPUSRPERSON.AUTHORIZATIONGROUP == TB037.AUGRP
  • P_BPUSRPERSON.MANDT == TB037.CLIENT
Marital Status of Business Partner
  • Marital Status of Business Partner
  • Client
  • P_BPUSRPERSON.BUSPARTMARITALSTATUS == TB027.MARST
  • P_BPUSRPERSON.MANDT == TB027.CLIENT
Nationality
  • Nationality
  • Client
  • P_BPUSRPERSON.BUSPARTNATIONALITY == T005.LAND1
  • P_BPUSRPERSON.MANDT == T005.MANDT
Correspondence Language P_BPUSRPERSON.CORRESPONDENCELANGUAGE == T002.SPRAS
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • P_BPUSRPERSON.FORMOFADDRESS == TSAD3.TITLE
  • P_BPUSRPERSON.MANDT == TSAD3.CLIENT
Language P_BPUSRPERSON.LANGUAGE == T002.SPRAS
Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • P_BPUSRPERSON.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
  • P_BPUSRPERSON.MANDT == TSAD4.CLIENT
2nd name prefix (key)
  • 2nd name prefix (key)
  • Client
  • P_BPUSRPERSON.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
  • P_BPUSRPERSON.MANDT == TSAD4.CLIENT
Name supplement, e.g. noble title (key)
  • Name supplement, e.g. noble title (key)
  • Client
  • P_BPUSRPERSON.NAMESUPPLEMENT == TSAD5.TITLE_KEY
  • P_BPUSRPERSON.MANDT == TSAD5.CLIENT