SAP ABAP Table VIXCITICIDATA (ICI master 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 | VIXCITICIDATA | Table Relationship Diagram |
Short Description | ICI master data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | T000 | |
2 | .INCLUDE | 0 | 0 | Key for ICI master data (VIXCITICIDATA) | |||||
3 | INTRENO | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | VIBDAO | |
4 | DATEFROM | RECADATEFROM | RECADATEBEG | DATS | 8 | 0 | Date: Valid From | ||
5 | .INCLUDE | 0 | 0 | ICI Data - data fields | |||||
6 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
7 | DATETO | RECADATETO | RECADATEEND | DATS | 8 | 0 | Date: Valid To | ||
8 | ICIAMOUNT | REXCITICIAMOUNT | RECACURR | CURR | 15 | 2 | ICI/IMU Tax Amount | ||
9 | POSTALCODE | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | * | |
10 | CITY | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | TIVXCITICIPARAM | |
11 | ICIRATE | REXCITICIRATE | DEC | 5 | 2 | ICI/IMU Rate | |||
12 | ISMANUALRATE | REXCITISMANUALRATE | RECABOOL | CHAR | 1 | 0 | Manually entered ICI/IMU rate differs from auto. det. rate | ||
13 | ICICOLLECTOR | REXCITICICOLLECTOR | RECAXLDESCRIPTION | CHAR | 60 | 0 | Name of the Tax Collector | ||
14 | ACCNO | REXCITACCNO | CHAR | 10 | 0 | Account number | |||
15 | CATID | REXCITCATID | CHAR | 4 | 0 | Cadastral Category ID | * | ||
16 | CATCOEFF | REXCITCATCOEFF | REXCITRATEGT100 | DEC | 5 | 2 | Category Coefficient | ||
17 | CALCTYPE | REXCITCALCTYPE | CHAR | 2 | 0 | Calculation Type | * | ||
18 | AOVALUE | REXCITAOVALUE | RECACURR | CURR | 15 | 2 | Value of Architectural Object | ||
19 | BASEAMOUNT | REXCITBASEAMOUNT | RECACURR | CURR | 15 | 2 | Base amount | ||
20 | TAXBASE | REXCITICITAXBASE | RECACURR | CURR | 15 | 2 | Taxable Amount | ||
21 | MONOWN | REXCITMONOWN | NUMC | 2 | 0 | Period of ownership | |||
22 | PERCOWN | REXCITPERCOWN | REXCITRATE | DEC | 5 | 2 | Ownership Percentage | ||
23 | MONEXCL | REXCITMONEXCL | NUMC | 2 | 0 | Months of exclusion | |||
24 | DETRAMOUNT | REXCITDETRAMOUNT | RECACURR | CURR | 15 | 2 | Detraction Amount | ||
25 | DETRACTPREC | REXCITDETRACTPREC | REXCITRATE | DEC | 5 | 2 | Detraction Percentage | ||
26 | RAISPERC | REXCITRAISPERC | REXCITRATE | DEC | 5 | 2 | Percentage Increase | ||
27 | ISANNUALPAY | REXCITISANNUALPAY | RECABOOL | CHAR | 1 | 0 | One Annual Payment (Without Down Payment) | ||
28 | DATPRI | REXCITDATPRI | RECADATE | DATS | 8 | 0 | Due Date of First Installment (Down Payment) | ||
29 | INSTPRIPAID | REXCITINSTPRIPAID | RECABOOL | CHAR | 1 | 0 | First Installment (downpayment) Paid | ||
30 | DOWNPAYMENT | REXCITDOWNPAYM | RECACURR | CURR | 15 | 2 | Down Payment | ||
31 | DATSEC | REXCITDATSEC | RECADATE | DATS | 8 | 0 | Due Date of Second Installment Payment | ||
32 | BALANCE | REXCITBALANCE | RECACURR | CURR | 15 | 2 | Balance | ||
33 | ISACTIVEICI | REXCITISACTIVEICI | RECABOOL | CHAR | 1 | 0 | ICI/IMU Record Locked for Recalculation | ||
34 | ASSIGINTRENO | REXCITASSIGINTRENO | RECAINTRENO | CHAR | 13 | 0 | Assigned real estate object | ||
35 | ASSIGOBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
36 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
37 | IS_EXEMPT | REXCITISEXEMPT | RECABOOL | CHAR | 1 | 0 | Exemption Status | ||
38 | IS_UNINHABIT | REXCITISUNINHABIT | RECABOOL | CHAR | 1 | 0 | Uninhabitable Building | ||
39 | IS_HISTORIC | REXCITHISTORIC | RECABOOL | CHAR | 1 | 0 | Historical Object | ||
40 | COUNTRYRATE | REXCITIMUCNTRYRATE | DEC | 5 | 2 | IMU Country Rate | |||
41 | CITYRATE | REXCITIMUCITYRATE | DEC | 5 | 2 | IMU City Rate | |||
42 | DOWNPAYMENTCITY | REXCITDOWNPAYMCITY | RECACURR | CURR | 15 | 2 | Down Payment to City | ||
43 | DOWNPAYMENTCNTRY | REXCITDOWNPAYMCNTRY | RECACURR | CURR | 15 | 2 | Down Payment to Country | ||
44 | BALANCECITY | REXCITBALANCECITY | RECACURR | CURR | 15 | 2 | Balance to City | ||
45 | BALANCECOUNTRY | REXCITBALANCECNTRY | RECACURR | CURR | 15 | 2 | Balance to Country | ||
46 | CITYAMOUNT | REXCITCITYAMOUNT | RECACURR | CURR | 15 | 2 | ICI/IMU City Tax Amount | ||
47 | COUNTRYAMOUNT | REXCITCNTRYAMOUNT | RECACURR | CURR | 15 | 2 | ICI/IMU Country Tax Amount | ||
48 | REDUCTION | REXCITREDUCTION | CHAR2 | CHAR | 2 | 0 | Reduction ID | TIVXCITREDUCT | |
49 | .INCLUDE | 0 | 0 | Field String for Maintenance of User Data | |||||
50 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
51 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
52 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
53 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
54 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
55 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
56 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
57 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
58 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VIXCITICIDATA | BUKRS | T001 | BUKRS | |||
2 | VIXCITICIDATA | CITY | TIVXCITICIPARAM | CITY | |||
3 | VIXCITICIDATA | CURRENCY | TCURC | WAERS | REF | ||
4 | VIXCITICIDATA | INTRENO | VIBDAO | INTRENO | |||
5 | VIXCITICIDATA | MANDT | T000 | MANDT | KEY | ||
6 | VIXCITICIDATA | REDUCTION | TIVXCITREDUCT | REDUCTION | 1 | CN |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 600 |