SAP ABAP Table J_1BTXIP3 (Grouped IPI)

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_1BTXIP3	Table Relationship Diagram
Short Description	Grouped IPI

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	*
2	GRUOP	☑	J_1BTXGRP	J_1BTXGRP	NUMC	2	0	Tax Group for Dynamic Tax Exceptions	J_1BTXGRUOP
3	VALUE	☑	J_1BVALUE	J_1BVALUE	CHAR	20	0	Dynamic Key Field
4	VALUE2	☑	J_1BVALUE2	J_1BVALUE2	CHAR	20	0	Dynamic Key Field
5	VALUE3	☑	J_1BVALUE3	J_1BVALUE3	CHAR	20	0	Dynamic Key Field
6	VALIDFROM	☑	J_1BTXDATF	DATUM_INV	CHAR	8	0	Date from which the tax rule is valid
7	RATE	☐	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
8	BASE	☐	J_1BTXBASE	J_1BTXBASE	DEC	6	2	Tax base (%)
9	EXEMPT	☐	J_1BTXEXIP	XFELD	CHAR	1	0	No IPI calculation - Other base
10	TAXLAW	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI	J_1BATL2
11	AMOUNT	☐	J_1BTXIPA	J_1BTXRATE	DEC	6	2	IPI rate per unit (pauta)
12	FACTOR	☐	J_1BTXIPF	DEC4_2	DEC	6	2	Number of units
13	UNIT	☐	J_1BTXIPU	MEINS	UNIT	3	0	Pauta Unit	*
14	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1BTXIP3	GRUOP	J_1BTXGRUOP	GRUOP		1	CN
2	J_1BTXIP3	TAXLAW	J_1BATL2	TAXLAW	KEY	1	CN
3	J_1BTXIP3	WAERS	TCURC	WAERS	KEY	1	CN

History

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