1. SAP Tutorial
  2. Real Estate Management

/CEERE/SDAN SAP table for – Property tax return – sheets

Here we would like to draw your attention to /CEERE/SDAN 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/SDAN is a SAP standard transp table used for storing Property tax return – sheets related data in SAP. It comes under the package /CEERE/DANNEM.

SAP /CEERE/SDAN table

Table /CEERE/SDAN technical data

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

SAP /CEERE/SDAN 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/SDAN 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
  • TYPDANP : Type of Tax Return
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • TYPNEM : Property Category
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DRNEM : Property Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • KODFU : Tax Office Code
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • KODOBCE : Code of Municipality or City District
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • GEMARK : Local Subdistrict
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • AGR_PAR1 : Free aggregation parameter
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • AGR_PAR2 : Free aggregation parameter
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • AGR_PAR3 : Free aggregation parameter
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • AGR_PAR4 : Free aggregation parameter
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • .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 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
  • CLISTU : Number of tax return sheet
    Its data type is CHAR (Character String) with field length 3
  • STAVLISTU : Status of tax return sheet
    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
  • VYPOCETL : Calculation Executed by
    Its data type is CHAR (Character String) with field length 12
  • MBUKR : Indicator: Dominant Company Code
    Its data type is CHAR (Character String) with field length 1
  • LISTCISLO : Numc3, internal use
    Its data type is NUMC (Character String with Digits Only) with field length 3

    • /CEERE/SDAN related tables

    • /CEERE/OKRES : Counties
    • /CEERE/FUR : Regional Tax Office Workplace
    • /CEERE/KOEFMP : obsolete Koeficients for municipalities parts
    • /CEERE/FUKDC : Tax office: master data – time dependent
    • /CEERE/USNAK : Property tax: posting schema – costs
    • /CEERE/SDAN : Property tax return – sheets
    • /CEERE/COBVYH : Districts in municipal regulation
    • /CEERE/KOEF : Factors according to §6 par.4 a) and §11 par.3 a)
    • /CEERE/SDANA : Property tax return – items
    • /CEERE/MAPLT : obsolete OT areas – description
    • /CEERE/KU : Cadastral district
    • /CEERE/BSEG : Property tax: booked FI items
    • /CEERE/COBCE : Districts (for municipal regulations)
    • /CEERE/MAPLFX : Area mapping PT-> RE-FX
    • /CEERE/RIZENI : PT settings for company code
    • /CEERE/SDANP : Property tax – master
    • /CEERE/KOSVOB : Tax exemption codes according to Act No.338 §4 and §9
    • /CEERE/OBCE : Municipalities
    • /CEERE/TBUKRS : Main Company Code
    • /CEERE/TPNEM : Property categories

    /CEERE/SDAN related transaction codes under SAP package /CEERE/DANNEM

    • /CEERE/DNUZ : Year closing
    • /CEERE/TBUKRS : Dominant Company Codes
    • /CEERE/DNPRE : Overview
    • /CEERE/19000327 : IMG activity: /CEERE/MMAPL
    • /CEERE/MMAPLT : Areas for property tax
    • /CEERE/19000330 : IMG activity: /CEERE/FU
    • /CEERE/MFUKD : Tax office: master data
    • /CEERE/DNLOAD : Download of key lists from internet
    • /CEERE/DANXML : xml output of property tax return
    • /CEERE/DN05 : Calculation
    • /CEERE/19000329 : IMG activity: /CEERE/MRIZENI
    • /CEERE/19000332 : IMG activity: /CEERE/MNUCOK
    • /CEERE/DNEM02 : Tax objects
    • /CEERE/MKUK : SO: Aver.prices of agricultural land
    • /CEERE/RIZBUK : Company Codes to Dominant Co.Codes
    • /CEERE/19000328 : IMG activity: /CEERE/MKONSTC
    • /CEERE/FU_MREGW : Tax office: master data
    • /CEERE/DNUCTO : Posting
    • /CEERE/MNUCOK : Company code settings
    • /CEERE/19000326 : IMG activity: /CEERE/MTPZDR

    Related References

    Related Tutorials

    /CEERE/SDANA SAP table for – Property tax return – items

    /CEERE/SDANA table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIXCSKTAXRET_S SAP table for – Property Tax Return SK – Sheets – Sections II,III,IV

    VIXCSKTAXRET_S table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    /CEERE/SDANFU SAP table for – Property tax return – section IV

    /CEERE/SDANFU table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

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

    /CEERE/SDANP table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIXCSKTAXRET_P SAP table for – Property Tax Return SK – Items – Sections II,III,IV

    VIXCSKTAXRET_P table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIXCSKTAXRET_H SAP table for – Property Tax Return SK – Cover, Section V

    VIXCSKTAXRET_H table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    /CEERE/DANXML SAP tcode for – xml output of property tax return

    /CEERE/DANXML tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for xml output...

    «
    »