SAP ABAP Table VIGW_R_VZGPM1F (Immobilien gew.: Geschäftspartner / Mieteinheiten)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-MI (Application Component) Migration
     ⤷ RE_MI_CR (Package) RE: Migration CRE (Data Dictionary Only)

Basic Data

Table Category	INTTAB	Structure
Structure	VIGW_R_VZGPM1F	Table Relationship Diagram
Short Description	Immobilien gew.: Geschäftspartner / Mieteinheiten

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	Immobilien gew.: Geschäftspartner / Mieteinheiten
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
4	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
5	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
6	.INCLUDE	☐				0	0	Immobilien gew.: Struktur BP000, BP010, BP020, BP030, BPDADR
7	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
8	ROLETYP	☐	BP_ROLETYP	BP_ROLETYP	CHAR	4	0	Business Partner Role Category	TPZ3
9	ROLE	☐	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type	TPZ6
10	.INCLUDE	☐				0	0	BP: Attributes of General Business Partner
11	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
12	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	ADRP
13	BU_GROUP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	*
14	EXTPARTNR	☐	BP_EXT_PNR	CHAR15	CHAR	15	0	External Business Partner ID
15	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
16	TYPE	☐	BP_TYPE_OLD	BP_TYPE	CHAR	1	0	Partner category
17	BP_GROUP	☐	BP_GROUP	XFELD	CHAR	1	0	BP: Collective Business Partner Indicator
18	GROUP_ID	☐	BP_GRP_ID_OLD	BP_GRP_ID	CHAR	4	0	Business Partner Grouping	TPZ2
19	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
20	NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
21	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
22	TITLE	☐	BP_TITLE_OLD	BP_TITLE	NUMC	2	0	Form of Address (Key)	TP01
23	TITLE_LET	☐	BP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	TP02
24	ADR_REF	☐	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	TP14
25	SORT1	☐	BP_SORT1	CHAR20	CHAR	20	0	Sort Field 1
26	SORT2	☐	BP_SORT2	CHAR20	CHAR	20	0	Sort Field 2
27	SORT_PHON	☐	BP_SORT_PH	CHAR20	CHAR	20	0	Sort Field for Phonetic Search; Obsolete
28	MC_NAME1	☐	BP_MC_NAM1	CHAR25	CHAR	25	0	Field NAME1 in Upper Case
29	MC_NAME2	☐	BP_MC_NAM2	CHAR25	CHAR	25	0	Field NAME2 in Upper Case
30	SOURCE	☐	BP_SOURCE	BP_SOURCE	CHAR	4	0	Source Key of Business Partner Data
31	CRUSER	☐	BP_CRUSER	SYCHAR12	CHAR	12	0	Entered by
32	CRDAT	☐	BP_CRDAT	DATUM	DATS	8	0	Creation Date
33	VIP	☐	BP_VIP	PAVIP	CHAR	1	0	Business Partner: VIP Partner	TVIP
34	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
35	DEL_IND	☐	BP_DEL_IND	XFELD	CHAR	1	0	Deletion Flag
36	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
37	XTITLE	☐	BP_XTITLE	TEXT50	CHAR	50	0	Text of Form of Address
38	XTIT_LE	☐	BP_XTIT_LE	TEXT50	CHAR	50	0	Salutation
39	PAR_REL	☐	BP_PAR_REL	BP_PAR_REL	CHAR	1	0	Business Partner Released
40	.INCLUDE	☐				0	0	BP: Attributes of Natural Persons
41	NAME_LAST	☐	BP_NAMLAST	TEXT40	CHAR	40	0	Last Name
42	NAME_FIRST	☐	BP_NAMFRST	TEXT40	CHAR	40	0	First Name
43	TITLE_AC	☐	BP_TITL_AC_OLD	TEXT20	CHAR	20	0	Academic Title
44	N_PREFIX	☐	BP_PREFIX_OLD	TEXT20	CHAR	20	0	Name Prefix
45	N_ADDITION	☐	BP_ADDITN_OLD	TEXT20	CHAR	20	0	Name Affix
46	NICKNAME	☐	BP_NICKNAM	TEXT20	CHAR	20	0	Known As
47	SEX	☐	BP_SEX_OLD	BP_SEX	CHAR	1	0	Gender of Business Partner
48	PROFESSION	☐	BP_PROFESS_OLD	TEXT40	CHAR	40	0	Description of Occupation for Business Partner
49	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
50	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
51	BIRTH_DATE	☐	BP_BIRTHD	DATUM	DATS	8	0	Date of Birth of Business Partner
52	BIRTH_PLAC	☐	BP_BIRTHPL	TEXT40	CHAR	40	0	Birthplace
53	BIRTH_NAME	☐	BP_BIRTHNA	TEXT40	CHAR	40	0	Name at Birth
54	BIRTH_N_AD	☐	BP_BIRTH_A	TEXT40	CHAR	40	0	Name at Birth Affix
55	DEATH_DATE	☐	BP_DEATH_D	DATUM	DATS	8	0	Date of Death
56	MARITAL_ST	☐	BP_MARITAL_OLD	BP_MARITAL	NUMC	2	0	Marital Status	TP03
57	PROPRTY_ST	☐	BP_PROPRTY_OLD	BP_PROPRTY	NUMC	2	0	Marital property regime	TP04
58	CHILDREN	☐	BP_CHILDRN	DEC2	DEC	2	0	Number of Children Belonging to the Business Partner
59	MEM_HOUSE	☐	BP_MEM_HOU	DEC2	DEC	2	0	Number of People Living in the Household
60	INCOME_CUR	☐	BP_INC_CUR	WAERS	CUKY	5	0	Currency of Net Income	TCURC
61	NET_INCOME	☐	BP_NET_INC	WERTV8	CURR	15	2	Net Annual Income
62	MO_NET_INC	☐	BP_MO_INC	WERTV8	CURR	15	2	Monthly Net Income of Business Partner
63	NET_INC_Y	☐	BP_N_INC_Y	GJAHR	NUMC	4	0	Year of Net Annual Income
64	MO_INC_M	☐	BP_M_INC_M	BP_M_INC_M	NUMC	2	0	Calendar Month of Monthly Net Income
65	MO_INC_Y	☐	BP_M_INC_Y	GJAHR	NUMC	4	0	Year of Monthly Net Income
66	PERS_NR	☐	BP_PERS_NR	CHAR15	CHAR	15	0	Personnel Number
67	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
68	HR_ORG_REF	☐	HR_ORG_REF	XFELD	CHAR	1	0	HR Org. Link
69	XUBNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
70	STAFF_REF	☐	BP_STAFF_R	XFELD	CHAR	1	0	Employee
71	.INCLUDE	☐				0	0	BP: Attributes of Organizations
72	ORG_NAME	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
73	ORG_NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
74	CALENDARID	☐	BP_CAL_ID	WFCID	CHAR	2	0	Factory calendar	TFACD
75	LEGAL_ENTY	☐	BP_LEG_ETY_OLD	BP_LEG_ETY	NUMC	2	0	Legal Form of Organization	TP08
76	LEGAL_ORG	☐	BP_LEG_ORG_OLD	BP_LEG_ORG	NUMC	2	0	Legal Entity of Organization	TP09
77	BALANCE_FL	☐	BP_BAL_FLG	BP_BAL_FLG	CHAR	1	0	Balance Sheet Display
78	FOUND_YEAR	☐	BP_FOUND_Y	GJAHR	NUMC	4	0	Foundation Year of Organization
79	COMM_REGIS	☐	BP_COM_REG	TEXT50	CHAR	50	0	Entry in Commercial Register
80	COMM_REG_D	☐	BP_COM_R_D	DATUM	DATS	8	0	Date of Entry in Commercial Register
81	CNTRY_COMP	☐	BP_CNTR_HD	LAND1	CHAR	3	0	Country of Organization's Registered Office	T005
82	REGIO	☐	BP_REGIO_HD	REGIO	CHAR	3	0	Region of Registered Office	T005S
83	COMP_HEAD	☐	BP_COMP_HD	TEXT35	CHAR	35	0	Registered Office
84	LIQUID_DAT	☐	BP_LIQUI_D	DATUM	DATS	8	0	Date of Liquidation
85	COMP_NR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
86	COMP_NR_AD	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
87	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
88	IND_SECTOR	☐	BP_BRSCH_OLD	BRSCH	CHAR	4	0	Industry Keys	T016
89	MIN_RESERV	☐	BP_MIN_RSV	XFELD	CHAR	1	0	Bank Subject to Minimum Reserve Requirement
90	BAL_SH_CUR	☐	BP_BAL_CUR	WAERS	CUKY	5	0	Balance Sheet Currency	TCURC
91	CAP_INCR_A	☐	BP_CA_IN_A	WERTV8	CURR	15	2	Amount of last capital increase
92	CAP_INCR_Y	☐	BP_CA_IN_Y	GJAHR	NUMC	4	0	Year of Last Capital Increase
93	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
94	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
95	.INCLUDE	☐				0	0	BP: Business Partner - Address Data
96	ADRNR	☐	BP_ADRNR_OLD	SADRNR	CHAR	10	0	Address Number	SANS1
97	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
98	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
99	ADR_D_E	☐	BP_ADR_D_E	DATUM	DATS	8	0	Business Partner Address Relationship Valid Until
100	ADR_LOC	☐	BP_ADR_LOC	CHAR20	CHAR	20	0	Building
101	FLOOR	☐	BP_FLOOR	CHAR10	CHAR	10	0	Floor
102	ROOM_NR	☐	BP_ROOM_NR	CHAR10	CHAR	10	0	Room Number
103	NAME3	☐	BP_NAME3	TEXT40	CHAR	40	0	Name 3
104	NAME4	☐	BP_NAME4	TEXT40	CHAR	40	0	Name 4
105	NAME_CO	☐	BP_NAME_CO	TEXT40	CHAR	40	0	c/o Name
106	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
107	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
108	.INCLUDE	☐				0	0	BP: Screen Structure Telecommunications Data
109	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
110	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
111	TELFX1	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
112	TELFX2	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
113	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
114	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
115	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
116	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
117	ADSMTP	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
118	TELNR_CALL1	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
119	TELNR_CALL2	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
120	.INCLUDE	☐				0	0	Immobilien gew.: Datenteil BPDADR
121	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
122	STRA1	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
123	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
124	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
125	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
126	PSTBZ	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
127	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in