SAP Table /CEERE/SDANP - Property tax - master

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
GJAHR X GJAHR NUMC 7 4 0 Fiscal Year
TYPNEMREM X /CEERE/TYPNEMREM CHAR 11 1 0 Real Estate Object Type
SWENR X SWENR CHAR 12 8 0 VIOB01 Business Entity Number
KEYNEM X /CEERE/KEYNEM CHAR 20 8 0 Property Key
TYPNEM /CEERE/TYPNEM CHAR 28 1 0 /CEERE/TPNEM Property Category
DRNEM /CEERE/DRUHNEM CHAR 29 1 0 /CEERE/DRNEM Property Type
KODFU /CEERE/KODFU CHAR 30 3 0 Tax Office Code
KODOBCE /CEERE/KODOBCE CHAR 33 8 0 /CEERE/OBCE Code of Municipality or City District
NAZEVOBCE /CEERE/NAZEVOBCE CHAR 41 35 0 Name of Municipality or City District
KODCOBCE /CEERE/KODCOBCE CHAR 76 6 0 District Code
GEMARK VVGEMARK CHAR 82 12 0 TIVG2 Local Subdistrict
NAZEVKU /CEERE/NAZEVKU CHAR 94 40 0 Cadastral District Name
NARPARK /CEERE/NARPARK CHAR 134 1 0 Property Located in National Park
PARCKMEN /CEERE/PARCKMEN CHAR 135 1 0 Master Number of Parcel
PARCPOD /CEERE/PARCPOD CHAR 140 1 0 Additional Number of Parcel
PARCDIL /CEERE/PARCDIL CHAR 143 1 0 Parcel Sub-Number
VYMERA /CEERE/VYMERA DEC 145 9 2 Total Area
PRAVZTAH /CEERE/PRAVZTAH CHAR 150 4 0 Legal Relations
SV_CITATEL /CEERE/SV_CITATEL DEC 154 7 0 Co-Ownership Proportion
SV_JMENOVATEL /CEERE/SV_JMENOVATEL DEC 158 7 0 Co-Ownership Proportion
VYMERAOSV /CEERE/VYMERAOSV DEC 162 9 2 Area Exempted From Tax
VYMERAPOD /CEERE/VYMERAPOD DEC 167 9 2 Floor Area for Business
ZASTPL /CEERE/ZASTPL DEC 172 9 2 Covered Area
PLOCHANP /CEERE/PLOCHANP DEC 177 9 2 Total Area of Floors Above the Ground Floor
KODOSVOB /CEERE/KODOSVOB CHAR 182 4 0 Tax Exemption Code
ROKOSVOD /CEERE/ROKOSVOD NUMC 186 4 0 Tax Exemption Period: Start Year
ROKOSVDO /CEERE/ROKOSVDO NUMC 190 4 0 Tax Exemption Period: End Year
CENASTODH /CEERE/CENAODH CHAR 194 1 0 Estimated Price
CENAODHAD /CEERE/CENAP DEC 195 9 2 Estimated Land Price
POCPATER /CEERE/POCPATER CHAR 200 1 0 Number of Floors Above Ground Floor
CISLOP /CEERE/CISLOP CHAR 202 1 0 Registration Number
ROKDOKONC /CEERE/ROKDOKONC NUMC 208 4 0 Completion Year of Building
POPIS /CEERE/POPISSTAVBY CHAR 212 80 0 Name of Property Tax Object
CIZIPOZ /CEERE/CIZIPOZ CHAR 292 1 0 Building on Third-Party Plot
DRUHSTA /CEERE/DRUHSTA CHAR 293 2 0 Building Type
BYTKAT /CEERE/BYTKAT CHAR 295 4 0 Apartment category
SVISKONST /CEERE/SVISKONST CHAR 299 2 0 Vertical supporting structure
JEDNKMEN /CEERE/JEDNKMEN CHAR 301 1 0 Unit-master part
JEDNBYT /CEERE/JEDNBYT CHAR 307 1 0 Unit-apartment
PLNOSVOB /CEERE/PLNOSVOB CHAR 310 1 0 Full Tax Exemption
DATZMENY DATUM DATS 311 8 0 Date
CASZMENY UZEIT TIMS 319 6 0 Time
ZMENIL USER CHAR 325 12 0 Changed by
WAERS WAERS CUKY 337 5 0 TCURC Currency Key
X18 /CEERE/X18 DEC 342 9 2 Area of Land Type
X19 /CEERE/X19 DEC 347 9 2 Land Price per Square Meter
X20 /CEERE/X20 CURR 352 11 2 Tax Base According to Par.5 (1,2)
X21 /CEERE/X21 DEC 358 5 2 Tax Rate (Par. 6(1))
X22 /CEERE/X22 DEC 361 9 2 Tax Base (Par.5(3))
X23 /CEERE/X23 DEC 366 5 2 Tax Rate (Par 6(2))
X24 /CEERE/X24 DEC 369 5 2 Factor According to Par. 6(4)
X25 /CEERE/X25 CURR 372 11 2 Land Tax
X26 /CEERE/X26 DEC 378 9 2 Claim for Exemption in Area
X27 /CEERE/X27 CURR 383 11 2 Amount of Claim for Exemption (Par. 4,18(1))
X28 /CEERE/X28 CURR 389 11 2 Tax Liability
X41 /CEERE/X41 DEC 395 9 2 Covered area
X42 /CEERE/X42 DEC 400 5 2 Basic tax rate §11(1)
X43 /CEERE/X43 CHAR 403 1 0 Number of above-ground floors
X44 /CEERE/X44 DEC 408 9 2 Incr.base rate for another above-ground floor §11(2)
X45 /CEERE/X45 DEC 413 5 2 Factor according to §11(3,4)
X46 /CEERE/X46 DEC 416 9 2 Resulting tax rate
X47 /CEERE/X47 CURR 421 11 2 Building tax
X48 /CEERE/X48 DEC 427 9 2 Business area
X49 /CEERE/X49 CURR 432 11 2 Tax increase according to §11(5)
X50 /CEERE/X50 DEC 438 9 2 Area relation §9(2)
X51 /CEERE/X51 CURR 443 11 2 Amount of exempt claim §11
X52 /CEERE/X52 CURR 449 11 2 Amount of claim for deduction §18(2)
X53 /CEERE/X53 CURR 455 11 2 Tax liability
X54_O /CEERE/X54_O CURR 461 11 2 Total land tax - till 2008
X54 /CEERE/X54 CURR 467 11 2 Total Amount of Land Tax
X54_B /CEERE/X54 CURR 473 11 2 Total Amount of Land Tax
X55_O /CEERE/X55_O CURR 479 11 2 Total building tax - till 2008
X55 /CEERE/X55 CURR 485 11 2 Total Amount of Building Tax
X55_B /CEERE/X55 CURR 491 11 2 Total Amount of Building Tax
X56_O /CEERE/X56_O CURR 497 11 2 Total property tax - till 2008
X56 /CEERE/X56 CURR 503 11 2 Total Amount of Property Tax
X56_B /CEERE/X56 CURR 509 11 2 Total Amount of Property Tax
XKO12 /CEERE/XKO12 INT1 515 3 0 Municipality Coefficient (Par. 12)
X58_1 /CEERE/SPLATKA CURR 516 11 2 Installment 1
X58_2 /CEERE/SPLATKA2 CURR 522 11 2 Installment 2
X59_1 /CEERE/SPLATKA CURR 528 11 2 Installment 1
X59_2 /CEERE/SPLATKA2 CURR 534 11 2 Installment 2
X59_3 /CEERE/SPLATKA3 CURR 540 11 2 Installment 3
X59_4 /CEERE/SPLATKA4 CURR 546 11 2 Installment 4
X67 /CEERE/X67 DEC 552 9 2 Land type area
X68A /CEERE/X68A CHAR 560 1 0 Com.quotient denominator
X68B /CEERE/X68B CHAR 564 1 0 Com.quotient numerator
X69 /CEERE/X69 DEC 568 9 2 Co-owned land type are
X70 /CEERE/X70 DEC 573 9 2 Land price per square meter
X71 /CEERE/X71 CURR 578 11 2 Tax base according to p.5 par. 1,2
X72 /CEERE/X72 DEC 584 5 2 Tax rate §6(1)
X73 /CEERE/X73 DEC 587 9 2 Tax base §5(3)
X74 /CEERE/X74 DEC 592 5 2 Tax rate §6(2)
X75 /CEERE/X75 DEC 595 5 2 Factor according to §6(4)
X76 /CEERE/X76 CURR 598 11 2 Land tax
X77 /CEERE/X77 DEC 604 9 2 Claim for area exempt
X78 /CEERE/X78 CURR 609 11 2 Amount of claim for exempt §4,18(1)
X79 /CEERE/X79 CURR 615 11 2 Liability to pay taxes
X95 /CEERE/X95 DEC 624 9 2 Floor area of the unit
X96 /CEERE/X96 DEC 629 5 2 Factor according to §10(2)
X97 /CEERE/X97 DEC 632 9 2 Base tax rate according to §10(2)
X98 /CEERE/X98 DEC 637 5 2 Base tax rate according to §11(1)
X99 /CEERE/X99 DEC 640 5 2 Factor according to §11(3,4)
X100 /CEERE/X100 DEC 643 5 2 Resulting tax rate
X101 /CEERE/X101 CURR 646 11 2 Building tax
X102 /CEERE/X102 CURR 652 11 2 Amount of claim for exemption according to §9
X103 /CEERE/X103 CURR 658 11 2 Tax liability
AGR_PAR1 /CEERE/AGR_PAR CHAR 664 1 0 Free aggregation parameter
AGR_PAR2 /CEERE/AGR_PAR CHAR 674 1 0 Free aggregation parameter
AGR_PAR3 /CEERE/AGR_PAR CHAR 684 1 0 Free aggregation parameter
AGR_PAR4 /CEERE/AGR_PAR CHAR 694 1 0 Free aggregation parameter
ANLN1 ANLN1 CHAR 704 12 0 ANLH Main Asset Number
ANLN2 ANLN2 CHAR 716 4 0 ANLA Asset Subnumber
KOSTL KOSTL CHAR 720 10 0 Cost Center
GSBER GSBER CHAR 730 4 0 TGSB Business Area
PRCTR PRCTR CHAR 734 10 0 Profit Center
AUFNR AUFNR CHAR 744 12 0 AUFK Order Number
PS_PSP_PNR PS_PSP_PNR NUMC 756 8 0 PRPS Work Breakdown Structure Element (WBS Element)
XDAN /CEERE/XDAN CHAR 764 1 0 Subject to Property Tax
DATVYPOCTU /CEERE/DATVYPOCTU CHAR 765 1 0 Calculation Date
CASVYPOCTU /CEERE/CASVYPOCTU CHAR 773 1 0 Calculation Time
STAVYPOCTU /CEERE/STAVYPOCTU CHAR 779 1 0 Calculation status
VYPOCETL /CEERE/VYPOCETL CHAR 780 1 0 Calculation Executed by
TBUKR2 /CEERE/FOT_TBUKRS CHAR 792 4 0 T001 Dominant Enterprise/Company Code
MBUKR /CEERE/MBUKR CHAR 796 1 0 Indicator: Dominant Company Code