SAP ABAP Table OIH_J1B_TXCD_CALC (Comunication Structure from tax validation to calculation)

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	INTTAB	Structure
Structure	OIH_J1B_TXCD_CALC	Table Relationship Diagram
Short Description	Comunication Structure from tax validation to calculation

Delivery and Maintenance

Pool/cluster
Delivery Class
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	TRAN_TYPE	☐	OIH_J1B_TRTYPE	OIH_J1B_TRTYPE	CHAR	2	0	Transaction type (sales, purchase, transf. in, transf. out)
2	INT_OP	☐	OIH_J1B_INT	OIH_J1B_OPER_SALES	CHAR	1	0	Inter / intra operation type
3	CUSTYPE	☐	OIH_J1B_CTYP	OIH_J1B_CTYP	CHAR	1	0	Customer type (end c./reseller/industry)
4	OIHCTXGR	☐	OIH_J1B_CTXGR	OIH_J1B_CTXGR	CHAR	4	0	Customer tax group
5	VEND_COD	☐	OIH_J1B_VTYP	OIH_J1B_VTYP	CHAR	1	0	Vendor type (refinery/mill/other) (Brazil)
6	OIHVTXGR	☐	OIH_J1B_VTXGR	OIH_J1B_VTXGR	CHAR	4	0	Vendor group (refinery/mill/other)
7	MAT_TAX_GR	☐	OIH_J1B_MTXGR	OIH_J1B_MTXGR	CHAR	4	0	Material tax group
8	TAXATION_ORIG	☐	OIH_J1B_TAX_ORIG	XFELD	CHAR	1	0	Taxation at origin
9	TAXATION_DEST	☐	OIH_J1B_TAX_DEST	XFELD	CHAR	1	0	Taxation at destination
10	OIHCV03	☐	OIH_CONV_03	XFELD	CHAR	1	0	Convenio 03
11	OIHCV80O	☐	OIH_CONV_80O	XFELD	CHAR	1	0	Convenio 80 at origin
12	OIHCV80D	☐	OIH_CONV_80D	XFELD	CHAR	1	0	Convenio 80 at destin.
13	PRICE_CONTROL	☐	OIH_J1B_PR_CNTRL	XFELD	CHAR	1	0	Price controlled
14	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
15	SUBTR_TYPE	☐	OIH_SUBTR_TYPE	OIH_SUBTR_TYPE	CHAR	1	0	Type of sub. trib. (in-coming or backwards)
16	PRINT_ICMS	☐	OIH_J1B_IPRINT	OIH_J1B_IPRINT	CHAR	1	0	Indicator where to print ICMS
17	STPR_INTRA	☐	OIH_J1BSTPR_INTRA	J_1BTXRATE	DEC	6	2	Sub.Trib. surcharge percentage rate intrastate
18	STPR_INTER	☐	OIH_J1BSTPR_INTER	J_1BTXRATE	DEC	6	2	Sub.Trib. surcharge percentage rate interstate =gross margin
19	FACTOR1	☐	OIH_J1B_REDFAC	OIH_J1B_PERCENT	DEC	6	2	Reduction factor alc.taxation
20	FACTOR2	☐	OIH_J1B_REDFAC	OIH_J1B_PERCENT	DEC	6	2	Reduction factor alc.taxation
21	CREDIT_IPI	☐	OIH_J1B_TXCREDIP	ANKREUZ	CHAR	1	0	IPI credit allowed
22	CREDIT_ICMS	☐	OIH_J1B_TXCREDIC	XFELD	CHAR	1	0	ICMS credit allowed (Brazil taxes)
23	TAXTYPE	☐	OIH_J1B_TXITYP	OIH_J1B_TXITYP	CHAR	1	0	Incoming taxation type (Brazil)
24	PERCENT	☐	OIH_J1B_BCKRATE	OIH_J1B_PERCENT	DEC	6	2	Percentage of backward sub.trib. collected
25	MIXPROD	☐	OIH_J1B_MATNR	MATNR	CHAR	18	0	Product to be mixed with	*
26	FACPIS	☐	OIH_J1B_FACPIS	OIH_J1B_FACTOR	DEC	6	2	Factor for PIS ST calculation
27	FACCOF	☐	OIH_J1B_FACCOF	OIH_J1B_FACTOR	DEC	6	2	Factor for COFINS ST calculation
28	FORMULA	☐	OIH_J1B_PIS_FORM	OIH_J1B_FORMULA	CHAR	1	0	Formula type for PIS/COFINS ST calculation
29	PRINT_IND	☐	OIH_J1B_IPRINT_PIS	OIH_J1B_IPRINT	CHAR	1	0	Indicator for PIS/COFINS ST printing exceptions
30	OS_TXLW1	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS	*
31	OS_TXLW2	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI	*
32	TXLW4	☐	OIH_J1B_TAXLW4	OIH_J1B_TAXLW4	CHAR	3	0	Tax law: PIS/COFINS
33	ZONA_FRANCA	☐	OIH_J1B_ZFR	XFELD	CHAR	1	0	Flag indicating whether operation involves Zona Franca
34	OIHVTYPE	☐	OIH_J1B_VTYP	OIH_J1B_VTYP	CHAR	1	0	Vendor type (refinery/mill/other) (Brazil)
35	OIHNOCON	☐	OIH_NO_CONTRIB	XFELD	CHAR	1	0	Product with no contrib.(law 87)
36	OIHREFST	☐	OIH_REFST_END	OIH_REFST	CHAR	1	0	Brazil: Refinery ST applied to end customer
37	LEG_CLAIM	☐	OIH_J1B_ICREF	XFELD	CHAR	1	0	Indicator: customer is legal claimant for this case
38	NO_LBOOK	☐	OIH_J1B_NLBOOK	XFELD	CHAR	1	0	Don't bring tax amount as tax credit to legal book
39	PUR_NOTAX	☐	OIH_J1B_PURNOTAX	XFELD	CHAR	1	0	Indicator: for this oper. no tax paid when purchasing
40	PISCOF_EXC	☐	OIH_J1B_PICO_EXC	XFELD	CHAR	1	0	PIS/COFINS exception for reading OIH_J1B_PIS
41	PMPF_USED_ORIGIN	☐	OIH_J1B_PMPF_USED	XFELD	CHAR	1	0	PMPF used indicator
42	PMPF_USED_DESTIN	☐	OIH_J1B_PMPF_USED	XFELD	CHAR	1	0	PMPF used indicator
43	OIHSURCHARGE	☐	OIH_J1B_SURCHARGE	XFELD	CHAR	1	0	Lubricants Sales # MVA Excluded

History

Last changed by/on	SAP	20131127
SAP Release Created in