SAP FSBP_GENERAL_DATA General Data Table data and field list

FSBP_GENERAL_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "General Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FSBP_GENERAL_DATA TYPE FSBP_GENERAL_DATA.

The FSBP_GENERAL_DATA table consists of various fields, each holding specific information or linking keys about General Data data available in SAP. These include CLIENT (Client), PARTNER (Business Partner Number), TYPE (Business partner category), BPKIND (Business Partner Type)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FSBP_GENERAL_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP FSBP_GENERAL_DATA structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FSBP_GENERAL_DATA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
GENERAL_DATA				0
CLIENT	Client	MANDT	CLNT	3			MANDT
PARTNER	Business Partner Number	BU_PARTNER	CHAR	10		ALPHA	BU_PARTNER	BPA	BUPA
TYPE	Business partner category	BU_TYPE	CHAR	1			BU_TYPE	BPY
BPKIND	Business Partner Type	BU_BPKIND	CHAR	4			BU_KIND
BU_GROUP	Business Partner Grouping	BU_GROUP	CHAR	4			BU_GROUP	BPP
BPEXT	Business Partner Number in External System	BU_BPEXT	CHAR	20			CHAR20
BU_SORT1	Search term 1 for business partner	BU_SORT1	CHAR	20			BU_SORT1
BU_SORT2	Search term 2 for business partner	BU_SORT2	CHAR	20			BU_SORT1
SOURCE	Data Origin Types	BU_SOURCE	CHAR	4			BU_SOURCE
TITLE	Form-of-Address Key	AD_TITLE	CHAR	4			AD_TITLE
XDELE	Central Archiving Flag	BU_XDELE	CHAR	1			XFELD
XBLCK	Central Block for Business Partner	BU_XBLCK	CHAR	1			XFELD
AUGRP	Authorization Group	BU_AUGRP	CHAR	4			BU_AUGRP
TITLE_LET	Salutation	BU_TITLE_LET	CHAR	50			TEXT50
BU_LOGSYS	Logical system	LOGSYS	CHAR	10		ALPHA	LOGSYS
CONTACT	Business Partner: Contact Permission	BU_CONTACT	CHAR	1			BU_CONTACT
NOT_RELEASED	Indicator: Not Released	BU_XNOT_RELEASED	CHAR	1			XFELD
NOT_LG_COMPETENT	Indicator: Not Legally Competent	BU_NOT_LEG_COMPETENT	CHAR	1			BOOLE
PRINT_MODE	Business Partner Print Format	BU_PRINT_MODE	CHAR	1			BU_PRINT_MODE
BP_EEW_DUMMY	Dummy function in length 1	DUMMY	CHAR	1			DUMMY
.INCLU--AP				0
NAPR	Business Partner Is a Natural Person Under the Tax Laws	BU_NATURAL_PERSON	CHAR	1			BU_NATURAL_PERSON
BBP_IPISP	Tax Split	BBP_J_1BINDEQU	CHAR	1			XFELD
.INCLU--AP				0
RATE	Cost Rate/Revenue Rate for Project Costing	DPR_TV_RATE	CHAR	15			DPR_RATE_TYPE
NAME_ORG1	Name 1 of organization	BU_NAMEOR1	CHAR	40			BU_NAME
NAME_ORG2	Name 2 of organization	BU_NAMEOR2	CHAR	40			BU_NAME
NAME_ORG3	Name 3 of organization	BU_NAMEOR3	CHAR	40			BU_NAME
NAME_ORG4	Name 4 of organization	BU_NAMEOR4	CHAR	40			BU_NAME
LEGAL_ENTY	BP: Legal form of organization	BU_LEGENTY	CHAR	2			BU_LEGENTY		H_TB019
IND_SECTOR	Industry sector	BU_INDSECT	CHAR	10			BU_INDSECT		H_TB023
LEGAL_ORG	Legal Entity of Organization	BU_LEGAL_ORG	CHAR	2			BU_LEGAL_ORG
FOUND_DAT	Date organization founded	BU_FOUND_DAT	DATS	8			DATUM
LIQUID_DAT	Liquidation date of organization	BU_LIQUID_DAT	DATS	8
LOCATION_1	International location number (part 1)	BBBNR	NUMC	7			NUM07
LOCATION_2	International location number (Part 2)	BBSNR	NUMC	5			NUM05
LOCATION_3	Check digit for the international location number	BUBKZ	NUMC	1			NUM01
NAME_LAST	Last name of business partner (person)	BU_NAMEP_L	CHAR	40			BU_NAME
NAME_FIRST	First name of business partner (person)	BU_NAMEP_F	CHAR	40			BU_NAME
NAME_LST2	Other Last Name of a Person	BU_NAMEPL2	CHAR	40			BU_NAME
NAME_LAST2	Name at birth of business partner	BU_BIRTHNM	CHAR	40			BU_NAME
NAMEMIDDLE	Middle name or second forename of a person	BU_NAMEMID	CHAR	40			BU_NAME
TITLE_ACA1	Academic Title: Key	AD_TITLE1	CHAR	4			AD_TITLE1		AD_TITLE1
TITLE_ACA2	Second academic title (key)	AD_TITLE2	CHAR	4			AD_TITLE1
TITLE_ROYL	Name supplement, e.g. noble title (key)	AD_TITLES	CHAR	4			AD_TITLES
PREFIX1	Name Prefix (Key)	AD_PREFIX	CHAR	4			AD_PREFIX
PREFIX2	2nd name prefix (key)	AD_PREFIX2	CHAR	4			AD_PREFIX
NAME1_TEXT	Full Name	BU_NAME1TX	CHAR	80			TEXT80
NICKNAME	Nickname of Business Partner (Person)	BU_NICKNAM	CHAR	40			BU_NAME
INITIALS	'Middle Initial' or personal initials	AD_INITS	CHAR	10			CHAR10
NAMEFORMAT	Name format	AD_FORMAT	CHAR	2			AD_NAMFORM
NAMCOUNTRY	Country for name format rule	AD_NAMCTRY	CHAR	3			LAND1
LANGU_CORR	Business Partner: Correspondence Language	BU_LANGU_CORR	LANG	1		ISOLA	SPRAS
XSEXM	Selection: Business partner is male	BU_XSEXM	CHAR	1			XFELD
XSEXF	Selection: Business partner is female	BU_XSEXF	CHAR	1			XFELD
BIRTHPL	Birthplace of business partner	BU_BIRTHPL	CHAR	40			TEXT40
MARST	Marital Status of Business Partner	BU_MARST	CHAR	1			BU_MARST
EMPLO	Name of Employer of a Natural Person	BU_EMPLO	CHAR	35			BU_EMPLO
JOBGR	Occupation/group	BU_JOBGR	CHAR	4			BU_JOBGR
NATIO	Nationality	BU_NATIO	CHAR	3			LAND1
CNTAX	Obsolete Field	BU_CNTAX	CHAR	3			LAND1
CNDSC	Ctry of Origin: Non-Res. Companies	BU_CNDSC	CHAR	3			LAND1
PERSNUMBER	Person number	AD_PERSNUM	CHAR	10		ALPHA	AD_PERSNUM	CDT	ADDRESS
XSEXU	Selection: Sex of business partner is not known	BU_XSEXU	CHAR	1			XFELD
XUBNAME	Obsolete Field	BU_XUBNAME	CHAR	12			XUBNAME
BU_LANGU	Business partner: Language	BU_LANGU	LANG	1		ISOLA	SPRAS
BIRTHDT	Date of Birth of Business Partner	BU_BIRTHDT	DATS	8			DATUM
DEATHDT	Date of death of business partner	BU_DEATHDT	DATS	8			DATUM
PERNO	Personnel Number	BU_PERNO	NUMC	8			PERSONID
CHILDREN	Obsolete Field	BU_CHILDREN	NUMC	2			NUMC2
MEM_HOUSE	Obsolete Field	BU_MEM_HOUSE	DEC	2			DEC2
PARTGRPTYP	Group type	BU_GRPTYP	CHAR	4			BU_GRPTYP		H_TB025
NAME_GRP1	Name 1 (group)	BU_NAMEGR1	CHAR	40			BU_NAME
NAME_GRP2	Name 2 (group)	BU_NAMEGR2	CHAR	40			BU_NAME
MC_NAME1	Search Help Field 1 (Name 1/Last Name)	BU_MCNAME1	CHAR	35			CHAR35
MC_NAME2	Search Help Field 2 (Name 2/First Name)	BU_MCNAME2	CHAR	35			CHAR35
CRUSR	User who created the object	BU_CRUSR	CHAR	12			USNAM
CRDAT	Date on which the object was created	BU_CRDAT	DATS	8			DATUM
CRTIM	Time at which the object was created	BU_CRTIM	TIMS	6			UZEIT
CHUSR	Last user to change object	BU_CHUSR	CHAR	12			USNAM
CHDAT	Date when object was last changed	BU_CHDAT	DATS	8			DATUM
CHTIM	Time at which object was last changed	BU_CHTIM	TIMS	6			UZEIT
PARTNER_GUID	Business Partner GUID	BU_PARTNER_GUID	RAW	16			SYSUUID
ADDRCOMM	Address Number	BU_ADDRCOMM	CHAR	10		ALPHA	AD_ADDRNUM	ADR
TD_SWITCH	Planned Change Documents for Partner Were Converted	BU_TD_SWITCH	CHAR	1			CHAR1
IS_ORG_CENTRE	Indicator: Business Partner Is Also an Organizational Center	BU_IS_ORG_CENTRE	CHAR	1			BU_IS_ORG_CENTRE
DB_KEY	UUID in X form (binary)	SYSUUID_X	RAW	16			SYSUUID
VALID_FROM	Validity Start BUT000 BP Data	BU_BP_VALID_FROM	DEC	15			TZNTSTMPS
VALID_TO	Validity End BUT000 BP Data	BU_BP_VALID_TO	DEC	15			TZNTSTMPS
XPCPT	Business Purpose Completed Flag	BU_XPCPT	CHAR	1			BU_XPCPT
.INCLU--AP				0
NATPERS	Business Partner Is a Natural Person Under the Tax Laws	BU_NATURAL_PERSON	CHAR	1			BU_NATURAL_PERSON
.INCLU--AP				0
PAR_REL	Business Partner Released	BP_PAR_REL	CHAR	1			BP_PAR_REL
BP_SORT	Sort Field for Phonetic Search; Obsolete	BP_SORT_PH	CHAR	20			CHAR20
.INCLU--AP				0
KBANKS	Bank country key	BANKS	CHAR	3			LAND1	BKL
KBANKL	Bank Keys	BANKK	CHAR	15			BANKK	BNK
.INCLU--AP				0
FS_ATTRIBUTES				0
CLIENT	Client	MANDT	CLNT	3			MANDT
PARTNER	Business Partner Number	BU_PARTNER	CHAR	10		ALPHA	BU_PARTNER	BPA	BUPA
TITLE_LET	Salutation	BP_TITL_LT	NUMC	2			BP_TITL_LT
GROUP_D	Target Group	BP_GROUP_D	CHAR	4			BP_GROUP_D
PAR_REL	Business Partner Released	BP_PAR_REL	CHAR	1			BP_PAR_REL
VIP	Business Partner Is VIP	BP_VIP_PARTNER	CHAR	1			XFELD
BP_SORT	Phonetic Search Term	BP_PHONSTRING	CHAR	80			CHAR80
SORT_PHON	Sort Field for Phonetic Search; Obsolete	BP_SORT_PH	CHAR	20			CHAR20
VBUND	Company ID of trading partner	RASSC	CHAR	6		ALPHA	RCOMP	PGS
COUNTRY_REP	Country for Reporting	BP_CNTR_REP	CHAR	3			LAND1
CALENDARID	Factory calendar	BP_CAL_ID	CHAR	2			WFCID
CNTRY_COMP	Country of Organization's Registered Office	BP_CNTR_HD	CHAR	3			LAND1
REGIO	Region of Registered Office	BP_REGIO_HD	CHAR	3			REGIO
COMP_HEAD	Registered Office	BP_COMP_HD	CHAR	35			TEXT35
MIN_RESERV	Bank Subject to Minimum Reserve Requirement	BP_MIN_RSV	CHAR	1			XFELD
BAL_SH_CUR	Balance Sheet Currency	BP_BAL_CUR	CUKY	5			WAERS
CAP_INCR_A	Amount of last capital increase	BP_CA_IN_A	CURR	15(2)			WERTV8
CAP_INCR_Y	Year of Last Capital Increase	BP_CA_IN_Y	NUMC	4		GJAHR	GJAHR
BALANCE_FL	Balance Sheet Display	BP_BAL_FLG	CHAR	1			BP_BAL_FLG
BANKL	Bank Keys	BANKK	CHAR	15			BANKK	BNK
BANKS	Bank country key	BANKS	CHAR	3			LAND1	BKL
STATE	Citizenship	BP_CNTR_ST	CHAR	3			LAND1
PROPRTY_ST	Marital property regime	BP_PROPRTY_OLD	NUMC	2			BP_PROPRTY
INCOME_CUR	Currency of Net Income	BP_INC_CUR	CUKY	5			WAERS
CHILDREN	Number of Children Belonging to the Business Partner	BP_CHILDRN	DEC	2			DEC2
MEM_HOUSE	Number of People Living in the Household	BP_MEM_HOU	DEC	2			DEC2
NET_INCOME	Net Annual Income	BP_NET_INC	CURR	15(2)			WERTV8
MO_NET_INC	Monthly Net Income of Business Partner	BP_MO_INC	CURR	15(2)			WERTV8
NET_INC_Y	Year of Net Annual Income	BP_N_INC_Y	NUMC	4		GJAHR	GJAHR
MO_INC_M	Calendar Month of Monthly Net Income	BP_M_INC_M	NUMC	2			BP_M_INC_M
MO_INC_Y	Year of Monthly Net Income	BP_M_INC_Y	NUMC	4		GJAHR	GJAHR
PERS_NR	Personnel Number	BP_PERS_NR	CHAR	15			CHAR15
STAFF_GRP	Employee Group	BP_STAFF_G	CHAR	4			BP_STAFF_G
HR_ORG_REF	HR Org. Link	HR_ORG_REF	CHAR	1			XFELD
XUBNAME	User Name in User Master Record	BP_XUBNAME	CHAR	12			XUBNAME	XUS
STAFF_REF	Employee	BP_STAFF_R	CHAR	1			XFELD
DYING_PLACE	Name of Place of Death of Natural Person	BP_DYING_PLACE	CHAR	40			BP_DYING_PLACE
BANK_DEL_D	Termination Date for Business Relations with the Bank	BP_BANK_DEL_D	DATS	8			DATUM
UNW_CUSTOMER	Undesirable Customer	BP_UNW_CUSTOMER	CHAR	1			XFELD
UNW_REASON	Reason for Undesirability	BP_UNW_REASON	CHAR	2			BP_UNW_REASON
UNW_REMARK	Comment on Undesirability	BP_UNW_REMARK	CHAR	35			TEXT35
ADRKIND	Address Type	BU_ADRKIND	CHAR	10			BU_ADRKIND
LAST_CUST_CONT	Date of Last Customer Contact	BP_LAST_CUST_CONTACT	DATS	8			DATS
.INCLU--AP				0
MAX_FILE_SIZE	Maximum Size for Ordering File	BP_BCA_DTE_CARD_MAX_FILE_SIZE	INT4	10
.INCLU--AP				0
GROUP_FEATURE	Grouping Character	BP_GROUP_FEATURE	CHAR	10			BP_GROUP_FEATURE	BP_GROUP_FEATURE

Key field

Non-key field

< FSBP_GDPDU_STR_STRUCT_NAME - Range Structure for Segment Name of DART FSBP_GENERIC_DATA - Generic Mapping of a Data Object >

How do I retrieve data from SAP structure FSBP_GENERAL_DATA using ABAP code?

As FSBP_GENERAL_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FSBP_GENERAL_DATA as there is no data to select.

How to access SAP table FSBP_GENERAL_DATA

Within an ECC or HANA version of SAP you can also view further information about FSBP_GENERAL_DATA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).