SAP ABAP Table VIXCITCADRO (Temporary rental object data)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX (Application Component) Flexible Real Estate Management
⤷ RE_XC_RA_IT (Package) RE: XC - Localisation of Flexible Real Estate for Italy
⤷ RE-FX (Application Component) Flexible Real Estate Management
⤷ RE_XC_RA_IT (Package) RE: XC - Localisation of Flexible Real Estate for Italy
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | VIXCITCADRO | Table Relationship Diagram |
Short Description | Temporary rental object data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | L | Table for storing temporary data, delivered empty |
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 | * | |
2 | .INCLUDE | 0 | 0 | Key for Cadaster temporary data of AO merging/splitting (VIX | |||||
3 | PROCESSID | REXCITCADPROC | VVSSOLLID | NUMC | 8 | 0 | ID of Splitting/Merging Process | ||
4 | KEY_DATE | DATUM | DATUM | DATS | 8 | 0 | Date | ||
5 | ORIG_INTRENO | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
6 | NEW_INTRENO | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
7 | .INCLUDE | 0 | 0 | Rental object | |||||
8 | CADOPERATION | REXCITCADOP | REXCITCADOP | CHAR | 1 | 0 | Process Type with Architectural Object | ||
9 | .INCLUDE | 0 | 0 | Rental Object: Non-Key Fields | |||||
10 | OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
11 | IMKEY | RECAIMKEY | IMKEY | CHAR | 8 | 0 | Internal Key of Real Estate Object (FI) | ||
12 | CREATIONTYPE | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 1 | 0 | How the Object Was Created | ||
13 | .INCLUDE | 0 | 0 | Field String for Maintenance of User Data | |||||
14 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
15 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
16 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
17 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
18 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
19 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
20 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
21 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
22 | RESPONSIBLE | RECARESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | USR02 | |
23 | USEREXCLUSIVE | RECAUSEREXCLUSIVE | XUBNAME | CHAR | 12 | 0 | User with Exclusive Change Authorization | USR02 | |
24 | AUTHGRP | RECAAUTHGRP | RECAAUTHGRP | CHAR | 40 | 0 | Authorization Group | ||
25 | VALIDFROM | REBDOBJVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date: Object Valid From | ||
26 | VALIDTO | REBDOBJVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Object Valid To | ||
27 | ROTYPE | REBDROTYPE | REBDROTYPE | CHAR | 2 | 0 | Rental Object Type | ||
28 | SNUNR | REBDUSAGETYPE | SNUNR | NUMC | 4 | 0 | Usage Type of Rental Object | TIV01 | |
29 | XMETXT | REBDXRO | RECAXLDESCRIPTION | CHAR | 60 | 0 | Rental Object Name | ||
30 | SGRNR | REBDPRNO | REBDPRNO | CHAR | 8 | 0 | Number of Land | ||
31 | SGENR | REBDBUNO | REBDBUNO | CHAR | 8 | 0 | Number of Building | ||
32 | SALTNR | SALTNR | SALTNR | CHAR | 20 | 0 | Number of rental unit in existing real estate system | ||
33 | CANBECOMMON | REBDCANBECOMMON | RECABOOL | CHAR | 1 | 0 | Common Usage Possible | ||
34 | FIRSTPOSTING | RECDCFSTARTFROM | RECADATE | DATS | 8 | 0 | Cash Flow Generated Starting On | ||
35 | DBEZU | DBEZU | DDAT | DATS | 8 | 0 | Date of initial usage | ||
36 | DWTVERM | DWTVERM | DATUM | DATS | 8 | 0 | Date: Subsequent rental | ||
37 | DRESAB | DRESA | DDAT | DATS | 8 | 0 | Date: Reserved from | ||
38 | DRESBIS | DRESB | DDAT | DATS | 8 | 0 | Date: Reserved upto | ||
39 | SGEBT | SGEBT | SGEBT | CHAR | 2 | 0 | Part of Building | TIV12 | |
40 | RLRAFIXFITCATE | REAJRLRAFIXFITCATE | REAJRLRAFIXFITCATE | CHAR | 6 | 0 | Fixtures and Fittings Category | TIVAJRLRAFFCT | |
41 | RLRALOC | REAJRLRALOC | REAJRLRALOC | CHAR | 6 | 0 | Location Class | TIVAJRLRALOC | |
42 | PZUABSP | REBDSUREPERCENT | REBDSUREPERCENT | DEC | 4 | 2 | Increase or Reduction for Representative List of Rents | ||
43 | SPOSINMSP | REBDRLRABASEIND | REAJRLRAADJMBASE | CHAR | 1 | 0 | Method for Calculating Base Rent of Rep. List of Rents | ||
44 | PPOSINMSP | REBDRLRAPERCENT | DECV3_2 | DEC | 5 | 2 | Percentage for Positioning RU in RLR Spread | ||
45 | PERHOE | PERHOE | DEC3_2 | DEC | 5 | 2 | Percentage rate increase | ||
46 | RPROZGRD | RPROZGRD | RPROZGRD | CHAR | 2 | 0 | Reason for variance in rate of percentage increase | TIV43 | |
47 | RLGESCH | RLGESCH | RLGESCH | CHAR | 2 | 0 | Location on Floor | TIV38 | |
48 | XSTANDNR | VVXSTANDNR | VVXSTANDNR | CHAR | 5 | 0 | Number of garage / parking space | ||
49 | JEIGWOHN | VVJEIGWOHN | JANE | CHAR | 1 | 0 | Rental Unit in Separate Ownership (COA) | ||
50 | SSTOCKW | VVSSTOCKW | VVSSTOCKW | NUMC | 3 | 0 | Floor | TIV37 | |
51 | SSTCKBIS | VVSSTCKBIS | VVSSTOCKW | NUMC | 3 | 0 | For RUs with Multiple Floors: Top Floor of RU | TIV37 | |
52 | DRESTAUR | VVDRESTAUR | DATUM | DATS | 8 | 0 | Date of reconstruction/extensive modernization | ||
53 | CFARCHIVEDTO | RECDCFARCHIVEDTO | RECADATE | DATS | 8 | 0 | Date Up to Which the Cash Flow Is Archived | ||
54 | CFLOCKEDTO | RECDCFLOCKEDTO | RECADATE | DATS | 8 | 0 | Date Until Which the Cash Flow Is Locked | ||
55 | CFPOSTINGFROM | RECDCFPOSTINGFROM | RECADATE | DATS | 8 | 0 | First Posting From | ||
56 | HASCOP | RESCHASCOP | RECABOOL | CHAR | 1 | 0 | Uses Current Occupancy Principle | ||
57 | RLRA | REAJRLRA | REAJRLRA | CHAR | 6 | 0 | Representative List of Rents | TIVAJRLRA | |
58 | USESRLRA | REAJUSESRLRA | RECABOOL | CHAR | 1 | 0 | Representative List of Rents Is Used | ||
59 | BUILDYEAR | VVYBAUJAHR | DATUM | DATS | 8 | 0 | ConstYr | ||
60 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
61 | COMMONOWNED | REBDCOMMONOWNED | RECABOOL | CHAR | 1 | 0 | Rental Object Is Common Property | ||
62 | OOLOCK | REOROOLOCK | RECABOOL | CHAR | 1 | 0 | Do Not Consider Object for Real Estate Search | ||
63 | NEIGHBORH1 | REBDNEIGHBORHOOD | REBDNEIGHBORHOOD | CHAR | 30 | 0 | Neighborhood | TIVBDNEIGHBORH | |
64 | NEIGHBORH2 | REBDNEIGHBORHOOD | REBDNEIGHBORHOOD | CHAR | 30 | 0 | Neighborhood | TIVBDNEIGHBORH | |
65 | NEIGHBORH3 | REBDNEIGHBORHOOD | REBDNEIGHBORHOOD | CHAR | 30 | 0 | Neighborhood | TIVBDNEIGHBORH | |
66 | .INCLUDE | 0 | 0 | ||||||
67 | .INCLU--AP | 0 | 0 | Country Specific fields for Switzerland | |||||
68 | .INCLUDE | 0 | 0 | Rental Object Customer fields | |||||
69 | EDID | REXCCHEDID | REXCCHEDID | NUMC | 2 | 0 | Federal Building Entrance Identification Number (EDID) | ||
70 | EGID | REXCCHEGID | REXCCHEGID | NUMC | 9 | 0 | Federal Building Identification Number (EGID) | ||
71 | FLOOR | REXCCHROFLOOR | REXCCHROFLOOR | NUMC | 4 | 0 | Code of Floor | * | |
72 | FLOORLOC | REXCCHROFLOORLOC | REXCCHROFLOORLOC | CHAR | 40 | 0 | Location of Dwelling on a Floor | ||
73 | EWID | REXCCHEWID | REXCCHEWID | NUMC | 3 | 0 | Federal Dwelling Identification Number (EWID) | ||
74 | KITCHEN | REXCCHROKITCHEN | REXCCHROKITCHEN | NUMC | 4 | 0 | Code of Cooking Facilities | * | |
75 | ADMINNO | REXCCHROADMINNO | REXCCHROADMINNO | CHAR | 12 | 0 | Administrative Dwelling Number | ||
76 | DOORNO | REXCCHRODOORNO | REXCCHRODOORNO | CHAR | 8 | 0 | Door Number of Dwelling | ||
77 | OBJCOND | REXCCHROCOND | REXCCHROCOND | NUMC | 4 | 0 | Code of Dwelling Status | * | |
78 | YEARDECONSTR | REXCCHBUDECONYEAR | DATUM | DATS | 8 | 0 | Year of Demolition | ||
79 | NUMROOMS | REXCCHRONUMROOMS | REXCCHRONUMROOMS | NUMC | 4 | 0 | Number of Rooms in the Dwelling | ||
80 | LIVINGAREA | REXCCHROAREA | REXCCHGWRFORMATUNITFIELD | DEC | 10 | 2 | Floor Area of Dwelling in M2 | ||
81 | USAGETYPE | REXCCHROUSAGETYPE | REXCCHROUSAGETYPE | NUMC | 4 | 0 | Code of Usage Type | * | |
82 | GEMEINDECH | RELMLRDISTRICT | RELMLRDISTRICT | CHAR | 6 | 0 | Land Register District | * | |
83 | .INCLU--AP | 0 | 0 | Country-Specific fields for Portugal | |||||
84 | .INCLUDE | 0 | 0 | Country-Specific Fields for Portugal - Rental Object | |||||
85 | VPT | REXCPTVPT_NOSIGN | REXCPTVPT_NOSIGN | CURR | 15 | 2 | Property Taxable Value | ||
86 | VPTCURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
87 | CONDK | REXCPTRACONS | CHAR | 4 | 0 | Conservation Level | TIVXCPTRACONS |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VIXCITCADRO | CONDK | TIVXCPTRACONS | CONSLEVEL | |||
2 | VIXCITCADRO | CURRENCY | TCURC | WAERS | KEY | 1 | CN |
3 | VIXCITCADRO | NEIGHBORH1 | TIVBDNEIGHBORH | NEIGHBORHOOD | |||
4 | VIXCITCADRO | NEIGHBORH2 | TIVBDNEIGHBORH | NEIGHBORHOOD | |||
5 | VIXCITCADRO | NEIGHBORH3 | TIVBDNEIGHBORH | NEIGHBORHOOD | |||
6 | VIXCITCADRO | RESPONSIBLE | USR02 | BNAME | REF | 1 | CN |
7 | VIXCITCADRO | RLGESCH | TIV38 | RLGESCH | REF | C | CN |
8 | VIXCITCADRO | RLRA | TIVAJRLRA | RLRA | KEY | 1 | CN |
9 | VIXCITCADRO | RLRAFIXFITCATE | TIVAJRLRAFFCT | RLRAFIXFITCATE | REF | C | CN |
10 | VIXCITCADRO | RLRALOC | TIVAJRLRALOC | RLRALOC | REF | C | CN |
11 | VIXCITCADRO | RPROZGRD | TIV43 | RPROZGRD | KEY | 1 | CN |
12 | VIXCITCADRO | SGEBT | TIV12 | SGEBT | REF | C | CN |
13 | VIXCITCADRO | SNUNR | TIV01 | SNUNR | |||
14 | VIXCITCADRO | SSTCKBIS | TIV37 | SSTOCKW | REF | C | CN |
15 | VIXCITCADRO | SSTOCKW | TIV37 | SSTOCKW | REF | C | CN |
16 | VIXCITCADRO | USEREXCLUSIVE | USR02 | BNAME | REF | C | CN |
17 | VIXCITCADRO | VPTCURRENCY | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 607 |