/CEERE/SDANP SAP (Property tax - master) Table details
Dictionary Type: Table
Description: Property tax - master
Description: Property tax - master
Table field list including key, data, relationships and ABAP select examples
/CEERE/SDANP is a standard SAP Table which is used to store Property tax - master data and is available within R/3 SAP systems depending on the version and release level.
The /CEERE/SDANP table consists of various fields, each holding specific information or linking keys about Property tax - master data available in SAP. These include BUKRS (Company Code), GJAHR (Fiscal Year), TYPNEMREM (Real Estate Object Type), SWENR (Site Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /CEERE/SDANP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
TYPNEMREM | Real Estate Object Type | /CEERE/TYPNEMREM | CHAR | 1 | /CEERE/TYPNEMREM | ||||
SWENR | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
KEYNEM | Property Key | /CEERE/KEYNEM | CHAR | 8 | Assigned to domain | SGRNR | SGRNR | /CEERE/KNM | |
TYPNEM | Property Category | /CEERE/TYPNEM | CHAR | 1 | /CEERE/TPNEM | /CEERE/TYPNEM | /CEERE/TNM | ||
DRNEM | Property Type | /CEERE/DRUHNEM | CHAR | 1 | /CEERE/DRNEM | /CEERE/DRUHNEM | |||
KODFU | Tax Office Code | /CEERE/KODFU | CHAR | 3 | /CEERE/FUC | ALPHA | /CEERE/KODFU | /CEERE/KFU | /CEERE/FUC |
KODOBCE | Code of Municipality or City District | /CEERE/KODOBCE | CHAR | 8 | /CEERE/OBCE | /CEERE/KODOBCE | /CEERE/OBMC | ||
NAZEVOBCE | Name of Municipality or City District | /CEERE/NAZEVOBCE | CHAR | 35 | /CEERE/NAZEVOBCE | ||||
KODCOBCE | District Code | /CEERE/KODCOBCE | CHAR | 6 | Assigned to domain | /CEERE/KODCOBCE | |||
GEMARK | Local Subdistrict | VVGEMARK | CHAR | 12 | /CEERE/KU | VVGEMARK | |||
NAZEVKU | Cadastral District Name | /CEERE/NAZEVKU | CHAR | 40 | /CEERE/NAZEVKU | ||||
NARPARK | Property Located in National Park | /CEERE/NARPARK | CHAR | 1 | |||||
PARCKMEN | Master Number of Parcel | /CEERE/PARCKMEN | CHAR | 5 | |||||
PARCPOD | Additional Number of Parcel | /CEERE/PARCPOD | CHAR | 3 | |||||
PARCDIL | Parcel Sub-Number | /CEERE/PARCDIL | CHAR | 2 | |||||
VYMERA | Total Area | /CEERE/VYMERA | DEC | 9(2) | /CEERE/PLOCHA | ||||
PRAVZTAH | Legal Relations | /CEERE/PRAVZTAH | CHAR | 4 | /CEERE/PRAVZTAH | ||||
SV_CITATEL | Co-Ownership Share (Numerator) | /CEERE/SV_CITATEL | DEC | 7 | /CEERE/SV_CITATEL | ||||
SV_JMENOVATEL | Co-Ownership Share (Denominator) | /CEERE/SV_JMENOVATEL | DEC | 7 | /CEERE/SV_JMENOVATEL | ||||
VYMERAOSV | Area Exempted From Tax | /CEERE/VYMERAOSV | DEC | 9(2) | /CEERE/PLOCHA | ||||
VYMERAPOD | Floor Area for Business | /CEERE/VYMERAPOD | DEC | 9(2) | /CEERE/PLOCHA | ||||
ZASTPL | Covered Area | /CEERE/ZASTPL | DEC | 9(2) | /CEERE/PLOCHA | ||||
PLOCHANP | Total Area of Floors Above the Ground Floor | /CEERE/PLOCHANP | DEC | 9(2) | /CEERE/PLOCHA | ||||
KODOSVOB | Tax Exemption Code | /CEERE/KODOSVOB | CHAR | 4 | Assigned to domain | /CEERE/KODOSVOB | |||
ROKOSVOD | Tax Exemption Period: Start Year | /CEERE/ROKOSVOD | NUMC | 4 | GJAHR | GJAHR | |||
ROKOSVDO | Tax Exemption Period: End Year | /CEERE/ROKOSVDO | NUMC | 4 | GJAHR | GJAHR | |||
CENASTODH | Estimated Price | /CEERE/CENAODH | CHAR | 1 | |||||
CENAODHAD | Estimated Land Price | /CEERE/CENAP | DEC | 9(2) | /CEERE/CENAP | ||||
POCPATER | Number of Other Aboveground Floors | /CEERE/POCPATER | DEC | 3 | |||||
CISLOP | Registration Number | /CEERE/CISLOP | CHAR | 6 | |||||
ROKDOKONC | Completion Year of Building | /CEERE/ROKDOKONC | NUMC | 4 | GJAHR | GJAHR | |||
POPIS | Name of Property Tax Object | /CEERE/POPISSTAVBY | CHAR | 80 | /CEERE/POPIS80 | ||||
CIZIPOZ | Building on Third-Party Plot | /CEERE/CIZIPOZ | CHAR | 1 | |||||
DRUHSTA | Building Type | /CEERE/DRUHSTA | CHAR | 2 | /CEERE/DRUHSTA | ||||
BYTKAT | Apartment category | /CEERE/BYTKAT | CHAR | 4 | /CEERE/BYTKAT | ||||
SVISKONST | Vertical supporting structure | /CEERE/SVISKONST | CHAR | 2 | /CEERE/SVISKONST | ||||
JEDNKMEN | Unit-master part | /CEERE/JEDNKMEN | CHAR | 6 | |||||
JEDNBYT | Unit-apartment | /CEERE/JEDNBYT | CHAR | 3 | |||||
PLNOSVOB | Full Tax Exemption | /CEERE/PLNOSVOB | CHAR | 1 | |||||
DATZMENY | Date | DATUM | DATS | 8 | DATUM | ||||
CASZMENY | Time | UZEIT | TIMS | 6 | UZEIT | ||||
ZMENIL | Changed by | USER | CHAR | 12 | CHAR12 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
X18 | Area of Land Type | /CEERE/X18 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X19 | Land Price per Square Meter | /CEERE/X19 | DEC | 9(2) | /CEERE/CENAP | ||||
X20 | Tax Base According to Par.5 (1,2) | /CEERE/X20 | CURR | 11(2) | /CEERE/CASTKA | ||||
X21 | Tax Rate (Par. 6(1)) | /CEERE/X21 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X22 | Tax Base (Par.5(3)) | /CEERE/X22 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X23 | Tax Rate (Par 6(2)) | /CEERE/X23 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X24 | Factor According to Par. 6(4) | /CEERE/X24 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X25 | Land Tax | /CEERE/X25 | CURR | 11(2) | /CEERE/CASTKA | ||||
X26 | Claim for Exemption in Area | /CEERE/X26 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X27 | Amount of Claim for Exemption (Par. 4,18(1)) | /CEERE/X27 | CURR | 11(2) | /CEERE/CASTKA | ||||
X28 | Tax Liability | /CEERE/X28 | CURR | 11(2) | /CEERE/CASTKA | ||||
X41 | Covered area | /CEERE/X41 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X42 | Basic tax rate §11(1) | /CEERE/X42 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X43 | Number of above-ground floors | /CEERE/X43 | DEC | 9 | |||||
X44 | Incr.base rate for another above-ground floor §11(2) | /CEERE/X44 | DEC | 9(2) | /CEERE/CENAP | ||||
X45 | Factor according to §11(3,4) | /CEERE/X45 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X46 | Resulting tax rate | /CEERE/X46 | DEC | 9(2) | /CEERE/DEC9_2 | ||||
X47 | Building tax | /CEERE/X47 | CURR | 11(2) | /CEERE/CASTKA | ||||
X48 | Business area | /CEERE/X48 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X49 | Tax increase according to §11(5) | /CEERE/X49 | CURR | 11(2) | /CEERE/CASTKA | ||||
X50 | Area relation §9(2) | /CEERE/X50 | DEC | 9(2) | /CEERE/DEC9_2 | ||||
X51 | Amount of exempt claim §11 | /CEERE/X51 | CURR | 11(2) | /CEERE/CASTKA | ||||
X52 | Amount of claim for deduction §18(2) | /CEERE/X52 | CURR | 11(2) | /CEERE/CASTKA | ||||
X53 | Tax liability | /CEERE/X53 | CURR | 11(2) | /CEERE/CASTKA | ||||
X54_O | Total land tax - till 2008 | /CEERE/X54_O | CURR | 11(2) | /CEERE/CASTKA | ||||
X54 | Total Amount of Land Tax | /CEERE/X54 | CURR | 11(2) | /CEERE/CASTKA | ||||
X54_B | Total Amount of Land Tax | /CEERE/X54 | CURR | 11(2) | /CEERE/CASTKA | ||||
X55_O | Total building tax - till 2008 | /CEERE/X55_O | CURR | 11(2) | /CEERE/CASTKA | ||||
X55 | Total Amount of Building Tax | /CEERE/X55 | CURR | 11(2) | /CEERE/CASTKA | ||||
X55_B | Total Amount of Building Tax | /CEERE/X55 | CURR | 11(2) | /CEERE/CASTKA | ||||
X56_O | Total property tax - till 2008 | /CEERE/X56_O | CURR | 11(2) | /CEERE/CASTKA | ||||
X56 | Total Amount of Property Tax | /CEERE/X56 | CURR | 11(2) | /CEERE/CASTKA | ||||
X56_B | Total Amount of Property Tax | /CEERE/X56 | CURR | 11(2) | /CEERE/CASTKA | ||||
XKO12 | Municipality Coefficient (Par. 12) | /CEERE/XKO12 | INT1 | 3 | INT1 | ||||
X58_1 | Installment 1 | /CEERE/SPLATKA | CURR | 11(2) | /CEERE/CASTKA | ||||
X58_2 | Installment 2 | /CEERE/SPLATKA2 | CURR | 11(2) | /CEERE/CASTKA | ||||
X59_1 | Installment 1 | /CEERE/SPLATKA | CURR | 11(2) | /CEERE/CASTKA | ||||
X59_2 | Installment 2 | /CEERE/SPLATKA2 | CURR | 11(2) | /CEERE/CASTKA | ||||
X59_3 | Installment 3 | /CEERE/SPLATKA3 | CURR | 11(2) | /CEERE/CASTKA | ||||
X59_4 | Installment 4 | /CEERE/SPLATKA4 | CURR | 11(2) | /CEERE/CASTKA | ||||
X67 | Land type area | /CEERE/X67 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X68A | Com.quotient denominator | /CEERE/X68A | INT4 | 10 | |||||
X68B | Com.quotient numerator | /CEERE/X68B | INT4 | 10 | |||||
X69 | Co-owned land type are | /CEERE/X69 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X70 | Land price per square meter | /CEERE/X70 | DEC | 9(2) | /CEERE/CENAP | ||||
X71 | Tax base according to p.5 par. 1,2 | /CEERE/X71 | CURR | 11(2) | /CEERE/CASTKA | ||||
X72 | Tax rate §6(1) | /CEERE/X72 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X73 | Tax base §5(3) | /CEERE/X73 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X74 | Tax rate §6(2) | /CEERE/X74 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X75 | Factor according to §6(4) | /CEERE/X75 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X76 | Land tax | /CEERE/X76 | CURR | 11(2) | /CEERE/CASTKA | ||||
X77 | Claim for area exempt | /CEERE/X77 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X78 | Amount of claim for exempt §4,18(1) | /CEERE/X78 | CURR | 11(2) | /CEERE/CASTKA | ||||
X79 | Liability to pay taxes | /CEERE/X79 | CURR | 11(2) | /CEERE/CASTKA | ||||
X95 | Floor area of the unit | /CEERE/X95 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X96 | Factor according to §10(2) | /CEERE/X96 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X97 | Base tax rate according to §10(2) | /CEERE/X97 | DEC | 9(2) | /CEERE/PLOCHA | ||||
X98 | Base tax rate according to §11(1) | /CEERE/X98 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X99 | Factor according to §11(3,4) | /CEERE/X99 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X100 | Resulting tax rate | /CEERE/X100 | DEC | 5(2) | /CEERE/DEC5_2 | ||||
X101 | Building tax | /CEERE/X101 | CURR | 11(2) | /CEERE/CASTKA | ||||
X102 | Amount of claim for exemption according to §9 | /CEERE/X102 | CURR | 11(2) | /CEERE/CASTKA | ||||
X103 | Tax liability | /CEERE/X103 | CURR | 11(2) | /CEERE/CASTKA | ||||
AGR_PAR1 | Free aggregation parameter | /CEERE/AGR_PAR | CHAR | 10 | |||||
AGR_PAR2 | Free aggregation parameter | /CEERE/AGR_PAR | CHAR | 10 | |||||
AGR_PAR3 | Free aggregation parameter | /CEERE/AGR_PAR | CHAR | 10 | |||||
AGR_PAR4 | Free aggregation parameter | /CEERE/AGR_PAR | CHAR | 10 | |||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
XDAN | Subject to Property Tax | /CEERE/XDAN | CHAR | 1 | |||||
DATVYPOCTU | Calculation Date | /CEERE/DATVYPOCTU | DATS | 8 | |||||
CASVYPOCTU | Calculation Time | /CEERE/CASVYPOCTU | TIMS | 6 | |||||
STAVYPOCTU | Calculation status | /CEERE/STAVYPOCTU | CHAR | 1 | |||||
VYPOCETL | Calculation Executed by | /CEERE/VYPOCETL | CHAR | 12 | |||||
TBUKR2 | Dominant Enterprise/Company Code | /CEERE/FOT_TBUKRS | CHAR | 4 | Assigned to domain | BUKRS | |||
MBUKR | Indicator: Dominant Company Code | /CEERE/MBUKR | CHAR | 1 | XFELD | ||||
SOLIDAGR | Paved Area (Agricultural Purp.) | /CEERE/SOLIDAGR | DEC | 9(2) | /CEERE/PLOCHA | ||||
SOLIDIND | Paved Area (Industrial Purp.) | /CEERE/SOLIDIND | DEC | 9(2) | /CEERE/PLOCHA | ||||
SOLAAGRE | Tax-Exempt Paved Area (Argicultural Purp.) | /CEERE/SOLAAGRE | DEC | 9(2) | /CEERE/PLOCHA | ||||
SOLAINDE | Tax-Exempt Paved Area (Industrial Purp.) | /CEERE/SOLAINDE | DEC | 9(2) | /CEERE/PLOCHA | ||||
YEAGREFR | First Year of Tax Exemption Period (Agricultural Purp.) | /CEERE/YEAGREFR | NUMC | 4 | GJAHR | GJAHR | |||
YEINDEFR | First Year of Tax Exemption Period (Industrial Purp.) | /CEERE/YEINDEFR | NUMC | 4 | GJAHR | GJAHR | |||
YEAGRETO | Last Year of Tax Exemption Period (Agricultural Purp.) | /CEERE/YEAGRETO | NUMC | 4 | GJAHR | GJAHR | |||
YEINDETO | Last Year of Tax Exemption Period (Industrial Purp.) | /CEERE/YEINDETO | NUMC | 4 | GJAHR | GJAHR | |||
CODEAGRE | Tax Exemption Code for Paved Area (Agr. Purp.) | /CEERE/CODEAGRE | CHAR | 4 | Assigned to domain | /CEERE/KODOSVOB | |||
CODEINDE | Tax Exemption Code for Paved Area (Ind. Purp.) | /CEERE/CODEINDE | CHAR | 4 | Assigned to domain | /CEERE/KODOSVOB |
Key field | Non-key field |
How do I retrieve data from SAP table /CEERE/SDANP using ABAP code
The following ABAP code Example will allow you to do a basic selection on /CEERE/SDANP to SELECT all data from the tableDATA: WA_/CEERE/SDANP TYPE /CEERE/SDANP.
SELECT SINGLE *
FROM /CEERE/SDANP
INTO CORRESPONDING FIELDS OF WA_/CEERE/SDANP
WHERE...
How to access SAP table /CEERE/SDANP
Within an ECC or HANA version of SAP you can also view further information about /CEERE/SDANP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects