/CEERE/SDAN SAP (Property tax return - sheets) Table details
Dictionary Type: Table
Description: Property tax return - sheets
Description: Property tax return - sheets
Table field list including key, data, relationships and ABAP select examples
/CEERE/SDAN is a standard SAP Table which is used to store Property tax return - sheets data and is available within R/3 SAP systems depending on the version and release level.
The /CEERE/SDAN table consists of various fields, each holding specific information or linking keys about Property tax return - sheets data available in SAP. These include BUKRS (Company Code), GJAHR (Fiscal Year), TYPDANP (Type of Tax Return), TYPNEM (Property Category).. 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/SDAN 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 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
TYPDANP | Type of Tax Return | /CEERE/TYPDANP | CHAR | 1 | /CEERE/TYPDANP | ||||
TYPNEM | Property Category | /CEERE/TYPNEM | CHAR | 1 | Assigned to domain | /CEERE/TYPNEM | /CEERE/TNM | ||
DRNEM | Property Type | /CEERE/DRUHNEM | CHAR | 1 | Assigned to domain | /CEERE/DRUHNEM | |||
KODFU | Tax Office Code | /CEERE/KODFU | CHAR | 3 | Assigned to domain | ALPHA | /CEERE/KODFU | /CEERE/KFU | /CEERE/FUC |
KODOBCE | Code of Municipality or City District | /CEERE/KODOBCE | CHAR | 8 | Assigned to domain | /CEERE/KODOBCE | /CEERE/OBMC | ||
GEMARK | Local Subdistrict | VVGEMARK | CHAR | 12 | Assigned to domain | VVGEMARK | |||
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 | |||||
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 | ||||
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 | ||||
CLISTU | Number of tax return sheet | /CEERE/CLISTU | CHAR | 3 | /CEERE/CLISTU | ||||
STAVLISTU | Status of tax return sheet | /CEERE/STAVLISTU | CHAR | 1 | /CEERE/STAVSLITU | ||||
DATVYPOCTU | Calculation Date | /CEERE/DATVYPOCTU | DATS | 8 | |||||
CASVYPOCTU | Calculation Time | /CEERE/CASVYPOCTU | TIMS | 6 | |||||
VYPOCETL | Calculation Executed by | /CEERE/VYPOCETL | CHAR | 12 | |||||
MBUKR | Indicator: Dominant Company Code | /CEERE/MBUKR | CHAR | 1 | XFELD | ||||
LISTCISLO | Numc3, internal use | NUMC3 | NUMC | 3 | NUMC3 |
Key field | Non-key field |
How do I retrieve data from SAP table /CEERE/SDAN using ABAP code
The following ABAP code Example will allow you to do a basic selection on /CEERE/SDAN to SELECT all data from the tableDATA: WA_/CEERE/SDAN TYPE /CEERE/SDAN.
SELECT SINGLE *
FROM /CEERE/SDAN
INTO CORRESPONDING FIELDS OF WA_/CEERE/SDAN
WHERE...
How to access SAP table /CEERE/SDAN
Within an ECC or HANA version of SAP you can also view further information about /CEERE/SDAN 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