SAP ABAP Table VVS401 (RE standard analysis partner)

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	VVS401	Table Relationship Diagram
Short Description	RE standard analysis 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	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	*
2	ROLE	☐	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
4	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
5	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
6	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
7	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
8	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
9	E_SMIVE	☐	VVESMIVE	VVSMIVE	CHAR	13	0	Contract No. of Collective Lease-Outs
10	XWETEXT	☐	XWETEXT	XMBEZ	CHAR	30	0	Business entity identification
11	XGRTXT	☐	XGRTXT	XLBEZ	CHAR	60	0	Text for property
12	XGETXT	☐	XGETXT	XLBEZ	CHAR	60	0	Building text
13	XMETXT	☐	VVXMETXT	XMBEZ	CHAR	30	0	Text for rental unit
14	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
15	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
16	TYPE	☐	BP_TYPE	BP_TYPE	CHAR	1	0	Partner category
17	GROUP_ID	☐	BP_GRP_ID	BP_GRP_ID	CHAR	4	0	Business Partner Grouping	*
18	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
19	NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
20	NAME_LAST	☐	BP_NAMLAST	TEXT40	CHAR	40	0	Last Name
21	NAME_FIRST	☐	BP_NAMFRST	TEXT40	CHAR	40	0	First Name
22	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
23	TITLE	☐	BP_TITLE	BP_TITLE	NUMC	2	0	Form of Address (Key)	*
24	TITLE_LET	☐	BP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	*
25	XORT	☐	VVXORT	TEXT35	CHAR	35	0	Address: City
26	XPLZ	☐	VVXPLZ	PSTLZ	CHAR	10	0	Address: Postal code
27	XSTRASSE	☐	VVXSTRASSE	TEXT35	CHAR	35	0	Address: Street/house number
28	ANZPT	☐	VVAPT	DEC5	DEC	5	0	No. of partners
29	TITLE_AC	☐	BP_TITL_AC	TEXT20	CHAR	20	0	Academic Title
30	N_PREFIX	☐	BP_PREFIX	TEXT20	CHAR	20	0	Name Prefix
31	N_ADDITION	☐	BP_ADDITN	TEXT20	CHAR	20	0	Name Affix
32	NICKNAME	☐	BP_NICKNAM	TEXT20	CHAR	20	0	Known As
33	SEX	☐	BP_SEX	BP_SEX	CHAR	1	0	Gender of business partner
34	PROFESSION	☐	BP_PROFESS	TEXT40	CHAR	40	0	Description of Occupation for Business Partner
35	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	*
36	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	*
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	*
39	HR_ORG_REF	☐	HR_ORG_REF	XFELD	CHAR	1	0	HR Org. Link
40	XUBNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
41	STAFF_REF	☐	BP_STAFF_R	XFELD	CHAR	1	0	Employee
42	ADR_REF_K	☐	BP_ADR_REF	BP_ADR_REF	CHAR	10	0	Address ID	*
43	ADR_DAT	☐	BP_ADR_DAT	DATUM	DATS	8	0	Business partner address relationship valid from
44	ADRNR	☐	BP_ADRNR	SADRNR	CHAR	10	0	Address Number	*
45	ADR_D_E	☐	BP_ADR_D_E	DATUM	DATS	8	0	Business Partner Address Relationship Valid Until
46	ADR_LOC	☐	VV_ADR_LOC2	CHAR20	CHAR	20	0	Partner: Building
47	FLOOR	☐	VV_FLOOR	CHAR10	CHAR	10	0	Partner: Storey
48	ROOM_NR	☐	VV_ROOM_NR	CHAR10	CHAR	10	0	Partner: Room number
49	XOBJTXT	☐	VVXOBJTXT	XMBEZ	CHAR	30	0	Text for Real Estate object
50	DBEBEZ	☐	DBEBEZ	DATUM	DATS	8	0	Date of start of relationship
51	DENBEZ	☐	DENBEZ	DATUM	DATS	8	0	Date of end of relationship
52	ROLETYP	☐	BP_ROLETYP	BP_ROLETYP	CHAR	4	0	Business Partner Role Category	*
53	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
54	XORT2	☐	ORT02_GP	TEXT35	CHAR	35	0	District
55	PSTBZ	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
56	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
57	XSTRASSE2	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street

History

Last changed by/on	SAP	20130529
SAP Release Created in