VIXCITICIDATA_TAB SAP (ICI Data - data fields) Structure details
Dictionary Type: Structure
Description: ICI Data - data fields
Description: ICI Data - data fields
ABAP Code to SELECT data from VIXCITICIDATA_TAB
Related tables to VIXCITICIDATA_TAB
Access table VIXCITICIDATA_TAB
Related tables to VIXCITICIDATA_TAB
Access table VIXCITICIDATA_TAB
Structure field list including key, data, relationships and ABAP select examples
VIXCITICIDATA_TAB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "ICI Data - data fields" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VIXCITICIDATA_TAB TYPE VIXCITICIDATA_TAB.
The VIXCITICIDATA_TAB table consists of various fields, each holding specific information or linking keys about ICI Data - data fields data available in SAP. These include DATETO (Date: Valid To), ICIAMOUNT (ICI/IMU Tax Amount), POSTALCODE (City postal code), CITY (City).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VIXCITICIDATA_TAB structure 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 |
| CURRENCY | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| DATETO | Date: Valid To | RECADATETO | DATS | 8 | REDAT | RECADATEEND | |||
| ICIAMOUNT | ICI/IMU Tax Amount | REXCITICIAMOUNT | CURR | 15(2) | RECACURR | ||||
| POSTALCODE | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
| CITY | City | AD_CITY1 | CHAR | 40 | TIVXCITICIPARAM | TEXT40 | CLCITYNAME | ||
| ICIRATE | ICI/IMU Rate | REXCITICIRATE | DEC | 5(2) | |||||
| ISMANUALRATE | Manually entered ICI/IMU rate differs from auto. det. rate | REXCITISMANUALRATE | CHAR | 1 | RECABOOL | ||||
| ICICOLLECTOR | Name of the Tax Collector | REXCITICICOLLECTOR | CHAR | 60 | RECAXLDESCRIPTION | ||||
| ACCNO | Account number | REXCITACCNO | CHAR | 10 | |||||
| CATID | Cadastral Category ID | REXCITCATID | CHAR | 4 | REXCITICICATID | ||||
| CATCOEFF | Category Coefficient | REXCITCATCOEFF | DEC | 5(2) | REXCITRATEGT100 | ||||
| CALCTYPE | Calculation Type | REXCITCALCTYPE | CHAR | 2 | |||||
| AOVALUE | Value of Architectural Object | REXCITAOVALUE | CURR | 15(2) | RECACURR | ||||
| BASEAMOUNT | Base amount | REXCITBASEAMOUNT | CURR | 15(2) | RECACURR | ||||
| TAXBASE | Taxable Amount | REXCITICITAXBASE | CURR | 15(2) | RECACURR | ||||
| MONOWN | Period of ownership | REXCITMONOWN | NUMC | 2 | |||||
| PERCOWN | Ownership Percentage | REXCITPERCOWN | DEC | 5(2) | REXCITRATE | ||||
| MONEXCL | Months of exclusion | REXCITMONEXCL | NUMC | 2 | |||||
| DETRAMOUNT | Detraction Amount | REXCITDETRAMOUNT | CURR | 15(2) | RECACURR | ||||
| DETRACTPREC | Detraction Percentage | REXCITDETRACTPREC | DEC | 5(2) | REXCITRATE | ||||
| RAISPERC | Percentage Increase | REXCITRAISPERC | DEC | 5(2) | REXCITRATE | ||||
| ISANNUALPAY | One Annual Payment (Without Down Payment) | REXCITISANNUALPAY | CHAR | 1 | RECABOOL | ||||
| DATPRI | Due Date of First Installment (Down Payment) | REXCITDATPRI | DATS | 8 | RECADATE | ||||
| INSTPRIPAID | First Installment (downpayment) Paid | REXCITINSTPRIPAID | CHAR | 1 | RECABOOL | ||||
| DOWNPAYMENT | Down Payment | REXCITDOWNPAYM | CURR | 15(2) | RECACURR | ||||
| DATSEC | Due Date of Second Installment Payment | REXCITDATSEC | DATS | 8 | RECADATE | ||||
| BALANCE | Balance | REXCITBALANCE | CURR | 15(2) | RECACURR | ||||
| ISACTIVEICI | ICI/IMU Record Locked for Recalculation | REXCITISACTIVEICI | CHAR | 1 | RECABOOL | ||||
| ASSIGINTRENO | Assigned real estate object | REXCITASSIGINTRENO | CHAR | 13 | RECAINTRENO | ||||
| ASSIGOBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| IS_EXEMPT | Exemption Status | REXCITISEXEMPT | CHAR | 1 | RECABOOL | ||||
| IS_UNINHABIT | Uninhabitable Building | REXCITISUNINHABIT | CHAR | 1 | RECABOOL | ||||
| IS_HISTORIC | Historical Object | REXCITHISTORIC | CHAR | 1 | RECABOOL | ||||
| COUNTRYRATE | IMU Country Rate | REXCITIMUCNTRYRATE | DEC | 5(2) | |||||
| CITYRATE | IMU City Rate | REXCITIMUCITYRATE | DEC | 5(2) | |||||
| DOWNPAYMENTCITY | Down Payment to City | REXCITDOWNPAYMCITY | CURR | 15(2) | RECACURR | ||||
| DOWNPAYMENTCNTRY | Down Payment to Country | REXCITDOWNPAYMCNTRY | CURR | 15(2) | RECACURR | ||||
| BALANCECITY | Balance to City | REXCITBALANCECITY | CURR | 15(2) | RECACURR | ||||
| BALANCECOUNTRY | Balance to Country | REXCITBALANCECNTRY | CURR | 15(2) | RECACURR | ||||
| CITYAMOUNT | ICI/IMU City Tax Amount | REXCITCITYAMOUNT | CURR | 15(2) | RECACURR | ||||
| COUNTRYAMOUNT | ICI/IMU Country Tax Amount | REXCITCNTRYAMOUNT | CURR | 15(2) | RECACURR | ||||
| REDUCTION | Reduction ID | REXCITREDUCTION | CHAR | 2 | TIVXCITREDUCT | CHAR2 |
| Key field | Non-key field |
How do I retrieve data from SAP structure VIXCITICIDATA_TAB using ABAP code?
As VIXCITICIDATA_TAB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VIXCITICIDATA_TAB as there is no data to select.How to access SAP table VIXCITICIDATA_TAB
Within an ECC or HANA version of SAP you can also view further information about VIXCITICIDATA_TAB 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