SAP ABAP Table OIH_J_1BTXIC2 (Tax calc.: ICMS rules (exceptions))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TDP (Application Component) Tariffs, Duties and Permits
     ⤷ OIH_CV_BR (Package) Oil country version Brazil

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIH_J_1BTXIC2	Table Relationship Diagram
Short Description	Tax calc.: ICMS rules (exceptions)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

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	OIHVTYPE	☑	OIH_J1B_VTYP	OIH_J1B_VTYP	CHAR	1	0	Vendor type (refinery/mill/other) (Brazil)
6	OIHMTXGR	☑	OIH_J1B_MTXGR	OIH_J1B_MTXGR	CHAR	4	0	Material tax group	OIH2M_J1B
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	RATE	☐	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
10	BASE	☐	J_1BTXBASE	J_1BTXBASE	DEC	6	2	Tax base (%)
11	EXEMPT	☐	J_1BTXEXIC	XFELD	CHAR	1	0	No ICMS calculation - Other base
12	TAXLAW	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS	J_1BATL1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIH_J_1BTXIC2	LAND1	T005	LAND1		1	CN
2	OIH_J_1BTXIC2	MANDT	T000	MANDT		1	CN
3	OIH_J_1BTXIC2	OIHMTXGR	OIH2M_J1B	OIHMTXGR		1	CN
4	OIH_J_1BTXIC2	SHIPFROM	J_1BTREGX	TXREG		1	CN
5	OIH_J_1BTXIC2	SHIPTO	J_1BTREGX	TXREG		1	CN
6	OIH_J_1BTXIC2	TAXLAW	J_1BATL1	TAXLAW	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in