SAP ABAP Table TXI_VIOB02 (Property master data)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ CA-GTF-DRT (Application Component) Data Retention Tool
⤷ FA_ILM (Package) Information Lifecycle Management
⤷ CA-GTF-DRT (Application Component) Data Retention Tool
⤷ FA_ILM (Package) Information Lifecycle Management
Basic Data
Table Category | INTTAB | Structure |
Structure | TXI_VIOB02 | Table Relationship Diagram |
Short Description | Property master data |
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 | .INCLUDE | 0 | 0 | Property master data | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
4 | SWENR | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | VIOB01 | |
5 | SGRNR | SGRNR | SGRNR | CHAR | 8 | 0 | Land Number for BE | * | |
6 | XGRTXT | XGRTXT | XLBEZ | CHAR | 60 | 0 | Text for property | ||
7 | SGRUNDB | SGRUNDB | SGRUNDB | NUMC | 8 | 0 | Land register number | VIGBUCH | |
8 | RGRNART | RGRNART | CHAR2 | CHAR | 2 | 0 | Usage Type of Property According to Land Use Map | TIVC4 | |
9 | BDMQMB1 | BDMQMB1 | WRTV7 | CURR | 13 | 2 | Market value | ||
10 | BDMQMB2 | BDMQMB2 | WRTV7 | CURR | 13 | 2 | Purchase price | ||
11 | BDNRWERT | BDNRWERT | WRTV7 | CURR | 13 | 2 | Land reference value for determining current market value | ||
12 | BDNWERT | BDNWERT | WRTV7 | CURR | 13 | 2 | Land value for determining current market value | ||
13 | DBDNWERT | DBDNWERT | DDAT | DATS | 8 | 0 | Date of land value | ||
14 | RBEPLAN | RBEPLAN | XMBEZ | CHAR | 30 | 0 | Development plan | ||
15 | DBEPLAN | DBEPLAN | DDAT | DATS | 8 | 0 | Date of development plan | ||
16 | XNUTZGRU | XNUTZGRU | XMBEZ | CHAR | 30 | 0 | Current usage of property | ||
17 | NZGRZ | NZGRZ | DEC1_2 | DEC | 3 | 2 | Permitted Usage: Site Occupancy Index | ||
18 | NZGFZ | NZGFZ | DEC2_2 | DEC | 4 | 2 | Permitted Usage: Floor Area Ratio | ||
19 | NZBMZ | NZBMZ | DEC3_2 | DEC | 5 | 2 | Permitted Usage: Construction Dimension Number | ||
20 | NTGRZ | NTGRZ | DEC1_2 | DEC | 3 | 2 | Actual Usage: Site Occupancy Index | ||
21 | NTGFZ | NTGFZ | DEC2_2 | DEC | 4 | 2 | Actual Usage: Floor Area Ratio | ||
22 | NTBMZ | NTBMZ | DEC3_2 | DEC | 5 | 2 | Actual Usage: Construction Dimension Number | ||
23 | JVORKAUF | JVORKAUF | JANEI | CHAR | 1 | 0 | Preemptive right indicator | ||
24 | JAUSNAHM | JAUSNAHM | JANEI | CHAR | 1 | 0 | Special licence indicator | ||
25 | JGRUNDW | JGRUNDW | JANEI | CHAR | 1 | 0 | Ground water indicator | ||
26 | JUEBERS | JUEBERS | JANEI | CHAR | 1 | 0 | Danger of flooding indicator | ||
27 | RARTOPT | RARTOPT | RARTOPT | NUMC | 1 | 0 | Option rate calculation type | ||
28 | JLOESCH | JLOESCH | JLOESCH | CHAR | 1 | 0 | Real Estate Deletion Indicator/Flag | ||
29 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
30 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
31 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
32 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
33 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
34 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
35 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
36 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
37 | DAKTBEST | DAKTBEST | DATUM | DATS | 8 | 0 | Date active in portfolio | ||
38 | ADRNR | SOBJNR | SOBJNR | NUMC | 10 | 0 | Object number (virtual object) | SANO1 | |
39 | RNBPLAN | RNBPLAN | RGRNART | CHAR | 4 | 0 | Usage type according to development plan | TIVB3 | |
40 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
41 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
42 | J_OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
43 | RFAKT | VVRFAKT | VVRFAKT | NUMC | 6 | 0 | Conversion factor for fractional share of property | ||
44 | SGRART | VVSGRART | VVSGRART | NUMC | 4 | 0 | Property type | TIV56 | |
45 | SGRQAL | VVSGRQAL | VVSGRQAL | NUMC | 3 | 0 | Property: Quality of location | TIV57 | |
46 | SGRFRM | VVSGRFRM | VVSGRFRM | NUMC | 3 | 0 | Property ground type | TIV58 | |
47 | SGRGZS | VVSGRGZS | VVSGRGZS | NUMC | 3 | 0 | Overall condition of property | TIV59 | |
48 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
49 | DWIRTUB | VVDWIRTUB | DATUM | DATS | 8 | 0 | Transfer usage / charges | ||
50 | DVERKAUF | VVDVERKAUF | DATUM | DATS | 8 | 0 | Sale date | ||
51 | SUNUTZA | VVSUNART | VVSUNART | CHAR | 8 | 0 | Main usage type | TIV36 | |
52 | JUNUTZA | VVJUNUTZA | JANE | CHAR | 1 | 0 | Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 | ||
53 | PROFL | VVAPROF | APROF | CHAR | 6 | 0 | Settlement profile for costs | TKB1A | |
54 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
55 | DVRKPLAN | VVDVRKPLAN | DATUM | DATS | 8 | 0 | Planned sale | ||
56 | INTRENO | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
57 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
58 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
59 | BERGRP | VVBERGRP | VVBERGRP | CHAR | 40 | 0 | Authorization group | ||
60 | XGEMARK | VVGEMARK | VVGEMARK | CHAR | 12 | 0 | Local Subdistrict | TIVG2 | |
61 | NFLURNR | NFLURNR | NFLURNR | CHAR | 6 | 0 | Number of Tract of Land in Land Register | ||
62 | XFLURST | XFLURST | TEXT10 | CHAR | 10 | 0 | Parcel of Land | ||
63 | BRFLURST | VVBRFLURST | VVBRFLURST | CHAR | 4 | 0 | Fractional Parcel of Land | ||
64 | JERBBAU | JERBBAU | SOBJERBBAU | CHAR | 1 | 0 | Heritable building right indicator | TDO9 | |
65 | GEMEINDE | VVGEMEINDE | VVGEMEINDE | CHAR | 8 | 0 | Municipality key | TIVG1 | |
66 | ZULBAUH | VVZULBAUH | VVZULBAUH | QUAN | 4 | 0 | Permitted building height | ||
67 | LEINS | VVLEINS | MEINS | UNIT | 3 | 0 | Unit of length | * | |
68 | .INCLUDE | 0 | 0 | ||||||
69 | .INCLU--AP | 0 | 0 | OBSOLETE: Property: Append Fields | |||||
70 | .INCLUDE | 0 | 0 | OBSOLETE: Property: Append Fields | |||||
71 | .INCLUDE | 0 | 0 | OBSOLETE: Shared Master Data Fields: Append Fields | |||||
72 | VALIDFROM | REBDOBJVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date: Object Valid From | ||
73 | VALIDTO | REBDOBJVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Object Valid To | ||
74 | CREATIONTYPE | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 1 | 0 | How the Object Was Created | ||
75 | RESPONSIBLE | RECARESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | * | |
76 | USEREXCLUSIVE | RECAUSEREXCLUSIVE | XUBNAME | CHAR | 12 | 0 | User with Exclusive Change Authorization | * | |
77 | BDMQMB1_CY | SYCUKY | SYCUKY | CUKY | 5 | 0 | CUKY for SYST | ||
78 | BDMQMB2_CY | SYCUKY | SYCUKY | CUKY | 5 | 0 | CUKY for SYST | ||
79 | BDNRWERT_CY | SYCUKY | SYCUKY | CUKY | 5 | 0 | CUKY for SYST | ||
80 | BDNWERT_CY | SYCUKY | SYCUKY | CUKY | 5 | 0 | CUKY for SYST | ||
81 | ZULBAUH_QY | UNIT | EINHEIT | UNIT | 3 | 0 | Unit |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TXI_VIOB02 | ADRNR | SANO1 | OBJNR | KEY | 1 | C |
2 | TXI_VIOB02 | BUKRS | T001 | BUKRS | KEY | 1 | CN |
3 | TXI_VIOB02 | GEMEINDE | TIVG1 | GEMEINDE | KEY | 1 | CN |
4 | TXI_VIOB02 | GSBER | TGSB | GSBER | REF | 1 | CN |
5 | TXI_VIOB02 | JERBBAU | TDO9 | SOBJERBBAU | |||
6 | TXI_VIOB02 | J_OBJNR | ONR00 | OBJNR | KEY | 1 | CN |
7 | TXI_VIOB02 | KOKRS | TKA01 | KOKRS | REF | C | CN |
8 | TXI_VIOB02 | PRCTR | CEPC | PRCTR | KEY | 1 | CN |
9 | TXI_VIOB02 | PROFL | TKB1A | APROF | REF | C | CN |
10 | TXI_VIOB02 | RGRNART | TIVC4 | RGRNART | KEY | 1 | CN |
11 | TXI_VIOB02 | RNBPLAN | TIVB3 | RNBPLAN | 1 | CN | |
12 | TXI_VIOB02 | SGRART | TIV56 | SGRART | KEY | 1 | CN |
13 | TXI_VIOB02 | SGRFRM | TIV58 | SGRFRM | KEY | 1 | CN |
14 | TXI_VIOB02 | SGRGZS | TIV59 | SGRGZS | KEY | 1 | CN |
15 | TXI_VIOB02 | SGRQAL | TIV57 | SGRQAL | KEY | 1 | CN |
16 | TXI_VIOB02 | SGRUNDB | VIGBUCH | SGRUNDB | KEY | 1 | CN |
17 | TXI_VIOB02 | SUNUTZA | TIV36 | SUNART | KEY | 1 | CN |
18 | TXI_VIOB02 | SWENR | VIOB01 | SWENR | KEY | 1 | CN |
19 | TXI_VIOB02 | XGEMARK | TIVG2 | GEMARK |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 606 |