SAP ABAP Table J_3R_TTAX_EXT (With Group-key Extended Transport Tax Structure)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ FI-LOC (Application Component) Localization
⤷ J3RALF (Package) Localization Russia - Legal Forms
⤷ FI-LOC (Application Component) Localization
⤷ J3RALF (Package) Localization Russia - Legal Forms
Basic Data
Table Category | INTTAB | Structure |
Structure | J_3R_TTAX_EXT | Table Relationship Diagram |
Short Description | With Group-key Extended Transport Tax Structure |
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 | GRTITLE | J_3R_TTAX_GRKEY_TITLE | STRU | 0 | 0 | ||||
2 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | ||
3 | GRKEY | J_3R_TTAX_GRKEY | STRU | 0 | 0 | ||||
4 | GR_BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
5 | GR_OKATO | J_3R_OKATO | CHAR | 12 | 0 | OKATO Code | |||
6 | GR_STRUCTDIV | J_3RSTRUCTDIV | TXT80 | CHAR | 80 | 0 | Structural Division Name | ||
7 | GR_TR_TYPE | J_3RTYPV | CHAR | 5 | 0 | Transport Type | |||
8 | .INCLUDE | 0 | 0 | Transport Tax Data | |||||
9 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
10 | .INCLUDE | 0 | 0 | Key Fields For The Transport Tax Table - J_3R_TTAX | |||||
11 | TAX_TYPE | J_3R_TAX_TYPE | J_3R_TAX_TYPE | CHAR | 1 | 0 | Tax Type | ||
12 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
13 | OKATO | J_3R_OKATO | CHAR | 12 | 0 | OKATO Code | |||
14 | STRUCT_DIV | J_3R_STRUCTDIV_INT | CHAR40 | CHAR | 40 | 0 | Internal Code of Structural Division | ||
15 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
16 | ANLN2 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
17 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
18 | VERSION | J_3R_TTAX_VER | CHAR | 5 | 0 | Version Of The Transport Tax Entry | |||
19 | LIGHT | ICON_4 | ICON_4 | CHAR | 4 | 0 | Temporary delivery status during wave creation | ||
20 | TAX01 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
21 | TAX02 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
22 | TAX03 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
23 | TAX04 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
24 | TAX05 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
25 | TAX06 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
26 | TAX07 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
27 | TAX08 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
28 | TAX09 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
29 | TAX10 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
30 | TAX11 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
31 | TAX12 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
32 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
33 | STATUS | J_3R_TTAX_STAT | J_3R_TTAX_STATUS | CHAR | 1 | 0 | Status of The Transport Tax Entry | ||
34 | LAST_DECLARED | J_3R_FATAX_DECL | CHAR | 1 | 0 | Indicator If This Entry Is The Last Declared Entry | |||
35 | CREATED_ON | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
36 | CALC_ID | J_3R_TTAX_ID | CHAR30 | CHAR | 30 | 0 | Identifier name of the Saved Transport Tax Entry | ||
37 | DECL_01 | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
38 | DECL_NUM1 | J_3R_DECL_NUM | CHAR | 10 | 0 | Tax Return Document Number | |||
39 | DECL_02 | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
40 | DECL_NUM2 | J_3R_DECL_NUM | CHAR | 10 | 0 | Tax Return Document Number | |||
41 | DECL_03 | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
42 | DECL_NUM3 | J_3R_DECL_NUM | CHAR | 10 | 0 | Tax Return Document Number | |||
43 | DECL_04 | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
44 | DECL_NUM4 | J_3R_DECL_NUM | CHAR | 10 | 0 | Tax Return Document Number | |||
45 | NBV01 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
46 | NBV02 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
47 | NBV03 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
48 | NBV04 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
49 | NBV05 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
50 | NBV06 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
51 | NBV07 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
52 | NBV08 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
53 | NBV09 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
54 | NBV10 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
55 | NBV11 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
56 | NBV12 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
57 | NBV13 | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
58 | VALID_MONTH | J_3R_VALID_MONTH | NUMC | 2 | 0 | Number of Valid Months with Respect To The Tax | |||
59 | ASSETNAME | J_3R_ASSET_DESC | TEXT100 | CHAR | 100 | 0 | Asset Description and Additional Description | ||
60 | TTAX01_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
61 | TTAX02_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
62 | TTAX03_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
63 | TTAX04_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
64 | TTAX05_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
65 | TTAX06_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
66 | TTAX07_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
67 | TTAX08_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
68 | TTAX09_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
69 | TTAX10_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
70 | TTAX11_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
71 | TTAX12_ORIG | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
72 | TTAX_RATE | J_3RTVAL | DEC | 8 | 2 | Transport Tax Rate | |||
73 | BRAND | J_3R_BRAND | CHAR120 | CHAR | 120 | 0 | Vehicle Brand | ||
74 | TAX_SUM | J_3R_TAX_SUM | CURR | 17 | 5 | Annual Tax Amount | |||
75 | PRIVILEGE | J_3RFPRIVILEGE | CHAR04 | CHAR | 4 | 0 | Property Tax Reduction | ||
76 | AMOUNTRED | J_3RFAMOUNTRED | CHAR04 | CHAR | 4 | 0 | Property tax amount reduction code | ||
77 | EXEMPTION | J_3RFEXEMPTION | CHAR04 | CHAR | 4 | 0 | Property Tax Exemption Code | ||
78 | CNOTX | J_3RTNOTX | CHAR | 5 | 0 | Transport Tax Exemption Code | |||
79 | CPRTX | J_3RTPREF | CHAR | 5 | 0 | Transport Tax Reduction Code | |||
80 | USAGE_YEARS | J_3R_TERM | CHAR | 3 | 0 | Term of Use | |||
81 | TAX_COEFF | J_3R_USE_COEFF | DEC1_2 | DEC | 3 | 2 | Tax Coefficient | ||
82 | CORR_NUM | INT2 | 5 | 0 | |||||
83 | DECL_NUM | J_3R_DECL_NUM | CHAR | 10 | 0 | Tax Return Document Number | |||
84 | KBK | J_3R_KBK | CHAR | 20 | 0 | KBK Code For Non-UGSS Asset | |||
85 | ADATU | ADATU | DATUM | DATS | 8 | 0 | Date for beginning of validity | ||
86 | BDATU | BDATU | DATUM | DATS | 8 | 0 | Date validity ends | ||
87 | .INCLUDE | 0 | 0 | FI-AA: Russia - Time-Dependent Transport Tax | |||||
88 | GLO_RUS_TXB_TYPE | UNIT_POWER | MEINS | UNIT | 3 | 0 | Power unit | T006 | |
89 | GLO_RUS_TXB_UNIT | J_3RTXBUNIT | GLO_RUS_TXB_UNIT | QUAN | 13 | 3 | Tax Base Unit | ||
90 | GLO_RUS_TTX_EXMP | J_3RTNOTX | CHAR | 5 | 0 | Transport Tax Exemption Code | J_3RTNTVEH | ||
91 | GLO_RUS_TTX_PRVG | J_3RTPREF | CHAR | 5 | 0 | Transport Tax Reduction Code | J_3RTPRTAX | ||
92 | GLO_RUS_TTX_STLD | J_3RTDTBRA | DATS | 8 | 0 | Date Stolen | |||
93 | GLO_RUS_TTX_RTRD | J_3RTDTBRB | DATS | 8 | 0 | Return Date | |||
94 | GLO_RUS_TTX_RGSD | J_3RTREG | DATS | 8 | 0 | Registration Date | |||
95 | GLO_RUS_TTX_RMVD | J_3RTREM | DATS | 8 | 0 | Cancellation Date | |||
96 | GLO_RUS_TTX_OKT1 | J_3RTOKATO1 | CHAR02 | CHAR | 2 | 0 | OKATO Code (Part 1) | ||
97 | GLO_RUS_TTX_OKT2 | J_3RTOKATO2 | CHAR03 | CHAR | 3 | 0 | OKATO Code (Part 2) | ||
98 | GLO_RUS_TTX_OKT3 | J_3RTOKATO3 | CHAR03 | CHAR | 3 | 0 | OKATO Code (Part 3) | ||
99 | GLO_RUS_TTX_OKT4 | J_3RTOKATO4 | CHAR03 | CHAR | 3 | 0 | OKATO Code (Part 4) | ||
100 | GLO_RUS_TTX_LNUM | LICENSE_NUM | LICENSE_NUM | CHAR | 15 | 0 | License plate number | ||
101 | GLO_RUS_TTX_AMTREDUCTION | J_3R_AMTREDUCTION | CHAR5 | CHAR | 5 | 0 | Transport tax amount reduction code | ||
102 | GLO_RUS_AMTRED | J_3R_AMTREDUCTION | CHAR5 | CHAR | 5 | 0 | Transport tax amount reduction code | ||
103 | .INCLUDE | 0 | 0 | FI-AA: Russia - Time-Independent Transport Tax | |||||
104 | GLO_RUS_TTX_TYPE | J_3RTYPV | CHAR | 5 | 0 | Transport Type | J_3RTTYPVEH | ||
105 | GLO_RUS_TTX_VIN | FLEET_VIN | FLEET_VIN | CHAR | 30 | 0 | Manufacturer Vehicle Identification Number for Fleet Object | ||
106 | GLO_RUS_TTX_MNFD | J_3RTBAUJJ | DATS | 8 | 0 | Manufacturing Date | |||
107 | GLO_RUS_TTX_ECOCLASS | J_3R_ECOCLASS | NUMC1 | NUMC | 1 | 0 | Ecological Class | ||
108 | GLO_RUS_ECOCLASS | J_3R_ECOCLASS | NUMC1 | NUMC | 1 | 0 | Ecological Class | ||
109 | GLO_RUS_ECO_CLS | J_3R_ECO_CLS | J_3R_ECO_CLS | CHAR | 1 | 0 | Ecological Class | ||
110 | TTAX_YEAR | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
111 | TTAX_YEARO | J_3R_TTAX_AMNT | CURR | 17 | 5 | Monthly Transport Tax Amount For | |||
112 | TAX_RATE | J_3RTVAL | DEC | 8 | 2 | Transport Tax Rate | |||
113 | TAX_RATEO | J_3RTVAL | DEC | 8 | 2 | Transport Tax Rate | |||
114 | GLO_RUS_OKOF | J_3RFOKOF | CHAR009 | CHAR | 9 | 0 | OKOF Code | ||
115 | REGION | J_3RFREGION | CHAR5 | CHAR | 5 | 0 | Region | ||
116 | DISTRICT | J_3RFDISTRICT | CHAR5 | CHAR | 5 | 0 | District | ||
117 | KPP | J_3R_KPP | TEXT9 | CHAR | 9 | 0 | KPP Number of Reporting Company | ||
118 | PRIVG_MONTH | J_3R_VALID_MONTH | NUMC | 2 | 0 | Number of Valid Months with Respect To The Tax | |||
119 | NONREDUCED_TAXRATE | J_3RTVAL | DEC | 8 | 2 | Transport Tax Rate | |||
120 | REDUCED_TAXRATE | J_3RTVAL | DEC | 8 | 2 | Transport Tax Rate |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | J_3R_TTAX_EXT | GLO_RUS_TTX_EXMP | J_3RTNTVEH | CNOTX | |||
2 | J_3R_TTAX_EXT | GLO_RUS_TTX_PRVG | J_3RTPRTAX | CPRTX | |||
3 | J_3R_TTAX_EXT | GLO_RUS_TTX_TYPE | J_3RTTYPVEH | CTYPV | |||
4 | J_3R_TTAX_EXT | GLO_RUS_TXB_TYPE | T006 | MSEHI | KEY | 1 | CN |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 604 |