/CEERE/SDANA

Property tax return - items | #masterdata | Component: Real Estate Localization Czech Republic
Column Name Description
MANDT FK Client
BUKRS FK Company Code
GJAHR Fiscal Year
TYPDANP Tax Return Type Show values
TYPNEM FK Property Category
DRNEM FK Property Type
KODFU FK Tax Office Code
KODOBCE FK Code of Municipality or City District
GEMARK FK Local Subdistrict
AGR_PAR1 Free aggregation parameter
AGR_PAR2 Free aggregation parameter
AGR_PAR3 Free aggregation parameter
AGR_PAR4 Free aggregation parameter
SWENR FK Business Entity Number
KEYNEM Property Key
CLISTU Number of tax return sheet
Column Name Description
X20 Tax Base According to Par.5 (1,2)
X25 Land Tax
X27 Amount of Claim for Exemption (Par. 4,18(1))
X28 Tax Liability
X47 Building tax
X49 Tax increase according to §11(5)
X51 Amount of exempt claim §11
X52 Amount of claim for deduction §18(2)
X53 Tax liability
X54_O Total land tax - till 2008
X54 Total Amount of Land Tax
X54_B Total Amount of Land Tax
X55_O Total building tax - till 2008
X55 Total Amount of Building Tax
X55_B Total Amount of Building Tax
X56_O Total property tax - till 2008
X56 Total Amount of Property Tax
X56_B Total Amount of Property Tax
X58_1 Installment 1
X58_2 Installment 2
X59_1 Installment 1
X59_2 Installment 2
X59_3 Installment 3
X59_4 Installment 4
X71 Tax base according to p.5 par. 1,2
X76 Land tax
X78 Amount of claim for exempt §4,18(1)
X79 Liability to pay taxes
X101 Building tax
X102 Amount of claim for exemption according to §9
X103 Tax liability
Column Name Description
Column Name Description
DATVYPOCTU Calculation Date
CASVYPOCTU Calculation Time
Column Name Description
TYPDANP Tax Return Type Show values
VYMERA Total Area Show values
PRAVZTAH Legal Relations Show values
VYMERAOSV Area Exempted From Tax Show values
VYMERAPOD Floor Area for Business Show values
ZASTPL Covered Area Show values
PLOCHANP Total Area of Floors Above the Ground Floor Show values
DRUHSTA Building Type Show values
BYTKAT Apartment category Show values
SVISKONST Vertical supporting structure Show values
X18 Area of Land Type Show values
X22 Tax Base (Par.5(3)) Show values
X26 Claim for Exemption in Area Show values
X41 Covered area Show values
X48 Business area Show values
X67 Land type area Show values
X69 Co-owned land type are Show values
X73 Tax base §5(3) Show values
X77 Claim for area exempt Show values
X95 Floor area of the unit Show values
X97 Base tax rate according to §10(2) Show values
MBUKR Indicator: Dominant Company Code Show values
Column Name Description Domain name
NAZEVOBCE Name of Municipality or City District /CEERE/NAZEVOBCE
NAZEVKU Cadastral District Name /CEERE/NAZEVKU
NARPARK Property Located in National Park
PARCKMEN Master Number of Parcel
PARCPOD Additional Number of Parcel
PARCDIL Parcel Sub-Number
SV_CITATEL Co-Ownership Share (Numerator) /CEERE/SV_CITATEL
SV_JMENOVATEL Co-Ownership Share (Denominator) /CEERE/SV_JMENOVATEL
KODOSVOB Tax Exemption Code /CEERE/KODOSVOB5
ROKOSVOD Tax Exemption Period: Start Year GJAHR
ROKOSVDO Tax Exemption Period: End Year GJAHR
CENASTODH Estimated Price
CENAODHAD Estimated Land Price /CEERE/CENAP
POCPATER Number of Other Aboveground Floors
CISLOP Registration Number
ROKDOKONC Completion Year of Building GJAHR
POPIS Name of Property Tax Object /CEERE/POPIS80
CIZIPOZ Building on Third-Party Plot
JEDNKMEN Unit-master part
JEDNBYT Unit-apartment
PLNOSVOB Full Tax Exemption
X19 Land Price per Square Meter /CEERE/CENAP
X21 Tax Rate (Par. 6(1)) /CEERE/DEC5_2
X23 Tax Rate (Par 6(2)) /CEERE/DEC5_2
X24 Factor According to Par. 6(4) /CEERE/DEC5_2
X42 Basic tax rate §11(1) /CEERE/DEC5_2
X43 Number of above-ground floors
X44 Incr.base rate for another above-ground floor §11(2) /CEERE/CENAP
X45 Factor according to §11(3,4) /CEERE/DEC5_2
X46 Resulting tax rate /CEERE/DEC9_2
X50 Area relation §9(2) /CEERE/DEC9_2
XKO12 Municipality Coefficient (Par. 12) INT1
XKO12NEW Municipality Coefficient (Par. 12)
X68A Com.quotient denominator
X68B Com.quotient numerator
X70 Land price per square meter /CEERE/CENAP
X72 Tax rate §6(1) /CEERE/DEC5_2
X74 Tax rate §6(2) /CEERE/DEC5_2
X75 Factor according to §6(4) /CEERE/DEC5_2
X96 Factor according to §10(2) /CEERE/DEC5_2
X98 Base tax rate according to §11(1) /CEERE/DEC5_2
X99 Factor according to §11(3,4) /CEERE/DEC5_2
X100 Resulting tax rate /CEERE/DEC5_2
STAVYPOCTU Calculation status
VYPOCETL Calculation Executed by
TBUKR2 Dominant Enterprise/Company Code BUKRS
Master Data Relations | to Other Relations ↓ Join Conditions
CoCode
  • /CEERE/SDANA.MANDT == T001.MANDT
  • /CEERE/SDANA.BUKRS == T001.BUKRS
Property Type
  • Property Type
  • Property Category
Municipalities
  • Code of Municipality or City District
  • ?
client /CEERE/SDANA.MANDT == T000.MANDT
Business entities
  • Company Code
  • Business Entity Number
  • /CEERE/SDANA.MANDT == VIOB01.MANDT
  • /CEERE/SDANA.BUKRS == VIOB01.BUKRS
  • /CEERE/SDANA.SWENR == VIOB01.SWENR
Property Category
Other Relations | to Master Data Relations ↑ Join Conditions
CD
  • Code of Municipality or City District
  • Local Subdistrict
  • ?
  • /CEERE/SDANA.MANDT == /CEERE/KU.MANDT
  • /CEERE/SDANA.KODOBCE == /CEERE/KU.KODOBCE
  • /CEERE/SDANA.GEMARK == /CEERE/KU.GEMARK
  • /CEERE/SDANA.[column in domain "/CEERE/FIRSTGJAHR"] == /CEERE/KU.YEAR_FROM
to