SAP FSBP_EI_COMMON External FS-BP Interface: General Data Table data and field list

FSBP_EI_COMMON 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 "External FS-BP Interface: 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_EI_COMMON TYPE FSBP_EI_COMMON.

The FSBP_EI_COMMON table consists of various fields, each holding specific information or linking keys about External FS-BP Interface: General Data data available in SAP. These include FSBP_COMMON (), SALUTATION (Salutation), TARGET_GROUP (Target Group), PAR_REL (Business Partner Released)... 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_EI_COMMON structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP FSBP_EI_COMMON 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_EI_COMMON 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
DATA 0
FSBP_COMMON 0
SALUTATIONSalutation BAPIBP_TITL_LTNUMC2BP_TITL_LT
TARGET_GROUPTarget Group BAPIBP_GROUP_DCHAR4BP_GROUP_D
PAR_RELBusiness Partner Released BAPIBP_PAR_RELCHAR1BP_PAR_REL
VIPSingle-Character Indicator CHAR1CHAR1CHAR1
BP_SORTSort Field for Phonetic Search; Obsolete BAPIBP_SORT_PHCHAR20CHAR20
SORT_PHONSort Field for Phonetic Search; Obsolete BAPIBP_SORT_PHCHAR20CHAR20
VBUNDCompany ID of the Business Partner BAPIRASSCCHAR6ALPHARCOMPPGS
COUNTRY_REPCountry for Reporting BAPIBP_CNTR_REPCHAR3LAND1
COUNTRY_REP_ISOCountry ISO code INTCACHAR2INTCAF4_INTCA
CALENDARIDFactory Calendar BAPIBP_CAL_IDCHAR2WFCID
CNTRY_COMPCountry of Organization's Registered Office BAPIBP_CNTR_HDCHAR3LAND1
CNTRY_COMP_ISOCountry ISO code INTCACHAR2INTCAF4_INTCA
REGIONRegion of Registered Office BAPIBP_REGIO_HDCHAR3REGIO
COMP_HEADRegistered Office BAPIBP_COMP_HDCHAR35TEXT35
MIN_RESERVBank Subject to Minimum Reserve Requirement BAPIBP_MIN_RSVCHAR1XFELD
BAL_SH_CURCurrency of Net Income BAPIBP_INC_CURCUKY5WAERS
BAL_SH_CUR_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
CAP_INCR_AAmount of Last Capital Increase BAPIBP_CA_IN_ADEC28(9) BAPIBP_BAPICUREXT
CAP_INCR_YYear of Last Capital Increase BAPIBP_CA_IN_YNUMC4GJAHRGJAHR
BALANCE_FLBalance Sheet Display BAPIBP_BAL_FLGCHAR1BP_BAL_FLG
BANK_KEYBank Key BAPIBANKKCHAR15BANKKBNK
BANK_CTRYBank Country Key BAPIBANKSCHAR3LAND1BKL
BANK_CTRY_ISOCountry ISO code INTCACHAR2INTCAF4_INTCA
STATECitizenship BAPIBP_CNTR_STCHAR3LAND1
STATE_ISOCountry ISO code INTCACHAR2INTCAF4_INTCA
PROPRTY_STMarital Property Regime BAPIBP_PROPRTY_OLDNUMC2BP_PROPRTY
INCOME_CURCurrency of Net Income BAPIBP_INC_CURCUKY5WAERS
INCOME_CUR_ISOISO Currency Code BAPIISOCDCHAR3ISOCD
CHILDRENNumber of Children Belonging to the Business Partner BAPIBP_CHILDRNDEC2DEC2
MEM_HOUSENumber of People Living in the Household BAPIBP_MEM_HOUDEC2DEC2
NET_INCOMEAnnual Net Income BAPIBP_NET_INCDEC28(9) BAPIBP_BAPICUREXT
MO_NET_INCMonthly Net Income of Business Partner BAPIBP_MO_INCDEC28(9) BAPIBP_BAPICUREXT
NET_INC_YYear of Net Annual Income BAPIBP_N_INC_YNUMC4GJAHRGJAHR
MO_INC_MMonth of Monthly Net Income BAPIBP_M_INC_MNUMC2BP_M_INC_M
MO_INC_YYear of monthly net income BAPIBP_M_INC_YNUMC4GJAHRGJAHR
PERS_NRPersonnel Number BAPIBP_PERS_NRCHAR15CHAR15
STAFF_GRPEmployee Group BAPIBP_STAFF_GCHAR4BP_STAFF_G
HR_ORG_REFHR Org. Link BAPIHR_ORG_REFCHAR1XFELD
XUBNAMEUser Name in User Master Record BAPIXUBNAMECHAR12XUBNAMEXUS
STAFF_REFEmployee BAPIBP_STAFF_RCHAR1XFELD
DYING_PLACEName of Place of Death of Natural Person BAPIBP_DYING_PLACECHAR40CHAR40
BANK_DEL_DTermination Date for Business Relations with the Bank BAPIBP_BANK_DEL_DDATS8DATUM
UNW_CUSTOMERUndesirable Customer BAPIBP_UNW_CUSTOMERCHAR1XFELD
UNW_REASONReason for Undesirability BAPIBP_UNW_REASONCHAR2BP_UNW_REASON
UNW_REMARKComment on Undesirability BAPIBP_UNW_REMARKCHAR35TEXT35
ADDRESSTYPEAddress Type BAPIBU_ADRKINDCHAR10BU_ADRKIND
GROUP_FEATUREGrouping Character BAPIBP_GROUP_FEATURECHAR10BP_GROUP_FEATUREBP_GROUP_FEATURE
LAST_CUST_CONTDate of Last Customer Contact BP_LAST_CUST_CONTACTDATS8DATS
MAX_FILE_SIZEMaximum Size for Ordering File BP_BCA_DTE_CARD_MAX_FILE_SIZEINT410
DATAX 0
FSBP_COMMON_X 0
TITLE_LETUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
GROUP_DUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PAR_RELUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VIPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BP_SORTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SORT_PHONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VBUNDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
COUNTRY_REPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
COUNTRY_REP_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CALENDARIDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CNTRY_COMPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CNTRY_COMP_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REGIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
COMP_HEADUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MIN_RESERVUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BAL_SH_CURUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BAL_SH_CUR_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CAP_INCR_AUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CAP_INCR_YUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BALANCE_FLUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BANK_KEYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BANK_CTRYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BANK_CTRY_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STATEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STATE_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PROPRTY_STUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INCOME_CURUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INCOME_CUR_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CHILDRENUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MEM_HOUSEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NET_INCOMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MO_NET_INCUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NET_INC_YUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MO_INC_MUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MO_INC_YUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PERS_NRUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STAFF_GRPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
HR_ORG_REFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
XUBNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STAFF_REFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DYING_PLACEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BANK_DEL_DUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UNW_CUSTOMERUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UNW_REASONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UNW_REMARKUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ADDRESSTYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
GROUP_FEATUREUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LAST_CUST_CONTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MAX_FILE_SIZEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE

Key field Non-key field



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

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

How to access SAP table FSBP_EI_COMMON

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

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