SAP ABAP Table /CEERE/DN (Data for property tax calculation)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-LC-CZ (Application Component) Real Estate Localization Czech Republic
⤷ /CEERE/DANNEM (Package) Localization Flexible Real Estate Czech Republic
⤷ RE-FX-LC-CZ (Application Component) Real Estate Localization Czech Republic
⤷ /CEERE/DANNEM (Package) Localization Flexible Real Estate Czech Republic
Basic Data
Table Category | INTTAB | Structure |
Structure | /CEERE/DN | Table Relationship Diagram |
Short Description | Data for property tax calculation |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | TYPNEM | /CEERE/TYPNEM | /CEERE/TYPNEM | CHAR | 1 | 0 | Property Category | /CEERE/TPNEM | |
2 | DRNEM | /CEERE/DRUHNEM | /CEERE/DRUHNEM | CHAR | 1 | 0 | Property Type | /CEERE/DRNEM | |
3 | KODFU | /CEERE/KODFU | /CEERE/KODFU | CHAR | 3 | 0 | Tax Office Code | /CEERE/FUC | |
4 | NAZEVFU | /CEERE/NAZEVFU | /CEERE/NAZEVFU | CHAR | 50 | 0 | Name of Tax Office | ||
5 | KODOBCE | /CEERE/KODOBCE | /CEERE/KODOBCE | CHAR | 8 | 0 | Code of Municipality or City District | /CEERE/OBCE | |
6 | NAZEVOBCE | /CEERE/NAZEVOBCE | /CEERE/NAZEVOBCE | CHAR | 35 | 0 | Name of Municipality or City District | ||
7 | KODCOBCE | /CEERE/KODCOBCE | /CEERE/KODCOBCE | CHAR | 6 | 0 | District Code | /CEERE/COBCE | |
8 | GEMARK | /CEERE/GEMARK | VVGEMARK | CHAR | 12 | 0 | Cadastral District Code | /CEERE/KU | |
9 | NAZEVKU | /CEERE/NAZEVKU | /CEERE/NAZEVKU | CHAR | 40 | 0 | Cadastral District Name | ||
10 | NARPARK | /CEERE/NARPARK | CHAR | 1 | 0 | Property Located in National Park | |||
11 | PARCKMEN | /CEERE/PARCKMEN | CHAR | 5 | 0 | Master Number of Parcel | |||
12 | PARCPOD | /CEERE/PARCPOD | CHAR | 3 | 0 | Additional Number of Parcel | |||
13 | PARCDIL | /CEERE/PARCDIL | CHAR | 2 | 0 | Parcel Sub-Number | |||
14 | VYMERA | /CEERE/VYMERA | /CEERE/PLOCHA | DEC | 9 | 2 | Total Area | ||
15 | PRAVZTAH | /CEERE/PRAVZTAH | /CEERE/PRAVZTAH | CHAR | 4 | 0 | Legal Relations | ||
16 | SV_CITATEL | /CEERE/SV_CITATEL | /CEERE/SV_CITATEL | DEC | 7 | 0 | Co-Ownership Share (Numerator) | ||
17 | SV_JMENOVATEL | /CEERE/SV_JMENOVATEL | /CEERE/SV_JMENOVATEL | DEC | 7 | 0 | Co-Ownership Share (Denominator) | ||
18 | VYMERAOSV | /CEERE/VYMERAOSV | /CEERE/PLOCHA | DEC | 9 | 2 | Area Exempted From Tax | ||
19 | VYMERAPOD | /CEERE/VYMERAPOD | /CEERE/PLOCHA | DEC | 9 | 2 | Floor Area for Business | ||
20 | ZASTPL | /CEERE/ZASTPL | /CEERE/PLOCHA | DEC | 9 | 2 | Covered Area | ||
21 | PLOCHANP | /CEERE/PLOCHANP | /CEERE/PLOCHA | DEC | 9 | 2 | Total Area of Floors Above the Ground Floor | ||
22 | KODOSVOB | /CEERE/KODOSVOB | /CEERE/KODOSVOB | CHAR | 4 | 0 | Tax Exemption Code | /CEERE/KOSVOB | |
23 | ROKOSVOD | /CEERE/ROKOSVOD | GJAHR | NUMC | 4 | 0 | Tax Exemption Period: Start Year | ||
24 | ROKOSVDO | /CEERE/ROKOSVDO | GJAHR | NUMC | 4 | 0 | Tax Exemption Period: End Year | ||
25 | CENASTODH | /CEERE/CENAODH | CHAR | 1 | 0 | Estimated Price | |||
26 | CENAODHAD | /CEERE/CENAP | /CEERE/CENAP | DEC | 9 | 2 | Estimated Land Price | ||
27 | POCPATER | /CEERE/POCPATER | DEC | 3 | 0 | Number of Other Aboveground Floors | |||
28 | CISLOP | /CEERE/CISLOP | CHAR | 6 | 0 | Registration Number | |||
29 | ROKDOKONC | /CEERE/ROKDOKONC | GJAHR | NUMC | 4 | 0 | Completion Year of Building | ||
30 | POPIS | /CEERE/POPISSTAVBY | /CEERE/POPIS80 | CHAR | 80 | 0 | Name of Property Tax Object | ||
31 | CIZIPOZ | /CEERE/CIZIPOZ | CHAR | 1 | 0 | Building on Third-Party Plot | |||
32 | DRUHSTA | /CEERE/DRUHSTA | /CEERE/DRUHSTA | CHAR | 2 | 0 | Building Type | ||
33 | BYTKAT | /CEERE/BYTKAT | /CEERE/BYTKAT | CHAR | 4 | 0 | Apartment category | ||
34 | SVISKONST | /CEERE/SVISKONST | /CEERE/SVISKONST | CHAR | 2 | 0 | Vertical supporting structure | ||
35 | JEDNKMEN | /CEERE/JEDNKMEN | CHAR | 6 | 0 | Unit-master part | |||
36 | JEDNBYT | /CEERE/JEDNBYT | CHAR | 3 | 0 | Unit-apartment | |||
37 | PLNOSVOB | /CEERE/PLNOSVOB | CHAR | 1 | 0 | Full Tax Exemption | |||
38 | XDAN | /CEERE/XDAN | CHAR | 1 | 0 | Subject to Property Tax | |||
39 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
40 | ANLN2 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
41 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
42 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
43 | .INCLUDE | 0 | 0 | Property tax - Paved Area | |||||
44 | SOLIDAGR | /CEERE/SOLIDAGR | /CEERE/PLOCHA | DEC | 9 | 2 | Paved Area (Agricultural Purp.) | ||
45 | SOLIDIND | /CEERE/SOLIDIND | /CEERE/PLOCHA | DEC | 9 | 2 | Paved Area (Industrial Purp.) | ||
46 | SOLAAGRE | /CEERE/SOLAAGRE | /CEERE/PLOCHA | DEC | 9 | 2 | Tax-Exempt Paved Area (Argicultural Purp.) | ||
47 | SOLAINDE | /CEERE/SOLAINDE | /CEERE/PLOCHA | DEC | 9 | 2 | Tax-Exempt Paved Area (Industrial Purp.) | ||
48 | YEAGREFR | /CEERE/YEAGREFR | GJAHR | NUMC | 4 | 0 | First Year of Tax Exemption Period (Agricultural Purp.) | ||
49 | YEINDEFR | /CEERE/YEINDEFR | GJAHR | NUMC | 4 | 0 | First Year of Tax Exemption Period (Industrial Purp.) | ||
50 | YEAGRETO | /CEERE/YEAGRETO | GJAHR | NUMC | 4 | 0 | Last Year of Tax Exemption Period (Agricultural Purp.) | ||
51 | YEINDETO | /CEERE/YEINDETO | GJAHR | NUMC | 4 | 0 | Last Year of Tax Exemption Period (Industrial Purp.) | ||
52 | CODEAGRE | /CEERE/CODEAGRE | /CEERE/KODOSVOB | CHAR | 4 | 0 | Tax Exemption Code for Paved Area (Agr. Purp.) | * | |
53 | CODEINDE | /CEERE/CODEINDE | /CEERE/KODOSVOB | CHAR | 4 | 0 | Tax Exemption Code for Paved Area (Ind. Purp.) | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /CEERE/DN | DRNEM | /CEERE/DRNEM | DRNEM | KEY | 1 | CN |
2 | /CEERE/DN | GEMARK | /CEERE/KU | GEMARK | |||
3 | /CEERE/DN | KODCOBCE | /CEERE/COBCE | KODCOBCE | KEY | 1 | CN |
4 | /CEERE/DN | KODFU | /CEERE/FUC | KODFU | |||
5 | /CEERE/DN | KODOBCE | /CEERE/OBCE | KODOBCE | KEY | 1 | CN |
6 | /CEERE/DN | KODOSVOB | /CEERE/KOSVOB | KODOSVOB | KEY | 1 | CN |
7 | /CEERE/DN | TYPNEM | /CEERE/TPNEM | TYPNEM | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C |