I_BusinessPartnerProcess

Core View: Business Partner (Process) | view: IBPPROCESS | TRAN | Extraction: Not supported | Component: Consolidation & Mass Processing.
Tables used: BUT000_PRC
Column Name Description
MasterDataChangeProcess Master Data Change Process Identifier
MDChgProcessStep Master Data Change Process Step Number
MDChgProcessSrceSystem Source System
MDChgProcessSrceObject Master Data Consolidation: ID of a Source Objects
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
BusinessPartnerBirthDateStatus Date of Birth: Status 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
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
AuthorizationGroup Authorization Group BU_AUGRP
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
BusinessPartnerBirthName Name at birth of business partner 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
Initials "Middle Initial" or personal initials CHAR10
BankCountry Country/Region Key of Bank LAND1
BankKey Bank Keys BANKK
IndependentAddressID Address Number AD_ADDRNUM
BusinessPartnerBirthplaceName Birthplace of business partner TEXT40
NaturalPersonEmployerName Name of Employer of a Natural Person BU_EMPLO
BusinessPartnerIDByExtSystem Business Partner Number in External System CHAR20
MDChgProcessSourceModified Indicator: Source Record modified MDC_SOURCE_MODIFIED
Master Data Relations Join Conditions
Academic Title: Key
  • Client
  • Academic Title: Key
  • I_BUSINESSPARTNERPROCESS.MANDT == TSAD2.CLIENT
  • I_BUSINESSPARTNERPROCESS.ACADEMICTITLE == TSAD2.TITLE_KEY
Second academic title (key)
  • Client
  • Second academic title (key)
  • I_BUSINESSPARTNERPROCESS.MANDT == TSAD2.CLIENT
  • I_BUSINESSPARTNERPROCESS.ACADEMICTITLE2 == TSAD2.TITLE_KEY
Data Origin Types
  • Data Origin Types
  • Client
  • I_BUSINESSPARTNERPROCESS.BUSINESSPARTNERDATAORIGINTYPE == TB005.SOURCE
  • I_BUSINESSPARTNERPROCESS.MANDT == TB005.CLIENT
Business Partner Grouping
  • Business Partner Grouping
  • Client
  • I_BUSINESSPARTNERPROCESS.BUSINESSPARTNERGROUPING == TB001.BU_GROUP
  • I_BUSINESSPARTNERPROCESS.MANDT == TB001.MANDT
Group type
  • Group type
  • Client
  • I_BUSINESSPARTNERPROCESS.BUSINESSPARTNERGROUPTYPE == TB025.PARTGRPTYP
  • I_BUSINESSPARTNERPROCESS.MANDT == TB025.CLIENT
Occupation/group
  • Client
  • Occupation/group
  • I_BUSINESSPARTNERPROCESS.MANDT == TB028.CLIENT
  • I_BUSINESSPARTNERPROCESS.BUSINESSPARTNEROCCUPATION == TB028.JOBGR
Name supplement, e.g. noble title (key)
  • Client
  • Name supplement, e.g. noble title (key)
  • I_BUSINESSPARTNERPROCESS.MANDT == TSAD5.CLIENT
  • I_BUSINESSPARTNERPROCESS.BUSINESSPARTNERSUPPLEMENTNAME == TSAD5.TITLE_KEY
Business Partner Type
  • Business Partner Type
  • Client
  • I_BUSINESSPARTNERPROCESS.BUSINESSPARTNERTYPE == TB004.BPKIND
  • I_BUSINESSPARTNERPROCESS.MANDT == TB004.CLIENT
Marital Status of Business Partner
  • Client
  • Marital Status of Business Partner
  • I_BUSINESSPARTNERPROCESS.MANDT == TB027.CLIENT
  • I_BUSINESSPARTNERPROCESS.BUSPARTMARITALSTATUS == TB027.MARST
Nationality
  • Client
  • Nationality
  • I_BUSINESSPARTNERPROCESS.MANDT == T005.MANDT
  • I_BUSINESSPARTNERPROCESS.BUSPARTNATIONALITY == T005.LAND1
Correspondence Language I_BUSINESSPARTNERPROCESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_BUSINESSPARTNERPROCESS.MANDT == TSAD3.CLIENT
  • I_BUSINESSPARTNERPROCESS.FORMOFADDRESS == TSAD3.TITLE
Language I_BUSINESSPARTNERPROCESS.LANGUAGE == T002.SPRAS
Name Prefix (Key)
  • Client
  • Name Prefix (Key)
  • I_BUSINESSPARTNERPROCESS.MANDT == TSAD4.CLIENT
  • I_BUSINESSPARTNERPROCESS.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
2nd name prefix (key)
  • Client
  • 2nd name prefix (key)
  • I_BUSINESSPARTNERPROCESS.MANDT == TSAD4.CLIENT
  • I_BUSINESSPARTNERPROCESS.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
Legal Entity of Organization
  • Client
  • Legal Entity of Organization
  • I_BUSINESSPARTNERPROCESS.MANDT == TB032.CLIENT
  • I_BUSINESSPARTNERPROCESS.LEGALENTITYOFORGANIZATION == TB032.LEGAL_ORG
BP: Legal form of organization
  • BP: Legal form of organization
  • Client
  • I_BUSINESSPARTNERPROCESS.LEGALFORM == TB019.LEGAL_ENTY
  • I_BUSINESSPARTNERPROCESS.MANDT == TB019.CLIENT
Country/Region for Name Format Rule
  • Client
  • Country/Region for Name Format Rule
  • I_BUSINESSPARTNERPROCESS.MANDT == T005.MANDT
  • I_BUSINESSPARTNERPROCESS.NAMECOUNTRY == T005.LAND1
Country/Region of Origin: Non-Resident Companies
  • Client
  • Country/Region of Origin: Non-Resident Companies
  • I_BUSINESSPARTNERPROCESS.MANDT == T005.MANDT
  • I_BUSINESSPARTNERPROCESS.NONRESIDENTCOMPANYORIGINCNTRY == T005.LAND1
Cost Rate/Revenue Rate for Project Costing
  • Client
  • Cost Rate/Revenue Rate for Project Costing
  • I_BUSINESSPARTNERPROCESS.MANDT == DPR_RATES.CLIENT
  • I_BUSINESSPARTNERPROCESS.REVENUERATE == DPR_RATES.RATE
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Client
  • Name format
  • Country/Region for Name Format Rule
  • I_BUSINESSPARTNERPROCESS.MANDT == T005N.MANDT
  • I_BUSINESSPARTNERPROCESS.NAMEFORMAT == T005N.NAMEFORMAT
  • I_BUSINESSPARTNERPROCESS.NAMECOUNTRY == T005N.LAND1