SAP ABAP Table J_1BTXST3 (Dynamic Calculation of Substituição Tributária)

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_1BTXST3	Table Relationship Diagram
Short Description	Dynamic Calculation of Substituição Tributária

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	STGRP	☑	J_1BTCST	J_1BTCST1	CHAR	3	0	Customer group for Substituiçao Tributária calculation	J_1BTXSTG
10	VALIDFROM	☑	J_1BTXDATF	DATUM_INV	CHAR	8	0	Date from which the tax rule is valid
11	VALIDTO	☐	J_1BTXDATT	DATUM_INV	CHAR	8	0	Date to which the tax rule is valid
12	SUR_TYPE	☐	J_1BTXSTT	J_1BTXSTT	NUMC	1	0	Sub.Trib. calculation rule
13	RATE	☐	J_1BTXSTPR	J_1BTXRATE	DEC	6	2	Sub.Trib. surcharge percentage rate
14	PRICE	☐	J_1BTXSTFP	J_1BTXSTFP	DEC	15	2	Sub.Trib. fixed price per unit
15	FACTOR	☐	J_1BTXSTF	DEC4_2	DEC	6	2	Number of units for Sub.Trib. calc. (price per n units)
16	UNIT	☐	J_1BTXSTU	MEINS	UNIT	3	0	Unit for Sub.Trib. calculation (price per n units)	T006
17	BASERED1	☐	J_1BTXSTB1	J_1BTXBASE	DEC	6	2	Sub.Trib. Base Reduction 1 (Federal) (in %)
18	BASERED2	☐	J_1BTXSTB2	J_1BTXBASE	DEC	6	2	Sub.Trib. Base Reduction 2 (State) (in %)
19	ICMSBASER	☐	J_1BTXSTI1	J_1BTXBASE	DEC	6	2	ICMS Reduction for Sub.Trib. (in %)
20	MINPRICE	☐	J_1BTXSTMP	J_1BTXSTFP	DEC	15	2	Minimum Price Per Item Is Basis for Substituição Tributária
21	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
22	MINFACT	☐	J_1BTXSTPF	J_1BTXRATE	DEC	6	2	Sub.Trib. Percentage to be Applied on Minimum Price
23	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_1BTXST3	GRUOP	J_1BTXGRUOP	GRUOP		1	CN
2	J_1BTXST3	LAND1	T005	LAND1		1	CN
3	J_1BTXST3	MANDT	T000	MANDT		1	CN
4	J_1BTXST3	SHIPFROM	J_1BTREGX	TXREG		1	CN
5	J_1BTXST3	SHIPTO	J_1BTREGX	TXREG		1	CN
6	J_1BTXST3	STGRP	J_1BTXSTG	STGRP		1	CN
7	J_1BTXST3	UNIT	T006	MSEHI		1	CN
8	J_1BTXST3	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C