SAP ABAP Table OIH_J1B_TXCD_ITEM (Comunication Structure from tax validation to nota fiscal)

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_ITEM	Table Relationship Diagram
Short Description	Comunication Structure from tax validation to nota fiscal

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

History

Last changed by/on	SAP	20131127
SAP Release Created in