SAP ABAP Table FSBP_STR_DCL_PERSON (Business Partner Data Cleansing (Person))

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ FS-BP (Application Component) Business Partner
     ⤷ FSBP_CLEARING (Package) SAP BP FS: Link to Cleansing Tool

Basic Data

Table Category	INTTAB	Structure
Structure	FSBP_STR_DCL_PERSON	Table Relationship Diagram
Short Description	Business Partner Data Cleansing (Person)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SALUTATION	☐	BAPIBP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	TP02
2	TARGET_GROUP	☐	BAPIBP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
3	PAR_REL	☐	BAPIBP_PAR_REL	BP_PAR_REL	CHAR	1	0	Business Partner Released
4	VIP	☐	BP_VIP_PARTNER	XFELD	CHAR	1	0	Business Partner Is VIP
5	VBUND	☐	BAPIRASSC	RCOMP	CHAR	6	0	Company ID of the Business Partner	T880
6	COUNTRY_REP	☐	BAPIBP_CNTR_REP	LAND1	CHAR	3	0	Country for Reporting	T005
7	STATE	☐	BAPIBP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
8	PROPRTY_ST	☐	BAPIBP_PROPRTY_OLD	BP_PROPRTY	NUMC	2	0	Marital Property Regime	TP04
9	INCOME_CUR	☐	BAPIBP_INC_CUR	WAERS	CUKY	5	0	Currency of Net Income	TCURC
10	CHILDREN	☐	BAPIBP_CHILDRN	DEC2	DEC	2	0	Number of Children Belonging to the Business Partner
11	MEM_HOUSE	☐	BAPIBP_MEM_HOU	DEC2	DEC	2	0	Number of People Living in the Household
12	NET_INCOME	☐	BAPIBP_NET_INC	BAPIBP_BAPICUREXT	DEC	28	9	Annual Net Income
13	MO_NET_INC	☐	BAPIBP_MO_INC	BAPIBP_BAPICUREXT	DEC	28	9	Monthly Net Income of Business Partner
14	NET_INC_Y	☐	BAPIBP_N_INC_Y	GJAHR	NUMC	4	0	Year of Net Annual Income
15	MO_INC_M	☐	BAPIBP_M_INC_M	BP_M_INC_M	NUMC	2	0	Month of Monthly Net Income
16	MO_INC_Y	☐	BAPIBP_M_INC_Y	GJAHR	NUMC	4	0	Year of monthly net income
17	PERS_NR	☐	BAPIBP_PERS_NR	CHAR15	CHAR	15	0	Personnel Number
18	STAFF_GRP	☐	BAPIBP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
19	HR_ORG_REF	☐	BAPIHR_ORG_REF	XFELD	CHAR	1	0	HR Org. Link
20	XUBNAME	☐	BAPIXUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
21	STAFF_REF	☐	BAPIBP_STAFF_R	XFELD	CHAR	1	0	Employee
22	DYING_PLACE	☐	BAPIBP_DYING_PLACE	CHAR40	CHAR	40	0	Name of Place of Death of Natural Person
23	BANK_DEL_D	☐	FSBP_DTE_BANK_DEL_D	DATUM	DATS	8	0	End of Business Relationship
24	UNW_CUSTOMER	☐	BAPIBP_UNW_CUSTOMER	XFELD	CHAR	1	0	Undesirable Customer
25	UNW_REASON	☐	BAPIBP_UNW_REASON	BP_UNW_REASON	CHAR	2	0	Reason for Undesirability	TP18
26	UNW_REMARK	☐	BAPIBP_UNW_REMARK	TEXT35	CHAR	35	0	Comment on Undesirability
27	ADDRESSTYPE	☐	BAPIBU_ADRKIND	BU_ADRKIND	CHAR	10	0	Address Type	TB009
28	GROUP_FEATURE	☐	BAPIBP_GROUP_FEATURE	BP_GROUP_FEATURE	CHAR	10	0	Grouping Character	TP24
29	LAST_CUST_CONT	☐	BP_LAST_CUST_CONTACT	DATS	DATS	8	0	Date of Last Customer Contact

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FSBP_STR_DCL_PERSON	ADDRESSTYPE	TB009	ADR_KIND
2	FSBP_STR_DCL_PERSON	COUNTRY_REP	T005	LAND1
3	FSBP_STR_DCL_PERSON	GROUP_FEATURE	TP24	GROUP_FEATURE
4	FSBP_STR_DCL_PERSON	INCOME_CUR	TCURC	WAERS
5	FSBP_STR_DCL_PERSON	PROPRTY_ST	TP04	PROPRTY_ST
6	FSBP_STR_DCL_PERSON	SALUTATION	TP02	TITLE_LET
7	FSBP_STR_DCL_PERSON	STAFF_GRP	TP05	STAFF_GRP
8	FSBP_STR_DCL_PERSON	STATE	T005	LAND1
9	FSBP_STR_DCL_PERSON	TARGET_GROUP	TP13	GROUP_D
10	FSBP_STR_DCL_PERSON	UNW_REASON	TP18	UNW_REASON
11	FSBP_STR_DCL_PERSON	VBUND	T880	RCOMP
12	FSBP_STR_DCL_PERSON	XUBNAME	USR02	BNAME

History

Last changed by/on	SAP	20110908
SAP Release Created in	640