SAP ABAP Table RECP_OI_DOC_PR_DETAIL (Basic Data of Property)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_XX (Package) RE: Obsolete Objects (Do Not Delete!!!)

Basic Data

Table Category	INTTAB	Structure
Structure	RECP_OI_DOC_PR_DETAIL	Table Relationship Diagram
Short Description	Basic Data of Property

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	SWENR	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
3	SGRNR	☐	REBDPRNO	REBDPRNO	CHAR	8	0	Number of Land
4	REALVALIDFROM	☐	REBDREALVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid from (Effective)
5	REALVALIDTO	☐	REBDREALVALIDTO	RECADATEEND	DATS	8	0	Date: Valid to (Effective)
6	XGRTXT	☐	REBDXPR	RECAXLDESCRIPTION	CHAR	60	0	Name of Land
7	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
8	BDMQMB1	☐	BDMQMB1	WRTV7	CURR	13	2	Market value
9	BDMQMB2	☐	BDMQMB2	WRTV7	CURR	13	2	Purchase price
10	BDNRWERT	☐	BDNRWERT	WRTV7	CURR	13	2	Land reference value for determining current market value
11	BDNWERT	☐	BDNWERT	WRTV7	CURR	13	2	Land value for determining current market value
12	DBDNWERT	☐	DBDNWERT	DDAT	DATS	8	0	Date of land value
13	RBEPLAN	☐	RBEPLAN	XMBEZ	CHAR	30	0	Development plan
14	DBEPLAN	☐	DBEPLAN	DDAT	DATS	8	0	Date of development plan
15	XNUTZGRU	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
16	NZGRZ	☐	NZGRZ	DEC1_2	DEC	3	2	Permitted Usage: Site Occupancy Index
17	NZGFZ	☐	NZGFZ	DEC2_2	DEC	4	2	Permitted Usage: Floor Area Ratio
18	NZBMZ	☐	NZBMZ	DEC3_2	DEC	5	2	Permitted Usage: Construction Dimension Number
19	NTGRZ	☐	NTGRZ	DEC1_2	DEC	3	2	Actual Usage: Site Occupancy Index
20	NTGFZ	☐	NTGFZ	DEC2_2	DEC	4	2	Actual Usage: Floor Area Ratio
21	NTBMZ	☐	NTBMZ	DEC3_2	DEC	5	2	Actual Usage: Construction Dimension Number
22	RNBPLAN	☐	RNBPLAN	RGRNART	CHAR	4	0	Usage type according to development plan	TIVB3
23	SGRART	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
24	SGRQAL	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
25	SGRFRM	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
26	SGRGZS	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
27	DWIRTUB	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
28	DVERKAUF	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
29	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
30	JUNUTZA	☐	VVJUNUTZA	JANE	CHAR	1	0	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
31	DVRKPLAN	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
32	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
33	XGEMARK	☐	VVGEMARK	VVGEMARK	CHAR	12	0	Local Subdistrict	TIVG2
34	NFLURNR	☐	NFLURNR	NFLURNR	CHAR	6	0	Number of Tract of Land in Land Register
35	XFLURST	☐	XFLURST	TEXT10	CHAR	10	0	Parcel of Land
36	BRFLURST	☐	VVBRFLURST	VVBRFLURST	CHAR	4	0	Fractional Parcel of Land
37	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
38	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
39	ZULBAUH	☐	VVZULBAUH	VVZULBAUH	QUAN	4	0	Permitted building height
40	LEINS	☐	VVLEINS	MEINS	UNIT	3	0	Unit of length	*
41	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
42	XWETEXT	☐	REBDXBE	RECAXLDESCRIPTION	CHAR	60	0	Business Entity Name
43	XUNART	☐	VVXUNART	XTEXT35	CHAR	35	0	Main usage type
44	KTEXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
45	XGEMEINDE	☐	VVXGEMEINDE	VVXGEMEINDE	CHAR	50	0	Name of municipality
46	XKREIS	☐	VVXKREIS	VVXKREIS	CHAR	30	0	Name of district
47	XREGIO	☐	VVXREGIO	VVXREGIO	CHAR	30	0	Name of federal state
48	LGEMARK	☐	VVLGEMARK	VVLGEMARK	CHAR	25	0	Explanation of sub-district
49	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
50	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECP_OI_DOC_PR_DETAIL	BUKRS	T001	BUKRS	KEY	1	CN
2	RECP_OI_DOC_PR_DETAIL	GEMEINDE	TIVG1	GEMEINDE	KEY	1	CN
3	RECP_OI_DOC_PR_DETAIL	JERBBAU	TDO9	SOBJERBBAU
4	RECP_OI_DOC_PR_DETAIL	RGRNART	TIVC4	RGRNART	KEY	1	CN
5	RECP_OI_DOC_PR_DETAIL	RNBPLAN	TIVB3	RNBPLAN		1	CN
6	RECP_OI_DOC_PR_DETAIL	SGRART	TIV56	SGRART	KEY	1	CN
7	RECP_OI_DOC_PR_DETAIL	SGRFRM	TIV58	SGRFRM	KEY	1	CN
8	RECP_OI_DOC_PR_DETAIL	SGRGZS	TIV59	SGRGZS	KEY	1	CN
9	RECP_OI_DOC_PR_DETAIL	SGRQAL	TIV57	SGRQAL	KEY	1	CN
10	RECP_OI_DOC_PR_DETAIL	SUNUTZA	TIV36	SUNART	KEY	1	CN
11	RECP_OI_DOC_PR_DETAIL	XGEMARK	TIVG2	GEMARK

History

Last changed by/on	SAP	20060208
SAP Release Created in	110