SAP ABAP Table TXI_BP001 (Treasury Attributes Organization)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_BP001	Table Relationship Diagram
Short Description	Treasury Attributes Organization

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	.INCLUDE	☐				0	0	FS-Specific Attributes; Organization
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	.INCLUDE	☐				0	0	FS-BP: All Data Fields for BP001
5	.INCLUDE	☐				0	0	Business Partner: Treasury Attributes General
6	TITLE_LET	☐	BP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	TP02
7	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
8	PAR_REL	☐	BP_PAR_REL	BP_PAR_REL	CHAR	1	0	Business Partner Released
9	VIP	☐	BP_VIP_PARTNER	XFELD	CHAR	1	0	Business Partner Is VIP	*
10	BP_SORT	☐	BP_PHONSTRING	CHAR80	CHAR	80	0	Phonetic Search Term
11	SORT_PHON	☐	BP_SORT_PH	CHAR20	CHAR	20	0	Sort Field for Phonetic Search; Obsolete
12	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
13	COUNTRY_REP	☐	BP_CNTR_REP	LAND1	CHAR	3	0	Country for Reporting	T005
14	.INCLUDE	☐				0	0	Business Partner - Treasury Attributes - Organization
15	CALENDARID	☐	BP_CAL_ID	WFCID	CHAR	2	0	Factory calendar	TFACD
16	CNTRY_COMP	☐	BP_CNTR_HD	LAND1	CHAR	3	0	Country of Organization's Registered Office	T005
17	REGIO	☐	BP_REGIO_HD	REGIO	CHAR	3	0	Region of Registered Office	T005S
18	COMP_HEAD	☐	BP_COMP_HD	TEXT35	CHAR	35	0	Registered Office
19	MIN_RESERV	☐	BP_MIN_RSV	XFELD	CHAR	1	0	Bank Subject to Minimum Reserve Requirement
20	BAL_SH_CUR	☐	BP_BAL_CUR	WAERS	CUKY	5	0	Balance Sheet Currency	TCURC
21	CAP_INCR_A	☐	BP_CA_IN_A	WERTV8	CURR	15	2	Amount of last capital increase
22	CAP_INCR_Y	☐	BP_CA_IN_Y	GJAHR	NUMC	4	0	Year of Last Capital Increase
23	BALANCE_FL	☐	BP_BAL_FLG	BP_BAL_FLG	CHAR	1	0	Balance Sheet Display
24	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
25	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
26	.INCLUDE	☐				0	0	Business Partner - Treasury Attributes - Natural Person
27	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
28	PROPRTY_ST	☐	BP_PROPRTY_OLD	BP_PROPRTY	NUMC	2	0	Marital property regime	TP04
29	INCOME_CUR	☐	BP_INC_CUR	WAERS	CUKY	5	0	Currency of Net Income	TCURC
30	CHILDREN	☐	BP_CHILDRN	DEC2	DEC	2	0	Number of Children Belonging to the Business Partner
31	MEM_HOUSE	☐	BP_MEM_HOU	DEC2	DEC	2	0	Number of People Living in the Household
32	NET_INCOME	☐	BP_NET_INC	WERTV8	CURR	15	2	Net Annual Income
33	MO_NET_INC	☐	BP_MO_INC	WERTV8	CURR	15	2	Monthly Net Income of Business Partner
34	NET_INC_Y	☐	BP_N_INC_Y	GJAHR	NUMC	4	0	Year of Net Annual Income
35	MO_INC_M	☐	BP_M_INC_M	BP_M_INC_M	NUMC	2	0	Calendar Month of Monthly Net Income
36	MO_INC_Y	☐	BP_M_INC_Y	GJAHR	NUMC	4	0	Year of Monthly Net Income
37	PERS_NR	☐	BP_PERS_NR	CHAR15	CHAR	15	0	Personnel Number
38	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
39	HR_ORG_REF	☐	HR_ORG_REF	XFELD	CHAR	1	0	HR Org. Link
40	XUBNAME	☐	BP_XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
41	STAFF_REF	☐	BP_STAFF_R	XFELD	CHAR	1	0	Employee
42	.INCLUDE	☐				0	0	Business Partner Treasury Attribute Death Data
43	DYING_PLACE	☐	BP_DYING_PLACE	BP_DYING_PLACE	CHAR	40	0	Name of Place of Death of Natural Person
44	.INCLUDE	☐				0	0	FS-Specific Attributes; Deletion Data
45	BANK_DEL_D	☐	BP_BANK_DEL_D	DATUM	DATS	8	0	Termination Date for Business Relations with the Bank
46	.INCLUDE	☐				0	0	FS-Specific Attributes: Undesirable Customer
47	UNW_CUSTOMER	☐	BP_UNW_CUSTOMER	XFELD	CHAR	1	0	Undesirable Customer
48	UNW_REASON	☐	BP_UNW_REASON	BP_UNW_REASON	CHAR	2	0	Reason for Undesirability	TP18
49	UNW_REMARK	☐	BP_UNW_REMARK	TEXT35	CHAR	35	0	Comment on Undesirability
50	.INCLUDE	☐				0	0	Business Parnter: Address Type for Parallel Processing
51	ADRKIND	☐	BU_ADRKIND	BU_ADRKIND	CHAR	10	0	Address Type	*
52	.INCLUDE	☐				0	0	FS-Specific Attributes: Date of Last Customer Contact
53	LAST_CUST_CONT	☐	BP_LAST_CUST_CONTACT	DATS	DATS	8	0	Date of Last Customer Contact
54	.INCLU--AP	☐				0	0	Maximum Size for Ordering File
55	MAX_FILE_SIZE	☐	BP_BCA_DTE_CARD_MAX_FILE_SIZE		INT4	10	0	Maximum Size for Ordering File
56	.INCLU--AP	☐				0	0	Grouping Character
57	GROUP_FEATURE	☐	BP_GROUP_FEATURE	BP_GROUP_FEATURE	CHAR	10	0	Grouping Character	TP24
58	CAP_INCR_A_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
59	NET_INCOME_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
60	MO_NET_INC_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXI_BP001	BAL_SH_CUR	TCURC	WAERS
2	TXI_BP001	BANKS	T005	LAND1
3	TXI_BP001	CALENDARID	TFACD	IDENT
4	TXI_BP001	CLIENT	T000	MANDT	KEY	1	CN
5	TXI_BP001	CNTRY_COMP	T005	LAND1
6	TXI_BP001	COUNTRY_REP	T005	LAND1
7	TXI_BP001	GROUP_D	TP13	GROUP_D
8	TXI_BP001	GROUP_FEATURE	TP24	GROUP_FEATURE	REF	1	CN
9	TXI_BP001	INCOME_CUR	TCURC	WAERS	KEY	1	CN
10	TXI_BP001	PROPRTY_ST	TP04	PROPRTY_ST	KEY
11	TXI_BP001	REGIO	T005S	BLAND
12	TXI_BP001	STAFF_GRP	TP05	STAFF_GRP	KEY
13	TXI_BP001	STATE	T005	LAND1	KEY
14	TXI_BP001	TITLE_LET	TP02	TITLE_LET	KEY	1	CN
15	TXI_BP001	UNW_REASON	TP18	UNW_REASON	REF	1	CN
16	TXI_BP001	VBUND	T880	RCOMP	REF	C	CN
17	TXI_BP001	XUBNAME	USR02	BNAME	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in