SAP ABAP Table S404 (Properties)

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	S404	Table Relationship Diagram
Short Description	Properties

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	BUKRS_01	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	GSBER_01	☑	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
10	SWENR_02	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
11	SGRNR_03	☑	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
12	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
13	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
14	USRUNIT1	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
15	USRUNIT2	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
16	USRCUKY1	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
17	USRCUKY2	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
18	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
19	XORT	☐	VVXORT	TEXT35	CHAR	35	0	Address: City
20	XPLZ	☐	VVXPLZ	PSTLZ	CHAR	10	0	Address: Postal code
21	XSTRASSE	☐	VVXSTRASSE	TEXT35	CHAR	35	0	Address: Street/house number
22	XNUTZGRU	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
23	ANZGR	☐	VVAGR	DEC6	DEC	6	0	No. of properties
24	RBEPLAN	☐	VVRBEPLAN	XMBEZ	CHAR	30	0	Development plan: Description
25	USR02	☐	USRCHAR101	USRCHAR10	CHAR	10	0	User-defined field 1 for 10 characters
26	USR03	☐	USRCHAR102	USRCHAR10	CHAR	10	0	User-defined field 2 for 10 characters
27	USR00	☐	USRCHAR201	USRCHAR20	CHAR	20	0	User-defined field 1 for 20 characters
28	USR01	☐	USRCHAR202	USRCHAR20	CHAR	20	0	User field 2 for 20 characters
29	USR08	☐	USRDATE1	USRDATE	DATS	8	0	User field 1 for date
30	USR09	☐	USRDATE2	USRDATE	DATS	8	0	User field 2 for date
31	USR10	☐	USRFLAG1	FLAG	CHAR	1	0	User field 1 indicator for evaluations
32	USR11	☐	USRFLAG2	FLAG	CHAR	1	0	User field 2 indicator for evaluations
33	USR04	☐	USRQUAN151	USRQUAN15	QUAN	15	3	User Field 1 for Set (Length 12,3)
34	USR05	☐	USRQUAN152	USRQUAN15	QUAN	15	3	User Field 2 for Set (Length 12,3)
35	USR06	☐	USRCURR131	USRCURR13	CURR	13	3	User field 1 for values (length 10.3)
36	USR07	☐	USRCURR132	USRCURR13	CURR	13	3	User field 2 for values (length 10.3)
37	BDNRWERT	☐	VVBDNRWERT	WRBTR	CURR	11	2	Land reference value: Market value determination
38	BDNWERT	☐	VVBDNWERT_2	WRTV8	CURR	15	2	Land Value: Market Value Determination
39	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
40	DBDNWERT	☐	VVDBDNWERT	DDAT	DATS	8	0	Land value: date
41	RFAKT	☐	VVXFAKT	CHAR6	CHAR	6	0	Conversion factor for fractional share of property
42	FQMFLART	☐	VVBFLART	VVBFLART	QUAN	14	4	Area of area type
43	DSFLART	☐	VVDSFLART	DATS	DATS	8	0	Area: effective from
44	SFLART	☐	SFLART	SFLART	NUMC	4	0	Area type	TIV08
45	SGRFRM	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
46	XGRFRM	☐	VVXGRFRM2	VVXTEXT20	CHAR	20	0	Property: Ground type
47	SGRGZS	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
48	XGRGZS	☐	VVXGRGZS2	VVXTEXT20	CHAR	20	0	Property: Overall condition
49	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
50	XGBVON	☐	XGBVON	XTEXT25	CHAR	25	0	Land register district
51	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	VIGBUCH
52	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
53	XGRART	☐	VVXGRART2	VVXTEXT20	CHAR	20	0	Property: Type
54	SGRART	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
55	XGRTXT	☐	VVXGRTXT	XLBEZ	CHAR	60	0	Text for property
56	BDMQMB2	☐	VVBDMQMB2_2	WRTV8	CURR	15	2	Land Price: Purchase Price
57	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
58	XGRQAL	☐	VVXGRQAL2	VVXTEXT20	CHAR	20	0	Property: Quality of location
59	SGRQAL	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
60	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map
61	XGRNART	☐	VVXGRNART	TEXT40	CHAR	40	0	Usage Type of Property According to Land Use Map
62	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	*
63	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
64	DBEPLAN	☐	VVDBEPLAN	DDAT	DATS	8	0	Development plan: date
65	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
66	STTXT_EXT	☐	VVXSTXTEXT	CHAR40	CHAR	40	0	Status: Set by user
67	STTXT_INT	☐	VVXSTTXTIN	CHAR40	CHAR	40	0	Status: Set by system
68	ONTBMZ	☐	VVBNTBMZS	DEC6_2	DEC	8	2	Actual usage: Construction Dimension No. (Total)
69	ONTGFZ	☐	VVBNTGFZS	DEC6_2	DEC	8	2	Actual usage: Amount of floor-area ratio (total)
70	ONTGRZ	☐	VVBNTGRZS	DEC6_2	DEC	8	2	Actual usage: Amount of floor area ratio (total)
71	DVERKAUF	☐	VVDVERKAU2	DATUM	DATS	8	0	Date: Sale
72	DVRKPLAN	☐	VVDVRKPLA2	DATUM	DATS	8	0	Date: Planned sale
73	BDMQMB1	☐	VVBDMQMB1	WRBTR	CURR	11	2	Land price: market value
74	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
75	ONZBMZ	☐	VVBNZBMZS	DEC6_2	DEC	8	2	Permitted usage: Construct.dimension no. (total)
76	ONZGFZ	☐	VVBNZGFZS	DEC6_2	DEC	8	2	Permitted usage: floor-area ratio (total)
77	ONZGRZ	☐	VVBNZGRZS	DEC6_2	DEC	8	2	Allowed Usage: Site Occupancy Index (Total)
78	DWIRTUB	☐	VVDWIRTUB2	DATUM	DATS	8	0	Date: Transfer usage/charges
79	XUNART	☐	VVXUNART	XTEXT35	CHAR	35	0	Main usage type
80	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
81	ANLN1	☐	VVANLN1	ANLN1	CHAR	12	0	Asset: main number	*
82	ANLN2	☐	VVANLN2	ANLN2	CHAR	4	0	Asset: Subnumber	*
83	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
84	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
85	XGEMARK	☐	VVGEMARK	VVGEMARK	CHAR	12	0	Local Subdistrict	*
86	NFLURNR	☐	NFLURNR	NFLURNR	CHAR	6	0	Number of Tract of Land in Land Register
87	XFLURST	☐	XFLURST	TEXT10	CHAR	10	0	Parcel of Land
88	BRFLURST	☐	VVBRFLURST	VVBRFLURST	CHAR	4	0	Fractional Parcel of Land
89	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	*
90	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	*
91	ZULBAUH	☐	VVZULBAUH	VVZULBAUH	QUAN	4	0	Permitted building height
92	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
93	XGEMEINDE	☐	VVXGEMEINDE	VVXGEMEINDE	CHAR	50	0	Name of municipality
94	XKREIS	☐	VVXKREIS	VVXKREIS	CHAR	30	0	Name of district
95	XREGIO	☐	VVXREGIO	VVXREGIO	CHAR	30	0	Name of federal state
96	XERBBAU	☐	VVXERBBAU	XTEXT30	CHAR	30	0	Heritable building right
97	XLGEMARK	☐	VVLGEMARK	VVLGEMARK	CHAR	25	0	Explanation of sub-district
98	.INCLUDE	☐				0	0	Customer Fields LIS: Include for Infostructure
99	DUMMYFIELD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
100	.INCLUDE	☐				0	0
101	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S404	BUKRS	T001	BUKRS
2	S404	BUKRS_01	T001	BUKRS	KEY	1	CN
3	S404	FEINS	T006	MSEHI
4	S404	GSBER	TGSB	GSBER
5	S404	GSBER_01	TGSB	GSBER
6	S404	MANDT	T000	MANDT
7	S404	OBJNR	ONR00	OBJNR
8	S404	SFLART	TIV08	SFLART
9	S404	SGRART	TIV56	SGRART
10	S404	SGRFRM	TIV58	SGRFRM
11	S404	SGRGZS	TIV59	SGRGZS
12	S404	SGRNR	VIOB02	SGRNR
13	S404	SGRNR_03	VIOB02	SGRNR
14	S404	SGRQAL	TIV57	SGRQAL
15	S404	SGRUNDB	VIGBUCH	SGRUNDB
16	S404	SUNUTZA	TIV36	SUNART
17	S404	SWENR	VIOB01	SWENR
18	S404	SWENR_02	VIOB01	SWENR
19	S404	USRCUKY1	TCURC	WAERS
20	S404	USRCUKY2	TCURC	WAERS
21	S404	USRUNIT1	T006	MSEHI
22	S404	USRUNIT2	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in