SAP ABAP Table VIRPS408 (Real estate: Reference Info structure S408 (Land registers))

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	VIRPS408	Table Relationship Diagram
Short Description	Real estate: Reference Info structure S408 (Land registers)

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	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	VIGBUCH
3	ANZGB	☐	VVAGB	DEC5	DEC	5	0	No. of land registers
4	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
5	XPARTNR	☐	VVXPARTNRG	CHAR35	CHAR	35	0	Land register: name
6	XSTRASSE	☐	VVXSTRASSE	TEXT35	CHAR	35	0	Address: Street/house number
7	XPLZ	☐	VVXPLZ	PSTLZ	CHAR	10	0	Address: Postal code
8	XORT	☐	VVXORT	TEXT35	CHAR	35	0	Address: City
9	XGBVON	☐	XGBVON	XTEXT25	CHAR	25	0	Land register district
10	NBANDNR	☐	NBANDNR	TEXT15	CHAR	15	0	Land register volume number
11	NBLATTNR	☐	NBLATTNR	TEXT15	CHAR	15	0	Land register page number
12	SGRBA	☐	SGRBA	SGRBA	NUMC	2	0	Land register type	TDO6
13	XGRBA	☐	XGRBA	TEXT50	CHAR	50	0	Type of land register
14	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
15	XGBAMT	☐	XGBAMT	XTEXT25	CHAR	25	0	Land registry ID
16	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
17	SNRABT1	☐	SNRABT1	NRABT1	NUMC	3	0	No. of entry in section 1 of land register
18	DBVORM	☐	DBVORM	DATUM	DATS	8	0	Date of approval of priority notice
19	DAUFLVOR	☐	DAUFLVOR	DDAT	DATS	8	0	Date of priority notice of conveyance
20	DBAUFL	☐	DBAUFL	DATUM	DATS	8	0	Date of approval of conveyance
21	DAUFLASS	☐	DAUFLASS	DDAT	DATS	8	0	Date of conveyance
22	JKZLOE	☐	JKZLOE	JFLAGG	CHAR	1	0	Indicator: Land register entry is marked as being deleted
23	XGRSTLST	☐	XGRSTLST	XTEXT18	CHAR	18	0	List of properties for an entry
24	XEIGTLST	☐	XEIGTLST	TEXT60	CHAR	60	0	Basis of entry
25	RGRSTLST	☐	RGRSTLST	RGRSTLST	NUMC	10	0	Reference to relational table properties
26	REIGTLST	☐	REIGTLST	REIGTLST	NUMC	10	0	Reference to relational data base table of owner
27	XNRA1	☐	VVXNRA1	VVXNRGB	CHAR	6	0	Section 1, number of entry
28	SNRABT2	☐	SNRABT2	NRABT2	NUMC	3	0	Number of entry in section 2 of land register
29	DBEINTR	☐	DBEINTR	DATUM	DATS	8	0	Date of approval of entry
30	DEINTRAG	☐	DEINTRAG	DDAT	DATS	8	0	Date of entry
31	XEINTXT	☐	XEINTXT	TEXT60	CHAR	60	0	Charges + restrictions in Section 2 of land register
32	BWRTMIN	☐	BWRTMIN	WRTV7	CURR	13	2	Net present value of law
33	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
34	PWRTMIN	☐	PWRTMIN	DEC03_2	DEC	5	2	Percentage decrease in value
35	RGBA2LB	☐	VVRGBA2LB	VVRGBA2LB	CHAR	1	0	Type of charges and restrictions for land register type
36	SNRABT2A	☐	SNRABT2A	NEINTRAG	NUMC	3	0	Changes section 2 of land register, no. of entry
37	DLOESCH	☐	DLOESCH	DDAT	DATS	8	0	Deletion date
38	XRNA2A	☐	VVXNRA2A	VVXNRGB	CHAR	6	0	No. of change in section II
39	SNRABT3	☐	SNRABT3	NRABT3	NUMC	3	0	No. of entry in Section 3 of land register
40	NRANG	☐	NRANG	NRANG	NUMC	4	0	Rank in section 3 of land register
41	BDARLEH	☐	BDARLEH	WRTV7	CURR	13	2	Total amount of right registered in Section III
42	RBELAST	☐	RBELAST	RBELAST	NUMC	2	0	Type of encumbrance in section 3 of land register	*
43	NRDARLEH	☐	NRDARLEH	NRDARLEH	NUMC	12	0	Loan number
44	XBELAST	☐	XBELAST	TEXT60	CHAR	60	0	Text about charge
45	BNOMIN	☐	BNOMIN	WRBTR	CURR	11	2	Nominal loan amount
46	BEFFECT	☐	BEFFECT	WRBTR	CURR	11	2	Effective loan amount
47	XGLAUB	☐	XGLAUB	XTEXT25	CHAR	25	0	Creditor
48	ZGRUSCH	☐	VVZGRUSCH	DEC3_7	DEC	10	7	Land charge interest rate
49	JREVAL	☐	JREVAL	JANEI	CHAR	1	0	Indicator: Revaluation permitted
50	ZNEBENL	☐	VVZNEBENL	DEC3_7	DEC	10	7	Additional service interest rate
51	JEIGENR	☐	JEIGENR	JANEI	CHAR	1	0	Individual right indicator
52	DAUSZGV	☐	DAUSZGV	DAUSZGV	DATS	8	0	Date: Land register extract from
53	XNRA3	☐	VVXNRA3	VVXNRGB	CHAR	6	0	Section 3, number of entry
54	SNRABT3A	☐	SNRABT3A	NEINTRAG	NUMC	3	0	No. of change/deletion in section 3 of land register
55	DAENDER	☐	DAENDER	DDAT	DATS	8	0	Change /deletion date
56	BAENLOE	☐	BAENLOE	BWHR	CURR	13	2	Change or deletion amount
57	XAEND	☐	VVXAEND	TEXT60	CHAR	60	0	Text for change or deletion
58	XNRA3A	☐	VVXNRARA	VVXNRGB	CHAR	6	0	No of change in sect. III
59	SLFDGRST	☐	SLFDGRST	NEINTRAG	NUMC	3	0	Property consecutive number
60	SNRFLST	☐	VVSNRFLST	VVSNRFLST	NUMC	3	0	Consecutive no. of a lot on a property
61	XFLURST	☐	XFLURST	TEXT10	CHAR	10	0	Parcel of Land
62	XCOMMNT	☐	VVXCOMMNT	TEXT60	CHAR	60	0	Comment about lot
63	NALTGRST	☐	NALTGRST	XTEXT7	CHAR	7	0	Previous number of property
64	NFLURNR	☐	NFLURNR	NFLURNR	CHAR	6	0	Number of Tract of Land in Land Register
65	XWIRTART	☐	XWIRTART	TEXT60	CHAR	60	0	Business type
66	XGSLAGE	☐	XGSLAGE	TEXT60	CHAR	60	0	Description of property location
67	NLSBUCHN	☐	NLSBUCHN	NLSBUCHN	NUMC	6	0	Real properties register number
68	FLAECHE	☐	VVBFLART	VVBFLART	QUAN	14	4	Area of area type
69	XGEMARK	☐	XGEMARK	XTEXT12	CHAR	12	0	Local subdistrict ID
70	NZUGRST	☐	VVNZUGRST	VVXNRGB	CHAR	6	0	Entry for property
71	XNRBSTD	☐	VVXNRBSTD	VVXNRGB	CHAR	6	0	Number in property list
72	SNRZUAB	☐	SNRZUAB	NEINTRAG	NUMC	3	0	Number of appreciation/depreciation
73	XZUATEXT	☐	XZUATEXT	TEXT60	CHAR	60	0	Text for entry//removal from land register
74	DATZUAB	☐	DATZUAB	DDAT	DATS	8	0	Date of entry/removal from land register
75	JZUAB	☐	JZUAB	JZUAB	CHAR	1	0	Value appreciation indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIRPS408	FEINS	T006	MSEHI
2	VIRPS408	MANDT	T000	MANDT
3	VIRPS408	PARTNR	BP000	PARTNR
4	VIRPS408	SGRBA	TDO6	SGRBA
5	VIRPS408	SGRUNDB	VIGBUCH	SGRUNDB
6	VIRPS408	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in