/CEERE/SDAN SAP (Property tax return - sheets) Table details

Dictionary Type: Table
Description: Property tax return - sheets




ABAP Code to SELECT data from /CEERE/SDAN
Related tables to /CEERE/SDAN
Access table /CEERE/SDAN




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
TYPDANPType of Tax Return /CEERE/TYPDANPCHAR1/CEERE/TYPDANP
TYPNEMProperty Category /CEERE/TYPNEMCHAR1Assigned to domain/CEERE/TYPNEM/CEERE/TNM
DRNEMProperty Type /CEERE/DRUHNEMCHAR1Assigned to domain/CEERE/DRUHNEM
KODFUTax Office Code /CEERE/KODFUCHAR3Assigned to domainALPHA/CEERE/KODFU/CEERE/KFU/CEERE/FUC
KODOBCECode of Municipality or City District /CEERE/KODOBCECHAR8Assigned to domain/CEERE/KODOBCE/CEERE/OBMC
GEMARKLocal Subdistrict VVGEMARKCHAR12Assigned to domainVVGEMARK
AGR_PAR1Free aggregation parameter /CEERE/AGR_PARCHAR10
AGR_PAR2Free aggregation parameter /CEERE/AGR_PARCHAR10
AGR_PAR3Free aggregation parameter /CEERE/AGR_PARCHAR10
AGR_PAR4Free aggregation parameter /CEERE/AGR_PARCHAR10
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
X18Area of Land Type /CEERE/X18DEC9(2) /CEERE/PLOCHA
X19Land Price per Square Meter /CEERE/X19DEC9(2) /CEERE/CENAP
X20Tax Base According to Par.5 (1,2) /CEERE/X20CURR11(2) /CEERE/CASTKA
X21Tax Rate (Par. 6(1)) /CEERE/X21DEC5(2) /CEERE/DEC5_2
X22Tax Base (Par.5(3)) /CEERE/X22DEC9(2) /CEERE/PLOCHA
X23Tax Rate (Par 6(2)) /CEERE/X23DEC5(2) /CEERE/DEC5_2
X24Factor According to Par. 6(4) /CEERE/X24DEC5(2) /CEERE/DEC5_2
X25Land Tax /CEERE/X25CURR11(2) /CEERE/CASTKA
X26Claim for Exemption in Area /CEERE/X26DEC9(2) /CEERE/PLOCHA
X27Amount of Claim for Exemption (Par. 4,18(1)) /CEERE/X27CURR11(2) /CEERE/CASTKA
X28Tax Liability /CEERE/X28CURR11(2) /CEERE/CASTKA
X41Covered area /CEERE/X41DEC9(2) /CEERE/PLOCHA
X42Basic tax rate §11(1) /CEERE/X42DEC5(2) /CEERE/DEC5_2
X43Number of above-ground floors /CEERE/X43DEC9
X44Incr.base rate for another above-ground floor §11(2) /CEERE/X44DEC9(2) /CEERE/CENAP
X45Factor according to §11(3,4) /CEERE/X45DEC5(2) /CEERE/DEC5_2
X46Resulting tax rate /CEERE/X46DEC9(2) /CEERE/DEC9_2
X47Building tax /CEERE/X47CURR11(2) /CEERE/CASTKA
X48Business area /CEERE/X48DEC9(2) /CEERE/PLOCHA
X49Tax increase according to §11(5) /CEERE/X49CURR11(2) /CEERE/CASTKA
X50Area relation §9(2) /CEERE/X50DEC9(2) /CEERE/DEC9_2
X51Amount of exempt claim §11 /CEERE/X51CURR11(2) /CEERE/CASTKA
X52Amount of claim for deduction §18(2) /CEERE/X52CURR11(2) /CEERE/CASTKA
X53Tax liability /CEERE/X53CURR11(2) /CEERE/CASTKA
X54_OTotal land tax - till 2008 /CEERE/X54_OCURR11(2) /CEERE/CASTKA
X54Total Amount of Land Tax /CEERE/X54CURR11(2) /CEERE/CASTKA
X54_BTotal Amount of Land Tax /CEERE/X54CURR11(2) /CEERE/CASTKA
X55_OTotal building tax - till 2008 /CEERE/X55_OCURR11(2) /CEERE/CASTKA
X55Total Amount of Building Tax /CEERE/X55CURR11(2) /CEERE/CASTKA
X55_BTotal Amount of Building Tax /CEERE/X55CURR11(2) /CEERE/CASTKA
X56_OTotal property tax - till 2008 /CEERE/X56_OCURR11(2) /CEERE/CASTKA
X56Total Amount of Property Tax /CEERE/X56CURR11(2) /CEERE/CASTKA
X56_BTotal Amount of Property Tax /CEERE/X56CURR11(2) /CEERE/CASTKA
XKO12Municipality Coefficient (Par. 12) /CEERE/XKO12INT13INT1
X67Land type area /CEERE/X67DEC9(2) /CEERE/PLOCHA
X68ACom.quotient denominator /CEERE/X68AINT410
X68BCom.quotient numerator /CEERE/X68BINT410
X69Co-owned land type are /CEERE/X69DEC9(2) /CEERE/PLOCHA
X70Land price per square meter /CEERE/X70DEC9(2) /CEERE/CENAP
X71Tax base according to p.5 par. 1,2 /CEERE/X71CURR11(2) /CEERE/CASTKA
X72Tax rate §6(1) /CEERE/X72DEC5(2) /CEERE/DEC5_2
X73Tax base §5(3) /CEERE/X73DEC9(2) /CEERE/PLOCHA
X74Tax rate §6(2) /CEERE/X74DEC5(2) /CEERE/DEC5_2
X75Factor according to §6(4) /CEERE/X75DEC5(2) /CEERE/DEC5_2
X76Land tax /CEERE/X76CURR11(2) /CEERE/CASTKA
X77Claim for area exempt /CEERE/X77DEC9(2) /CEERE/PLOCHA
X78Amount of claim for exempt §4,18(1) /CEERE/X78CURR11(2) /CEERE/CASTKA
X79Liability to pay taxes /CEERE/X79CURR11(2) /CEERE/CASTKA
X95Floor area of the unit /CEERE/X95DEC9(2) /CEERE/PLOCHA
X96Factor according to §10(2) /CEERE/X96DEC5(2) /CEERE/DEC5_2
X97Base tax rate according to §10(2) /CEERE/X97DEC9(2) /CEERE/PLOCHA
X98Base tax rate according to §11(1) /CEERE/X98DEC5(2) /CEERE/DEC5_2
X99Factor according to §11(3,4) /CEERE/X99DEC5(2) /CEERE/DEC5_2
X100Resulting tax rate /CEERE/X100DEC5(2) /CEERE/DEC5_2
X101Building tax /CEERE/X101CURR11(2) /CEERE/CASTKA
X102Amount of claim for exemption according to §9 /CEERE/X102CURR11(2) /CEERE/CASTKA
X103Tax liability /CEERE/X103CURR11(2) /CEERE/CASTKA
CLISTUNumber of tax return sheet /CEERE/CLISTUCHAR3/CEERE/CLISTU
STAVLISTUStatus of tax return sheet /CEERE/STAVLISTUCHAR1/CEERE/STAVSLITU
DATVYPOCTUCalculation Date /CEERE/DATVYPOCTUDATS8
CASVYPOCTUCalculation Time /CEERE/CASVYPOCTUTIMS6
VYPOCETLCalculation Executed by /CEERE/VYPOCETLCHAR12
MBUKRIndicator: Dominant Company Code /CEERE/MBUKRCHAR1XFELD
LISTCISLONumc3, internal use NUMC3NUMC3NUMC3

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!