J_3R_TTAX_DECL_EX SAP (Communication Structure Between Tax Decl. Programs and DME) Structure details
Description: Communication Structure Between Tax Decl. Programs and DME
Related tables to J_3R_TTAX_DECL_EX
Access table J_3R_TTAX_DECL_EX
Structure field list including key, data, relationships and ABAP select examples
J_3R_TTAX_DECL_EX 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 "Communication Structure Between Tax Decl. Programs and DME" 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_J_3R_TTAX_DECL_EX TYPE J_3R_TTAX_DECL_EX.
The J_3R_TTAX_DECL_EX table consists of various fields, each holding specific information or linking keys about Communication Structure Between Tax Decl. Programs and DME data available in SAP. These include BUKRS (Company Code), OKATO (Common Administrative Territory Division Classifier - OKATO), KBK (Budget Classification Code - KBK), TAX_PER (TAX Period).. 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 J_3R_TTAX_DECL_EX 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 |
J_3R_TTAX_DECL_DME_HEADER | 0 | ||||||||
BUKRS | Company Code | 0 | |||||||
OKATO | Common Administrative Territory Division Classifier - OKATO | 0 | |||||||
KBK | Budget Classification Code - KBK | 0 | |||||||
TAX_PER | TAX Period | 0 | |||||||
TAX_YEAR | TAX Year | 0 | |||||||
CR_DATE | Creation Date | 0 | |||||||
DOC_NUM | Document Number | 0 | |||||||
TAX_INSP_CODE | Tax Inspection Code | 0 | |||||||
E_MAIL | Sender E-mail | 0 | |||||||
JOB | Job of The Sender | 0 | |||||||
SEND_SURNAME | Surname of The Sender | 0 | |||||||
SEND_NAME | Name of The Sender | 0 | |||||||
SEND_PATR | Patronymic of The Sender | 0 | |||||||
REP_NAME | Name of Person Responsible | J_3R_RESPNAME | CHAR | 80 | TEXT80 | ||||
REP_INN | INN of Person Responsible | 0 | |||||||
CORR_NUM | Number of Correction | 0 | |||||||
DOC_ATTR | Attribute of The Document Type | 0 | |||||||
DOC_TYPE | Document Type For Declaration | J_3R_DECL_DOC_TYPE | NUMC | 1 | J_3R_DECL_DOC_TYPE | ||||
OKVED_CODE | OKVED Code | J_3R_OKVED_CODE | CHAR | 20 | CHAR20 | ||||
REP_YEAR | Reporting Year | J_3R_REP_YEAR | NUMC | 4 | |||||
CEO_SURNAME | Surname of the CEO | 0 | |||||||
CEO_NAME | Name of the CEO | 0 | |||||||
CEO_PATR | Patronymic of the CEO | 0 | |||||||
LOCATION | Code of the place where this document is provided | 0 | |||||||
DECL_BY | Declaration is done by the representative | 0 | |||||||
REPR_DOC_NAME | Name of the Authorization Document | J_3R_REPRDOC | CHAR | 100 | CHAR100 | ||||
TAXPAYER_ORG | Taxpayer Representative | J_3R_TAXPORG | CHAR | 50 | CHAR50 | ||||
KPP | Subdivision's KPP | J_3RF_KPP | CHAR | 12 | CHAR12 | ||||
REORGANIZATION | Reorganization | J_3R_REORGANIZATION | CHAR | 1 | J_3R_REORG | ||||
REORGINN | INN of Reorganized Company | J_3R_REORGINN | CHAR | 30 | TEXT30 | ||||
REORGKPP | KPP of Reorganized Company | J_3R_REORGKPP | CHAR | 9 | TEXT9 | ||||
SIGN_DATE | Date of Signature | J_3R_SIGNDATE | DATS | 8 | |||||
J_3R_TTAX_DECL_DME | 0 | ||||||||
COUNTER | Counter | 0 | |||||||
SECTION_NUM | Section number | 0 | |||||||
WAERS | Currency Key | 0 | |||||||
000010001000 | 000010001000 | 0 | |||||||
000010002000 | 000010002000 | 0 | |||||||
000010003000 | 000010003000 | 0 | |||||||
000010004000 | 000010004000 | 0 | |||||||
000010005000 | 000010005000 | 0 | |||||||
000010006000 | 000010006000 | 0 | |||||||
000020001000 | 000020001000 | 0 | |||||||
000020002002 | 000020002002 | 0 | |||||||
000020002003 | 000020002003 | 0 | |||||||
000020002004 | 000020002004 | 0 | |||||||
000020002005 | 000020002005 | 0 | |||||||
000020002006 | 000020002006 | 0 | |||||||
000020002007 | 000020002007 | 0 | |||||||
000020002008 | 000020002008 | 0 | |||||||
000020002009 | 000020002009 | 0 | |||||||
000020002010 | 000020002010 | 0 | |||||||
000020002011 | 000020002011 | 0 | |||||||
000020002012 | 000020002012 | 0 | |||||||
000020002013 | 000020002013 | 0 | |||||||
000020002014 | 000020002014 | 0 | |||||||
000010002300 | Section 1 String 023 | 0 | |||||||
000010002500 | Section 1 String 025 | 0 | |||||||
000010002700 | Section 1 String 027 | 0 | |||||||
000020009000 | Ecological Class | J_3R_ECO_CLS | CHAR | 1 | J_3R_ECO_CLS | ||||
000020011000 | Number of Valid Months with Respect To The Tax | J_3R_VALID_MONTH | NUMC | 2 | |||||
000020012000 | Tax Coefficient | 0 | |||||||
000020015000 | Number of Valid Months with Respect To The Tax | J_3R_VALID_MONTH | NUMC | 2 | |||||
000020016000 | Tax Coefficient | 0 | |||||||
000020017000 | Transport Tax Exemption Code | J_3RTNOTX | CHAR | 5 | |||||
000020018000 | Section 2 String 180 - Exemption Amount | 0 | |||||||
000020017001 | Section 2 String 170 - Exemption Code Law | 0 | |||||||
000020019000 | Transport tax amount reduction code | J_3R_AMTREDUCTION | CHAR | 5 | CHAR5 | ||||
000020019001 | Section 2 String 190 - Reduction Code Law | 0 | |||||||
000020020000 | Section 2 String 200 - Amount Reduction Amount | 0 | |||||||
000020021000 | Transport Tax Reduction Code | J_3RTPREF | CHAR | 5 | |||||
000020021001 | Section 2 String 210 - Amount Reduction Code Law | 0 | |||||||
000020022000 | Section 2 String 220 - Reduction Amount | 0 | |||||||
J_3R_PTAX_DECL_S1 | 0 | ||||||||
COUNTER | Counter | 0 | |||||||
SECTION_NUM | Section number | 0 | |||||||
WAERS | Currency Key Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
000010001000 | 000010001000 | 0 | |||||||
000010002000 | 000010002000 | 0 | |||||||
000010003000 | 000010003000 | 0 | |||||||
000010004000 | 000010004000 | 0 | |||||||
000020001003 | 000020001003 | 0 | |||||||
000020001004 | 000020001004 | 0 | |||||||
000020002003 | 000020002003 | 0 | |||||||
000020002004 | 000020002004 | 0 | |||||||
000020003003 | 000020003003 | 0 | |||||||
000020003004 | 000020003004 | 0 | |||||||
000020004003 | 000020004003 | 0 | |||||||
000020004004 | 000020004004 | 0 | |||||||
000020005003 | 000020005003 | 0 | |||||||
000020005004 | 000020005004 | 0 | |||||||
000020006003 | 000020006003 | 0 | |||||||
000020006004 | 000020006004 | 0 | |||||||
000020007003 | 000020007003 | 0 | |||||||
000020007004 | 000020007004 | 0 | |||||||
000020008003 | 000020008003 | 0 | |||||||
000020008004 | 000020008004 | 0 | |||||||
000020009003 | 000020009003 | 0 | |||||||
000020009004 | 000020009004 | 0 | |||||||
000020010003 | 000020010003 | 0 | |||||||
000020010004 | 000020010004 | 0 | |||||||
000020011003 | 000020011003 | 0 | |||||||
000020011004 | 000020011004 | 0 | |||||||
000020012003 | 000020012003 | 0 | |||||||
000020012004 | 000020012004 | 0 | |||||||
000020013003 | 000020013003 | 0 | |||||||
000020013004 | 000020013004 | 0 | |||||||
000020014003 | 000020014003 | 0 | |||||||
000020015003 | 000020015003 | 0 | |||||||
000020016003 | 000020016003 | 0 | |||||||
000020017003 | 000020017003 | 0 | |||||||
000020018003 | 000020018003 | 0 | |||||||
000020019003 | 000020019003 | 0 | |||||||
000020020003 | 000020020003 | 0 | |||||||
000020021003 | 000020021003 | 0 | |||||||
000020022003 | 000020022003 | 0 | |||||||
000020023003 | 000020023003 | 0 | |||||||
000020024003 | 000020024003 | 0 | |||||||
000040001000 | 000040001000 | 0 | |||||||
000040002003 | 000040002003 | 0 | |||||||
000040003003 | 000040003003 | 0 | |||||||
000040004003 | 000040004003 | 0 | |||||||
000040005003 | 000040005003 | 0 | |||||||
000040006003 | 000040006003 | 0 | |||||||
000040007003 | 000040007003 | 0 | |||||||
000040008003 | 000040008003 | 0 | |||||||
000040009003 | 000040009003 | 0 | |||||||
000040010003 | 000040010003 | 0 | |||||||
000040011003 | 000040011003 | 0 | |||||||
000040012003 | 000040012003 | 0 | |||||||
000040013003 | 000040013003 | 0 | |||||||
000040014003 | 000040014003 | 0 | |||||||
000040015003 | 000040015003 | 0 | |||||||
000040016003 | 000040016003 | 0 | |||||||
000040017003 | 000040017003 | 0 | |||||||
000040018003 | 000040018003 | 0 | |||||||
000040019003 | 000040019003 | 0 | |||||||
000040020003 | 000040020003 | 0 | |||||||
000040021003 | 000040021003 | 0 | |||||||
000040022003 | 000040022003 | 0 | |||||||
000040023003 | 000040023003 | 0 | |||||||
000040024003 | 000040024003 | 0 | |||||||
000040025003 | 000040025003 | 0 | |||||||
000040026003 | 000040026003 | 0 | |||||||
000050001000 | 000050001000 | 0 | |||||||
000050002000 | 000050002000 | 0 | |||||||
000050003003 | 000050003003 | 0 | |||||||
000050004003 | 000050004003 | 0 | |||||||
000050005003 | 000050005003 | 0 | |||||||
000050006003 | 000050006003 | 0 | |||||||
000050007003 | 000050007003 | 0 | |||||||
000050008003 | 000050008003 | 0 | |||||||
000050009003 | 000050009003 | 0 | |||||||
000050010003 | 000050010003 | 0 | |||||||
000050011003 | 000050011003 | 0 | |||||||
000050012003 | 000050012003 | 0 | |||||||
000050013003 | 000050013003 | 0 | |||||||
000050014003 | 000050014003 | 0 | |||||||
000050015003 | 000050015003 | 0 | |||||||
000050016003 | 000050016003 | 0 | |||||||
000050017003 | 000050017003 | 0 | |||||||
000050018003 | 000050018003 | 0 | |||||||
N130_PRVG | Federal Property Tax Concession | J_3RFOFPRIVILEGE | CHAR | 10 | CHAR10 | ||||
N140_REALEST_AVRG | Cumulative acquisition and production costs | KANSW | CURR | 13(2) | ANLKWERT | ||||
N150_PROPPART | Part of balance cost of Real Estate | J_3R_PROPBAL | DEC | 17(2) | DEC17_2 | ||||
N150_PROPPART_1 | Part of balance cost of Real Estate | J_3R_PROPBAL | DEC | 17(2) | DEC17_2 | ||||
PROPERTY_CHAR | 0 | ||||||||
N160_EXEMP_LAW | Law Article for Exemption Code | J_3RFEXEMPLAW | CHAR | 12 | CHAR12 | ||||
N130_PRVG_LAW | Law Article for Reduction Code | 0 | |||||||
N240_LAW | Law Article for String 240 | 0 | |||||||
N141_TOTAL | String 141 column 3 | 0 | |||||||
N141_REAL_ESTATE | String 141 column 4 | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure J_3R_TTAX_DECL_EX using ABAP code?
As J_3R_TTAX_DECL_EX 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 J_3R_TTAX_DECL_EX as there is no data to select.How to access SAP table J_3R_TTAX_DECL_EX
Within an ECC or HANA version of SAP you can also view further information about J_3R_TTAX_DECL_EX 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