SAP ABAP Table J_1BTXST1 (Tax calc.: Sub.Trib. rules)
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_1BTXST1   Table Relationship Diagram
Short Description Tax calc.: Sub.Trib. rules    
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 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
6 STGRP J_1BTCST J_1BTCST1 CHAR 3   0   Customer group for Substituiçao Tributária calculation J_1BTXSTG
7 VALIDFROM J_1BTXDATF DATUM_INV CHAR 8   0   Date from which the tax rule is valid  
8 VALIDTO J_1BTXDATT DATUM_INV CHAR 8   0   Date to which the tax rule is valid  
9 SUR_TYPE J_1BTXSTT J_1BTXSTT NUMC 1   0   Sub.Trib. calculation rule  
10 RATE J_1BTXSTPR J_1BTXRATE DEC 6   2   Sub.Trib. surcharge percentage rate  
11 PRICE J_1BTXSTFP J_1BTXSTFP DEC 15   2   Sub.Trib. fixed price per unit  
12 FACTOR J_1BTXSTF DEC4_2 DEC 6   2   Number of units for Sub.Trib. calc. (price per n units)  
13 UNIT J_1BTXSTU MEINS UNIT 3   0   Unit for Sub.Trib. calculation (price per n units) T006
14 BASERED1 J_1BTXSTB1 J_1BTXBASE DEC 6   2   Sub.Trib. Base Reduction 1 (Federal) (in %)  
15 BASERED2 J_1BTXSTB2 J_1BTXBASE DEC 6   2   Sub.Trib. Base Reduction 2 (State) (in %)  
16 ICMSBASER J_1BTXSTI1 J_1BTXBASE DEC 6   2   ICMS Reduction for Sub.Trib. (in %)  
17 MINPRICE J_1BTXSTMP J_1BTXSTFP DEC 15   2   Minimum Price Per Item Is Basis for Substituição Tributária  
18 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
19 MINFACT J_1BTXSTPF J_1BTXRATE DEC 6   2   Sub.Trib. Percentage to be Applied on Minimum Price  
20 SURCHIN J_1BTXSTSC XFELD CHAR 1   0   Compare Minimum Price Without Surcharge  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 J_1BTXST1 LAND1 T005 LAND1 1 CN
2 J_1BTXST1 MANDT T000 MANDT 1 CN
3 J_1BTXST1 MATNR MARA MATNR 1 CN
4 J_1BTXST1 SHIPFROM J_1BTREGX TXREG 1 CN
5 J_1BTXST1 SHIPTO J_1BTREGX TXREG 1 CN
6 J_1BTXST1 STGRP J_1BTXSTG STGRP KEY 1 CN
7 J_1BTXST1 UNIT T006 MSEHI REF 1 CN
8 J_1BTXST1 WAERS TCURC WAERS KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in