J_1BTXIC3 - Grouped ICMS

Grouped ICMS information is stored in SAP table J_1BTXIC3.
It is part of development package J1BA in software component FI-LOC-LO-BR. This development package consists of objects that can be grouped under "Localization Brazil".

Fields for table J_1BTXIC3

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
LAND1	Country/Region Key	X	LAND1	CHAR	6	T005
SHIPFROM	Ship from location (tax region)	X	J_1BTXSHPF	CHAR	6	J_1BTREGX
SHIPTO	Ship to location (tax region)	X	J_1BTXSHPT	CHAR	6	J_1BTREGX
GRUOP	Tax Group for Dynamic Tax Exceptions	X	J_1BTXGRP	NUMC	4	J_1BTXGRUOP
VALUE	Dynamic Key Field	X	J_1BVALUE	CHAR	80
VALUE2	Dynamic Key Field	X	J_1BVALUE2	CHAR	80
VALUE3	Dynamic Key Field	X	J_1BVALUE3	CHAR	80
VALIDFROM	Date from which the tax rule is valid	X	J_1BTXDATF	CHAR	16
VALIDTO	Date to which the tax rule is valid		J_1BTXDATT	CHAR	16
RATE	Tax Rate		J_1BTXRATE	DEC	4
BASE	Tax base (%)		J_1BTXBASE	DEC	4
EXEMPT	No ICMS calculation - Other base		J_1BTXEXIC	CHAR	2
TAXLAW	Tax law: ICMS		J_1BTAXLW1	CHAR	6	J_1BATL1
CONVEN100	Product Subject to Convenio 100		J_1BTXC100	CHAR	2
SPECF_RATE	ICMS FCP Rate		J_1BSPECFRATE	DEC	4
SPECF_BASE	ICMS FCP Base		J_1BSPECFBASE	DEC	4
PARTILHA_EXEMPT	ICMS Partilha Exemption		J_1BPARTEXEMPT	CHAR	2
SPECF_RESALE	Calculate FCP for Resale		J_1BSPECFRESALE	CHAR	2