I_BusinessPartner

Business Partner | view: IBUSINESSPARTNER | ATTR | Extraction: Full or Incremental | Component: SAP Business Partner
Tables used: BUT000
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
BusinessPartnerDeathDate Date of death 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
IsFemale Selection: Business partner is female Show values
IsMale Selection: Business partner is male Show values
IsSexUnknown Selection: Sex of business partner is not known Show values
IsActiveEntity Draft - Indicator - Is active document Show values
IsMarkedForArchiving Central Archiving Flag Show values
ContactPermission Business Partner: Contact Permission Show values
BusinessPartnerPrintFormat Business Partner Print Format Show values
BusinessPartnerIsNotReleased Indicator: Not Released Show values
IsNotContractuallyCapable Indicator: Not Legally Competent Show values
BusinessPartnerBirthDateStatus Date of Birth: Status Show values
TrdCmplncLicenseIsMilitarySctr ID for mainly military use Show values
TrdCmplncLicenseIsNuclearSctr Nuclear Sector (Indicator) 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
BusinessPartnerNicknameLabel Nickname of Business Partner (Person) BU_NAME
IndependentAddressID Address Number AD_ADDRNUM
BusinessPartnerIDByExtSystem Business Partner Number in External System CHAR20
BusinessPartnerSalutation Salutation TEXT50
BusinessPartnerBirthName Name at birth of business partner BU_NAME
BusinessPartnerBirthplaceName Birthplace of business partner TEXT40
NaturalPersonEmployerName Name of Employer of a Natural Person BU_EMPLO
Initials "Middle Initial" or personal initials CHAR10
Master Data Relations Join Conditions
Academic Title: Key
  • Client
  • Academic Title: Key
  • I_BUSINESSPARTNER.MANDT == TSAD2.CLIENT
  • I_BUSINESSPARTNER.ACADEMICTITLE == TSAD2.TITLE_KEY
Second academic title (key)
  • Client
  • Second academic title (key)
  • I_BUSINESSPARTNER.MANDT == TSAD2.CLIENT
  • I_BUSINESSPARTNER.ACADEMICTITLE2 == TSAD2.TITLE_KEY
Authorization Group
  • Authorization Group
  • Client
  • ?
  • I_BUSINESSPARTNER.AUTHORIZATIONGROUP == TB037.AUGRP
  • I_BUSINESSPARTNER.MANDT == TB037.CLIENT
  • I_BUSINESSPARTNER.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Data Origin Types
  • Client
  • Data Origin Types
  • I_BUSINESSPARTNER.MANDT == TB005.CLIENT
  • I_BUSINESSPARTNER.BUSINESSPARTNERDATAORIGINTYPE == TB005.SOURCE
Business Partner Grouping
  • Business Partner Grouping
  • Client
  • I_BUSINESSPARTNER.BUSINESSPARTNERGROUPING == TB001.BU_GROUP
  • I_BUSINESSPARTNER.MANDT == TB001.MANDT
Group type
  • Client
  • Group type
  • I_BUSINESSPARTNER.MANDT == TB025.CLIENT
  • I_BUSINESSPARTNER.BUSINESSPARTNERGROUPTYPE == TB025.PARTGRPTYP
Occupation/group
  • Client
  • Occupation/group
  • I_BUSINESSPARTNER.MANDT == TB028.CLIENT
  • I_BUSINESSPARTNER.BUSINESSPARTNEROCCUPATION == TB028.JOBGR
Name supplement, e.g. noble title (key)
  • Client
  • Name supplement, e.g. noble title (key)
  • I_BUSINESSPARTNER.MANDT == TSAD5.CLIENT
  • I_BUSINESSPARTNER.BUSINESSPARTNERSUPPLEMENTNAME == TSAD5.TITLE_KEY
Business Partner Type
  • Client
  • Business Partner Type
  • I_BUSINESSPARTNER.MANDT == TB004.CLIENT
  • I_BUSINESSPARTNER.BUSINESSPARTNERTYPE == TB004.BPKIND
Marital Status of Business Partner
  • Client
  • Marital Status of Business Partner
  • I_BUSINESSPARTNER.MANDT == TB027.CLIENT
  • I_BUSINESSPARTNER.BUSPARTMARITALSTATUS == TB027.MARST
Nationality
  • Client
  • Nationality
  • I_BUSINESSPARTNER.MANDT == T005.MANDT
  • I_BUSINESSPARTNER.BUSPARTNATIONALITY == T005.LAND1
Correspondence Language I_BUSINESSPARTNER.CORRESPONDENCELANGUAGE == T002.SPRAS
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_BUSINESSPARTNER.MANDT == TSAD3.CLIENT
  • I_BUSINESSPARTNER.FORMOFADDRESS == TSAD3.TITLE
Sex of business partner (person) I_BUSINESSPARTNER.GENDERCODENAME == TB995.GENDER
Language I_BUSINESSPARTNER.LANGUAGE == T002.SPRAS
Name Prefix (Key)
  • Client
  • Name Prefix (Key)
  • I_BUSINESSPARTNER.MANDT == TSAD4.CLIENT
  • I_BUSINESSPARTNER.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
2nd name prefix (key)
  • Client
  • 2nd name prefix (key)
  • I_BUSINESSPARTNER.MANDT == TSAD4.CLIENT
  • I_BUSINESSPARTNER.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
Legal Entity of Organization
  • Client
  • Legal Entity of Organization
  • I_BUSINESSPARTNER.MANDT == TB032.CLIENT
  • I_BUSINESSPARTNER.LEGALENTITYOFORGANIZATION == TB032.LEGAL_ORG
BP: Legal form of organization
  • Client
  • BP: Legal form of organization
  • I_BUSINESSPARTNER.MANDT == TB019.CLIENT
  • I_BUSINESSPARTNER.LEGALFORM == TB019.LEGAL_ENTY
Country/Region for Name Format Rule
  • Client
  • Country/Region for Name Format Rule
  • I_BUSINESSPARTNER.MANDT == T005.MANDT
  • I_BUSINESSPARTNER.NAMECOUNTRY == T005.LAND1
Country/Region of Origin: Non-Resident Companies
  • Client
  • Country/Region of Origin: Non-Resident Companies
  • I_BUSINESSPARTNER.MANDT == T005.MANDT
  • I_BUSINESSPARTNER.NONRESIDENTCOMPANYORIGINCNTRY == T005.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Client
  • Country/Region for Name Format Rule
  • Name format
  • I_BUSINESSPARTNER.MANDT == T005N.MANDT
  • I_BUSINESSPARTNER.NAMECOUNTRY == T005N.LAND1
  • I_BUSINESSPARTNER.NAMEFORMAT == T005N.NAMEFORMAT