SAP ABAP Table J1B_NF_XML_ITEM (Nota Fiscal Eletronica / NF-e Data - Item (1:n))

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-LOC-BR (Application Component) Brazil
⤷

J1BA (Package) Localization Brazil

Basic Data

Table Category	INTTAB	Structure
Structure	J1B_NF_XML_ITEM	Table Relationship Diagram
Short Description	Nota Fiscal Eletronica / NF-e Data - Item (1:n)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DOCNUM	J_1BDOCNUM	J_1BDOCNUM	NUMC	10	0	Document Number	*
2	ITMNUM	J_1BITMNUM	J_1BITMNUM	NUMC	6	0	Document Item Number
3	.INCLUDE				0	0	NF-e Block H / Products and Services of the NF-e /Tag: det
4	NITEM			NUMC	3	0
5	.INCLUDE				0	0	NF-e Block H1 / Products and Services of the NF-e /Tag: prod
6	CPROD	MATNR	MATNR	CHAR	18	0	Material Number	*
7	CEAN	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
8	XPROD			CHAR	120	0
9	NCM	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	*
10	EXTIPI			CHAR	3	0
11	GENERO			CHAR	2	0
12	CFOP	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension	*
13	UTRIB	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
14	UCOM	VRKME	MEINS	UNIT	3	0	Sales unit	*
15	QTRIB	MENGE_D	MENG13	QUAN	13	3	Quantity
16	QCOM	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
17	VPROD	J_1BNFTOT	WERTV8	CURR	15	2	Total value including all taxes
18	VFRETE	J_1BNFFRE	WERTV8	CURR	15	2	Freight value including taxes
19	VSEG	J_1BNFINS	WERTV8	CURR	15	2	Insurance value including taxes
20	VDESC	J_1BNFDIS	WERTV8	CURR	15	2	Discount value including taxes
21	VUNCOM			DEC	15	4
22	CEANTRIB			CHAR	14	0
23	VUNTRIB			DEC	15	4
24	.INCLUDE				0	0	NF-e Block H2 / Import Declaration /Tag: DI
25	NDI			CHAR	10	0
26	DDI			DATS	8	0
27	XLOCDESEMB			CHAR	60	0
28	UFDESEMB			CHAR	2	0
29	DDESEMB			DATS	8	0
30	CEXPORTADOR			CHAR	60	0
31	.INCLUDE				0	0	NF-e Block H2 / Import Declaration Add. Data /Tag: ADI
32	NADICAO			NUMC	3	0
33	NSEQADIC			NUMC	3	0
34	CFABRICANTE			CHAR	60	0
35	VDESCDI			CURR	15	2
36	.INCLUDE				0	0	NF-e Block I / New Vehicles /Tag: veic
37	I_TPOP			NUMC	1	0
38	I_CHASSI			CHAR	17	0
39	I_COR			CHAR	4	0
40	I_XCOR			CHAR	40	0
41	I_POT			CHAR	4	0
42	I_CM3			CHAR	4	0
43	I_PESOL			CHAR	9	0
44	I_PESOB			CHAR	9	0
45	I_NSERIE			CHAR	9	0
46	I_TPCOMB			CHAR	8	0
47	I_NMOTOR			CHAR	21	0
48	I_CMKG			CHAR	9	0
49	I_DIST			CHAR	4	0
50	I_RENAVAM			CHAR	9	0
51	I_ANOMOD			NUMC	4	0
52	I_ANOFAB			NUMC	4	0
53	I_TPPINT			CHAR	1	0
54	I_TPVEIC			NUMC	2	0
55	I_ESPVEIC			CHAR	1	0
56	I_VIN			CHAR	1	0
57	I_CONDVEIC			NUMC	1	0
58	I_CMOD			CHAR	6	0
59	.INCLUDE				0	0	NF-e Block H4 / Guns / Tag: gun
60	K_TPARMA			NUMC	1	0
61	K_NSERIE			NUMC	9	0
62	K_NCANO			NUMC	9	0
63	K_DESCR			CHAR	256	0
64	.INCLUDE				0	0	NF-e Block L / Taxes /Tag: impostos
65	.INCLUDE				0	0	NF-e Block L1 / Taxes ICMS /Tag: ICMS
66	L1_ICMS			CHAR	1	0
67	.INCLUDE				0	0	NF-e Block L1_00 / Taxes ICMS /Tag: ICMS00
68	L1_00_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
69	L1_00_CST			NUMC	2	0
70	L1_00_MODBC			NUMC	1	0
71	L1_00_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
72	L1_00_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
73	L1_00_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
74	.INCLUDE				0	0	NF-e Block L1_10 / Taxes ICMS /Tag: ICMS10
75	L1_10_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
76	L1_10_CST			NUMC	2	0
77	L1_10_MODBC			NUMC	1	0
78	L1_10_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
79	L1_10_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
80	L1_10_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
81	L1_10_MODBCST			NUMC	1	0
82	L1_10_PMVAST			DEC	5	2
83	L1_10_PREDBCST			DEC	5	2
84	L1_10_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
85	L1_10_PICMSST	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
86	L1_10_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
87	.INCLUDE				0	0	NF-e Block L1_20 / Taxes ICMS /Tag: ICMS20
88	L1_20_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
89	L1_20_CST			NUMC	2	0
90	L1_20_MODBC			NUMC	1	0
91	L1_20_PREDBC			DEC	5	2
92	L1_20_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
93	L1_20_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
94	L1_20_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
95	.INCLUDE				0	0	NF-e Block L1_30 / Taxes ICMS /Tag: ICMS30
96	L1_30_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
97	L1_30_CST			NUMC	2	0
98	L1_30_MODBCST			NUMC	1	0
99	L1_30_PMVAST			DEC	5	2
100	L1_30_PREDBCST			DEC	5	2
101	L1_30_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
102	L1_30_PICMSST	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
103	L1_30_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
104	.INCLUDE				0	0	NF-e Block L1_40 / Taxes ICMS /Tag: ICMS40
105	L1_40_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
106	L1_40_CST			NUMC	2	0
107	.INCLUDE				0	0	NF-e Block L1_51 / Taxes ICMS /Tag: ICMS51
108	L1_51_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
109	L1_51_CST			NUMC	2	0
110	L1_51_MODBC			NUMC	1	0
111	L1_51_PREDBC			DEC	5	2
112	L1_51_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
113	L1_51_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
114	L1_51_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
115	.INCLUDE				0	0	NF-e Block L1_60 / Taxes ICMS /Tag: ICMS60
116	L1_60_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
117	L1_60_CST			NUMC	2	0
118	L1_60_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
119	L1_60_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
120	.INCLUDE				0	0	NF-e Block L1_70 / Taxes ICMS /Tag: ICMS70
121	L1_70_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
122	L1_70_CST			NUMC	2	0
123	L1_70_MODBC			NUMC	1	0
124	L1_70_PREDBC			DEC	5	2
125	L1_70_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
126	L1_70_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
127	L1_70_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
128	L1_70_MODBCST			NUMC	1	0
129	L1_70_PMVAST			DEC	5	2
130	L1_70_PREDBCST			DEC	5	2
131	L1_70_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
132	L1_70_PICMSST	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
133	L1_70_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
134	.INCLUDE				0	0	NF-e Block L1_90 / Taxes ICMS /Tag: ICMS90
135	L1_90_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
136	L1_90_CST			NUMC	2	0
137	L1_90_MODBC			NUMC	1	0
138	L1_90_PREDBC			DEC	5	2
139	L1_90_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
140	L1_90_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
141	L1_90_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
142	L1_90_MODBCST			NUMC	1	0
143	L1_90_PMVAST			DEC	5	2
144	L1_90_PREDBCST			DEC	5	2
145	L1_90_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
146	L1_90_PICMSST	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
147	L1_90_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
148	.INCLUDE				0	0	NF-e Block N / Taxes IPI /Tag: IPI
149	N_IPI			CHAR	1	0
150	.INCLUDE				0	0	NF-e Block N0 / Taxes IPI /Tag: IPI
151	N_CLENQ			CHAR	5	0
152	N_CNPJPROD	STCD1	STCD1	CHAR	16	0	Tax Number 1
153	N_CSELO			CHAR	60	0
154	N_QSELO			NUMC	12	0
155	N_CENQ			CHAR	3	0
156	.INCLUDE				0	0	NF-e Block N1 / Taxes IPI /Tag: IPITrip
157	N1_CST			CHAR	2	0
158	N1_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
159	N1_QUNID			DEC	15	4
160	N1_VUNID			DEC	15	4
161	N1_PIPI	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
162	N1_VIPI	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
163	.INCLUDE				0	0	NF-e Block N2 / Taxes IPI /Tag: IPINT
164	N2_CST			CHAR	2	0
165	.INCLUDE				0	0	NF-e Block O / Taxes Import /Tag: II
166	O_II			CHAR	1	0
167	O_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
168	O_VDESPADU			DEC	15	2
169	O_VII			DEC	15	2
170	O_VIOF			DEC	15	2
171	.INCLUDE				0	0	NF-e Block P / Taxes PIS /Tag: PIS
172	P_PIS			CHAR	1	0
173	.INCLUDE				0	0	NF-e Block P1/ Taxes PIS /Tag: PISAlig
174	P1_CST			NUMC	2	0
175	P1_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
176	P1_PPIS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
177	P1_VPIS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
178	.INCLUDE				0	0	NF-e Block P2 / Taxes PIS /Tag: PISQtde
179	P2_CST			NUMC	2	0
180	P2_QBCPROD			DEC	15	4
181	P2_VALIQPROD			DEC	15	4
182	P2_VPIS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
183	.INCLUDE				0	0	NF-e Block P2 / Taxes PIS /Tag: PISNT
184	P3_CST			NUMC	2	0
185	.INCLUDE				0	0	NF-e Block P4 / Taxes PIS /Tag: PISOutr
186	P4_CST			NUMC	2	0
187	P4_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
188	P4_PPIS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
189	P4_QBCPROD			DEC	15	4
190	P4_VALIQPROD			DEC	15	4
191	P4_VPIS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
192	.INCLUDE				0	0	NF-e Block P5 / Taxes PIS /Tag: PISST - Selling Zona Franca
193	P5_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
194	P5_PPIS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
195	P5_QBCPROD			DEC	15	4
196	P5_VALIQPROD			DEC	15	4
197	P5_VPIS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
198	.INCLUDE				0	0	NF-e Block Q / Taxes COFINS /Tag: COFINS
199	Q_COFINS			CHAR	1	0
200	.INCLUDE				0	0	NF-e Block Q1 / Taxes COFINS /Tag: COFINSAlig
201	Q1_CST			NUMC	2	0
202	Q1_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
203	Q1_PCOFINS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
204	Q1_VCOFINS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
205	.INCLUDE				0	0	NF-e Block Q2/ Taxes COFINS /Tag: COFINSQtde
206	Q2_CST			NUMC	2	0
207	Q2_QBCPROD			DEC	15	4
208	Q2_VALIQPROD			DEC	15	4
209	Q2_VCOFINS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
210	.INCLUDE				0	0	NF-e Block Q3 / Taxes COFINS /Tag: COFINSNT
211	Q3_CST			NUMC	2	0
212	.INCLUDE				0	0	NF-e Block Q4 / Taxes COFINS /Tag: COFINS
213	Q4_CST			NUMC	2	0
214	Q4_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
215	Q4_PCOFINS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
216	Q4_QBCPROD			DEC	15	4
217	Q4_VALIQPROD			DEC	15	4
218	Q4_VCOFINS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
219	.INCLUDE				0	0	NF-e Block Q5 / Taxes COFINS /Tag: COFINSST - SD Zona Franca
220	Q5_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
221	Q5_PCOFINS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
222	Q5_QBCPROD			DEC	15	4
223	Q5_VALIQPROD			DEC	15	4
224	Q5_VCOFINS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
225	.INCLUDE				0	0	NF-e Block / Taxes ISS /Tag: ISSQN
226	X_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
227	X_VALIQ	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
228	X_VISSQN	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
229	X_CMUNFG			NUMC	7	0
230	X_CLISTSERV			NUMC	4	0
231	.INCLUDE				0	0	NF-e Block R / Content of Tax laws /Tag:
232	INFADPROD			STRG	0	0
233	.INCLUDE				0	0	Nota Fiscal Eletronica / NF-e Data Item Version 1.10 IS-Oil
234	OIL_CPRODANP			NUMC	9	0
235	OIL_CODIF			NUMC	21	0
236	OIL_GTEMP			DEC	16	4
237	OIL_QBCPROD			DEC	12	4
238	OIL_VALIGPROD			DEC	11	4
239	OIL_VCIDE			DEC	13	2
240	OIL_VBCICMS			DEC	13	2
241	OIL_VICMS			DEC	13	2
242	OIL_VBCICMSST			DEC	13	2
243	OIL_VCICMSST			DEC	13	2
244	OIL_VBCICMSSTDEST			DEC	13	2
245	OIL_VICMSSTDEST			DEC	13	2
246	OIL_VBCICMSSTCONS			DEC	13	2
247	OIL_VICMSSTCONS			DEC	13	2
248	OIL_UFCONS			CHAR	2	0
249	.INCLUDE				0	0	Nota Fiscal Eletronica / NF-e Data - Item (1:n) - Vers. 2.0
250	H1_VOUTRO			DEC	15	2
251	INDTOT			NUMC	1	0
252	XPED			CHAR	15	0
253	NITEMPED			NUMC	6	0
254	CCORDEN			NUMC	2	0
255	LOTA			NUMC	3	0
256	TPREST			NUMC	1	0
257	L1_40_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
258	L1_40_MOTDESICMS			NUMC	1	0
259	X_CSITTRIB			CHAR	1	0
260	QCOM_V20	J1B_NF_XML_QUANTITY		QUAN	15	4	Quantity in XML Layout
261	VUNCOM_V20			DEC	21	10
262	QTRIB_V20	J1B_NF_XML_QUANTITY		QUAN	15	4	Quantity in XML Layout
263	VUNTRIB_V20			DEC	21	10
264	.INCLUDE				0	0	NF-e Block L1_2R - Vers 2.0
265	L1_2R_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
266	L1_2R_CST			NUMC	2	0
267	L1_2R_MODBC			NUMC	1	0
268	L1_2R_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
269	L1_2R_PREDBC			DEC	5	2
270	L1_2R_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
271	L1_2R_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
272	L1_2R_MODBCST			NUMC	1	0
273	L1_2R_PMVAST			DEC	5	2
274	L1_2R_PREDBCST			DEC	5	2
275	L1_2R_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
276	L1_2R_PICMSST	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
277	L1_2R_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
278	L1_2R_PBCOP			DEC	5	2
279	L1_2R_UFST	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
280	.INCLUDE				0	0	Nota Fiscal Eletronica / NF-e Data ITEM: Interstate Vers 2.0
281	ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
282	CST			NUMC	2	0
283	VBCSTRET	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
284	VICMSSTRET	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
285	VBCSTDEST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
286	VICMSSTDEST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
287	VTOTTRIB	J_1BNFE_VTOTTRIB		DEC	15	2	Total Tax Value
288	NFCI	J_1BNFE_NFCI		CHAR	36	0	FCI Number