SAP Table J_3RTTRANS

Tax rates of vehicle

J_3RTTRANS (Tax rates of vehicle) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link J_3RTTRANS to other SAP tables.

J_3RTTRANS table fields

Field		Data element	Checktable	Datatype	Length	Decimals
MANDT	Client	MANDT	T000	CLNT	3	0
OKATO1	OKATO Code (Part 1)	J_3RTOKATO1	J_3RFOKATO	CHAR	2	0
CTYPV	Transport Type	J_3RTYPV	J_3RTTYPVEH	CHAR	5	0
GJAHE	Validity	J_3RTGJEND		NUMC	4	0
VEAGE	Age of Vehicle	J_3RTGJAGE		NUMC	3	0
CPRTX	Transport Tax Reduction Code	J_3RTPREF	J_3RTPRTAX	CHAR	5	0
THRES	Tax Base	J_3RTTHRES		DEC	8	2
TAXVL	Transport Tax Rate	J_3RTVAL		DEC	8	2

J_3RTTRANS foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
J_3RTTRANS	CPRTX	J_3RTTRANS	MANDT	J_3RTPRTAX	Preferential tax code of vehicle	MANDT
J_3RTTRANS	CPRTX	J_3RTTRANS	CPRTX	J_3RTPRTAX	Preferential tax code of vehicle	CPRTX
J_3RTTRANS	CTYPV	J_3RTTRANS	CTYPV	J_3RTTYPVEH	Vehicle tax type	CTYPV
J_3RTTRANS	CTYPV	*		J_3RTTYPVEH	Vehicle tax type	OKOF
J_3RTTRANS	CTYPV	J_3RTTRANS	MANDT	J_3RTTYPVEH	Vehicle tax type	MANDT
J_3RTTRANS	MANDT	J_3RTTRANS	MANDT	T000	Clients	MANDT
J_3RTTRANS	OKATO1	*		J_3RFOKATO	Classifier of the administrative and territorial division	OKATO3
J_3RTTRANS	OKATO1	*		J_3RFOKATO	Classifier of the administrative and territorial division	OKATO4
J_3RTTRANS	OKATO1	J_3RTTRANS	MANDT	J_3RFOKATO	Classifier of the administrative and territorial division	MANDT
J_3RTTRANS	OKATO1	J_3RTTRANS	OKATO1	J_3RFOKATO	Classifier of the administrative and territorial division	OKATO1
J_3RTTRANS	OKATO1	*		J_3RFOKATO	Classifier of the administrative and territorial division	OKATO2