/CEERE/SDANP

Property tax - master | #masterdata | Component: Real Estate Localization Czech Republic
Column Name Description
MANDT FK Client
BUKRS FK Company Code
GJAHR Fiscal Year
TYPNEMREM Real Estate Object Type Show values
SWENR FK Business Entity Number
KEYNEM Property Key
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
KC_ZVDA115PO The increase in tax under § 11a
KC_DANOSV3PO Property Tax increased from amount under § 11 (5)
Column Name Description
Column Name Description
DATZMENY Date
CASZMENY Time
DATVYPOCTU Calculation Date
CASVYPOCTU Calculation Time
Column Name Description
TYPNEMREM Real Estate Object 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
SOLIDAGR Paved Area (Agricultural Purp.) Show values
SOLIDIND Paved Area (Industrial Purp.) Show values
SOLAAGRE Tax-Exempt Paved Area (Argicultural Purp.) Show values
SOLAINDE Tax-Exempt Paved Area (Industrial Purp.) Show values
RVZ_PODNIK Non-residential Property Type Used for Business Show values
VYM_PODNIKPO Landscaped area designed for business Show values
K_K102PO Coefficient 1.2 according Par. 10. 3 Show values
Column Name Description Domain name
NAZEVOBCE Name of Municipality or City District /CEERE/NAZEVOBCE
KODCOBCE District Code /CEERE/KODCOBCE
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
ZMENIL Changed by CHAR12
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
AGR_PAR1 Free aggregation parameter
AGR_PAR2 Free aggregation parameter
AGR_PAR3 Free aggregation parameter
AGR_PAR4 Free aggregation parameter
ANLN1 Main Asset Number ANLN1
ANLN2 Asset Subnumber ANLN2
KOSTL Cost Center KOSTL
GSBER Business Area GSBER
PRCTR Profit Center PRCTR
AUFNR Order Number AUFNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
XDAN Subject to Property Tax
STAVYPOCTU Calculation status
VYPOCETL Calculation Executed by
TBUKR2 Dominant Enterprise/Company Code BUKRS
YEAGREFR First Year of Tax Exemption Period (Agricultural Purp.) GJAHR
YEINDEFR First Year of Tax Exemption Period (Industrial Purp.) GJAHR
YEAGRETO Last Year of Tax Exemption Period (Agricultural Purp.) GJAHR
YEINDETO Last Year of Tax Exemption Period (Industrial Purp.) GJAHR
CODEAGRE Tax Exemption Code for Paved Area (Agr. Purp.) /CEERE/KODOSVOB5
CODEINDE Tax Exemption Code for Paved Area (Ind. Purp.) /CEERE/KODOSVOB5
Master Data Relations | to Other Relations ↓ Join Conditions
CoCode
  • /CEERE/SDANP.MANDT == T001.MANDT
  • /CEERE/SDANP.BUKRS == T001.BUKRS
Property Type
  • Property Type
  • Property Category
Municipalities
  • Code of Municipality or City District
  • ?
client /CEERE/SDANP.MANDT == T000.MANDT
Business entities
  • Company Code
  • Business Entity Number
  • /CEERE/SDANP.MANDT == VIOB01.MANDT
  • /CEERE/SDANP.BUKRS == VIOB01.BUKRS
  • /CEERE/SDANP.SWENR == VIOB01.SWENR
Property Category
Other Relations | to Master Data Relations ↑ Join Conditions
CD
  • Code of Municipality or City District
  • Local Subdistrict
  • ?
  • /CEERE/SDANP.MANDT == /CEERE/KU.MANDT
  • /CEERE/SDANP.KODOBCE == /CEERE/KU.KODOBCE
  • /CEERE/SDANP.GEMARK == /CEERE/KU.GEMARK
  • /CEERE/SDANP.[column in domain "/CEERE/FIRSTGJAHR"] == /CEERE/KU.YEAR_FROM
to
  • Tax Office Code
  • Client
  • ?
  • /CEERE/SDANP.KODFU == /CEERE/FUC.KODFU
  • /CEERE/SDANP.MANDT == /CEERE/FUC.MANDT
  • /CEERE/SDANP.[column in domain "/CEERE/STARTDATE"] == /CEERE/FUC.STARTDATE