SAP ABAP Table RFVPRT_ROL (RE: Partner (Role, Obj.) - Parts of Name and Addit.Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	RFVPRT_ROL	Table Relationship Diagram
Short Description	RE: Partner (Role, Obj.) - Parts of Name and Addit.Fields

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	SPRSLRCP	☐	VVSPRSLRCP	SPRAS	LANG	1	0	Language key for texts for letter printout	*
2	LAND1RCP	☐	VVLAND1RCP	LAND1	CHAR	3	0	Country key for recipient of a letter	*
3	APPL	☐	BP_APPL	BP_APPL	CHAR	4	0	Application Category	*
4	XAPPL	☐	BP_XAPPL	TEXT30	CHAR	30	0	Application Name
5	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
6	ROLETYP	☐	BP_ROLETYP	BP_ROLETYP	CHAR	4	0	Business Partner Role Category	*
7	XROLETYP	☐	BP_XROLTYP	TEXT30	CHAR	30	0	Name of Role Category
8	ROLE	☐	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type	*
9	XROLE	☐	BP_XROLE	TEXT30	CHAR	30	0	Name of role type
10	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
11	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
12	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
13	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
14	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
15	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
16	.INCLUDE	☐				0	0	Business Partner Master (General Data)
17	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
18	PARTNR	☐	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	*
19	PARTNR_OLD	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
20	.INCLUDE	☐				0	0	BP: Attributes of General Business Partner
21	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
22	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	ADRP
23	BU_GROUP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	*
24	EXTPARTNR	☐	BP_EXT_PNR	CHAR15	CHAR	15	0	External Business Partner ID
25	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
26	TYPE	☐	BP_TYPE_OLD	BP_TYPE	CHAR	1	0	Partner category
27	BP_GROUP	☐	BP_GROUP	XFELD	CHAR	1	0	BP: Collective Business Partner Indicator
28	GROUP_ID	☐	BP_GRP_ID_OLD	BP_GRP_ID	CHAR	4	0	Business Partner Grouping	TPZ2
29	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
30	NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
31	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
32	TITLE	☐	BP_TITLE_OLD	BP_TITLE	NUMC	2	0	Form of Address (Key)	TP01
33	TITLE_LET	☐	BP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	TP02
34	ADR_REF	☐	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	TP14
35	SORT1	☐	BP_SORT1	CHAR20	CHAR	20	0	Sort Field 1
36	SORT2	☐	BP_SORT2	CHAR20	CHAR	20	0	Sort Field 2
37	SORT_PHON	☐	BP_SORT_PH	CHAR20	CHAR	20	0	Sort Field for Phonetic Search; Obsolete
38	MC_NAME1	☐	BP_MC_NAM1	CHAR25	CHAR	25	0	Field NAME1 in Upper Case
39	MC_NAME2	☐	BP_MC_NAM2	CHAR25	CHAR	25	0	Field NAME2 in Upper Case
40	SOURCE	☐	BP_SOURCE	BP_SOURCE	CHAR	4	0	Source Key of Business Partner Data
41	CRUSER	☐	BP_CRUSER	SYCHAR12	CHAR	12	0	Entered by
42	CRDAT	☐	BP_CRDAT	DATUM	DATS	8	0	Creation Date
43	VIP	☐	BP_VIP	PAVIP	CHAR	1	0	Business Partner: VIP Partner	TVIP
44	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
45	DEL_IND	☐	BP_DEL_IND	XFELD	CHAR	1	0	Deletion Flag
46	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
47	XTITLE	☐	BP_XTITLE	TEXT50	CHAR	50	0	Text of Form of Address
48	XTIT_LE	☐	BP_XTIT_LE	TEXT50	CHAR	50	0	Salutation
49	PAR_REL	☐	BP_PAR_REL	BP_PAR_REL	CHAR	1	0	Business Partner Released
50	.INCLUDE	☐				0	0	BP: Attributes of Natural Persons
51	NAME_LAST	☐	BP_NAMLAST	TEXT40	CHAR	40	0	Last Name
52	NAME_FIRST	☐	BP_NAMFRST	TEXT40	CHAR	40	0	First Name
53	TITLE_AC	☐	BP_TITL_AC_OLD	TEXT20	CHAR	20	0	Academic Title
54	N_PREFIX	☐	BP_PREFIX_OLD	TEXT20	CHAR	20	0	Name Prefix
55	N_ADDITION	☐	BP_ADDITN_OLD	TEXT20	CHAR	20	0	Name Affix
56	NICKNAME	☐	BP_NICKNAM	TEXT20	CHAR	20	0	Known As
57	SEX	☐	BP_SEX_OLD	BP_SEX	CHAR	1	0	Gender of Business Partner
58	PROFESSION	☐	BP_PROFESS_OLD	TEXT40	CHAR	40	0	Description of Occupation for Business Partner
59	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
60	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
61	BIRTH_DATE	☐	BP_BIRTHD	DATUM	DATS	8	0	Date of Birth of Business Partner
62	BIRTH_PLAC	☐	BP_BIRTHPL	TEXT40	CHAR	40	0	Birthplace
63	BIRTH_NAME	☐	BP_BIRTHNA	TEXT40	CHAR	40	0	Name at Birth
64	BIRTH_N_AD	☐	BP_BIRTH_A	TEXT40	CHAR	40	0	Name at Birth Affix
65	DEATH_DATE	☐	BP_DEATH_D	DATUM	DATS	8	0	Date of Death
66	MARITAL_ST	☐	BP_MARITAL_OLD	BP_MARITAL	NUMC	2	0	Marital Status	TP03
67	PROPRTY_ST	☐	BP_PROPRTY_OLD	BP_PROPRTY	NUMC	2	0	Marital property regime	TP04
68	CHILDREN	☐	BP_CHILDRN	DEC2	DEC	2	0	Number of Children Belonging to the Business Partner
69	MEM_HOUSE	☐	BP_MEM_HOU	DEC2	DEC	2	0	Number of People Living in the Household
70	INCOME_CUR	☐	BP_INC_CUR	WAERS	CUKY	5	0	Currency of Net Income	TCURC
71	NET_INCOME	☐	BP_NET_INC	WERTV8	CURR	15	2	Net Annual Income
72	MO_NET_INC	☐	BP_MO_INC	WERTV8	CURR	15	2	Monthly Net Income of Business Partner
73	NET_INC_Y	☐	BP_N_INC_Y	GJAHR	NUMC	4	0	Year of Net Annual Income
74	MO_INC_M	☐	BP_M_INC_M	BP_M_INC_M	NUMC	2	0	Calendar Month of Monthly Net Income
75	MO_INC_Y	☐	BP_M_INC_Y	GJAHR	NUMC	4	0	Year of Monthly Net Income
76	PERS_NR	☐	BP_PERS_NR	CHAR15	CHAR	15	0	Personnel Number
77	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
78	HR_ORG_REF	☐	HR_ORG_REF	XFELD	CHAR	1	0	HR Org. Link
79	XUBNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
80	STAFF_REF	☐	BP_STAFF_R	XFELD	CHAR	1	0	Employee
81	.INCLUDE	☐				0	0	BP: Attributes of Organizations
82	ORG_NAME	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
83	ORG_NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
84	CALENDARID	☐	BP_CAL_ID	WFCID	CHAR	2	0	Factory calendar	TFACD
85	LEGAL_ENTY	☐	BP_LEG_ETY_OLD	BP_LEG_ETY	NUMC	2	0	Legal Form of Organization	TP08
86	LEGAL_ORG	☐	BP_LEG_ORG_OLD	BP_LEG_ORG	NUMC	2	0	Legal Entity of Organization	TP09
87	BALANCE_FL	☐	BP_BAL_FLG	BP_BAL_FLG	CHAR	1	0	Balance Sheet Display
88	FOUND_YEAR	☐	BP_FOUND_Y	GJAHR	NUMC	4	0	Foundation Year of Organization
89	COMM_REGIS	☐	BP_COM_REG	TEXT50	CHAR	50	0	Entry in Commercial Register
90	COMM_REG_D	☐	BP_COM_R_D	DATUM	DATS	8	0	Date of Entry in Commercial Register
91	CNTRY_COMP	☐	BP_CNTR_HD	LAND1	CHAR	3	0	Country of Organization's Registered Office	T005
92	REGIO	☐	BP_REGIO_HD	REGIO	CHAR	3	0	Region of Registered Office	T005S
93	COMP_HEAD	☐	BP_COMP_HD	TEXT35	CHAR	35	0	Registered Office
94	LIQUID_DAT	☐	BP_LIQUI_D	DATUM	DATS	8	0	Date of Liquidation
95	COMP_NR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
96	COMP_NR_AD	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
97	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
98	IND_SECTOR	☐	BP_BRSCH_OLD	BRSCH	CHAR	4	0	Industry Keys	T016
99	MIN_RESERV	☐	BP_MIN_RSV	XFELD	CHAR	1	0	Bank Subject to Minimum Reserve Requirement
100	BAL_SH_CUR	☐	BP_BAL_CUR	WAERS	CUKY	5	0	Balance Sheet Currency	TCURC
101	CAP_INCR_A	☐	BP_CA_IN_A	WERTV8	CURR	15	2	Amount of last capital increase
102	CAP_INCR_Y	☐	BP_CA_IN_Y	GJAHR	NUMC	4	0	Year of Last Capital Increase
103	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
104	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
105	.INCLU--AP	☐				0	0	BP: Attribute switch-off parallel maintenance
106	NO_CONV	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
107	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
108	XLANDRCP	☐	VVXLANDRCP	TEXT15	CHAR	15	0	Description of country of letter recipient
109	XSPRASRCP	☐	VVXSPRSRCP	SPTXT16	CHAR	16	0	Description of language of available texts
110	.INCLUDE	☐				0	0	Additional fields for BP000
111	.INCLUDE	☐				0	0	Additional fields for BPI000
112	XLANGU	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
113	XADR_REF	☐	BP_XADRREF	TEXT40	CHAR	40	0	Description of Address ID
114	XPAVIP	☐	VTEXT	TEXT20	CHAR	20	0	Description
115	XGROUP_D	☐	BP_GRP_D_T	TEXT35	CHAR	35	0	Description of Target Group
116	.INCLUDE	☐				0	0	Additional fields for BPI010
117	XNATION	☐	LANDX	TEXT15	CHAR	15	0	Country Name
118	XSTATE	☐	LANDX	TEXT15	CHAR	15	0	Country Name
119	XMARITALST	☐	BP_MARIT_T	TEXT30	CHAR	30	0	Description of Marital Status
120	XPROPRTYST	☐	BP_PROP_T	TEXT30	CHAR	30	0	Description of Marital Property Regime
121	XINC_CUR_K	☐	XWAERSK	TEXT15	CHAR	15	0	Currency key short text
122	XINC_CUR_L	☐	XWAERSL	TEXT40	CHAR	40	0	Currency key long text
123	XSTAFF_GRP	☐	BP_STAFF_T	TEXT30	CHAR	30	0	Description of Employee Group
124	.INCLUDE	☐				0	0	Additional fields for BPI020
125	XLEGAL_ET	☐	BP_LEGAL_T	TEXT30	CHAR	30	0	Description of Legal Form
126	XLEGL_ORG1	☐	BP_LGLO_T1	TEXT15	CHAR	15	0	Short Name of Legal Entity
127	XLEGL_ORG2	☐	BP_LGLO_T2	TEXT60	CHAR	60	0	Name of Legal Entity
128	XCNTRYCOMP	☐	LANDX	TEXT15	CHAR	15	0	Country Name
129	XINDSECTOR	☐	TEXT1_016T	TEXT20	CHAR	20	0	Description of the Industry Key
130	XBALSHCURK	☐	XWAERSK	TEXT15	CHAR	15	0	Currency key short text
131	XBALSHCURL	☐	XWAERSL	TEXT40	CHAR	40	0	Currency key long text
132	XBANKS	☐	LANDX	TEXT15	CHAR	15	0	Country Name

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in