/CEERE/SDANP SAP table for – Property tax – master

Here we would like to draw your attention to /CEERE/SDANP table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). /CEERE/SDANP is a SAP standard transp table used for storing Property tax – master related data in SAP. It comes under the package /CEERE/DANNEM.

SAP /CEERE/SDANP table

Table /CEERE/SDANP technical data

Table/CEERE/SDANP
Data storingProperty tax – master
ModuleRE
Sub ModuleRE-FX-LC-CZ
SAP Package/CEERE/DANNEM
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP /CEERE/SDANP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in /CEERE/SDANP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • TYPNEMREM : Real Estate Object Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SWENR : Business Entity Number
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • KEYNEM : Property Key
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • TYPNEM : Property Category
    Its data type is CHAR (Character String) with field length 1
  • DRNEM : Property Type
    Its data type is CHAR (Character String) with field length 1
  • KODFU : Tax Office Code
    Its data type is CHAR (Character String) with field length 3
  • KODOBCE : Code of Municipality or City District
    Its data type is CHAR (Character String) with field length 8
  • NAZEVOBCE : Name of Municipality or City District
    Its data type is CHAR (Character String) with field length 35
  • KODCOBCE : District Code
    Its data type is CHAR (Character String) with field length 6
  • GEMARK : Local Subdistrict
    Its data type is CHAR (Character String) with field length 12
  • NAZEVKU : Cadastral District Name
    Its data type is CHAR (Character String) with field length 40
  • NARPARK : Property Located in National Park
    Its data type is CHAR (Character String) with field length 1
  • PARCKMEN : Master Number of Parcel
    Its data type is CHAR (Character String) with field length 5
  • PARCPOD : Additional Number of Parcel
    Its data type is CHAR (Character String) with field length 3
  • PARCDIL : Parcel Sub-Number
    Its data type is CHAR (Character String) with field length 2
  • VYMERA : Total Area
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PRAVZTAH : Legal Relations
    Its data type is CHAR (Character String) with field length 4
  • SV_CITATEL : Co-Ownership Share (Numerator)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • SV_JMENOVATEL : Co-Ownership Share (Denominator)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • VYMERAOSV : Area Exempted From Tax
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • VYMERAPOD : Floor Area for Business
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ZASTPL : Covered Area
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PLOCHANP : Total Area of Floors Above the Ground Floor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • KODOSVOB : Tax Exemption Code
    Its data type is CHAR (Character String) with field length 4
  • ROKOSVOD : Tax Exemption Period: Start Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ROKOSVDO : Tax Exemption Period: End Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CENASTODH : Estimated Price
    Its data type is CHAR (Character String) with field length 1
  • CENAODHAD : Estimated Land Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • POCPATER : Number of Other Aboveground Floors
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • CISLOP : Registration Number
    Its data type is CHAR (Character String) with field length 6
  • ROKDOKONC : Completion Year of Building
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • POPIS : Name of Property Tax Object
    Its data type is CHAR (Character String) with field length 80
  • CIZIPOZ : Building on Third-Party Plot
    Its data type is CHAR (Character String) with field length 1
  • DRUHSTA : Building Type
    Its data type is CHAR (Character String) with field length 2
  • BYTKAT : Apartment category
    Its data type is CHAR (Character String) with field length 4
  • SVISKONST : Vertical supporting structure
    Its data type is CHAR (Character String) with field length 2
  • JEDNKMEN : Unit-master part
    Its data type is CHAR (Character String) with field length 6
  • JEDNBYT : Unit-apartment
    Its data type is CHAR (Character String) with field length 3
  • PLNOSVOB : Full Tax Exemption
    Its data type is CHAR (Character String) with field length 1
  • DATZMENY : Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CASZMENY : Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ZMENIL : Changed by
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Currency key
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Tax return items 18-28
  • X18 : Area of Land Type
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X19 : Land Price per Square Meter
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X20 : Tax Base According to Par.5 (1,2)
    Its data type is CURR (Currency Field) with field length 11
  • X21 : Tax Rate (Par. 6(1))
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X22 : Tax Base (Par.5(3))
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X23 : Tax Rate (Par 6(2))
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X24 : Factor According to Par. 6(4)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X25 : Land Tax
    Its data type is CURR (Currency Field) with field length 11
  • X26 : Claim for Exemption in Area
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X27 : Amount of Claim for Exemption (Par. 4,18(1))
    Its data type is CURR (Currency Field) with field length 11
  • X28 : Tax Liability
    Its data type is CURR (Currency Field) with field length 11
  • .INCLUDE : Tax return items 41-53
  • X41 : Covered area
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X42 : Basic tax rate §11(1)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X43 : Number of above-ground floors
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X44 : Incr.base rate for another above-ground floor §11(2)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X45 : Factor according to §11(3,4)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X46 : Resulting tax rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X47 : Building tax
    Its data type is CURR (Currency Field) with field length 11
  • X48 : Business area
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X49 : Tax increase according to §11(5)
    Its data type is CURR (Currency Field) with field length 11
  • X50 : Area relation §9(2)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X51 : Amount of exempt claim §11
    Its data type is CURR (Currency Field) with field length 11
  • X52 : Amount of claim for deduction §18(2)
    Its data type is CURR (Currency Field) with field length 11
  • X53 : Tax liability
    Its data type is CURR (Currency Field) with field length 11
  • .INCLUDE : Tax return items 54-56
  • X54_O : Total land tax – till 2008
    Its data type is CURR (Currency Field) with field length 11
  • X54 : Total Amount of Land Tax
    Its data type is CURR (Currency Field) with field length 11
  • X54_B : Total Amount of Land Tax
    Its data type is CURR (Currency Field) with field length 11
  • X55_O : Total building tax – till 2008
    Its data type is CURR (Currency Field) with field length 11
  • X55 : Total Amount of Building Tax
    Its data type is CURR (Currency Field) with field length 11
  • X55_B : Total Amount of Building Tax
    Its data type is CURR (Currency Field) with field length 11
  • X56_O : Total property tax – till 2008
    Its data type is CURR (Currency Field) with field length 11
  • X56 : Total Amount of Property Tax
    Its data type is CURR (Currency Field) with field length 11
  • X56_B : Total Amount of Property Tax
    Its data type is CURR (Currency Field) with field length 11
  • XKO12 : Municipality Coefficient (Par. 12)
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • .INCLUDE : Tax return items 58-59
  • X58_1 : Installment 1
    Its data type is CURR (Currency Field) with field length 11
  • X58_2 : Installment 2
    Its data type is CURR (Currency Field) with field length 11
  • X59_1 : Installment 1
    Its data type is CURR (Currency Field) with field length 11
  • X59_2 : Installment 2
    Its data type is CURR (Currency Field) with field length 11
  • X59_3 : Installment 3
    Its data type is CURR (Currency Field) with field length 11
  • X59_4 : Installment 4
    Its data type is CURR (Currency Field) with field length 11
  • .INCLUDE : Tax return items 67-69
  • X67 : Land type area
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X68A : Com.quotient denominator
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • X68B : Com.quotient numerator
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • X69 : Co-owned land type are
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X70 : Land price per square meter
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X71 : Tax base according to p.5 par. 1,2
    Its data type is CURR (Currency Field) with field length 11
  • X72 : Tax rate §6(1)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X73 : Tax base §5(3)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X74 : Tax rate §6(2)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X75 : Factor according to §6(4)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X76 : Land tax
    Its data type is CURR (Currency Field) with field length 11
  • X77 : Claim for area exempt
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X78 : Amount of claim for exempt §4,18(1)
    Its data type is CURR (Currency Field) with field length 11
  • X79 : Liability to pay taxes
    Its data type is CURR (Currency Field) with field length 11
  • .INCLUDE : Tax return items 95-103
  • X95 : Floor area of the unit
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X96 : Factor according to §10(2)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X97 : Base tax rate according to §10(2)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • X98 : Base tax rate according to §11(1)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X99 : Factor according to §11(3,4)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X100 : Resulting tax rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • X101 : Building tax
    Its data type is CURR (Currency Field) with field length 11
  • X102 : Amount of claim for exemption according to §9
    Its data type is CURR (Currency Field) with field length 11
  • X103 : Tax liability
    Its data type is CURR (Currency Field) with field length 11
  • AGR_PAR1 : Free aggregation parameter
    Its data type is CHAR (Character String) with field length 10
  • AGR_PAR2 : Free aggregation parameter
    Its data type is CHAR (Character String) with field length 10
  • AGR_PAR3 : Free aggregation parameter
    Its data type is CHAR (Character String) with field length 10
  • AGR_PAR4 : Free aggregation parameter
    Its data type is CHAR (Character String) with field length 10
  • ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • XDAN : Subject to Property Tax
    Its data type is CHAR (Character String) with field length 1
  • DATVYPOCTU : Calculation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CASVYPOCTU : Calculation Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • STAVYPOCTU : Calculation status
    Its data type is CHAR (Character String) with field length 1
  • VYPOCETL : Calculation Executed by
    Its data type is CHAR (Character String) with field length 12
  • TBUKR2 : Dominant Enterprise/Company Code
    Its data type is CHAR (Character String) with field length 4
  • MBUKR : Indicator: Dominant Company Code
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Property tax – Paved Area
  • SOLIDAGR : Paved Area (Agricultural Purp.)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SOLIDIND : Paved Area (Industrial Purp.)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SOLAAGRE : Tax-Exempt Paved Area (Argicultural Purp.)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SOLAINDE : Tax-Exempt Paved Area (Industrial Purp.)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • YEAGREFR : First Year of Tax Exemption Period (Agricultural Purp.)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • YEINDEFR : First Year of Tax Exemption Period (Industrial Purp.)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • YEAGRETO : Last Year of Tax Exemption Period (Agricultural Purp.)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • YEINDETO : Last Year of Tax Exemption Period (Industrial Purp.)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CODEAGRE : Tax Exemption Code for Paved Area (Agr. Purp.)
    Its data type is CHAR (Character String) with field length 4
  • CODEINDE : Tax Exemption Code for Paved Area (Ind. Purp.)
    Its data type is CHAR (Character String) with field length 4