SAP ABAP Table J1B_NF_XML_H (NF-e Block H / Products and Services of the NF-e /Tag: det)

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_H	Table Relationship Diagram
Short Description	NF-e Block H / Products and Services of the NF-e /Tag: det

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	NITEM			NUMC	3	0
2	.INCLUDE				0	0	NF-e Block H1 / Products and Services of the NF-e /Tag: prod
3	CPROD	MATNR	MATNR	CHAR	18	0	Material Number	*
4	CEAN	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
5	XPROD			CHAR	120	0
6	NCM	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	*
7	EXTIPI			CHAR	3	0
8	GENERO			CHAR	2	0
9	CFOP	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension	*
10	UTRIB	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
11	UCOM	VRKME	MEINS	UNIT	3	0	Sales unit	*
12	QTRIB	MENGE_D	MENG13	QUAN	13	3	Quantity
13	QCOM	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
14	VPROD	J_1BNFTOT	WERTV8	CURR	15	2	Total value including all taxes
15	VFRETE	J_1BNFFRE	WERTV8	CURR	15	2	Freight value including taxes
16	VSEG	J_1BNFINS	WERTV8	CURR	15	2	Insurance value including taxes
17	VDESC	J_1BNFDIS	WERTV8	CURR	15	2	Discount value including taxes
18	VUNCOM			DEC	15	4
19	CEANTRIB			CHAR	14	0
20	VUNTRIB			DEC	15	4
21	.INCLUDE				0	0	NF-e Block H2 / Import Declaration /Tag: DI
22	NDI			CHAR	10	0
23	DDI			DATS	8	0
24	XLOCDESEMB			CHAR	60	0
25	UFDESEMB			CHAR	2	0
26	DDESEMB			DATS	8	0
27	CEXPORTADOR			CHAR	60	0
28	.INCLUDE				0	0	NF-e Block H2 / Import Declaration Add. Data /Tag: ADI
29	NADICAO			NUMC	3	0
30	NSEQADIC			NUMC	3	0
31	CFABRICANTE			CHAR	60	0
32	VDESCDI			CURR	15	2
33	.INCLUDE				0	0	NF-e Block I / New Vehicles /Tag: veic
34	I_TPOP			NUMC	1	0
35	I_CHASSI			CHAR	17	0
36	I_COR			CHAR	4	0
37	I_XCOR			CHAR	40	0
38	I_POT			CHAR	4	0
39	I_CM3			CHAR	4	0
40	I_PESOL			CHAR	9	0
41	I_PESOB			CHAR	9	0
42	I_NSERIE			CHAR	9	0
43	I_TPCOMB			CHAR	8	0
44	I_NMOTOR			CHAR	21	0
45	I_CMKG			CHAR	9	0
46	I_DIST			CHAR	4	0
47	I_RENAVAM			CHAR	9	0
48	I_ANOMOD			NUMC	4	0
49	I_ANOFAB			NUMC	4	0
50	I_TPPINT			CHAR	1	0
51	I_TPVEIC			NUMC	2	0
52	I_ESPVEIC			CHAR	1	0
53	I_VIN			CHAR	1	0
54	I_CONDVEIC			NUMC	1	0
55	I_CMOD			CHAR	6	0
56	.INCLUDE				0	0	NF-e Block H4 / Guns / Tag: gun
57	K_TPARMA			NUMC	1	0
58	K_NSERIE			NUMC	9	0
59	K_NCANO			NUMC	9	0
60	K_DESCR			CHAR	256	0
61	.INCLUDE				0	0	NF-e Block L / Taxes /Tag: impostos
62	.INCLUDE				0	0	NF-e Block L1 / Taxes ICMS /Tag: ICMS
63	L1_ICMS			CHAR	1	0
64	.INCLUDE				0	0	NF-e Block L1_00 / Taxes ICMS /Tag: ICMS00
65	L1_00_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
66	L1_00_CST			NUMC	2	0
67	L1_00_MODBC			NUMC	1	0
68	L1_00_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
69	L1_00_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
70	L1_00_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
71	.INCLUDE				0	0	NF-e Block L1_10 / Taxes ICMS /Tag: ICMS10
72	L1_10_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
73	L1_10_CST			NUMC	2	0
74	L1_10_MODBC			NUMC	1	0
75	L1_10_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
76	L1_10_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
77	L1_10_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
78	L1_10_MODBCST			NUMC	1	0
79	L1_10_PMVAST			DEC	5	2
80	L1_10_PREDBCST			DEC	5	2
81	L1_10_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
82	L1_10_PICMSST	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
83	L1_10_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
84	.INCLUDE				0	0	NF-e Block L1_20 / Taxes ICMS /Tag: ICMS20
85	L1_20_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
86	L1_20_CST			NUMC	2	0
87	L1_20_MODBC			NUMC	1	0
88	L1_20_PREDBC			DEC	5	2
89	L1_20_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
90	L1_20_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
91	L1_20_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
92	.INCLUDE				0	0	NF-e Block L1_30 / Taxes ICMS /Tag: ICMS30
93	L1_30_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
94	L1_30_CST			NUMC	2	0
95	L1_30_MODBCST			NUMC	1	0
96	L1_30_PMVAST			DEC	5	2
97	L1_30_PREDBCST			DEC	5	2
98	L1_30_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
99	L1_30_PICMSST	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
100	L1_30_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
101	.INCLUDE				0	0	NF-e Block L1_40 / Taxes ICMS /Tag: ICMS40
102	L1_40_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
103	L1_40_CST			NUMC	2	0
104	.INCLUDE				0	0	NF-e Block L1_51 / Taxes ICMS /Tag: ICMS51
105	L1_51_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
106	L1_51_CST			NUMC	2	0
107	L1_51_MODBC			NUMC	1	0
108	L1_51_PREDBC			DEC	5	2
109	L1_51_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
110	L1_51_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
111	L1_51_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
112	.INCLUDE				0	0	NF-e Block L1_60 / Taxes ICMS /Tag: ICMS60
113	L1_60_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
114	L1_60_CST			NUMC	2	0
115	L1_60_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
116	L1_60_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
117	.INCLUDE				0	0	NF-e Block L1_70 / Taxes ICMS /Tag: ICMS70
118	L1_70_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
119	L1_70_CST			NUMC	2	0
120	L1_70_MODBC			NUMC	1	0
121	L1_70_PREDBC			DEC	5	2
122	L1_70_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
123	L1_70_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
124	L1_70_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
125	L1_70_MODBCST			NUMC	1	0
126	L1_70_PMVAST			DEC	5	2
127	L1_70_PREDBCST			DEC	5	2
128	L1_70_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
129	L1_70_PICMSST	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
130	L1_70_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
131	.INCLUDE				0	0	NF-e Block L1_90 / Taxes ICMS /Tag: ICMS90
132	L1_90_ORIG	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
133	L1_90_CST			NUMC	2	0
134	L1_90_MODBC			NUMC	1	0
135	L1_90_PREDBC			DEC	5	2
136	L1_90_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
137	L1_90_PICMS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
138	L1_90_VICMS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
139	L1_90_MODBCST			NUMC	1	0
140	L1_90_PMVAST			DEC	5	2
141	L1_90_PREDBCST			DEC	5	2
142	L1_90_VBCST	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
143	L1_90_PICMSST	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
144	L1_90_VICMSST	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
145	.INCLUDE				0	0	NF-e Block N / Taxes IPI /Tag: IPI
146	N_IPI			CHAR	1	0
147	.INCLUDE				0	0	NF-e Block N0 / Taxes IPI /Tag: IPI
148	N_CLENQ			CHAR	5	0
149	N_CNPJPROD	STCD1	STCD1	CHAR	16	0	Tax Number 1
150	N_CSELO			CHAR	60	0
151	N_QSELO			NUMC	12	0
152	N_CENQ			CHAR	3	0
153	.INCLUDE				0	0	NF-e Block N1 / Taxes IPI /Tag: IPITrip
154	N1_CST			CHAR	2	0
155	N1_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
156	N1_QUNID			DEC	15	4
157	N1_VUNID			DEC	15	4
158	N1_PIPI	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
159	N1_VIPI	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
160	.INCLUDE				0	0	NF-e Block N2 / Taxes IPI /Tag: IPINT
161	N2_CST			CHAR	2	0
162	.INCLUDE				0	0	NF-e Block O / Taxes Import /Tag: II
163	O_II			CHAR	1	0
164	O_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
165	O_VDESPADU			DEC	15	2
166	O_VII			DEC	15	2
167	O_VIOF			DEC	15	2
168	.INCLUDE				0	0	NF-e Block P / Taxes PIS /Tag: PIS
169	P_PIS			CHAR	1	0
170	.INCLUDE				0	0	NF-e Block P1/ Taxes PIS /Tag: PISAlig
171	P1_CST			NUMC	2	0
172	P1_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
173	P1_PPIS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
174	P1_VPIS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
175	.INCLUDE				0	0	NF-e Block P2 / Taxes PIS /Tag: PISQtde
176	P2_CST			NUMC	2	0
177	P2_QBCPROD			DEC	15	4
178	P2_VALIQPROD			DEC	15	4
179	P2_VPIS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
180	.INCLUDE				0	0	NF-e Block P2 / Taxes PIS /Tag: PISNT
181	P3_CST			NUMC	2	0
182	.INCLUDE				0	0	NF-e Block P4 / Taxes PIS /Tag: PISOutr
183	P4_CST			NUMC	2	0
184	P4_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
185	P4_PPIS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
186	P4_QBCPROD			DEC	15	4
187	P4_VALIQPROD			DEC	15	4
188	P4_VPIS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
189	.INCLUDE				0	0	NF-e Block P5 / Taxes PIS /Tag: PISST - Selling Zona Franca
190	P5_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
191	P5_PPIS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
192	P5_QBCPROD			DEC	15	4
193	P5_VALIQPROD			DEC	15	4
194	P5_VPIS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
195	.INCLUDE				0	0	NF-e Block Q / Taxes COFINS /Tag: COFINS
196	Q_COFINS			CHAR	1	0
197	.INCLUDE				0	0	NF-e Block Q1 / Taxes COFINS /Tag: COFINSAlig
198	Q1_CST			NUMC	2	0
199	Q1_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
200	Q1_PCOFINS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
201	Q1_VCOFINS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
202	.INCLUDE				0	0	NF-e Block Q2/ Taxes COFINS /Tag: COFINSQtde
203	Q2_CST			NUMC	2	0
204	Q2_QBCPROD			DEC	15	4
205	Q2_VALIQPROD			DEC	15	4
206	Q2_VCOFINS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
207	.INCLUDE				0	0	NF-e Block Q3 / Taxes COFINS /Tag: COFINSNT
208	Q3_CST			NUMC	2	0
209	.INCLUDE				0	0	NF-e Block Q4 / Taxes COFINS /Tag: COFINS
210	Q4_CST			NUMC	2	0
211	Q4_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
212	Q4_PCOFINS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
213	Q4_QBCPROD			DEC	15	4
214	Q4_VALIQPROD			DEC	15	4
215	Q4_VCOFINS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
216	.INCLUDE				0	0	NF-e Block Q5 / Taxes COFINS /Tag: COFINSST - SD Zona Franca
217	Q5_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
218	Q5_PCOFINS	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
219	Q5_QBCPROD			DEC	15	4
220	Q5_VALIQPROD			DEC	15	4
221	Q5_VCOFINS	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
222	.INCLUDE				0	0	NF-e Block / Taxes ISS /Tag: ISSQN
223	X_VBC	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
224	X_VALIQ	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
225	X_VISSQN	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
226	X_CMUNFG			NUMC	7	0
227	X_CLISTSERV			NUMC	4	0
228	.INCLUDE				0	0	NF-e Block R / Content of Tax laws /Tag:
229	INFADPROD			STRG	0	0