SAP ABAP Table JBDBW_BA_PARTNR (Extraction Structure PARTNR (Business Partner))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-DP (Application Component) Transaction Data Pool
     ⤷ JBD (Package) Application development IS-B Data Pool

Basic Data

Table Category	INTTAB	Structure
Structure	JBDBW_BA_PARTNR	Table Relationship Diagram
Short Description	Extraction Structure PARTNR (Business Partner)

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	PARTNR	☐	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	*
3	EXTPARTNR	☐	BP_EXT_PNR	CHAR15	CHAR	15	0	External Business Partner ID
4	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
5	TYPE	☐	BP_TYPE_OLD	BP_TYPE	CHAR	1	0	Partner category
6	BP_GROUP	☐	BP_GROUP	XFELD	CHAR	1	0	BP: Collective Business Partner Indicator
7	GROUP_ID	☐	BP_GRP_ID_OLD	BP_GRP_ID	CHAR	4	0	Business Partner Grouping	*
8	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
9	NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
10	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
11	TITLE	☐	BP_TITLE_OLD	BP_TITLE	NUMC	2	0	Form of Address (Key)	*
12	TITLE_LET	☐	BP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	*
13	ADR_REF	☐	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	*
14	SORT1	☐	BP_SORT1	CHAR20	CHAR	20	0	Sort Field 1
15	SORT2	☐	BP_SORT2	CHAR20	CHAR	20	0	Sort Field 2
16	SORT_PHON	☐	BP_SORT_PH	CHAR20	CHAR	20	0	Sort Field for Phonetic Search; Obsolete
17	MC_NAME1	☐	BP_MC_NAM1	CHAR25	CHAR	25	0	Field NAME1 in Upper Case
18	MC_NAME2	☐	BP_MC_NAM2	CHAR25	CHAR	25	0	Field NAME2 in Upper Case
19	SOURCE	☐	BP_SOURCE	BP_SOURCE	CHAR	4	0	Source Key of Business Partner Data
20	CRUSER	☐	BP_CRUSER	SYCHAR12	CHAR	12	0	Entered by
21	CRDAT	☐	BP_CRDAT	DATUM	DATS	8	0	Creation Date
22	VIP	☐	BP_VIP	PAVIP	CHAR	1	0	Business Partner: VIP Partner	*
23	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	*
24	DEL_IND	☐	BP_DEL_IND	XFELD	CHAR	1	0	Deletion Flag
25	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
26	XTITLE	☐	BP_XTITLE	TEXT50	CHAR	50	0	Text of Form of Address
27	XTIT_LE	☐	BP_XTIT_LE	TEXT50	CHAR	50	0	Salutation
28	PAR_REL	☐	BP_PAR_REL	BP_PAR_REL	CHAR	1	0	Business Partner Released
29	NAME_LAST	☐	BP_NAMLAST	TEXT40	CHAR	40	0	Last Name
30	NAME_FIRST	☐	BP_NAMFRST	TEXT40	CHAR	40	0	First Name
31	TITLE_AC	☐	BP_TITL_AC_OLD	TEXT20	CHAR	20	0	Academic Title
32	N_PREFIX	☐	BP_PREFIX_OLD	TEXT20	CHAR	20	0	Name Prefix
33	N_ADDITION	☐	BP_ADDITN_OLD	TEXT20	CHAR	20	0	Name Affix
34	NICKNAME	☐	BP_NICKNAM	TEXT20	CHAR	20	0	Known As
35	SEX	☐	BP_SEX_OLD	BP_SEX	CHAR	1	0	Gender of Business Partner
36	PROFESSION	☐	BP_PROFESS_OLD	TEXT40	CHAR	40	0	Description of Occupation for Business Partner
37	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	*
38	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	*
39	BIRTH_DATE	☐	BP_BIRTHD	DATUM	DATS	8	0	Date of Birth of Business Partner
40	BIRTH_PLAC	☐	BP_BIRTHPL	TEXT40	CHAR	40	0	Birthplace
41	BIRTH_NAME	☐	BP_BIRTHNA	TEXT40	CHAR	40	0	Name at Birth
42	BIRTH_N_AD	☐	BP_BIRTH_A	TEXT40	CHAR	40	0	Name at Birth Affix
43	DEATH_DATE	☐	BP_DEATH_D	DATUM	DATS	8	0	Date of Death
44	MARITAL_ST	☐	BP_MARITAL_OLD	BP_MARITAL	NUMC	2	0	Marital Status	*
45	PROPRTY_ST	☐	BP_PROPRTY_OLD	BP_PROPRTY	NUMC	2	0	Marital property regime	*
46	CHILDREN	☐	BP_CHILDRN	DEC2	DEC	2	0	Number of Children Belonging to the Business Partner
47	MEM_HOUSE	☐	BP_MEM_HOU	DEC2	DEC	2	0	Number of People Living in the Household
48	INCOME_CUR	☐	BP_INC_CUR	WAERS	CUKY	5	0	Currency of Net Income	*
49	NET_INCOME	☐	BP_NET_INC	WERTV8	CURR	15	2	Net Annual Income
50	MO_NET_INC	☐	BP_MO_INC	WERTV8	CURR	15	2	Monthly Net Income of Business Partner
51	NET_INC_Y	☐	BP_N_INC_Y	GJAHR	NUMC	4	0	Year of Net Annual Income
52	MO_INC_M	☐	BP_M_INC_M	BP_M_INC_M	NUMC	2	0	Calendar Month of Monthly Net Income
53	MO_INC_Y	☐	BP_M_INC_Y	GJAHR	NUMC	4	0	Year of Monthly Net Income
54	PERS_NR	☐	BP_PERS_NR	CHAR15	CHAR	15	0	Personnel Number
55	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	*
56	HR_ORG_REF	☐	HR_ORG_REF	XFELD	CHAR	1	0	HR Org. Link
57	XUBNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
58	STAFF_REF	☐	BP_STAFF_R	XFELD	CHAR	1	0	Employee
59	ORG_NAME	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
60	ORG_NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
61	CALENDARID	☐	BP_CAL_ID	WFCID	CHAR	2	0	Factory calendar	*
62	LEGAL_ENTY	☐	BP_LEG_ETY_OLD	BP_LEG_ETY	NUMC	2	0	Legal Form of Organization	*
63	LEGAL_ORG	☐	BP_LEG_ORG_OLD	BP_LEG_ORG	NUMC	2	0	Legal Entity of Organization	*
64	BALANCE_FL	☐	BP_BAL_FLG	BP_BAL_FLG	CHAR	1	0	Balance Sheet Display
65	FOUND_YEAR	☐	BP_FOUND_Y	GJAHR	NUMC	4	0	Foundation Year of Organization
66	COMM_REGIS	☐	BP_COM_REG	TEXT50	CHAR	50	0	Entry in Commercial Register
67	COMM_REG_D	☐	BP_COM_R_D	DATUM	DATS	8	0	Date of Entry in Commercial Register
68	CNTRY_COMP	☐	BP_CNTR_HD	LAND1	CHAR	3	0	Country of Organization's Registered Office	*
69	REGIO	☐	BP_REGIO_HD	REGIO	CHAR	3	0	Region of Registered Office	*
70	COMP_HEAD	☐	BP_COMP_HD	TEXT35	CHAR	35	0	Registered Office
71	LIQUID_DAT	☐	BP_LIQUI_D	DATUM	DATS	8	0	Date of Liquidation
72	COMP_NR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
73	COMP_NR_AD	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
74	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
75	IND_SECTOR	☐	BP_SECTOR	BU_INDSECT	CHAR	10	0	Business Partner: Industry (Organization)	*
76	MIN_RESERV	☐	BP_MIN_RSV	XFELD	CHAR	1	0	Bank Subject to Minimum Reserve Requirement
77	BAL_SH_CUR	☐	BP_BAL_CUR	WAERS	CUKY	5	0	Balance Sheet Currency	*
78	CAP_INCR_A	☐	BP_CA_IN_A	WERTV8	CURR	15	2	Amount of last capital increase
79	CAP_INCR_Y	☐	BP_CA_IN_Y	GJAHR	NUMC	4	0	Year of Last Capital Increase
80	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
81	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*

History

Last changed by/on	SAP	20130529
SAP Release Created in