/CEERE/DN SAP (Data for property tax calculation) Structure details
Description: Data for property tax calculation
Structure field list including key, data, relationships and ABAP select examples
/CEERE/DN is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Data for property tax calculation" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_/CEERE/DN TYPE /CEERE/DN.
The /CEERE/DN table consists of various fields, each holding specific information or linking keys about Data for property tax calculation data available in SAP. These include DRNEM (Property Type), KODFU (Tax Office Code), NAZEVFU (Name of Tax Office), KODOBCE (Code of Municipality or City District).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /CEERE/DN structure 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 |
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 |
NAZEVFU | Name of Tax Office | /CEERE/NAZEVFU | CHAR | 50 | /CEERE/NAZEVFU | ||||
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 | /CEERE/COBCE | /CEERE/KODCOBCE | |||
GEMARK | Cadastral District Code | /CEERE/GEMARK | 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 | /CEERE/KOSVOB | /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 | |||||
XDAN | Subject to Property Tax | /CEERE/XDAN | CHAR | 1 | |||||
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 | ||
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 structure /CEERE/DN using ABAP code?
As /CEERE/DN is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /CEERE/DN as there is no data to select.How to access SAP table /CEERE/DN
Within an ECC or HANA version of SAP you can also view further information about /CEERE/DN 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