VIXCITCADRO SAP (Temporary rental object data) Table details
Dictionary Type: Table
Description: Temporary rental object data
Description: Temporary rental object data
Table field list including key, data, relationships and ABAP select examples
VIXCITCADRO is a standard SAP Table which is used to store Temporary rental object data data and is available within R/3 SAP systems depending on the version and release level.
The VIXCITCADRO table consists of various fields, each holding specific information or linking keys about Temporary rental object data data available in SAP. These include PROCESSID (ID of Splitting/Merging Process), KEY_DATE (Date), ORIG_INTRENO (Internal Key of Real Estate Object), NEW_INTRENO (Internal Key of Real Estate Object).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VIXCITCADRO table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PROCESSID | ID of Splitting/Merging Process | REXCITCADPROC | NUMC | 8 | VVSSOLLID | ||||
KEY_DATE | Date | DATUM | DATS | 8 | DATUM | ||||
ORIG_INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
NEW_INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
CADOPERATION | Process Type with Architectural Object | REXCITCADOP | CHAR | 1 | REXCITCADOP | ||||
OBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
IMKEY | Internal Key of Real Estate Object (FI) | RECAIMKEY | CHAR | 8 | IMKEY | IMKEY | RECLFXCAIMKEY | ||
CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | RECACREATIONTYPE | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
RESPONSIBLE | Person Responsible | RECARESPONSIBLE | CHAR | 12 | USR02 | XUBNAME | USER_COMP | ||
USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | CHAR | 12 | USR02 | XUBNAME | USER_COMP | ||
AUTHGRP | Authorization Group | RECAAUTHGRP | CHAR | 40 | RECAAUTHGRP | ||||
VALIDFROM | Date: Object Valid From | REBDOBJVALIDFROM | DATS | 8 | RECADATEBEG | ||||
VALIDTO | Date: Object Valid To | REBDOBJVALIDTO | DATS | 8 | REDAT | RECADATEEND | |||
ROTYPE | Rental Object Type | REBDROTYPE | CHAR | 2 | REBDROTYPE | REBDROTYPE | |||
SNUNR | Usage Type of Rental Object | REBDUSAGETYPE | NUMC | 4 | TIV01 | SNUNR | REBDUSAGETYPE | REBDUSAGETYPE | |
XMETXT | Rental Object Name | REBDXRO | CHAR | 60 | RECAXLDESCRIPTION | ||||
SGRNR | Number of Land | REBDPRNO | CHAR | 8 | SGRNR | REBDPRNO | REBDPRNO | REBDPRNO | |
SGENR | Number of Building | REBDBUNO | CHAR | 8 | SGENR | REBDBUNO | REBDBUNO | REBDBUNO | |
SALTNR | Number of rental unit in existing real estate system | SALTNR | CHAR | 20 | SALTNR | ||||
CANBECOMMON | Common Usage Possible | REBDCANBECOMMON | CHAR | 1 | RECABOOL | ||||
FIRSTPOSTING | Cash Flow Generated Starting On | RECDCFSTARTFROM | DATS | 8 | RECADATE | ||||
DBEZU | Date of initial usage | DBEZU | DATS | 8 | DDAT | ||||
DWTVERM | Date: Subsequent rental | DWTVERM | DATS | 8 | DATUM | ||||
DRESAB | Date: Reserved from | DRESA | DATS | 8 | DDAT | ||||
DRESBIS | Date: Reserved upto | DRESB | DATS | 8 | DDAT | ||||
SGEBT | Part of Building | SGEBT | CHAR | 2 | TIV12 | SGEBT | |||
RLRAFIXFITCATE | Fixtures and Fittings Category | REAJRLRAFIXFITCATE | CHAR | 6 | TIVAJRLRAFFCT | ALPHA | REAJRLRAFIXFITCATE | ||
RLRALOC | Location Class | REAJRLRALOC | CHAR | 6 | TIVAJRLRALOC | ALPHA | REAJRLRALOC | ||
PZUABSP | Increase or Reduction for Representative List of Rents | REBDSUREPERCENT | DEC | 4(2) | REBDSUREPERCENT | ||||
SPOSINMSP | Method for Calculating Base Rent of Rep. List of Rents | REBDRLRABASEIND | CHAR | 1 | REAJRLRAADJMBASE | ||||
PPOSINMSP | Percentage for Positioning RU in RLR Spread | REBDRLRAPERCENT | DEC | 5(2) | DECV3_2 | ||||
PERHOE | Percentage rate increase | PERHOE | DEC | 5(2) | DEC3_2 | ||||
RPROZGRD | Reason for variance in rate of percentage increase | RPROZGRD | CHAR | 2 | TIV43 | RPROZGRD | |||
RLGESCH | Location on Floor | RLGESCH | CHAR | 2 | TIV38 | ALPHA | RLGESCH | ||
XSTANDNR | Number of garage / parking space | VVXSTANDNR | CHAR | 5 | ALPHA | VVXSTANDNR | |||
JEIGWOHN | Rental Unit in Separate Ownership (COA) | VVJEIGWOHN | CHAR | 1 | JANE | ||||
SSTOCKW | Floor | VVSSTOCKW | NUMC | 3 | TIV37 | VVSSTOCKW | |||
SSTCKBIS | For RUs with Multiple Floors: Top Floor of RU | VVSSTCKBIS | NUMC | 3 | TIV37 | VVSSTOCKW | |||
DRESTAUR | Date of reconstruction/extensive modernization | VVDRESTAUR | DATS | 8 | DATUM | ||||
CFARCHIVEDTO | Date Up to Which the Cash Flow Is Archived | RECDCFARCHIVEDTO | DATS | 8 | RECADATE | ||||
CFLOCKEDTO | Date Until Which the Cash Flow Is Locked | RECDCFLOCKEDTO | DATS | 8 | RECADATE | ||||
CFPOSTINGFROM | First Posting From | RECDCFPOSTINGFROM | DATS | 8 | RECADATE | ||||
HASCOP | Uses Current Occupancy Principle | RESCHASCOP | CHAR | 1 | RECABOOL | ||||
RLRA | Representative List of Rents | REAJRLRA | CHAR | 6 | TIVAJRLRA | ALPHA | REAJRLRA | ||
USESRLRA | Representative List of Rents Is Used | REAJUSESRLRA | CHAR | 1 | RECABOOL | ||||
BUILDYEAR | ConstYr | VVYBAUJAHR | DATS | 8 | DATUM | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
COMMONOWNED | Rental Object Is Common Property | REBDCOMMONOWNED | CHAR | 1 | RECABOOL | ||||
OOLOCK | Do Not Consider Object for Real Estate Search | REOROOLOCK | CHAR | 1 | RECABOOL | ||||
NEIGHBORH1 | Neighborhood | REBDNEIGHBORHOOD | CHAR | 30 | TIVBDNEIGHBORH | REBDNEIGHBORHOOD | |||
NEIGHBORH2 | Neighborhood | REBDNEIGHBORHOOD | CHAR | 30 | TIVBDNEIGHBORH | REBDNEIGHBORHOOD | |||
NEIGHBORH3 | Neighborhood | REBDNEIGHBORHOOD | CHAR | 30 | TIVBDNEIGHBORH | REBDNEIGHBORHOOD | |||
.INCLU--AP | 0 | ||||||||
EDID | Federal Building Entrance Identification Number (EDID) | REXCCHEDID | NUMC | 2 | REXCCHEDID | ||||
EGID | Federal Building Identification Number (EGID) | REXCCHEGID | NUMC | 9 | REXCCHEGID | ||||
FLOOR | Code of Floor | REXCCHROFLOOR | NUMC | 4 | Assigned to domain | REXCCHROFLOOR | |||
FLOORLOC | Location of Dwelling on a Floor | REXCCHROFLOORLOC | CHAR | 40 | ALPHA | REXCCHROFLOORLOC | |||
EWID | Federal Dwelling Identification Number (EWID) | REXCCHEWID | NUMC | 3 | REXCCHEWID | ||||
KITCHEN | Code of Cooking Facilities | REXCCHROKITCHEN | NUMC | 4 | Assigned to domain | REXCCHROKITCHEN | |||
ADMINNO | Administrative Dwelling Number | REXCCHROADMINNO | CHAR | 12 | ALPHA | REXCCHROADMINNO | |||
DOORNO | Door Number of Dwelling | REXCCHRODOORNO | CHAR | 8 | ALPHA | REXCCHRODOORNO | |||
OBJCOND | Code of Dwelling Status | REXCCHROCOND | NUMC | 4 | Assigned to domain | REXCCHROCOND | |||
YEARDECONSTR | Year of Demolition | REXCCHBUDECONYEAR | DATS | 8 | DATUM | ||||
NUMROOMS | Number of Rooms in the Dwelling | REXCCHRONUMROOMS | NUMC | 4 | REXCCHRONUMROOMS | ||||
LIVINGAREA | Floor Area of Dwelling in M2 | REXCCHROAREA | DEC | 10(2) | REXCCHGWRFORMATUNITFIELD | ||||
USAGETYPE | Code of Usage Type | REXCCHROUSAGETYPE | NUMC | 4 | Assigned to domain | REXCCHROUSAGETYPE | |||
GEMEINDECH | Land Register District | RELMLRDISTRICT | CHAR | 6 | Assigned to domain | RELMLRDISTRICT | RELMLRDISTRICT | RELMLRDIST | |
.INCLU--AP | 0 | ||||||||
VPT | Property Taxable Value | REXCPTVPT_NOSIGN | CURR | 15(2) | REXCPTVPT_NOSIGN | ||||
VPTCURRENCY | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
CONDK | Conservation Level | REXCPTRACONS | CHAR | 4 | TIVXCPTRACONS |
Key field | Non-key field |
How do I retrieve data from SAP table VIXCITCADRO using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIXCITCADRO to SELECT all data from the tableDATA: WA_VIXCITCADRO TYPE VIXCITCADRO.
SELECT SINGLE *
FROM VIXCITCADRO
INTO CORRESPONDING FIELDS OF WA_VIXCITCADRO
WHERE...
How to access SAP table VIXCITCADRO
Within an ECC or HANA version of SAP you can also view further information about VIXCITCADRO and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects