SAP ABAP Table J_1BTXIC3 (Grouped ICMS)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC-BR (Application Component) Brazil
     ⤷ J1BA (Package) Localization Brazil
Basic Data
Table Category TRANSP    Transparent table 
Transparent table J_1BTXIC3   Table Relationship Diagram
Short Description Grouped ICMS    
Delivery and Maintenance
Pool/cluster      
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
3 SHIPFROM J_1BTXSHPF J_1BTXREG CHAR 3   0   Ship from location (tax region) J_1BTREGX
4 SHIPTO J_1BTXSHPT J_1BTXREG CHAR 3   0   Ship to location (tax region) J_1BTREGX
5 GRUOP J_1BTXGRP J_1BTXGRP NUMC 2   0   Tax Group for Dynamic Tax Exceptions J_1BTXGRUOP
6 VALUE J_1BVALUE J_1BVALUE CHAR 20   0   Dynamic Key Field  
7 VALUE2 J_1BVALUE2 J_1BVALUE2 CHAR 20   0   Dynamic Key Field  
8 VALUE3 J_1BVALUE3 J_1BVALUE3 CHAR 20   0   Dynamic Key Field  
9 VALIDFROM J_1BTXDATF DATUM_INV CHAR 8   0   Date from which the tax rule is valid  
10 VALIDTO J_1BTXDATT DATUM_INV CHAR 8   0   Date to which the tax rule is valid  
11 RATE J_1BTXRATE J_1BTXRATE DEC 6   2   Tax Rate  
12 BASE J_1BTXBASE J_1BTXBASE DEC 6   2   Tax base (%)  
13 EXEMPT J_1BTXEXIC XFELD CHAR 1   0   No ICMS calculation - Other base  
14 TAXLAW J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS J_1BATL1
15 CONVEN100 J_1BTXC100 XFELD CHAR 1   0   Product Subject to Convenio 100  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 J_1BTXIC3 GRUOP J_1BTXGRUOP GRUOP 1 CN
2 J_1BTXIC3 LAND1 T005 LAND1 1 CN
3 J_1BTXIC3 MANDT T000 MANDT 1 CN
4 J_1BTXIC3 SHIPFROM J_1BTREGX TXREG 1 CN
5 J_1BTXIC3 SHIPTO J_1BTREGX TXREG 1 CN
6 J_1BTXIC3 TAXLAW J_1BATL1 TAXLAW KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 46C