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