SAP ABAP Table JBVBBP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JBVBBP	Table Relationship Diagram
Short Description	Generated Table for View

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	T000
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	TPZ2
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	T002
11	TITLE	☐	BP_TITLE_OLD	BP_TITLE	NUMC	2	0	Form of Address (Key)	TP01
12	TITLE_LET	☐	BP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	TP02
13	ADR_REF	☐	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	TP14
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	TVIP
23	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
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	T005
38	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
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	TP03
45	PROPRTY_ST	☐	BP_PROPRTY_OLD	BP_PROPRTY	NUMC	2	0	Marital property regime	TP04
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	TCURC
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	TP05
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	USR02
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	TFACD
62	LEGAL_ENTY	☐	BP_LEG_ETY_OLD	BP_LEG_ETY	NUMC	2	0	Legal Form of Organization	TP08
63	LEGAL_ORG	☐	BP_LEG_ORG_OLD	BP_LEG_ORG	NUMC	2	0	Legal Entity of Organization	TP09
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	T005
69	REGIO	☐	BP_REGIO_HD	REGIO	CHAR	3	0	Region of Registered Office	T005S
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_BRSCH_OLD	BRSCH	CHAR	4	0	Industry Keys	T016
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	TCURC
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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBVBBP	ADR_REF	TP14	ADR_REF
2	JBVBBP	BAL_SH_CUR	TCURC	WAERS
3	JBVBBP	CALENDARID	TFACD	IDENT
4	JBVBBP	CNTRY_COMP	T005	LAND1
5	JBVBBP	GROUP_D	TP13	GROUP_D	KEY	1	CN
6	JBVBBP	GROUP_ID	TPZ2	GROUP_ID	KEY	1	CN
7	JBVBBP	INCOME_CUR	TCURC	WAERS	KEY	1	CN
8	JBVBBP	IND_SECTOR	T016	BRSCH
9	JBVBBP	LANGU	T002	SPRAS	KEY	1	CN
10	JBVBBP	LEGAL_ENTY	TP08	LEGAL_ENTY
11	JBVBBP	LEGAL_ORG	TP09	LEGAL_ORG
12	JBVBBP	MANDT	T000	MANDT	KEY	1	CN
13	JBVBBP	MARITAL_ST	TP03	MARITAL_ST	KEY	1	CN
14	JBVBBP	NATION	T005	LAND1	KEY	1	CN
15	JBVBBP	PROPRTY_ST	TP04	PROPRTY_ST	KEY	1	CN
16	JBVBBP	REGIO	T005S	BLAND	KEY
17	JBVBBP	STAFF_GRP	TP05	STAFF_GRP	KEY	1	CN
18	JBVBBP	STATE	T005	LAND1	KEY	1	CN
19	JBVBBP	TITLE	TP01	TITLE	KEY	1	CN
20	JBVBBP	TITLE_LET	TP02	TITLE_LET	KEY	1	CN
21	JBVBBP	VIP	TVIP	PAVIP	KEY	1	CN
22	JBVBBP	XUBNAME	USR02	BNAME	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in