SAP ABAP Table JBIXPART (Processing Structure for Transferring Business Partners)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ JBA (Package) Application developmnet IS-B General Development

Basic Data

Table Category	INTTAB	Structure
Structure	JBIXPART	Table Relationship Diagram
Short Description	Processing Structure for Transferring Business Partners

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	Bus.Part.Processing Structure - Data Rel.for Regul.Reporting
2	UPUSERS	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
3	DUPDATS	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
4	TUPTIMS	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
5	.INCLUDE	☐				0	0	Bus.Part.Receiver Structure - Data Rel.for Regul.Reporting
6	SMWUB	☐	JBSMWUB	JBSMWUB	CHAR	1	0	RR Transfer Indicator for Object Transfer
7	SFMMODE	☐	JBSMODE	JBSMODE	CHAR	1	0	Mode of Data Flow
8	.INCLUDE	☐				0	0	BP: Attributes of Reporting Data
9	NRESIDT	☐	BP_NRESIDT	XFELD	CHAR	1	0	Non-Resident According to Paragraph 4 AWG
10	NRESI_D	☐	BP_NRESI_D	DATUM	DATS	8	0	Start of Non-Residency According to Paragraph 4 AWG
11	KWG_RLV	☐	BP_KWG_RLV	XFELD	CHAR	1	0	Recipient of Multimillion Loan According to Paragraph 14 GBA
12	KWG_NR	☐	BP_KWG_NR	CHAR8	CHAR	8	0	Borrower Number for Reporting a Loan According to GBA
13	KWG_ENR	☐	BP_KWG_ENR	CHAR8	CHAR	8	0	Borrower Entity Number Used to Report Loan acc. to GBA
14	KWG_CRE	☐	BP_KWG_CRE	BP_KWG_CRE	NUMC	2	0	Credit Standing Review According to Paragraph 18 GBA	TP12
15	KWG_CRE_D	☐	BP_KWG_CRE_D	DATUM	DATS	8	0	Date of Credit Standing Review According to Paragraph 18 GBA
16	KWG_ORG	☐	BP_KWG_ORG	BP_KWG_ORG	NUMC	2	0	Loan to Manager According to Paragraph 15 German Banking Act	*
17	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
18	.INCLUDE	☐				0	0	Business Partner: Reporting Data Austria
19	XID_AT	☐	VVXID_AT_FS	VVXID_AT_FS	CHAR	11	0	(OeNB) Ident Number
20	SZG_AT	☐	VVSZG_AT_FS	VVSZG_AT_FS	CHAR	2	0	Target Group According to OeNB	TD05_AT_FS
21	SID_AT	☐	VVSID_AT_FS	BP_JANEI	CHAR	1	0	Assign (OeNB) Ident Number
22	SINLZ_AT	☐	VVSINLZ_AT	VVSINLZ_AT	CHAR	7	0	Institute Number According to OeNB
23	SINME_AT	☐	VVSINME_AT	XFELD	CHAR	1	0	Institute Subject to Austrian Reg. Reporting Requirements
24	GID_AT	☐	VVGID_AT		CHAR	15	0	Group ID
25	GIDTYPE_AT	☐	VVGIDTYPE_AT	VVGIDTYPE_AT	CHAR	1	0	Group Assignment Category
26	GNAME_AT	☐	VVGNAME_AT	TEXT50	CHAR	50	0	Group Name
27	RBRBAN	☐	JBRBRBAN	JBRBRBAN	CHAR	10	0	Industry Key for Businss Partners of the Bank
28	.INCLUDE	☐				0	0	Include for BP Table BP1030 - Regulatory Reporting
29	RBRSAP	☐	JBRBRSAP	JBRBRSAP	NUMC	6	0	Industry Key in SAP Format	*
30	S13AWV	☐	JBS13AWV	JBS13AWV	CHAR	1	0	Indicator for Further Processing with § 13 a	*
31	SBERBN	☐	JBSBERBN	JBSBERBN	CHAR	2	0	Reporting Country Banks	*
32	SKNSVR	☐	JBSKNSVR	JBSKNSVR	CHAR	1	0	Consolidation Settlement	*
33	SLNZON	☐	JBSLNZON	JBSLNZON	CHAR	1	0	Indicator - Zone Allocation of Countries	*
34	SNERWR	☐	JBSNERWR	JBSNERWR	CHAR	1	0	Domestic State Adminisitration not Pursuing Business Goal	*
35	SHANDW	☐	JBSHANDW	JBSHANDW	CHAR	1	0	Indicator - Craftsperson (Borrower Statistics)	*
36	SUEBW	☐	JBSUEBW	JBSUEBW	CHAR	2	0	Supervision Indicator for §§13,14,16	*
37	SKNEIN	☐	JBSKNEIN	BU_PARTNER	CHAR	10	0	Number for Borrower Entity	*
38	SDUPPF	☐	JBSDUPPF	JBSDUPPF	CHAR	8	0	Kennzeichen Duplikats-Pflicht
39	SKDREF	☐	JBSKDREF	JBSKDREF	CHAR	2	0	Indicator for Legal Form of Customer
40	.INCLUDE	☐				0	0	Include for EDT Business Partner, Single Trans. Cost., Long
41	.INCLUDE	☐				0	0	Include for EDT Bus. Partner, Sngl. Trans. Cost. Part, Short
42	.INCLUDE	☐				0	0	BP: Attributes of General Business Partner
43	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
44	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	ADRP
45	BU_GROUP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	*
46	EXTPARTNR	☐	BP_EXT_PNR	CHAR15	CHAR	15	0	External Business Partner ID
47	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
48	TYPE	☐	BP_TYPE_OLD	BP_TYPE	CHAR	1	0	Partner category
49	BP_GROUP	☐	BP_GROUP	XFELD	CHAR	1	0	BP: Collective Business Partner Indicator
50	GROUP_ID	☐	BP_GRP_ID_OLD	BP_GRP_ID	CHAR	4	0	Business Partner Grouping	TPZ2
51	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
52	NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
53	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
54	TITLE	☐	BP_TITLE_OLD	BP_TITLE	NUMC	2	0	Form of Address (Key)	TP01
55	TITLE_LET	☐	BP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	TP02
56	ADR_REF	☐	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	TP14
57	SORT1	☐	BP_SORT1	CHAR20	CHAR	20	0	Sort Field 1
58	SORT2	☐	BP_SORT2	CHAR20	CHAR	20	0	Sort Field 2
59	SORT_PHON	☐	BP_SORT_PH	CHAR20	CHAR	20	0	Sort Field for Phonetic Search; Obsolete
60	MC_NAME1	☐	BP_MC_NAM1	CHAR25	CHAR	25	0	Field NAME1 in Upper Case
61	MC_NAME2	☐	BP_MC_NAM2	CHAR25	CHAR	25	0	Field NAME2 in Upper Case
62	SOURCE	☐	BP_SOURCE	BP_SOURCE	CHAR	4	0	Source Key of Business Partner Data
63	CRUSER	☐	BP_CRUSER	SYCHAR12	CHAR	12	0	Entered by
64	CRDAT	☐	BP_CRDAT	DATUM	DATS	8	0	Creation Date
65	VIP	☐	BP_VIP	PAVIP	CHAR	1	0	Business Partner: VIP Partner	TVIP
66	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
67	DEL_IND	☐	BP_DEL_IND	XFELD	CHAR	1	0	Deletion Flag
68	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
69	XTITLE	☐	BP_XTITLE	TEXT50	CHAR	50	0	Text of Form of Address
70	XTIT_LE	☐	BP_XTIT_LE	TEXT50	CHAR	50	0	Salutation
71	PAR_REL	☐	BP_PAR_REL	BP_PAR_REL	CHAR	1	0	Business Partner Released
72	.INCLUDE	☐				0	0	BP: Attributes of Natural Persons
73	NAME_LAST	☐	BP_NAMLAST	TEXT40	CHAR	40	0	Last Name
74	NAME_FIRST	☐	BP_NAMFRST	TEXT40	CHAR	40	0	First Name
75	TITLE_AC	☐	BP_TITL_AC_OLD	TEXT20	CHAR	20	0	Academic Title
76	N_PREFIX	☐	BP_PREFIX_OLD	TEXT20	CHAR	20	0	Name Prefix
77	N_ADDITION	☐	BP_ADDITN_OLD	TEXT20	CHAR	20	0	Name Affix
78	NICKNAME	☐	BP_NICKNAM	TEXT20	CHAR	20	0	Known As
79	SEX	☐	BP_SEX_OLD	BP_SEX	CHAR	1	0	Gender of Business Partner
80	PROFESSION	☐	BP_PROFESS_OLD	TEXT40	CHAR	40	0	Description of Occupation for Business Partner
81	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
82	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
83	BIRTH_DATE	☐	BP_BIRTHD	DATUM	DATS	8	0	Date of Birth of Business Partner
84	BIRTH_PLAC	☐	BP_BIRTHPL	TEXT40	CHAR	40	0	Birthplace
85	BIRTH_NAME	☐	BP_BIRTHNA	TEXT40	CHAR	40	0	Name at Birth
86	BIRTH_N_AD	☐	BP_BIRTH_A	TEXT40	CHAR	40	0	Name at Birth Affix
87	DEATH_DATE	☐	BP_DEATH_D	DATUM	DATS	8	0	Date of Death
88	MARITAL_ST	☐	BP_MARITAL_OLD	BP_MARITAL	NUMC	2	0	Marital Status	TP03
89	PROPRTY_ST	☐	BP_PROPRTY_OLD	BP_PROPRTY	NUMC	2	0	Marital property regime	TP04
90	CHILDREN	☐	BP_CHILDRN	DEC2	DEC	2	0	Number of Children Belonging to the Business Partner
91	MEM_HOUSE	☐	BP_MEM_HOU	DEC2	DEC	2	0	Number of People Living in the Household
92	INCOME_CUR	☐	BP_INC_CUR	WAERS	CUKY	5	0	Currency of Net Income	TCURC
93	NET_INCOME	☐	BP_NET_INC	WERTV8	CURR	15	2	Net Annual Income
94	MO_NET_INC	☐	BP_MO_INC	WERTV8	CURR	15	2	Monthly Net Income of Business Partner
95	NET_INC_Y	☐	BP_N_INC_Y	GJAHR	NUMC	4	0	Year of Net Annual Income
96	MO_INC_M	☐	BP_M_INC_M	BP_M_INC_M	NUMC	2	0	Calendar Month of Monthly Net Income
97	MO_INC_Y	☐	BP_M_INC_Y	GJAHR	NUMC	4	0	Year of Monthly Net Income
98	PERS_NR	☐	BP_PERS_NR	CHAR15	CHAR	15	0	Personnel Number
99	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
100	HR_ORG_REF	☐	HR_ORG_REF	XFELD	CHAR	1	0	HR Org. Link
101	XUBNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
102	STAFF_REF	☐	BP_STAFF_R	XFELD	CHAR	1	0	Employee
103	.INCLUDE	☐				0	0	BP: Attributes of Organizations
104	ORG_NAME	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
105	ORG_NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
106	CALENDARID	☐	BP_CAL_ID	WFCID	CHAR	2	0	Factory calendar	TFACD
107	LEGAL_ENTY	☐	BP_LEG_ETY_OLD	BP_LEG_ETY	NUMC	2	0	Legal Form of Organization	TP08
108	LEGAL_ORG	☐	BP_LEG_ORG_OLD	BP_LEG_ORG	NUMC	2	0	Legal Entity of Organization	TP09
109	BALANCE_FL	☐	BP_BAL_FLG	BP_BAL_FLG	CHAR	1	0	Balance Sheet Display
110	FOUND_YEAR	☐	BP_FOUND_Y	GJAHR	NUMC	4	0	Foundation Year of Organization
111	COMM_REGIS	☐	BP_COM_REG	TEXT50	CHAR	50	0	Entry in Commercial Register
112	COMM_REG_D	☐	BP_COM_R_D	DATUM	DATS	8	0	Date of Entry in Commercial Register
113	CNTRY_COMP	☐	BP_CNTR_HD	LAND1	CHAR	3	0	Country of Organization's Registered Office	T005
114	REGIO	☐	BP_REGIO_HD	REGIO	CHAR	3	0	Region of Registered Office	T005S
115	COMP_HEAD	☐	BP_COMP_HD	TEXT35	CHAR	35	0	Registered Office
116	LIQUID_DAT	☐	BP_LIQUI_D	DATUM	DATS	8	0	Date of Liquidation
117	COMP_NR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
118	COMP_NR_AD	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
119	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
120	IND_SECTOR	☐	BP_BRSCH_OLD	BRSCH	CHAR	4	0	Industry Keys	T016
121	MIN_RESERV	☐	BP_MIN_RSV	XFELD	CHAR	1	0	Bank Subject to Minimum Reserve Requirement
122	BAL_SH_CUR	☐	BP_BAL_CUR	WAERS	CUKY	5	0	Balance Sheet Currency	TCURC
123	CAP_INCR_A	☐	BP_CA_IN_A	WERTV8	CURR	15	2	Amount of last capital increase
124	CAP_INCR_Y	☐	BP_CA_IN_Y	GJAHR	NUMC	4	0	Year of Last Capital Increase
125	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
126	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
127	.INCLUDE	☐				0	0	BP: Business partner - address
128	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
129	PARTNR	☐	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
130	ADR_REF_K	☐	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	TP14
131	ADR_DAT	☐	BP_ADR_DAT	DATUM	DATS	8	0	Business partner address relationship valid from
132	.INCLUDE	☐				0	0	BP: Business Partner - Address Data
133	ADRNR	☐	BP_ADRNR_OLD	SADRNR	CHAR	10	0	Address Number	SANS1
134	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
135	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
136	ADR_D_E	☐	BP_ADR_D_E	DATUM	DATS	8	0	Business Partner Address Relationship Valid Until
137	ADR_LOC	☐	BP_ADR_LOC	CHAR20	CHAR	20	0	Building
138	FLOOR	☐	BP_FLOOR	CHAR10	CHAR	10	0	Floor
139	ROOM_NR	☐	BP_ROOM_NR	CHAR10	CHAR	10	0	Room Number
140	NAME3	☐	BP_NAME3	TEXT40	CHAR	40	0	Name 3
141	NAME4	☐	BP_NAME4	TEXT40	CHAR	40	0	Name 4
142	NAME_CO	☐	BP_NAME_CO	TEXT40	CHAR	40	0	c/o Name
143	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
144	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
145	.INCLUDE	☐				0	0	BP: Screen Structure Telecommunications Data
146	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
147	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
148	TELFX1	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
149	TELFX2	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
150	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
151	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
152	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
153	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
154	ADSMTP	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
155	TELNR_CALL1	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
156	TELNR_CALL2	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
157	SERKRS	☐	ERKRS	ERKRS	CHAR	4	0	Operating concern	*
158	SALLROL	☐	JBSALLROL	CHAR1	CHAR	1	0	Create all Roles
159	SALLGPB	☐	JBSALLGPB	CHAR1	CHAR	1	0	Transaction Authorizations per Company Code
160	SFEMODE	☐	JBSMODE	JBSMODE	CHAR	1	0	Mode of Data Flow
161	SEGUB	☐	JBSEGUB	JBSEGUB	CHAR	1	0	Indicator - Record Relevant for Profitability Analysis?
162	CHANGE	☐	JBRCHANG	JBRCHANG	CHAR	1	0	Counter for Group Change
163	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
164	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
165	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
166	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
167	PSTBZ	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
168	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
169	STRA1	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
170	ORT01_MC	☐	VVXORT01MC	CHAR16	CHAR	16	0	IS-IS: City 1 in upper case characters for matchcode search
171	STRAS_MC	☐	VVXSTRASMC	CHAR16	CHAR	16	0	IS-IS: Street in upper case characters for matchcode search
172	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
173	ROLETYP	☐	BP_ROLETYP_OLD	BP_ROLETYP	CHAR	4	0	Business Partner Role Category	*
174	ROLE	☐	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type	*
175	AUTHORITY	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
176	DEL_INDRO	☐	BP_DEL_IND	XFELD	CHAR	1	0	Deletion Flag
177	SUSEGPB	☐	JBSUSEGE	CHAR1	CHAR	1	0	Indicator: Transaction Authorizations Used for Co.Code?
178	SUSEROL	☐	JBSUSERO	CHAR1	CHAR	1	0	Indicator: Use Delivered Role?
179	SERROR	☐	JBSERROR	JBSERROR	CHAR	1	0	Error flag
180	ORG_INDEX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
181	SEGMENT	☐	JBSEGMENT	CHAR1	CHAR	1	0	Indicator for Segment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBIXPART	ADDRNUMBER	ADRC	ADDRNUMBER	KEY
2	JBIXPART	ADRNR	SANS1	ADRNR		1	CN
3	JBIXPART	ADR_REF	TP14	ADR_REF	REF
4	JBIXPART	ADR_REF_K	TP14	ADR_REF	KEY	1	CN
5	JBIXPART	BAL_SH_CUR	TCURC	WAERS
6	JBIXPART	CALENDARID	TFACD	IDENT
7	JBIXPART	CNTRY_COMP	T005	LAND1
8	JBIXPART	GROUP_D	TP13	GROUP_D
9	JBIXPART	GROUP_ID	TPZ2	GROUP_ID
10	JBIXPART	INCOME_CUR	TCURC	WAERS
11	JBIXPART	IND_SECTOR	T016	BRSCH
12	JBIXPART	KWG_CRE	TP12	KWG_CRE
13	JBIXPART	LANGU	T002	SPRAS
14	JBIXPART	LEGAL_ENTY	TP08	LEGAL_ENTY
15	JBIXPART	LEGAL_ORG	TP09	LEGAL_ORG
16	JBIXPART	MANDT	T000	MANDT	KEY	1	CN
17	JBIXPART	MARITAL_ST	TP03	MARITAL_ST
18	JBIXPART	NATION	T005	LAND1
19	JBIXPART	PARTNR	BP000	PARTNR	KEY	1	CN
20	JBIXPART	PERSNUMBER	ADRP	PERSNUMBER	KEY
21	JBIXPART	PROPRTY_ST	TP04	PROPRTY_ST
22	JBIXPART	REGIO	T005S	BLAND	KEY
23	JBIXPART	STAFF_GRP	TP05	STAFF_GRP
24	JBIXPART	STATE	T005	LAND1
25	JBIXPART	SZG_AT	TD05_AT_FS	SZG_AT	KEY	1	CN
26	JBIXPART	TITLE	TP01	TITLE
27	JBIXPART	TITLE_LET	TP02	TITLE_LET
28	JBIXPART	VIP	TVIP	PAVIP

History

Last changed by/on	SAP	20130529
SAP Release Created in