BUT000 - BP: General data I

BP: General data I information is stored in SAP table BUT000.
It is part of development package S_BUPA_GENERAL in software component BC-SRV-BP. This development package consists of objects that can be grouped under "SAP Business Partner: Basic Components".

Fields for table BUT000

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	T000
PARTNER	Business Partner Number	X	BU_PARTNER	CHAR	20
.INCLUDE				BUS000_DAT	0
.INCLUDE	INDEP			BUS000A	0
.INCLUDE				BUS000AINI	0
TYPE	Business Partner Category		BU_TYPE	CHAR	2
BPKIND	Business Partner Type		BU_BPKIND	CHAR	8	TB004
BU_GROUP	Business Partner Grouping		BU_GROUP	CHAR	8	TB001
BPEXT	Business Partner Number in External System		BU_BPEXT	CHAR	40
.INCLUDE				BUS000ADAT	0
BU_SORT1	Search Term 1 for Business Partner		BU_SORT1	CHAR	40
BU_SORT2	Search Term 2 for Business Partner		BU_SORT2	CHAR	40
SOURCE	Data Origin Types		BU_SOURCE	CHAR	8	TB005
TITLE	Form-of-Address Key		AD_TITLE	CHAR	8	TSAD3
XDELE	Central Archiving Flag		BU_XDELE	CHAR	2
XBLCK	Central Block for Business Partner		BU_XBLCK	CHAR	2
AUGRP	Authorization Group		BU_AUGRP	CHAR	8	TB037
TITLE_LET	Salutation		BU_TITLE_LET	CHAR	100
BU_LOGSYS	Logical system		LOGSYS	CHAR	20	TBDLS
CONTACT	Business Partner: Contact Permission		BU_CONTACT	CHAR	2
NOT_RELEASED	Indicator: Not Released		BU_XNOT_RELEASED	CHAR	2
NOT_LG_COMPETENT	Indicator: Not Legally Competent		BU_NOT_LEG_COMPETENT	CHAR	2
PRINT_MODE	Business Partner Print Format		BU_PRINT_MODE	CHAR	2
.INCLUDE	INCL_EEW_BUT000			INCL_EEW_BUT000	0
BP_EEW_DUMMY	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE	CI			CI_EEW_BUT000	0
.INCLU--AP				PRP_BUPA_RATE	0
RATE	Cost Rate/Revenue Rate for Project Costing		DPR_TV_RATE	CHAR	30	DPR_RATES
.INCLUDE	ORG			BUS000O	0
.INCLUDE				BUS000O_CHAR	0
NAME_ORG1	Name 1 of organization		BU_NAMEOR1	CHAR	80
NAME_ORG2	Name 2 of organization		BU_NAMEOR2	CHAR	80
NAME_ORG3	Name 3 of organization		BU_NAMEOR3	CHAR	80
NAME_ORG4	Name 4 of organization		BU_NAMEOR4	CHAR	80
LEGAL_ENTY	BP: Legal form of organization		BU_LEGENTY	CHAR	4	TB019
IND_SECTOR	Industry sector		BU_INDSECT	CHAR	20	TB023
LEGAL_ORG	Legal Entity of Organization		BU_LEGAL_ORG	CHAR	4	TB032
.INCLUDE				BUS000O_NCHR	0
FOUND_DAT	Date organization founded		BU_FOUND_DAT	DATS	16
LIQUID_DAT	Liquidation date of organization		BU_LIQUID_DAT	DATS	16
LOCATION_1	International location number (part 1)		BBBNR	NUMC	14
LOCATION_2	International location number (Part 2)		BBSNR	NUMC	10
LOCATION_3	Check digit for the international location number		BUBKZ	NUMC	2
.INCLUDE	PERS			BUS000N	0
.INCLUDE				BUS000N_CHAR	0
NAME_LAST	Last name of business partner (person)		BU_NAMEP_L	CHAR	80
NAME_FIRST	First name of business partner (person)		BU_NAMEP_F	CHAR	80
NAME_LST2	Other Last Name of a Person		BU_NAMEPL2	CHAR	80
NAME_LAST2	Name at birth of business partner		BU_BIRTHNM	CHAR	80
NAMEMIDDLE	Middle name or second forename of a person		BU_NAMEMID	CHAR	80
TITLE_ACA1	Academic Title: Key		AD_TITLE1	CHAR	8	TSAD2
TITLE_ACA2	Second academic title (key)		AD_TITLE2	CHAR	8	TSAD2
TITLE_ROYL	Name supplement, e.g. noble title (key)		AD_TITLES	CHAR	8	TSAD5
PREFIX1	Name Prefix (Key)		AD_PREFIX	CHAR	8	TSAD4
PREFIX2	2nd name prefix (key)		AD_PREFIX2	CHAR	8	TSAD4
NAME1_TEXT	Full Name		BU_NAME1TX	CHAR	160
NICKNAME	Nickname of Business Partner (Person)		BU_NICKNAM	CHAR	80
INITIALS	"Middle Initial" or personal initials		AD_INITS	CHAR	20
NAMEFORMAT	Name format		AD_FORMAT	CHAR	4	T005N
NAMCOUNTRY	Country/Region for Name Format Rule		AD_NAMCTRY	CHAR	6	T005
LANGU_CORR	Business Partner: Correspondence Language		BU_LANGU_CORR	LANG	2	T002
XSEXM	Selection: Business partner is male		BU_XSEXM	CHAR	2
XSEXF	Selection: Business partner is female		BU_XSEXF	CHAR	2
BIRTHPL	Birthplace of business partner		BU_BIRTHPL	CHAR	80
MARST	Marital Status of Business Partner		BU_MARST	CHAR	2	TB027
EMPLO	Name of Employer of a Natural Person		BU_EMPLO	CHAR	70
JOBGR	Occupation/group		BU_JOBGR	CHAR	8	TB028
NATIO	Nationality		BU_NATIO	CHAR	6	T005
CNTAX	Obsolete Field		BU_CNTAX	CHAR	6	*
CNDSC	Country/Region of Origin: Non-Resident Companies		BU_CNDSC	CHAR	6	T005
PERSNUMBER	Person Number		AD_PERSNUM	CHAR	20
XSEXU	Selection: Sex of business partner is not known		BU_XSEXU	CHAR	2
XUBNAME	Obsolete Field		BU_XUBNAME	CHAR	24	USR02
BU_LANGU	Business partner: Language		BU_LANGU	LANG	2	T002
GENDER	Sex of business partner (person)		BU_SEXID	CHAR	2	TB995
.INCLUDE				BUS000N_NCHR	0
BIRTHDT	Date of Birth of Business Partner		BU_BIRTHDT	DATS	16
DEATHDT	Date of death of business partner		BU_DEATHDT	DATS	16
PERNO	Personnel Number		BU_PERNO	NUMC	16
CHILDREN	Obsolete Field		BU_CHILDREN	NUMC	4
MEM_HOUSE	Obsolete Field		BU_MEM_HOUSE	DEC	2
BIRTHDT_STATUS	Date of Birth: Status		BU_BIRTHDT_STATUS	CHAR	2
.INCLUDE	GROUP			BUS000G	0
PARTGRPTYP	Group type		BU_GRPTYP	CHAR	8	TB025
NAME_GRP1	Name 1 (group)		BU_NAMEGR1	CHAR	80
NAME_GRP2	Name 2 (group)		BU_NAMEGR2	CHAR	80
.INCLUDE				BUS000_INT	0
.INCLUDE				BUS000AINT	0
MC_NAME1	Search Help Field 1 (Name 1/Last Name)		BU_MCNAME1	CHAR	70
MC_NAME2	Search Help Field 2 (Name 2/First Name)		BU_MCNAME2	CHAR	70
CRUSR	User who created the object		BU_CRUSR	CHAR	24
CRDAT	Date on which the object was created		BU_CRDAT	DATS	16
CRTIM	Time at which the object was created		BU_CRTIM	TIMS	12
CHUSR	Last user to change object		BU_CHUSR	CHAR	24
CHDAT	Date when object was last changed		BU_CHDAT	DATS	16
CHTIM	Time at which object was last changed		BU_CHTIM	TIMS	12
PARTNER_GUID	Business Partner GUID		BU_PARTNER_GUID	RAW	16
ADDRCOMM	Address Number		BU_ADDRCOMM	CHAR	20	*
TD_SWITCH	Planned Change Documents for Partner Were Converted		BU_TD_SWITCH	CHAR	2
IS_ORG_CENTRE	Indicator: Business Partner Is Also an Organizational Center		BU_IS_ORG_CENTRE	CHAR	2
DB_KEY	UUID in X form (binary)		SYSUUID_X	RAW	16
VALID_FROM	Validity Start BUT000 BP Data		BU_BP_VALID_FROM	DEC	8
VALID_TO	Validity End BUT000 BP Data		BU_BP_VALID_TO	DEC	8
XPCPT	Business Purpose Completed Flag		BU_XPCPT	CHAR	2
.INCLU--AP				APP_BUT000_TAX	0
NATPERS	Business Partner Is a Natural Person Under the Tax Laws		BU_NATURAL_PERSON	CHAR	2
.INCLU--AP				BUT000_MILITARY	0
MILVE	ID for mainly military use		MILVE	CHAR	2
NUC_SEC	Nuclear Sector (Indicator)		NUC_SEC	CHAR	2
.INCLU--AP				BUT000_TR	0
PAR_REL	Business Partner Released		BP_PAR_REL	CHAR	2
BP_SORT	Sort Field for Phonetic Search; Obsolete		BP_SORT_PH	CHAR	40
.INCLU--AP				IBKK20	0
KBANKS	Country/Region Key of Bank		BANKS	CHAR	6	*
KBANKL	Bank Keys		BANKK	CHAR	30