SAP ABAP Table J_3R_PTAX_EXT2 (Group-key2 Extended Property Tax Structure)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J3RALF (Package) Localization Russia - Legal Forms

Basic Data

Table Category	INTTAB	Structure
Structure	J_3R_PTAX_EXT2	Table Relationship Diagram
Short Description	Group-key2 Extended Property 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_PROPTAX_GRKEY_TITLE		STRU	0	0
2	GR_REGION	☐	J_3RFREGION	CHAR5	CHAR	5	0	Region
3	GR_DISTRICT	☐	J_3RFDISTRICT	CHAR5	CHAR	5	0	District
4	GRKEY4	☐	J_3R_PTAX_GRKEY4		STRU	0	0
5	GR_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code
6	GR_STRUCT_DIV	☐	J_3RSTRUCTDIV	TXT80	CHAR	80	0	Structural Division Name
7	GR_OKATO	☐	J_3R_OKATO		CHAR	12	0	OKATO Code
8	GR_PRIVILEGE	☐	J_3RFOFPRIVILEGE	CHAR10	CHAR	10	0	Federal Property Tax Concession
9	GR_TRATE	☐	J_3RFPROPTAXRATE	J_3RFPROPTAXRATE	DEC	8	5	Property Tax Rate
10	GR_PROPTYPE	☐	J_3RFPROPTYPE	CHAR1	CHAR	1	0	Property Type
11	.INCLUDE	☐				0	0	Data For Tax Declaration
12	.INCLUDE	☐				0	0	Transport Tax Data
13	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
14	.INCLUDE	☐				0	0	Key Fields For The Transport Tax Table - J_3R_TTAX
15	TAX_TYPE	☐	J_3R_TAX_TYPE	J_3R_TAX_TYPE	CHAR	1	0	Tax Type
16	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
17	OKATO	☐	J_3R_OKATO		CHAR	12	0	OKATO Code
18	STRUCT_DIV	☐	J_3R_STRUCTDIV_INT	CHAR40	CHAR	40	0	Internal Code of Structural Division
19	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
20	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
21	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
22	VERSION	☐	J_3R_TTAX_VER		CHAR	5	0	Version Of The Transport Tax Entry
23	LIGHT	☐	ICON_4	ICON_4	CHAR	4	0	Temporary delivery status during wave creation
24	TAX01	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
25	TAX02	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
26	TAX03	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
27	TAX04	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
28	TAX05	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
29	TAX06	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
30	TAX07	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
31	TAX08	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
32	TAX09	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
33	TAX10	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
34	TAX11	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
35	TAX12	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
36	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
37	STATUS	☐	J_3R_TTAX_STAT	J_3R_TTAX_STATUS	CHAR	1	0	Status of The Transport Tax Entry
38	LAST_DECLARED	☐	J_3R_FATAX_DECL		CHAR	1	0	Indicator If This Entry Is The Last Declared Entry
39	CREATED_ON	☐	DATS	DATS	DATS	8	0	Field of type DATS
40	CALC_ID	☐	J_3R_TTAX_ID	CHAR30	CHAR	30	0	Identifier name of the Saved Transport Tax Entry
41	DECL_01	☐	DATS	DATS	DATS	8	0	Field of type DATS
42	DECL_NUM1	☐	J_3R_DECL_NUM		CHAR	10	0	Tax Return Document Number
43	DECL_02	☐	DATS	DATS	DATS	8	0	Field of type DATS
44	DECL_NUM2	☐	J_3R_DECL_NUM		CHAR	10	0	Tax Return Document Number
45	DECL_03	☐	DATS	DATS	DATS	8	0	Field of type DATS
46	DECL_NUM3	☐	J_3R_DECL_NUM		CHAR	10	0	Tax Return Document Number
47	DECL_04	☐	DATS	DATS	DATS	8	0	Field of type DATS
48	DECL_NUM4	☐	J_3R_DECL_NUM		CHAR	10	0	Tax Return Document Number
49	NBV01	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
50	NBV02	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
51	NBV03	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
52	NBV04	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
53	NBV05	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
54	NBV06	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
55	NBV07	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
56	NBV08	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
57	NBV09	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
58	NBV10	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
59	NBV11	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
60	NBV12	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
61	NBV13	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
62	VALID_MONTH	☐	J_3R_VALID_MONTH		NUMC	2	0	Number of Valid Months with Respect To The Tax
63	ASSETNAME	☐	J_3R_ASSET_DESC	TEXT100	CHAR	100	0	Asset Description and Additional Description
64	TTAX01_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
65	TTAX02_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
66	TTAX03_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
67	TTAX04_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
68	TTAX05_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
69	TTAX06_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
70	TTAX07_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
71	TTAX08_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
72	TTAX09_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
73	TTAX10_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
74	TTAX11_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
75	TTAX12_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
76	TTAX_RATE	☐	J_3RTVAL		DEC	8	2	Transport Tax Rate
77	BRAND	☐	J_3R_BRAND	CHAR120	CHAR	120	0	Vehicle Brand
78	TAX_SUM	☐	J_3R_TAX_SUM		CURR	17	5	Annual Tax Amount
79	PRIVILEGE	☐	J_3RFPRIVILEGE	CHAR04	CHAR	4	0	Property Tax Reduction
80	AMOUNTRED	☐	J_3RFAMOUNTRED	CHAR04	CHAR	4	0	Property tax amount reduction code
81	EXEMPTION	☐	J_3RFEXEMPTION	CHAR04	CHAR	4	0	Property Tax Exemption Code
82	CNOTX	☐	J_3RTNOTX		CHAR	5	0	Transport Tax Exemption Code
83	CPRTX	☐	J_3RTPREF		CHAR	5	0	Transport Tax Reduction Code
84	USAGE_YEARS	☐	J_3R_TERM		CHAR	3	0	Term of Use
85	TAX_COEFF	☐	J_3R_USE_COEFF	DEC1_2	DEC	3	2	Tax Coefficient
86	PTAX_YEAR	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
87	.INCLUDE	☐				0	0	FI-AA: Russia - Time-Independent General Data
88	GLO_RUS_DEPGR	☐	J_3RFAMORTGR	ORD4X	CHAR	4	0	Depreciation Group	J_3RFDEPRGROUP
89	GLO_RUS_OKOF	☐	J_3RFOKOF	CHAR009	CHAR	9	0	OKOF Code	J_3RFTOKOF
90	GLO_RUS_SERNR	☐	J_3RFSERNR	CHAR32	CHAR	32	0	Serial Number
91	GLO_RUS_PRECCT	☐	J_3RPRECC	CHAR30	CHAR	30	0	Precious materials codes
92	GLO_RUS_PRECQ	☐	J_3RPRECQ	CHAR40	CHAR	40	0	Quantities list of countable precious materials
93	GLO_RUS_PRECW	☐	J_3RPRECW		CHAR	50	0	Weights list of precious materials
94	.INCLUDE	☐				0	0	FI-AA: Russia - Time-Independent Transport Tax
95	GLO_RUS_TTX_TYPE	☐	J_3RTYPV		CHAR	5	0	Transport Type	J_3RTTYPVEH
96	GLO_RUS_TTX_VIN	☐	FLEET_VIN	FLEET_VIN	CHAR	30	0	Manufacturer Vehicle Identification Number for Fleet Object
97	GLO_RUS_TTX_MNFD	☐	J_3RTBAUJJ		DATS	8	0	Manufacturing Date
98	GLO_RUS_TTX_ECOCLASS	☐	J_3R_ECOCLASS	NUMC1	NUMC	1	0	Ecological Class
99	GLO_RUS_ECOCLASS	☐	J_3R_ECOCLASS	NUMC1	NUMC	1	0	Ecological Class
100	GLO_RUS_ECO_CLS	☐	J_3R_ECO_CLS	J_3R_ECO_CLS	CHAR	1	0	Ecological Class
101	.INCLUDE	☐				0	0	FI-AA: Russia - Time-Independent Property Tax
102	GLO_RUS_PRT_TYPE	☐	J_3RFPROPTYPE	CHAR1	CHAR	1	0	Property Type	J_3RFPROPTYPES
103	ADATU	☐	ADATU	DATUM	DATS	8	0	Date for beginning of validity
104	BDATU	☐	BDATU	DATUM	DATS	8	0	Date validity ends
105	AIMMO	☐	AIMMO	AIMMO	NUMC	1	0	Indicator: real estate
106	OFPRIV1	☐	J_3RFOFPRIVILEGE	CHAR10	CHAR	10	0	Federal Property Tax Concession
107	OFPRIV2	☐	J_3RFOFPRIVILEGE	CHAR10	CHAR	10	0	Federal Property Tax Concession
108	RATE	☐	J_3RFPROPTAXRATE	J_3RFPROPTAXRATE	DEC	8	5	Property Tax Rate
109	KBK	☐	J_3R_KBK		CHAR	20	0	KBK Code For Non-UGSS Asset
110	REGION	☐	J_3RFREGION	CHAR5	CHAR	5	0	Region
111	DISTRICT	☐	J_3RFDISTRICT	CHAR5	CHAR	5	0	District
112	AVGNBV	☐	J_3R_PTAX_AVGNBV		CURR	17	5	Property Tax Average Net Book Value
113	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
114	DECL_NUM	☐	J_3R_DECL_NUM		CHAR	10	0	Tax Return Document Number
115	CORR_NUM	☐			INT4	10	0
116	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
117	TAX_AUTH_CODE	☐	J_3R_TAX_AUTH		CHAR	4	0	Tax Office Code
118	KPP	☐	J_3R_KPP	TEXT9	CHAR	9	0	KPP Number of Reporting Company
119	NBV01_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
120	NBV02_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
121	NBV03_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
122	NBV04_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
123	NBV05_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
124	NBV06_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
125	NBV07_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
126	NBV08_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
127	NBV09_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
128	NBV10_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
129	NBV11_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
130	NBV12_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
131	NBV13_ORIG	☐	J_3R_TTAX_AMNT		CURR	17	5	Monthly Transport Tax Amount For
132	EXEMP_LAW	☐	J_3RFEXEMPLAW	CHAR12	CHAR	12	0	Law Article for Exemption Code
133	PRVG_LAW	☐	J_3RFPRVGLAW	CHAR12	CHAR	12	0	Law Article for Reduction Code
134	AMTR_LAW	☐	J_3RFAMTRLAW	CHAR12	CHAR	12	0	Law Article for Amount Reduction Code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3R_PTAX_EXT2	GLO_RUS_DEPGR	J_3RFDEPRGROUP	AMORTGR
2	J_3R_PTAX_EXT2	GLO_RUS_OKOF	J_3RFTOKOF	OKOF
3	J_3R_PTAX_EXT2	GLO_RUS_PRT_TYPE	J_3RFPROPTYPES	PROPTYPE
4	J_3R_PTAX_EXT2	GLO_RUS_TTX_TYPE	J_3RTTYPVEH	CTYPV

History

Last changed by/on	SAP	20131127
SAP Release Created in	604