SAP FSBP_PXE_COMMON_DATA General Data with Change Information (Before and After) Table data and field list

FSBP_PXE_COMMON_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 with Change Information (Before and After)" 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_PXE_COMMON_DATA TYPE FSBP_PXE_COMMON_DATA.

The FSBP_PXE_COMMON_DATA table consists of various fields, each holding specific information or linking keys about General Data with Change Information (Before and After) data available in SAP. These include TYPE (Business partner category), BU_GROUP (Business Partner Grouping), BU_SORT1 (Search term 1 for business partner), BU_SORT2 (Search term 2 for business partner)... 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_PXE_COMMON_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP FSBP_PXE_COMMON_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_PXE_COMMON_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
TYPE	Business partner category	BU_TYPE	CHAR	1			BU_TYPE	BPY
BU_GROUP	Business Partner Grouping	BU_GROUP	CHAR	4	Assigned to domain		BU_GROUP	BPP
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
BU_LANGU	Business partner: Language	BU_LANGU	LANG	1	Assigned to domain	ISOLA	SPRAS
SOURCE	Data Origin Types	BU_SOURCE	CHAR	4	Assigned to domain		BU_SOURCE
TITLE_LET	Salutation	BU_TITLE_LET	CHAR	50			TEXT50
TITLE	Form-of-Address Key	AD_TITLE	CHAR	4	Assigned to domain		AD_TITLE
PRINT_MODE	Business Partner Print Format	BU_PRINT_MODE	CHAR	1			BU_PRINT_MODE
NATPERS	Business Partner Is a Natural Person Under the Tax Laws	BU_NATURAL_PERSON	CHAR	1			BU_NATURAL_PERSON
VIP	Business Partner Is VIP	BP_VIP_PARTNER	CHAR	1			XFELD
UNW_CUSTOMER	Undesirable Customer	BP_UNW_CUSTOMER	CHAR	1			XFELD
UNW_REASON	Reason for Undesirability	BP_UNW_REASON	CHAR	2	Assigned to domain		BP_UNW_REASON
UNW_REMARK	Comment on Undesirability	BP_UNW_REMARK	CHAR	35			TEXT35
XBLCK	Central Block for Business Partner	BU_XBLCK	CHAR	1			XFELD
CONTACT	Business Partner: Contact Permission	BU_CONTACT	CHAR	1			BU_CONTACT
LAST_CUST_CONT	Date of Last Customer Contact	BP_LAST_CUST_CONTACT	DATS	8			DATS
NOT_RELEASED	Indicator: Not Released	BU_XNOT_RELEASED	CHAR	1			XFELD
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
NICKNAME	Nickname of Business Partner (Person)	BU_NICKNAM	CHAR	40			BU_NAME
INITIALS	'Middle Initial' or personal initials	AD_INITS	CHAR	10			CHAR10
TITLE_ACA1	Academic Title: Key	AD_TITLE1	CHAR	4	Assigned to domain		AD_TITLE1		AD_TITLE1
TITLE_ACA2	Second academic title (key)	AD_TITLE2	CHAR	4	Assigned to domain		AD_TITLE1
TITLE_ROYL	Name supplement, e.g. noble title (key)	AD_TITLES	CHAR	4	Assigned to domain		AD_TITLES
PREFIX1	Name Prefix (Key)	AD_PREFIX	CHAR	4	Assigned to domain		AD_PREFIX
PREFIX2	2nd name prefix (key)	AD_PREFIX2	CHAR	4	Assigned to domain		AD_PREFIX
NAME1_TEXT	Full Name	BU_NAME1TX	CHAR	80			TEXT80
NAMEFORMAT	Name format	AD_FORMAT	CHAR	2	Assigned to domain		AD_NAMFORM
NAMCOUNTRY	Country for name format rule	AD_NAMCTRY	CHAR	3	Assigned to domain		LAND1
XSEXM	Selection: Business partner is male	BU_XSEXM	CHAR	1			XFELD
XSEXF	Selection: Business partner is female	BU_XSEXF	CHAR	1			XFELD
XSEXU	Selection: Sex of business partner is not known	BU_XSEXU	CHAR	1			XFELD
BIRTHPL	Birthplace of business partner	BU_BIRTHPL	CHAR	40			TEXT40
BIRTHDT	Date of Birth of Business Partner	BU_BIRTHDT	DATS	8			DATUM
DEATHDT	Date of death of business partner	BU_DEATHDT	DATS	8			DATUM
MARST	Marital Status of Business Partner	BU_MARST	CHAR	1	Assigned to domain		BU_MARST
LANGU_CORR	Business Partner: Correspondence Language	BU_LANGU_CORR	LANG	1	Assigned to domain	ISOLA	SPRAS
JOBGR	Occupation/group	BU_JOBGR	CHAR	4	Assigned to domain		BU_JOBGR
NATIO	Nationality	BU_NATIO	CHAR	3	Assigned to domain		LAND1
CNDSC	Ctry of Origin: Non-Res. Companies	BU_CNDSC	CHAR	3	Assigned to domain		LAND1
PROPRTY_ST	Marital property regime	BP_PROPRTY_OLD	NUMC	2	Assigned to domain		BP_PROPRTY
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
DYING_PLACE	Name of Place of Death of Natural Person	BP_DYING_PLACE	CHAR	40			BP_DYING_PLACE
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	Assigned to domain		BU_LEGENTY		H_TB019
FOUND_DAT	Date organization founded	BU_FOUND_DAT	DATS	8			DATUM
LIQUID_DAT	Liquidation date of organization	BU_LIQUID_DAT	DATS	8
LEGAL_ORG	Legal Entity of Organization	BU_LEGAL_ORG	CHAR	2	Assigned to domain		BU_LEGAL_ORG
CALENDARID	Factory calendar	BP_CAL_ID	CHAR	2	Assigned to domain		WFCID
NAME_GRP1	Name 1 (group)	BU_NAMEGR1	CHAR	40			BU_NAME
NAME_GRP2	Name 2 (group)	BU_NAMEGR2	CHAR	40			BU_NAME
PARTGRPTYP	Group type	BU_GRPTYP	CHAR	4	Assigned to domain		BU_GRPTYP		H_TB025
PREVIOUS				0
TYPE	Business partner category	BU_TYPE	CHAR	1			BU_TYPE	BPY
BU_GROUP	Business Partner Grouping	BU_GROUP	CHAR	4			BU_GROUP	BPP
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
BU_LANGU	Business partner: Language	BU_LANGU	LANG	1		ISOLA	SPRAS
SOURCE	Data Origin Types	BU_SOURCE	CHAR	4			BU_SOURCE
TITLE_LET	Salutation	BU_TITLE_LET	CHAR	50			TEXT50
TITLE	Form-of-Address Key	AD_TITLE	CHAR	4			AD_TITLE
PRINT_MODE	Business Partner Print Format	BU_PRINT_MODE	CHAR	1			BU_PRINT_MODE
NATPERS	Business Partner Is a Natural Person Under the Tax Laws	BU_NATURAL_PERSON	CHAR	1			BU_NATURAL_PERSON
VIP	Business Partner Is VIP	BP_VIP_PARTNER	CHAR	1			XFELD
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
XBLCK	Central Block for Business Partner	BU_XBLCK	CHAR	1			XFELD
CONTACT	Business Partner: Contact Permission	BU_CONTACT	CHAR	1			BU_CONTACT
LAST_CUST_CONT	Date of Last Customer Contact	BP_LAST_CUST_CONTACT	DATS	8			DATS
NOT_RELEASED	Indicator: Not Released	BU_XNOT_RELEASED	CHAR	1			XFELD
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
NICKNAME	Nickname of Business Partner (Person)	BU_NICKNAM	CHAR	40			BU_NAME
INITIALS	'Middle Initial' or personal initials	AD_INITS	CHAR	10			CHAR10
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
NAMEFORMAT	Name format	AD_FORMAT	CHAR	2			AD_NAMFORM
NAMCOUNTRY	Country for name format rule	AD_NAMCTRY	CHAR	3			LAND1
XSEXM	Selection: Business partner is male	BU_XSEXM	CHAR	1			XFELD
XSEXF	Selection: Business partner is female	BU_XSEXF	CHAR	1			XFELD
XSEXU	Selection: Sex of business partner is not known	BU_XSEXU	CHAR	1			XFELD
BIRTHPL	Birthplace of business partner	BU_BIRTHPL	CHAR	40			TEXT40
BIRTHDT	Date of Birth of Business Partner	BU_BIRTHDT	DATS	8			DATUM
DEATHDT	Date of death of business partner	BU_DEATHDT	DATS	8			DATUM
MARST	Marital Status of Business Partner	BU_MARST	CHAR	1			BU_MARST
LANGU_CORR	Business Partner: Correspondence Language	BU_LANGU_CORR	LANG	1		ISOLA	SPRAS
JOBGR	Occupation/group	BU_JOBGR	CHAR	4			BU_JOBGR
NATIO	Nationality	BU_NATIO	CHAR	3			LAND1
CNDSC	Ctry of Origin: Non-Res. Companies	BU_CNDSC	CHAR	3			LAND1
PROPRTY_ST	Marital property regime	BP_PROPRTY_OLD	NUMC	2			BP_PROPRTY
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
DYING_PLACE	Name of Place of Death of Natural Person	BP_DYING_PLACE	CHAR	40			BP_DYING_PLACE
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
FOUND_DAT	Date organization founded	BU_FOUND_DAT	DATS	8			DATUM
LIQUID_DAT	Liquidation date of organization	BU_LIQUID_DAT	DATS	8
LEGAL_ORG	Legal Entity of Organization	BU_LEGAL_ORG	CHAR	2			BU_LEGAL_ORG
CALENDARID	Factory calendar	BP_CAL_ID	CHAR	2			WFCID
NAME_GRP1	Name 1 (group)	BU_NAMEGR1	CHAR	40			BU_NAME
NAME_GRP2	Name 2 (group)	BU_NAMEGR2	CHAR	40			BU_NAME
PARTGRPTYP	Group type	BU_GRPTYP	CHAR	4			BU_GRPTYP		H_TB025

Key field

Non-key field

< FSBP_PXE_COMMON_CHANGED - Structure for 'Change General Data' Event FSBP_PXE_CURRENT_COMMON_DATA - General Data with Change Information (After) >

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

As FSBP_PXE_COMMON_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_PXE_COMMON_DATA as there is no data to select.

How to access SAP table FSBP_PXE_COMMON_DATA

Within an ECC or HANA version of SAP you can also view further information about FSBP_PXE_COMMON_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).