BUT000_PRC

Master Data Consolidation: Process Table for BUT000 | #transactional | Component: Business Partner.
Column Name Description
CLIENT Client
PROCESS_ID Master Data Change Process Identifier
PROCESS_STEP_NO Master Data Change Process Step Number
SOURCE_SYSTEM Source System
SOURCE_ID Master Data Consolidation: ID of a Source Objects
Column Name Description
Column Name Description
Column Name Description
FOUND_DAT Date organization founded
LIQUID_DAT Liquidation date of organization
BIRTHDT Date of Birth of Business Partner
DEATHDT Date of death of business partner
CRDAT Date on which the object was created
CRTIM Time at which the object was created
CHDAT Date when object was last changed
CHTIM Time at which object was last changed
Column Name Description
TYPE Business Partner Category Show values
XDELE Central Archiving Flag Show values
XBLCK Central Block for Business Partner Show values
CONTACT Business Partner: Contact Permission Show values
NOT_RELEASED Indicator: Not Released Show values
NOT_LG_COMPETENT Indicator: Not Legally Competent Show values
PRINT_MODE Business Partner Print Format Show values
XSEXM Selection: Business partner is male Show values
XSEXF Selection: Business partner is female Show values
XSEXU Selection: Sex of business partner is not known Show values
BIRTHDT_STATUS Date of Birth: Status Show values
IS_ORG_CENTRE Indicator: Business Partner Is Also an Organizational Center Show values
XPCPT Business Purpose Completed Flag Show values
NATPERS Business Partner Is a Natural Person Under the Tax Laws Show values
VALIDATION_STATUS Master Data Consolidation: Validation Status Show values
MILVE ID for mainly military use Show values
NUC_SEC Nuclear Sector (Indicator) Show values
PAR_REL Business Partner Released Show values
Column Name Description Domain name
PARTNER Business Partner Number BU_PARTNER
BPEXT Business Partner Number in External System CHAR20
BU_SORT1 Search Term 1 for Business Partner BU_SORT1
BU_SORT2 Search Term 2 for Business Partner BU_SORT1
AUGRP Authorization Group BU_AUGRP
TITLE_LET Salutation TEXT50
BP_EEW_DUMMY Dummy function in length 1 DUMMY
NAME_ORG1 Name 1 of organization BU_NAME
NAME_ORG2 Name 2 of organization BU_NAME
NAME_ORG3 Name 3 of organization BU_NAME
NAME_ORG4 Name 4 of organization BU_NAME
LOCATION_1 International location number (part 1) NUM07
LOCATION_2 International location number (Part 2) NUM05
LOCATION_3 Check digit for the international location number NUM01
NAME_LAST Last name of business partner (person) BU_NAME
NAME_FIRST First name of business partner (person) BU_NAME
NAME_LST2 Other Last Name of a Person BU_NAME
NAME_LAST2 Name at birth of business partner BU_NAME
NAMEMIDDLE Middle name or second forename of a person BU_NAME
NAME1_TEXT Full Name TEXT80
NICKNAME Nickname of Business Partner (Person) BU_NAME
INITIALS "Middle Initial" or personal initials CHAR10
BIRTHPL Birthplace of business partner TEXT40
EMPLO Name of Employer of a Natural Person BU_EMPLO
CNTAX Obsolete Field LAND1
PERSNUMBER Person Number AD_PERSNUM
PERNO Personnel Number PERSONID
CHILDREN Obsolete Field NUMC2
MEM_HOUSE Obsolete Field DEC2
NAME_GRP1 Name 1 (group) BU_NAME
NAME_GRP2 Name 2 (group) BU_NAME
MC_NAME1 Search Help Field 1 (Name 1/Last Name) CHAR35
MC_NAME2 Search Help Field 2 (Name 2/First Name) CHAR35
CRUSR User who created the object USNAM
CHUSR Last user to change object USNAM
PARTNER_GUID Business Partner GUID SYSUUID
ADDRCOMM Address Number AD_ADDRNUM
TD_SWITCH Planned Change Documents for Partner Were Converted CHAR1
DB_KEY UUID in X form (binary) SYSUUID
VALID_FROM Validity Start BUT000 BP Data TZNTSTMPS
VALID_TO Validity End BUT000 BP Data TZNTSTMPS
SOURCE_RECENCY Master Data Consolidation: Recency TZNTSTMPS
SOURCE_FILTER Master Data Change Process Source Filter
SOURCE_MODIFIED Indicator: Source Record modified MDC_SOURCE_MODIFIED
SOURCE_MODIFICATION_BLIP Modification Indicator refering to a field's position
SOURCE_INDEX Index of record
BP_SORT Sort Field for Phonetic Search; Obsolete CHAR20
KBANKS Country/Region Key of Bank LAND1
KBANKL Bank Keys BANKK
Master Data Relations Join Conditions
Business Partner Type
  • BUT000_PRC.CLIENT == TB004.CLIENT
  • BUT000_PRC.BPKIND == TB004.BPKIND
Business Partner Grouping
  • BUT000_PRC.CLIENT == TB001.MANDT
  • BUT000_PRC.BU_GROUP == TB001.BU_GROUP
Language BUT000_PRC.BU_LANGU == T002.SPRAS
Logical system BUT000_PRC.BU_LOGSYS == TBDLS.LOGSYS
Country/Region of Origin: Non-Resident Companies
  • Country/Region of Origin: Non-Resident Companies
  • Client
  • BUT000_PRC.CNDSC == T005.LAND1
  • BUT000_PRC.CLIENT == T005.MANDT
Sex of business partner (person) BUT000_PRC.GENDER == TB995.GENDER
Occupation/group
  • BUT000_PRC.CLIENT == TB028.CLIENT
  • BUT000_PRC.JOBGR == TB028.JOBGR
Correspondence Language BUT000_PRC.LANGU_CORR == T002.SPRAS
BP: Legal form of organization
  • BP: Legal form of organization
  • ?
  • BUT000_PRC.LEGAL_ENTY == TB019.LEGAL_ENTY
  • BUT000_PRC.[column in domain "MANDT"] == TB019.CLIENT
Legal Entity of Organization
  • BUT000_PRC.CLIENT == TB032.CLIENT
  • BUT000_PRC.LEGAL_ORG == TB032.LEGAL_ORG
Marital Status of Business Partner
  • BUT000_PRC.CLIENT == TB027.CLIENT
  • BUT000_PRC.MARST == TB027.MARST
Country/Region for Name Format Rule
  • Country/Region for Name Format Rule
  • Client
  • BUT000_PRC.NAMCOUNTRY == T005.LAND1
  • BUT000_PRC.CLIENT == T005.MANDT
Nationality
  • Nationality
  • Client
  • BUT000_PRC.NATIO == T005.LAND1
  • BUT000_PRC.CLIENT == T005.MANDT
Group type
  • Group type
  • ?
  • BUT000_PRC.PARTGRPTYP == TB025.PARTGRPTYP
  • BUT000_PRC.[column in domain "MANDT"] == TB025.CLIENT
Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • BUT000_PRC.PREFIX1 == TSAD4.PREFIX_KEY
  • BUT000_PRC.CLIENT == TSAD4.CLIENT
2nd name prefix (key)
  • 2nd name prefix (key)
  • Client
  • BUT000_PRC.PREFIX2 == TSAD4.PREFIX_KEY
  • BUT000_PRC.CLIENT == TSAD4.CLIENT
Cost Rate/Revenue Rate for Project Costing
Data Origin Types
  • ?
  • Data Origin Types
  • BUT000_PRC.[column in domain "MANDT"] == TB005.CLIENT
  • BUT000_PRC.SOURCE == TB005.SOURCE
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • BUT000_PRC.TITLE == TSAD3.TITLE
  • BUT000_PRC.CLIENT == TSAD3.CLIENT
Academic Title: Key
  • BUT000_PRC.CLIENT == TSAD2.CLIENT
  • BUT000_PRC.TITLE_ACA1 == TSAD2.TITLE_KEY
Second academic title (key)
  • BUT000_PRC.CLIENT == TSAD2.CLIENT
  • BUT000_PRC.TITLE_ACA2 == TSAD2.TITLE_KEY
Name supplement, e.g. noble title (key)
  • BUT000_PRC.CLIENT == TSAD5.CLIENT
  • BUT000_PRC.TITLE_ROYL == TSAD5.TITLE_KEY
Obsolete Field
  • BUT000_PRC.CLIENT == USR02.MANDT
  • BUT000_PRC.XUBNAME == USR02.BNAME
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Country/Region for Name Format Rule
  • Name format
  • BUT000_PRC.CLIENT == T005N.MANDT
  • BUT000_PRC.NAMCOUNTRY == T005N.LAND1
  • BUT000_PRC.NAMEFORMAT == T005N.NAMEFORMAT