SAP ABAP Table BAPI_RE_PROPERTY (Land)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-BD (Application Component) Basic Data
     ⤷ RE_BD_PR (Package) RE: Property Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	BAPI_RE_PROPERTY	Table Relationship Diagram
Short Description	Land

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	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	BUSINESS_ENTITY	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
3	PROPERTY	☐	REBDPRNO	REBDPRNO	CHAR	8	0	Number of Land
4	IDENT_OBJECT_TYPE	☐	RECAIDENTTYPE	J_OBART	CHAR	2	0	ID Part of Object Type, such as "IS" (Real Estate Contract)	TBO00
5	IDENT_KEY	☐	RECAIDENTKEY	CHAR45	CHAR	45	0	ID Part Key, for example "1000/123"
6	CREATION_USER	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
7	CREATION_DATE	☐	DERF	DATUM	DATS	8	0	First Entered on
8	CREATION_TIME	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
9	LASTCHANGE_USER	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
10	LASTCHANGE_DATE	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
11	LASTCHANGE_TIME	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
12	PROPERTY_TEXT	☐	REBDXPR	RECAXLDESCRIPTION	CHAR	60	0	Name of Land
13	PROPERTY_TYPE	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
14	LOCATION_QUALITY	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
15	GROUND_TYPE	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
16	OVERALL_CONDITION	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
17	MARKET_VALUE	☐	REBDBAPIVALMARKET	BAPICURR	DEC	23	4	BAPI: Market Value
18	PURCHASE_PRICE	☐	REBDBAPIVALPURCHASE	BAPICURR	DEC	23	4	BAPI: Purchase Price
19	LAND_REFERENCE_VALUE	☐	REBDBAPIVALLANDREF	BAPICURR	DEC	23	4	BAPI: Land Reference Value for Determining Market Value
20	LAND_VALUE	☐	REBDBAPIVALLAND	BAPICURR	DEC	23	4	BAPI: Land Value for Determining Market Value
21	LAND_VALUE_DATE	☐	DBDNWERT	DDAT	DATS	8	0	Date of land value
22	DEVELOPMENT_PLAN	☐	RBEPLAN	XMBEZ	CHAR	30	0	Development plan
23	DEVELOPMENT_PLAN_DATE	☐	DBEPLAN	DDAT	DATS	8	0	Date of development plan
24	CURRENT_USAGE	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
25	USAGE_TYPE_LAND_USE_MAP	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map
26	USAGE_TYPE_DEVELOPMENT_PLAN	☐	RNBPLAN	RGRNART	CHAR	4	0	Usage type according to development plan
27	MAIN_USAGE_TYPE	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
28	PERM_USAGE_SITE_OCCUP_INDEX	☐	NZGRZ	DEC1_2	DEC	3	2	Permitted Usage: Site Occupancy Index
29	PERM_USAGE_FLOOR_AREA_RATIO	☐	NZGFZ	DEC2_2	DEC	4	2	Permitted Usage: Floor Area Ratio
30	PERM_USAGE_CONSTRCT_DIM_NO	☐	NZBMZ	DEC3_2	DEC	5	2	Permitted Usage: Construction Dimension Number
31	PERM_BUILDING_HEIGHT	☐	VVZULBAUH	VVZULBAUH	QUAN	4	0	Permitted building height
32	ACTL_USAGE_SITE_OCCUP_INDEX	☐	NTGRZ	DEC1_2	DEC	3	2	Actual Usage: Site Occupancy Index
33	ACTL_USAGE_FLOOR_AREA_RATIO	☐	NTGFZ	DEC2_2	DEC	4	2	Actual Usage: Floor Area Ratio
34	ACTL_USAGE_CONSTRCT_DIM_NO	☐	NTBMZ	DEC3_2	DEC	5	2	Actual Usage: Construction Dimension Number
35	TRANSF_USE_AND_ENCUMBR_DATE	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
36	PLANNED_SALE_DATE	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
37	SALE_DATE	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
38	LOCAL_SUBDISTRICT	☐	VVGEMARK	VVGEMARK	CHAR	12	0	Local Subdistrict	TIVG2
39	PLACE_IN_LAND_REGISTER	☐	NFLURNR	NFLURNR	CHAR	6	0	Number of Tract of Land in Land Register
40	PARCEL_OF_LAND	☐	XFLURST	TEXT10	CHAR	10	0	Parcel of Land
41	FRACT_PARCEL_OF_LAND	☐	VVBRFLURST	VVBRFLURST	CHAR	4	0	Fractional Parcel of Land
42	HERITABLE_BLDG_RIGHT_IND	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
43	MUNICIPALITY_KEY	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
44	UNIT_LENGTH	☐	VVLEINS	MEINS	UNIT	3	0	Unit of length	*
45	UNIT_LENGTH_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
46	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
47	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
48	AUTHORIZATION_GROUP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
49	OBJECT_VALID_FROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
50	OBJECT_VALID_TO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
51	REAL_VALID_FROM	☐	REBDREALVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid from (Effective)
52	REAL_VALID_TO	☐	REBDREALVALIDTO	RECADATEEND	DATS	8	0	Date: Valid to (Effective)
53	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
54	STAT_PROF	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	TJ20
55	MANDATE_OBJECT_ID	☐	REMMBUSOBJIDMN	CHAR45	CHAR	45	0	ID of Mandate Object in Mandate Company Code
56	MANDATE_MNG_OBJECT_ID	☐	REMMBUSOBJIDMNG	CHAR45	CHAR	45	0	ID of Mandate Object in Manager Company Code
57	MANDATE_CR_OBJECT_ID	☐	REMMBUSOBJIDCR	CHAR45	CHAR	45	0	ID of Mandate Object in Condominium Owner Company Code
58	FUNCTION	☐	REBDUSGFUNCTION	REBDUSGFUNCTION	CHAR	4	0	Function of Object	TIVBDUSGFUNC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI_RE_PROPERTY	FUNCTION	TIVBDUSGFUNC	USGFUNCTION	REF	C	CN
2	BAPI_RE_PROPERTY	GROUND_TYPE	TIV58	SGRFRM	REF	C	CN
3	BAPI_RE_PROPERTY	HERITABLE_BLDG_RIGHT_IND	TDO9	SOBJERBBAU	REF	C	CN
4	BAPI_RE_PROPERTY	IDENT_OBJECT_TYPE	TBO00	OBART	REF	1	CN
5	BAPI_RE_PROPERTY	LOCAL_SUBDISTRICT	TIVG2	GEMARK	REF	C	CN
6	BAPI_RE_PROPERTY	LOCATION_QUALITY	TIV57	SGRQAL	REF	C	CN
7	BAPI_RE_PROPERTY	MAIN_USAGE_TYPE	TIV36	SUNART	REF	C	CN
8	BAPI_RE_PROPERTY	MUNICIPALITY_KEY	TIVG1	GEMEINDE	REF	C	CN
9	BAPI_RE_PROPERTY	OVERALL_CONDITION	TIV59	SGRGZS	REF	C	CN
10	BAPI_RE_PROPERTY	PROPERTY_TYPE	TIV56	SGRART	REF	C	CN
11	BAPI_RE_PROPERTY	STAT_PROF	TJ20	STSMA	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	200