SAP Table J_1BTXIC3

Grouped ICMS

The table J_1BTXIC3 (Grouped ICMS) is a standard table in SAP ERP. It belongs to the package J1BA.

Technical Information

Table	J_1BTXIC3
Short Text	Grouped ICMS
Package	J1BA
Table Type	Transparent Table

Fields for Table J_1BTXIC3

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
LAND1	✔	Country Key	LAND1	CHAR	3	T005
SHIPFROM	✔	Ship from location (tax region)	J_1BTXSHPF	CHAR	3	J_1BTREGX
SHIPTO	✔	Ship to location (tax region)	J_1BTXSHPT	CHAR	3	J_1BTREGX
GRUOP	✔	Tax Group for Dynamic Tax Exceptions	J_1BTXGRP	NUMC	2	J_1BTXGRUOP
VALUE	✔	Dynamic Key Field	J_1BVALUE	CHAR	20
VALUE2	✔	Dynamic Key Field	J_1BVALUE2	CHAR	20
VALUE3	✔	Dynamic Key Field	J_1BVALUE3	CHAR	20
VALIDFROM	✔	Date from which the tax rule is valid	J_1BTXDATF	CHAR	8
VALIDTO		Date to which the tax rule is valid	J_1BTXDATT	CHAR	8
RATE		Tax Rate	J_1BTXRATE	DEC	6
BASE		Tax base (%)	J_1BTXBASE	DEC	6
EXEMPT		No ICMS calculation - Other base	J_1BTXEXIC	CHAR	1
TAXLAW		Tax law: ICMS	J_1BTAXLW1	CHAR	3	J_1BATL1
CONVEN100		Product Subject to Convenio 100	J_1BTXC100	CHAR	1