SAP ABAP Table /CEERE/SDANP (Property tax - master)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷
RE-FX-LC-CZ (Application Component) Real Estate Localization Czech Republic
⤷
/CEERE/DANNEM (Package) Localization Flexible Real Estate Czech Republic
EA-FIN (Software Component) EA-FIN⤷
RE-FX-LC-CZ (Application Component) Real Estate Localization Czech Republic⤷
/CEERE/DANNEM (Package) Localization Flexible Real Estate Czech Republic
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | /CEERE/SDANP |
Table Relationship Diagram 
|
| Short Description | Property tax - master |
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 | BUKRS |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
| 3 | GJAHR |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
| 4 | TYPNEMREM |
/CEERE/TYPNEMREM | /CEERE/TYPNEMREM | CHAR | 1 | 0 | Real Estate Object Type | ||
| 5 | SWENR |
SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | VIOB01 | |
| 6 | KEYNEM |
/CEERE/KEYNEM | SGRNR | CHAR | 8 | 0 | Property Key | * | |
| 7 | TYPNEM |
/CEERE/TYPNEM | /CEERE/TYPNEM | CHAR | 1 | 0 | Property Category | /CEERE/TPNEM | |
| 8 | DRNEM |
/CEERE/DRUHNEM | /CEERE/DRUHNEM | CHAR | 1 | 0 | Property Type | /CEERE/DRNEM | |
| 9 | KODFU |
/CEERE/KODFU | /CEERE/KODFU | CHAR | 3 | 0 | Tax Office Code | /CEERE/FUC | |
| 10 | KODOBCE |
/CEERE/KODOBCE | /CEERE/KODOBCE | CHAR | 8 | 0 | Code of Municipality or City District | /CEERE/OBCE | |
| 11 | NAZEVOBCE |
/CEERE/NAZEVOBCE | /CEERE/NAZEVOBCE | CHAR | 35 | 0 | Name of Municipality or City District | ||
| 12 | KODCOBCE |
/CEERE/KODCOBCE | /CEERE/KODCOBCE | CHAR | 6 | 0 | District Code | * | |
| 13 | GEMARK |
VVGEMARK | VVGEMARK | CHAR | 12 | 0 | Local Subdistrict | /CEERE/KU | |
| 14 | NAZEVKU |
/CEERE/NAZEVKU | /CEERE/NAZEVKU | CHAR | 40 | 0 | Cadastral District Name | ||
| 15 | NARPARK |
/CEERE/NARPARK | CHAR | 1 | 0 | Property Located in National Park | |||
| 16 | PARCKMEN |
/CEERE/PARCKMEN | CHAR | 5 | 0 | Master Number of Parcel | |||
| 17 | PARCPOD |
/CEERE/PARCPOD | CHAR | 3 | 0 | Additional Number of Parcel | |||
| 18 | PARCDIL |
/CEERE/PARCDIL | CHAR | 2 | 0 | Parcel Sub-Number | |||
| 19 | VYMERA |
/CEERE/VYMERA | /CEERE/PLOCHA | DEC | 9 | 2 | Total Area | ||
| 20 | PRAVZTAH |
/CEERE/PRAVZTAH | /CEERE/PRAVZTAH | CHAR | 4 | 0 | Legal Relations | ||
| 21 | SV_CITATEL |
/CEERE/SV_CITATEL | /CEERE/SV_CITATEL | DEC | 7 | 0 | Co-Ownership Share (Numerator) | ||
| 22 | SV_JMENOVATEL |
/CEERE/SV_JMENOVATEL | /CEERE/SV_JMENOVATEL | DEC | 7 | 0 | Co-Ownership Share (Denominator) | ||
| 23 | VYMERAOSV |
/CEERE/VYMERAOSV | /CEERE/PLOCHA | DEC | 9 | 2 | Area Exempted From Tax | ||
| 24 | VYMERAPOD |
/CEERE/VYMERAPOD | /CEERE/PLOCHA | DEC | 9 | 2 | Floor Area for Business | ||
| 25 | ZASTPL |
/CEERE/ZASTPL | /CEERE/PLOCHA | DEC | 9 | 2 | Covered Area | ||
| 26 | PLOCHANP |
/CEERE/PLOCHANP | /CEERE/PLOCHA | DEC | 9 | 2 | Total Area of Floors Above the Ground Floor | ||
| 27 | KODOSVOB |
/CEERE/KODOSVOB | /CEERE/KODOSVOB | CHAR | 4 | 0 | Tax Exemption Code | * | |
| 28 | ROKOSVOD |
/CEERE/ROKOSVOD | GJAHR | NUMC | 4 | 0 | Tax Exemption Period: Start Year | ||
| 29 | ROKOSVDO |
/CEERE/ROKOSVDO | GJAHR | NUMC | 4 | 0 | Tax Exemption Period: End Year | ||
| 30 | CENASTODH |
/CEERE/CENAODH | CHAR | 1 | 0 | Estimated Price | |||
| 31 | CENAODHAD |
/CEERE/CENAP | /CEERE/CENAP | DEC | 9 | 2 | Estimated Land Price | ||
| 32 | POCPATER |
/CEERE/POCPATER | DEC | 3 | 0 | Number of Other Aboveground Floors | |||
| 33 | CISLOP |
/CEERE/CISLOP | CHAR | 6 | 0 | Registration Number | |||
| 34 | ROKDOKONC |
/CEERE/ROKDOKONC | GJAHR | NUMC | 4 | 0 | Completion Year of Building | ||
| 35 | POPIS |
/CEERE/POPISSTAVBY | /CEERE/POPIS80 | CHAR | 80 | 0 | Name of Property Tax Object | ||
| 36 | CIZIPOZ |
/CEERE/CIZIPOZ | CHAR | 1 | 0 | Building on Third-Party Plot | |||
| 37 | DRUHSTA |
/CEERE/DRUHSTA | /CEERE/DRUHSTA | CHAR | 2 | 0 | Building Type | ||
| 38 | BYTKAT |
/CEERE/BYTKAT | /CEERE/BYTKAT | CHAR | 4 | 0 | Apartment category | ||
| 39 | SVISKONST |
/CEERE/SVISKONST | /CEERE/SVISKONST | CHAR | 2 | 0 | Vertical supporting structure | ||
| 40 | JEDNKMEN |
/CEERE/JEDNKMEN | CHAR | 6 | 0 | Unit-master part | |||
| 41 | JEDNBYT |
/CEERE/JEDNBYT | CHAR | 3 | 0 | Unit-apartment | |||
| 42 | PLNOSVOB |
/CEERE/PLNOSVOB | CHAR | 1 | 0 | Full Tax Exemption | |||
| 43 | DATZMENY |
DATUM | DATUM | DATS | 8 | 0 | Date | ||
| 44 | CASZMENY |
UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
| 45 | ZMENIL |
USER | CHAR12 | CHAR | 12 | 0 | Changed by | ||
| 46 | .INCLUDE |
0 | 0 | Currency key | |||||
| 47 | WAERS |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
| 48 | .INCLUDE |
0 | 0 | Tax return items 18-28 | |||||
| 49 | X18 |
/CEERE/X18 | /CEERE/PLOCHA | DEC | 9 | 2 | Area of Land Type | ||
| 50 | X19 |
/CEERE/X19 | /CEERE/CENAP | DEC | 9 | 2 | Land Price per Square Meter | ||
| 51 | X20 |
/CEERE/X20 | /CEERE/CASTKA | CURR | 11 | 2 | Tax Base According to Par.5 (1,2) | ||
| 52 | X21 |
/CEERE/X21 | /CEERE/DEC5_2 | DEC | 5 | 2 | Tax Rate (Par. 6(1)) | ||
| 53 | X22 |
/CEERE/X22 | /CEERE/PLOCHA | DEC | 9 | 2 | Tax Base (Par.5(3)) | ||
| 54 | X23 |
/CEERE/X23 | /CEERE/DEC5_2 | DEC | 5 | 2 | Tax Rate (Par 6(2)) | ||
| 55 | X24 |
/CEERE/X24 | /CEERE/DEC5_2 | DEC | 5 | 2 | Factor According to Par. 6(4) | ||
| 56 | X25 |
/CEERE/X25 | /CEERE/CASTKA | CURR | 11 | 2 | Land Tax | ||
| 57 | X26 |
/CEERE/X26 | /CEERE/PLOCHA | DEC | 9 | 2 | Claim for Exemption in Area | ||
| 58 | X27 |
/CEERE/X27 | /CEERE/CASTKA | CURR | 11 | 2 | Amount of Claim for Exemption (Par. 4,18(1)) | ||
| 59 | X28 |
/CEERE/X28 | /CEERE/CASTKA | CURR | 11 | 2 | Tax Liability | ||
| 60 | .INCLUDE |
0 | 0 | Tax return items 41-53 | |||||
| 61 | X41 |
/CEERE/X41 | /CEERE/PLOCHA | DEC | 9 | 2 | Covered area | ||
| 62 | X42 |
/CEERE/X42 | /CEERE/DEC5_2 | DEC | 5 | 2 | Basic tax rate §11(1) | ||
| 63 | X43 |
/CEERE/X43 | DEC | 9 | 0 | Number of above-ground floors | |||
| 64 | X44 |
/CEERE/X44 | /CEERE/CENAP | DEC | 9 | 2 | Incr.base rate for another above-ground floor §11(2) | ||
| 65 | X45 |
/CEERE/X45 | /CEERE/DEC5_2 | DEC | 5 | 2 | Factor according to §11(3,4) | ||
| 66 | X46 |
/CEERE/X46 | /CEERE/DEC9_2 | DEC | 9 | 2 | Resulting tax rate | ||
| 67 | X47 |
/CEERE/X47 | /CEERE/CASTKA | CURR | 11 | 2 | Building tax | ||
| 68 | X48 |
/CEERE/X48 | /CEERE/PLOCHA | DEC | 9 | 2 | Business area | ||
| 69 | X49 |
/CEERE/X49 | /CEERE/CASTKA | CURR | 11 | 2 | Tax increase according to §11(5) | ||
| 70 | X50 |
/CEERE/X50 | /CEERE/DEC9_2 | DEC | 9 | 2 | Area relation §9(2) | ||
| 71 | X51 |
/CEERE/X51 | /CEERE/CASTKA | CURR | 11 | 2 | Amount of exempt claim §11 | ||
| 72 | X52 |
/CEERE/X52 | /CEERE/CASTKA | CURR | 11 | 2 | Amount of claim for deduction §18(2) | ||
| 73 | X53 |
/CEERE/X53 | /CEERE/CASTKA | CURR | 11 | 2 | Tax liability | ||
| 74 | .INCLUDE |
0 | 0 | Tax return items 54-56 | |||||
| 75 | X54_O |
/CEERE/X54_O | /CEERE/CASTKA | CURR | 11 | 2 | Total land tax - till 2008 | ||
| 76 | X54 |
/CEERE/X54 | /CEERE/CASTKA | CURR | 11 | 2 | Total Amount of Land Tax | ||
| 77 | X54_B |
/CEERE/X54 | /CEERE/CASTKA | CURR | 11 | 2 | Total Amount of Land Tax | ||
| 78 | X55_O |
/CEERE/X55_O | /CEERE/CASTKA | CURR | 11 | 2 | Total building tax - till 2008 | ||
| 79 | X55 |
/CEERE/X55 | /CEERE/CASTKA | CURR | 11 | 2 | Total Amount of Building Tax | ||
| 80 | X55_B |
/CEERE/X55 | /CEERE/CASTKA | CURR | 11 | 2 | Total Amount of Building Tax | ||
| 81 | X56_O |
/CEERE/X56_O | /CEERE/CASTKA | CURR | 11 | 2 | Total property tax - till 2008 | ||
| 82 | X56 |
/CEERE/X56 | /CEERE/CASTKA | CURR | 11 | 2 | Total Amount of Property Tax | ||
| 83 | X56_B |
/CEERE/X56 | /CEERE/CASTKA | CURR | 11 | 2 | Total Amount of Property Tax | ||
| 84 | XKO12 |
/CEERE/XKO12 | INT1 | INT1 | 3 | 0 | Municipality Coefficient (Par. 12) | ||
| 85 | .INCLUDE |
0 | 0 | Tax return items 58-59 | |||||
| 86 | X58_1 |
/CEERE/SPLATKA | /CEERE/CASTKA | CURR | 11 | 2 | Installment 1 | ||
| 87 | X58_2 |
/CEERE/SPLATKA2 | /CEERE/CASTKA | CURR | 11 | 2 | Installment 2 | ||
| 88 | X59_1 |
/CEERE/SPLATKA | /CEERE/CASTKA | CURR | 11 | 2 | Installment 1 | ||
| 89 | X59_2 |
/CEERE/SPLATKA2 | /CEERE/CASTKA | CURR | 11 | 2 | Installment 2 | ||
| 90 | X59_3 |
/CEERE/SPLATKA3 | /CEERE/CASTKA | CURR | 11 | 2 | Installment 3 | ||
| 91 | X59_4 |
/CEERE/SPLATKA4 | /CEERE/CASTKA | CURR | 11 | 2 | Installment 4 | ||
| 92 | .INCLUDE |
0 | 0 | Tax return items 67-69 | |||||
| 93 | X67 |
/CEERE/X67 | /CEERE/PLOCHA | DEC | 9 | 2 | Land type area | ||
| 94 | X68A |
/CEERE/X68A | INT4 | 10 | 0 | Com.quotient denominator | |||
| 95 | X68B |
/CEERE/X68B | INT4 | 10 | 0 | Com.quotient numerator | |||
| 96 | X69 |
/CEERE/X69 | /CEERE/PLOCHA | DEC | 9 | 2 | Co-owned land type are | ||
| 97 | X70 |
/CEERE/X70 | /CEERE/CENAP | DEC | 9 | 2 | Land price per square meter | ||
| 98 | X71 |
/CEERE/X71 | /CEERE/CASTKA | CURR | 11 | 2 | Tax base according to p.5 par. 1,2 | ||
| 99 | X72 |
/CEERE/X72 | /CEERE/DEC5_2 | DEC | 5 | 2 | Tax rate §6(1) | ||
| 100 | X73 |
/CEERE/X73 | /CEERE/PLOCHA | DEC | 9 | 2 | Tax base §5(3) | ||
| 101 | X74 |
/CEERE/X74 | /CEERE/DEC5_2 | DEC | 5 | 2 | Tax rate §6(2) | ||
| 102 | X75 |
/CEERE/X75 | /CEERE/DEC5_2 | DEC | 5 | 2 | Factor according to §6(4) | ||
| 103 | X76 |
/CEERE/X76 | /CEERE/CASTKA | CURR | 11 | 2 | Land tax | ||
| 104 | X77 |
/CEERE/X77 | /CEERE/PLOCHA | DEC | 9 | 2 | Claim for area exempt | ||
| 105 | X78 |
/CEERE/X78 | /CEERE/CASTKA | CURR | 11 | 2 | Amount of claim for exempt §4,18(1) | ||
| 106 | X79 |
/CEERE/X79 | /CEERE/CASTKA | CURR | 11 | 2 | Liability to pay taxes | ||
| 107 | .INCLUDE |
0 | 0 | Tax return items 95-103 | |||||
| 108 | X95 |
/CEERE/X95 | /CEERE/PLOCHA | DEC | 9 | 2 | Floor area of the unit | ||
| 109 | X96 |
/CEERE/X96 | /CEERE/DEC5_2 | DEC | 5 | 2 | Factor according to §10(2) | ||
| 110 | X97 |
/CEERE/X97 | /CEERE/PLOCHA | DEC | 9 | 2 | Base tax rate according to §10(2) | ||
| 111 | X98 |
/CEERE/X98 | /CEERE/DEC5_2 | DEC | 5 | 2 | Base tax rate according to §11(1) | ||
| 112 | X99 |
/CEERE/X99 | /CEERE/DEC5_2 | DEC | 5 | 2 | Factor according to §11(3,4) | ||
| 113 | X100 |
/CEERE/X100 | /CEERE/DEC5_2 | DEC | 5 | 2 | Resulting tax rate | ||
| 114 | X101 |
/CEERE/X101 | /CEERE/CASTKA | CURR | 11 | 2 | Building tax | ||
| 115 | X102 |
/CEERE/X102 | /CEERE/CASTKA | CURR | 11 | 2 | Amount of claim for exemption according to §9 | ||
| 116 | X103 |
/CEERE/X103 | /CEERE/CASTKA | CURR | 11 | 2 | Tax liability | ||
| 117 | AGR_PAR1 |
/CEERE/AGR_PAR | CHAR | 10 | 0 | Free aggregation parameter | |||
| 118 | AGR_PAR2 |
/CEERE/AGR_PAR | CHAR | 10 | 0 | Free aggregation parameter | |||
| 119 | AGR_PAR3 |
/CEERE/AGR_PAR | CHAR | 10 | 0 | Free aggregation parameter | |||
| 120 | AGR_PAR4 |
/CEERE/AGR_PAR | CHAR | 10 | 0 | Free aggregation parameter | |||
| 121 | ANLN1 |
ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
| 122 | ANLN2 |
ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
| 123 | KOSTL |
KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
| 124 | GSBER |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
| 125 | PRCTR |
PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
| 126 | AUFNR |
AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
| 127 | PS_PSP_PNR |
PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
| 128 | XDAN |
/CEERE/XDAN | CHAR | 1 | 0 | Subject to Property Tax | |||
| 129 | DATVYPOCTU |
/CEERE/DATVYPOCTU | DATS | 8 | 0 | Calculation Date | |||
| 130 | CASVYPOCTU |
/CEERE/CASVYPOCTU | TIMS | 6 | 0 | Calculation Time | |||
| 131 | STAVYPOCTU |
/CEERE/STAVYPOCTU | CHAR | 1 | 0 | Calculation status | |||
| 132 | VYPOCETL |
/CEERE/VYPOCETL | CHAR | 12 | 0 | Calculation Executed by | |||
| 133 | TBUKR2 |
/CEERE/FOT_TBUKRS | BUKRS | CHAR | 4 | 0 | Dominant Enterprise/Company Code | * | |
| 134 | MBUKR |
/CEERE/MBUKR | XFELD | CHAR | 1 | 0 | Indicator: Dominant Company Code | ||
| 135 | .INCLUDE |
0 | 0 | Property tax - Paved Area | |||||
| 136 | SOLIDAGR |
/CEERE/SOLIDAGR | /CEERE/PLOCHA | DEC | 9 | 2 | Paved Area (Agricultural Purp.) | ||
| 137 | SOLIDIND |
/CEERE/SOLIDIND | /CEERE/PLOCHA | DEC | 9 | 2 | Paved Area (Industrial Purp.) | ||
| 138 | SOLAAGRE |
/CEERE/SOLAAGRE | /CEERE/PLOCHA | DEC | 9 | 2 | Tax-Exempt Paved Area (Argicultural Purp.) | ||
| 139 | SOLAINDE |
/CEERE/SOLAINDE | /CEERE/PLOCHA | DEC | 9 | 2 | Tax-Exempt Paved Area (Industrial Purp.) | ||
| 140 | YEAGREFR |
/CEERE/YEAGREFR | GJAHR | NUMC | 4 | 0 | First Year of Tax Exemption Period (Agricultural Purp.) | ||
| 141 | YEINDEFR |
/CEERE/YEINDEFR | GJAHR | NUMC | 4 | 0 | First Year of Tax Exemption Period (Industrial Purp.) | ||
| 142 | YEAGRETO |
/CEERE/YEAGRETO | GJAHR | NUMC | 4 | 0 | Last Year of Tax Exemption Period (Agricultural Purp.) | ||
| 143 | YEINDETO |
/CEERE/YEINDETO | GJAHR | NUMC | 4 | 0 | Last Year of Tax Exemption Period (Industrial Purp.) | ||
| 144 | CODEAGRE |
/CEERE/CODEAGRE | /CEERE/KODOSVOB | CHAR | 4 | 0 | Tax Exemption Code for Paved Area (Agr. Purp.) | * | |
| 145 | CODEINDE |
/CEERE/CODEINDE | /CEERE/KODOSVOB | CHAR | 4 | 0 | Tax Exemption Code for Paved Area (Ind. Purp.) | * |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /CEERE/SDANP | BUKRS |  T001 |
BUKRS |
|||
| 2 | /CEERE/SDANP | DRNEM | /CEERE/DRNEM |
DRNEM |
KEY | 1 | CN |
| 3 | /CEERE/SDANP | GEMARK | /CEERE/KU |
GEMARK |
|||
| 4 | /CEERE/SDANP | KODFU | /CEERE/FUC |
KODFU |
|||
| 5 | /CEERE/SDANP | KODOBCE | /CEERE/OBCE |
KODOBCE |
|||
| 6 | /CEERE/SDANP | MANDT | T000 |
MANDT |
|||
| 7 | /CEERE/SDANP | SWENR | VIOB01 |
SWENR |
|||
| 8 | /CEERE/SDANP | TYPNEM | /CEERE/TPNEM |
TYPNEM |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in | 46C |
