AVIXCITICIDATA SAP (Change Document Structure ICI master data (VIXCITICIDATA)) Structure details

Dictionary Type: Structure
Description: Change Document Structure ICI master data (VIXCITICIDATA)




ABAP Code to SELECT data from AVIXCITICIDATA
Related tables to AVIXCITICIDATA
Access table AVIXCITICIDATA




Structure field list including key, data, relationships and ABAP select examples

AVIXCITICIDATA 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 "Change Document Structure ICI master data (VIXCITICIDATA)" 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_AVIXCITICIDATA TYPE AVIXCITICIDATA.

The AVIXCITICIDATA table consists of various fields, each holding specific information or linking keys about Change Document Structure ICI master data (VIXCITICIDATA) data available in SAP. These include MANDT (Client), INTRENO (Internal Key of Real Estate Object), DATEFROM (Date: Valid From), CURRENCY (Currency Key).. 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 AVIXCITICIDATA 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
MANDTClient MANDTCLNT3T000MANDT
INTRENOInternal Key of Real Estate Object RECAINTRENOCHAR13VIBDAORECAINTRENO
DATEFROMDate: Valid From RECADATEFROMDATS8RECADATEBEG
CURRENCYCurrency Key WAERSCUKY5TCURCWAERSFWS
DATETODate: Valid To RECADATETODATS8REDATRECADATEEND
ICIAMOUNTICI/IMU Tax Amount REXCITICIAMOUNTCURR15(2) RECACURR
POSTALCODECity postal code AD_PSTCD1CHAR10Assigned to domainCHAR10
CITYCity AD_CITY1CHAR40TIVXCITICIPARAMTEXT40CLCITYNAME
ICIRATEICI/IMU Rate REXCITICIRATEDEC5(2)
ISMANUALRATEManually entered ICI/IMU rate differs from auto. det. rate REXCITISMANUALRATECHAR1RECABOOL
ICICOLLECTORName of the Tax Collector REXCITICICOLLECTORCHAR60RECAXLDESCRIPTION
ACCNOAccount number REXCITACCNOCHAR10
CATIDCadastral Category ID REXCITCATIDCHAR4Assigned to domainREXCITICICATID
CATCOEFFCategory Coefficient REXCITCATCOEFFDEC5(2) REXCITRATEGT100
CALCTYPECalculation Type REXCITCALCTYPECHAR2Assigned to domain
AOVALUEValue of Architectural Object REXCITAOVALUECURR15(2) RECACURR
BASEAMOUNTBase amount REXCITBASEAMOUNTCURR15(2) RECACURR
TAXBASETaxable Amount REXCITICITAXBASECURR15(2) RECACURR
MONOWNPeriod of ownership REXCITMONOWNNUMC2
PERCOWNOwnership Percentage REXCITPERCOWNDEC5(2) REXCITRATE
MONEXCLMonths of exclusion REXCITMONEXCLNUMC2
DETRAMOUNTDetraction Amount REXCITDETRAMOUNTCURR15(2) RECACURR
DETRACTPRECDetraction Percentage REXCITDETRACTPRECDEC5(2) REXCITRATE
RAISPERCPercentage Increase REXCITRAISPERCDEC5(2) REXCITRATE
ISANNUALPAYOne Annual Payment (Without Down Payment) REXCITISANNUALPAYCHAR1RECABOOL
DATPRIDue Date of First Installment (Down Payment) REXCITDATPRIDATS8RECADATE
INSTPRIPAIDFirst Installment (downpayment) Paid REXCITINSTPRIPAIDCHAR1RECABOOL
DOWNPAYMENTDown Payment REXCITDOWNPAYMCURR15(2) RECACURR
DATSECDue Date of Second Installment Payment REXCITDATSECDATS8RECADATE
BALANCEBalance REXCITBALANCECURR15(2) RECACURR
ISACTIVEICIICI/IMU Record Locked for Recalculation REXCITISACTIVEICICHAR1RECABOOL
ASSIGINTRENOAssigned real estate object REXCITASSIGINTRENOCHAR13RECAINTRENO
ASSIGOBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
IS_EXEMPTExemption Status REXCITISEXEMPTCHAR1RECABOOL
IS_UNINHABITUninhabitable Building REXCITISUNINHABITCHAR1RECABOOL
IS_HISTORICHistorical Object REXCITHISTORICCHAR1RECABOOL
COUNTRYRATEIMU Country Rate REXCITIMUCNTRYRATEDEC5(2)
CITYRATEIMU City Rate REXCITIMUCITYRATEDEC5(2)
DOWNPAYMENTCITYDown Payment to City REXCITDOWNPAYMCITYCURR15(2) RECACURR
DOWNPAYMENTCNTRYDown Payment to Country REXCITDOWNPAYMCNTRYCURR15(2) RECACURR
BALANCECITYBalance to City REXCITBALANCECITYCURR15(2) RECACURR
BALANCECOUNTRYBalance to Country REXCITBALANCECNTRYCURR15(2) RECACURR
CITYAMOUNTICI/IMU City Tax Amount REXCITCITYAMOUNTCURR15(2) RECACURR
COUNTRYAMOUNTICI/IMU Country Tax Amount REXCITCNTRYAMOUNTCURR15(2) RECACURR
REDUCTIONReduction ID REXCITREDUCTIONCHAR2TIVXCITREDUCTCHAR2
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
KZChange Type (U, I, S, D) CDCHNGINDCHAR1CDCHNGIND

Key field Non-key field



How do I retrieve data from SAP structure AVIXCITICIDATA using ABAP code?

As AVIXCITICIDATA 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 AVIXCITICIDATA as there is no data to select.

How to access SAP table AVIXCITICIDATA

Within an ECC or HANA version of SAP you can also view further information about AVIXCITICIDATA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!