/CEERE/SDANP SAP (Property tax - master) Table details

Dictionary Type: Table
Description: Property tax - master




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




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
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
TYPNEMREMReal Estate Object Type /CEERE/TYPNEMREMCHAR1/CEERE/TYPNEMREM
SWENRSite Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
KEYNEMProperty Key /CEERE/KEYNEMCHAR8Assigned to domainSGRNRSGRNR/CEERE/KNM
TYPNEMProperty Category /CEERE/TYPNEMCHAR1/CEERE/TPNEM/CEERE/TYPNEM/CEERE/TNM
DRNEMProperty Type /CEERE/DRUHNEMCHAR1/CEERE/DRNEM/CEERE/DRUHNEM
KODFUTax Office Code /CEERE/KODFUCHAR3/CEERE/FUCALPHA/CEERE/KODFU/CEERE/KFU/CEERE/FUC
KODOBCECode of Municipality or City District /CEERE/KODOBCECHAR8/CEERE/OBCE/CEERE/KODOBCE/CEERE/OBMC
NAZEVOBCEName of Municipality or City District /CEERE/NAZEVOBCECHAR35/CEERE/NAZEVOBCE
KODCOBCEDistrict Code /CEERE/KODCOBCECHAR6Assigned to domain/CEERE/KODCOBCE
GEMARKLocal Subdistrict VVGEMARKCHAR12/CEERE/KUVVGEMARK
NAZEVKUCadastral District Name /CEERE/NAZEVKUCHAR40/CEERE/NAZEVKU
NARPARKProperty Located in National Park /CEERE/NARPARKCHAR1
PARCKMENMaster Number of Parcel /CEERE/PARCKMENCHAR5
PARCPODAdditional Number of Parcel /CEERE/PARCPODCHAR3
PARCDILParcel Sub-Number /CEERE/PARCDILCHAR2
VYMERATotal Area /CEERE/VYMERADEC9(2) /CEERE/PLOCHA
PRAVZTAHLegal Relations /CEERE/PRAVZTAHCHAR4/CEERE/PRAVZTAH
SV_CITATELCo-Ownership Share (Numerator) /CEERE/SV_CITATELDEC7/CEERE/SV_CITATEL
SV_JMENOVATELCo-Ownership Share (Denominator) /CEERE/SV_JMENOVATELDEC7/CEERE/SV_JMENOVATEL
VYMERAOSVArea Exempted From Tax /CEERE/VYMERAOSVDEC9(2) /CEERE/PLOCHA
VYMERAPODFloor Area for Business /CEERE/VYMERAPODDEC9(2) /CEERE/PLOCHA
ZASTPLCovered Area /CEERE/ZASTPLDEC9(2) /CEERE/PLOCHA
PLOCHANPTotal Area of Floors Above the Ground Floor /CEERE/PLOCHANPDEC9(2) /CEERE/PLOCHA
KODOSVOBTax Exemption Code /CEERE/KODOSVOBCHAR4Assigned to domain/CEERE/KODOSVOB
ROKOSVODTax Exemption Period: Start Year /CEERE/ROKOSVODNUMC4GJAHRGJAHR
ROKOSVDOTax Exemption Period: End Year /CEERE/ROKOSVDONUMC4GJAHRGJAHR
CENASTODHEstimated Price /CEERE/CENAODHCHAR1
CENAODHADEstimated Land Price /CEERE/CENAPDEC9(2) /CEERE/CENAP
POCPATERNumber of Other Aboveground Floors /CEERE/POCPATERDEC3
CISLOPRegistration Number /CEERE/CISLOPCHAR6
ROKDOKONCCompletion Year of Building /CEERE/ROKDOKONCNUMC4GJAHRGJAHR
POPISName of Property Tax Object /CEERE/POPISSTAVBYCHAR80/CEERE/POPIS80
CIZIPOZBuilding on Third-Party Plot /CEERE/CIZIPOZCHAR1
DRUHSTABuilding Type /CEERE/DRUHSTACHAR2/CEERE/DRUHSTA
BYTKATApartment category /CEERE/BYTKATCHAR4/CEERE/BYTKAT
SVISKONSTVertical supporting structure /CEERE/SVISKONSTCHAR2/CEERE/SVISKONST
JEDNKMENUnit-master part /CEERE/JEDNKMENCHAR6
JEDNBYTUnit-apartment /CEERE/JEDNBYTCHAR3
PLNOSVOBFull Tax Exemption /CEERE/PLNOSVOBCHAR1
DATZMENYDate DATUMDATS8DATUM
CASZMENYTime UZEITTIMS6UZEIT
ZMENILChanged by USERCHAR12CHAR12
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
X58_1Installment 1 /CEERE/SPLATKACURR11(2) /CEERE/CASTKA
X58_2Installment 2 /CEERE/SPLATKA2CURR11(2) /CEERE/CASTKA
X59_1Installment 1 /CEERE/SPLATKACURR11(2) /CEERE/CASTKA
X59_2Installment 2 /CEERE/SPLATKA2CURR11(2) /CEERE/CASTKA
X59_3Installment 3 /CEERE/SPLATKA3CURR11(2) /CEERE/CASTKA
X59_4Installment 4 /CEERE/SPLATKA4CURR11(2) /CEERE/CASTKA
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
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
ANLN1Main Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
XDANSubject to Property Tax /CEERE/XDANCHAR1
DATVYPOCTUCalculation Date /CEERE/DATVYPOCTUDATS8
CASVYPOCTUCalculation Time /CEERE/CASVYPOCTUTIMS6
STAVYPOCTUCalculation status /CEERE/STAVYPOCTUCHAR1
VYPOCETLCalculation Executed by /CEERE/VYPOCETLCHAR12
TBUKR2Dominant Enterprise/Company Code /CEERE/FOT_TBUKRSCHAR4Assigned to domainBUKRS
MBUKRIndicator: Dominant Company Code /CEERE/MBUKRCHAR1XFELD
SOLIDAGRPaved Area (Agricultural Purp.) /CEERE/SOLIDAGRDEC9(2) /CEERE/PLOCHA
SOLIDINDPaved Area (Industrial Purp.) /CEERE/SOLIDINDDEC9(2) /CEERE/PLOCHA
SOLAAGRETax-Exempt Paved Area (Argicultural Purp.) /CEERE/SOLAAGREDEC9(2) /CEERE/PLOCHA
SOLAINDETax-Exempt Paved Area (Industrial Purp.) /CEERE/SOLAINDEDEC9(2) /CEERE/PLOCHA
YEAGREFRFirst Year of Tax Exemption Period (Agricultural Purp.) /CEERE/YEAGREFRNUMC4GJAHRGJAHR
YEINDEFRFirst Year of Tax Exemption Period (Industrial Purp.) /CEERE/YEINDEFRNUMC4GJAHRGJAHR
YEAGRETOLast Year of Tax Exemption Period (Agricultural Purp.) /CEERE/YEAGRETONUMC4GJAHRGJAHR
YEINDETOLast Year of Tax Exemption Period (Industrial Purp.) /CEERE/YEINDETONUMC4GJAHRGJAHR
CODEAGRETax Exemption Code for Paved Area (Agr. Purp.) /CEERE/CODEAGRECHAR4Assigned to domain/CEERE/KODOSVOB
CODEINDETax Exemption Code for Paved Area (Ind. Purp.) /CEERE/CODEINDECHAR4Assigned 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 table
DATA: 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 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!