SAP ABAP Table 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	TRANSP	Transparent table
Transparent table	S408	Table Relationship Diagram
Short Description	Land registers

Delivery and Maintenance

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S408	FEINS	T006	MSEHI
2	S408	FEINS_01	T006	MSEHI
3	S408	MANDT	T000	MANDT
4	S408	PARTNR	BP000	PARTNR
5	S408	RBELAST	TIV02	SBELAST
6	S408	SGRBA	TDO6	SGRBA
7	S408	SGRUNDB	VIGBUCH	SGRUNDB
8	S408	SGRUNDB_01	VIGBUCH	SGRUNDB
9	S408	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in