P_QltyBPEmployee

Business Partners with Role of Cat. Employee | view: PQLTYBPEMPL | Extraction: Not supported | Component: Quality Notifications
Tables used: BUT000BUT100TB003
Column Name Description
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
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
TrdCmplncLicenseIsMilitarySctr ID for mainly military use Show values
TrdCmplncLicenseIsNuclearSctr Nuclear Sector (Indicator) Show values
BusinessPartnerIsNotReleased Indicator: Not Released Show values
Column Name Description Domain name
BusinessPartnerUUID Business Partner GUID SYSUUID
PersonNumber Person Number AD_PERSNUM
BusinessPartnerName null
BusinessPartnerFullName null
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
PersonFullName Full Name TEXT80
MiddleName Middle name or second forename of a person BU_NAME
AdditionalLastName Other Last Name of a Person BU_NAME
SearchTerm1 Search Term 1 for Business Partner BU_SORT1
SearchTerm2 Search Term 2 for Business Partner BU_SORT1
Master Data Relations Join Conditions
Academic Title: Key
  • Client
  • Academic Title: Key
  • P_QLTYBPEMPLOYEE.MANDT == TSAD2.CLIENT
  • P_QLTYBPEMPLOYEE.ACADEMICTITLE == TSAD2.TITLE_KEY
Authorization Group
  • Client
  • ?
  • Authorization Group
  • P_QLTYBPEMPLOYEE.MANDT == TB037.CLIENT
  • P_QLTYBPEMPLOYEE.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • P_QLTYBPEMPLOYEE.AUTHORIZATIONGROUP == TB037.AUGRP
Business Partner Grouping
  • Client
  • Business Partner Grouping
  • P_QLTYBPEMPLOYEE.MANDT == TB001.MANDT
  • P_QLTYBPEMPLOYEE.BUSINESSPARTNERGROUPING == TB001.BU_GROUP
BP Role
  • BP Role
  • Client
  • P_QLTYBPEMPLOYEE.BUSINESSPARTNERROLE == TB003.ROLE
  • P_QLTYBPEMPLOYEE.MANDT == TB003.CLIENT
Business Partner Type
  • Client
  • Business Partner Type
  • P_QLTYBPEMPLOYEE.MANDT == TB004.CLIENT
  • P_QLTYBPEMPLOYEE.BUSINESSPARTNERTYPE == TB004.BPKIND
Country/Region for Name Format Rule
  • Client
  • Country/Region for Name Format Rule
  • P_QLTYBPEMPLOYEE.MANDT == T005.MANDT
  • P_QLTYBPEMPLOYEE.NAMECOUNTRY == T005.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Client
  • Country/Region for Name Format Rule
  • Name format
  • P_QLTYBPEMPLOYEE.MANDT == T005N.MANDT
  • P_QLTYBPEMPLOYEE.NAMECOUNTRY == T005N.LAND1
  • P_QLTYBPEMPLOYEE.NAMEFORMAT == T005N.NAMEFORMAT