C_BusinessPartner

Business Partner | view: CBUSINESSPARTNER | Extraction: Not supported | Component: Business Partners
Tables used: BP001BUT000TB003BUT100USR21
Column Name Description
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
OrganizationFoundationDate Date organization founded
OrganizationLiquidationDate Liquidation date of organization
BirthDate Date of Birth of Business Partner
CreationTime Time at which the object was created
LastChangeDate Date when object was last changed
LastChangeTime Time at which object was last changed
CreationDate Date on which the object was created
Column Name Description
BusinessPartnerCategory Business Partner Category Show values
BusinessPartnerBirthDateStatus Date of Birth: Status Show values
BusinessPartnerIsBlocked Central Block for Business Partner Show values
IsNaturalPerson Business Partner Is a Natural Person Under the Tax Laws Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
BPCustMultiAddrIsActive Truth Value: True/False Show values
BPTaxNmbrMultiAddrIsActive Truth Value: True/False Show values
BPIntlLocNmbrMultiAddrIsActive Truth Value: True/False Show values
IsMultipleAccountAssignment Truth Value: True/False Show values
BPIsMltplAddrDepdntDataPresent Truth Value: True/False Show values
IsMarkedForArchiving Central Archiving Flag Show values
BPHasEmployeeRoles Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
FullName null
BusinessPartnerForEdit Business Partner Number BU_PARTNER
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
Name Name 1 of organization BU_NAME
AdditionalName Name 2 of organization BU_NAME
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
BusinessPartnerBirthplaceName Birthplace of business partner TEXT40
Role null
CityName null
StreetName null
CountryName null
PostalCode null
IndustrySector null
HouseNumber null
Region null
BPIdentificationNumber Identification Number CHAR60
BPIdentificationType Identification Type BU_ID_TYPE
BPLastNameSearchHelp Search Help Field 1 (Name 1/Last Name) CHAR35
BPFirstNameSearchHelp Search Help Field 2 (Name 2/First Name) CHAR35
DataControllerName null
BusinessPartnerUUID Business Partner GUID SYSUUID
CreatedByUser User who created the object USNAM
LastChangedByUser Last user to change object USNAM
LastChangedByUserName User Description SUIDTECHDESC
CreatedByUserName User Description SUIDTECHDESC
SearchTerm1 Search Term 1 for Business Partner BU_SORT1
SearchTerm2 Search Term 2 for Business Partner BU_SORT1
BusinessPartnerName null
BusinessPartnerIDByExtSystem Business Partner Number in External System CHAR20
InternationalLocationNumber1 International location number (part 1) NUM07
InternationalLocationNumber2 International location number (Part 2) NUM05
InternationalLocationNumber3 Check digit for the international location number NUM01
IndependentAddressID Address Number AD_ADDRNUM
BusinessPartnerImageURL null
Master Data Relations Join Conditions
Academic Title: Key
  • Client
  • Academic Title: Key
  • C_BUSINESSPARTNER.MANDT == TSAD2.CLIENT
  • C_BUSINESSPARTNER.ACADEMICTITLE == TSAD2.TITLE_KEY
Authorization Group
  • ?
  • Client
  • Authorization Group
  • C_BUSINESSPARTNER.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_BUSINESSPARTNER.MANDT == TB037.CLIENT
  • C_BUSINESSPARTNER.AUTHORIZATIONGROUP == TB037.AUGRP
Business Partner Grouping
  • Client
  • Business Partner Grouping
  • C_BUSINESSPARTNER.MANDT == TB001.MANDT
  • C_BUSINESSPARTNER.BUSINESSPARTNERGROUPING == TB001.BU_GROUP
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • Form-of-Address Key
  • C_BUSINESSPARTNER.MANDT == TSAD3.CLIENT
  • C_BUSINESSPARTNER.FORMOFADDRESSPERSON == TSAD3.TITLE
  • C_BUSINESSPARTNER.FORMOFADDRESSORGANIZATION == TSAD3.TITLE
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • Form-of-Address Key
  • C_BUSINESSPARTNER.MANDT == TSAD3.CLIENT
  • C_BUSINESSPARTNER.FORMOFADDRESSPERSON == TSAD3.TITLE
  • C_BUSINESSPARTNER.FORMOFADDRESSORGANIZATION == TSAD3.TITLE
Sex of business partner (person) C_BUSINESSPARTNER.GENDERCODENAME == TB995.GENDER
BP: Legal form of organization
  • BP: Legal form of organization
  • Client
  • C_BUSINESSPARTNER.LEGALFORM == TB019.LEGAL_ENTY
  • C_BUSINESSPARTNER.MANDT == TB019.CLIENT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_BUSINESSPARTNER.MANDT == T880.MANDT
  • C_BUSINESSPARTNER.TRADINGPARTNER == T880.RCOMP