1. Home
  2. Resources
  3. SAP Tables
  4. J1B_NF_XML_ITEM - Nota Fiscal Eletronica / NF-e Data - Item (1:n)

SAP Table J1B_NF_XML_ITEM

Nota Fiscal Eletronica / NF-e Data - Item (1:n)

J1B_NF_XML_ITEM (Nota Fiscal Eletronica / NF-e Data - Item (1:n)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link J1B_NF_XML_ITEM to other SAP tables.

Source: J1B_NF_XML_ITEM (Nota Fiscal Eletronica / NF-e Data - Item (1:n))

J1B_NF_XML_ITEM table fields

Field Data element Checktable Datatype Length Decimals
DOCNUM Document Number J_1BDOCNUM NUMC 10 0
ITMNUM Document Item Number J_1BITMNUM NUMC 6 0
NITEM NUMC 3 0
CPROD Material Number MATNR CHAR 18 0
CEAN International Article Number (EAN/UPC) EAN11 CHAR 18 0
XPROD CHAR 120 0
NCM Control code for consumption taxes in foreign trade STEUC CHAR 16 0
EXTIPI CHAR 3 0
GENERO CHAR 2 0
CFOP CFOP Code and Extension J_1BCFOP CHAR 10 0
UTRIB Base Unit of Measure MEINS UNIT 3 0
UCOM Sales unit VRKME UNIT 3 0
QTRIB Quantity MENGE_D QUAN 13 3
QCOM Actual quantity delivered (in sales units) LFIMG QUAN 13 3
VPROD Total value including all taxes J_1BNFTOT CURR 15 2
VFRETE Freight value including taxes J_1BNFFRE CURR 15 2
VSEG Insurance value including taxes J_1BNFINS CURR 15 2
VDESC Discount value including taxes J_1BNFDIS CURR 15 2
VUNCOM DEC 15 4
CEANTRIB CHAR 14 0
VUNTRIB DEC 15 4
NDI CHAR 10 0
DDI DATS 8 0
XLOCDESEMB CHAR 60 0
UFDESEMB CHAR 2 0
DDESEMB DATS 8 0
CEXPORTADOR CHAR 60 0
NADICAO NUMC 3 0
NSEQADIC NUMC 3 0
CFABRICANTE CHAR 60 0
VDESCDI CURR 15 2
I_TPOP NUMC 1 0
I_CHASSI CHAR 17 0
I_COR CHAR 4 0
I_XCOR CHAR 40 0
I_POT CHAR 4 0
I_CM3 CHAR 4 0
I_PESOL CHAR 9 0
I_PESOB CHAR 9 0
I_NSERIE CHAR 9 0
I_TPCOMB CHAR 8 0
I_NMOTOR CHAR 21 0
I_CMKG CHAR 9 0
I_DIST CHAR 4 0
I_RENAVAM CHAR 9 0
I_ANOMOD NUMC 4 0
I_ANOFAB NUMC 4 0
I_TPPINT CHAR 1 0
I_TPVEIC NUMC 2 0
I_ESPVEIC CHAR 1 0
I_VIN CHAR 1 0
I_CONDVEIC NUMC 1 0
I_CMOD CHAR 6 0
K_TPARMA NUMC 1 0
K_NSERIE NUMC 9 0
K_NCANO NUMC 9 0
K_DESCR CHAR 256 0
L1_ICMS CHAR 1 0
L1_00_ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
L1_00_CST NUMC 2 0
L1_00_MODBC NUMC 1 0
L1_00_VBC Base amount J_1BBASE CURR 15 2
L1_00_PICMS Tax Rate J_1BTXRATE DEC 6 2
L1_00_VICMS Tax value J_1BTAXVAL CURR 15 2
L1_10_ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
L1_10_CST NUMC 2 0
L1_10_MODBC NUMC 1 0
L1_10_VBC Base amount J_1BBASE CURR 15 2
L1_10_PICMS Tax Rate J_1BTXRATE DEC 6 2
L1_10_VICMS Tax value J_1BTAXVAL CURR 15 2
L1_10_MODBCST NUMC 1 0
L1_10_PMVAST DEC 5 2
L1_10_PREDBCST DEC 5 2
L1_10_VBCST Base amount J_1BBASE CURR 15 2
L1_10_PICMSST Tax Rate J_1BTXRATE DEC 6 2
L1_10_VICMSST Tax value J_1BTAXVAL CURR 15 2
L1_20_ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
L1_20_CST NUMC 2 0
L1_20_MODBC NUMC 1 0
L1_20_PREDBC DEC 5 2
L1_20_VBC Base amount J_1BBASE CURR 15 2
L1_20_PICMS Tax Rate J_1BTXRATE DEC 6 2
L1_20_VICMS Tax value J_1BTAXVAL CURR 15 2
L1_30_ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
L1_30_CST NUMC 2 0
L1_30_MODBCST NUMC 1 0
L1_30_PMVAST DEC 5 2
L1_30_PREDBCST DEC 5 2
L1_30_VBCST Base amount J_1BBASE CURR 15 2
L1_30_PICMSST Tax Rate J_1BTXRATE DEC 6 2
L1_30_VICMSST Tax value J_1BTAXVAL CURR 15 2
L1_40_ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
L1_40_CST NUMC 2 0
L1_51_ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
L1_51_CST NUMC 2 0
L1_51_MODBC NUMC 1 0
L1_51_PREDBC DEC 5 2
L1_51_VBC Base amount J_1BBASE CURR 15 2
L1_51_PICMS Tax Rate J_1BTXRATE DEC 6 2
L1_51_VICMS Tax value J_1BTAXVAL CURR 15 2
L1_60_ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
L1_60_CST NUMC 2 0
L1_60_VBCST Base amount J_1BBASE CURR 15 2
L1_60_VICMSST Tax value J_1BTAXVAL CURR 15 2
L1_70_ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
L1_70_CST NUMC 2 0
L1_70_MODBC NUMC 1 0
L1_70_PREDBC DEC 5 2
L1_70_VBC Base amount J_1BBASE CURR 15 2
L1_70_PICMS Tax Rate J_1BTXRATE DEC 6 2
L1_70_VICMS Tax value J_1BTAXVAL CURR 15 2
L1_70_MODBCST NUMC 1 0
L1_70_PMVAST DEC 5 2
L1_70_PREDBCST DEC 5 2
L1_70_VBCST Base amount J_1BBASE CURR 15 2
L1_70_PICMSST Tax Rate J_1BTXRATE DEC 6 2
L1_70_VICMSST Tax value J_1BTAXVAL CURR 15 2
L1_90_ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
L1_90_CST NUMC 2 0
L1_90_MODBC NUMC 1 0
L1_90_PREDBC DEC 5 2
L1_90_VBC Base amount J_1BBASE CURR 15 2
L1_90_PICMS Tax Rate J_1BTXRATE DEC 6 2
L1_90_VICMS Tax value J_1BTAXVAL CURR 15 2
L1_90_MODBCST NUMC 1 0
L1_90_PMVAST DEC 5 2
L1_90_PREDBCST DEC 5 2
L1_90_VBCST Base amount J_1BBASE CURR 15 2
L1_90_PICMSST Tax Rate J_1BTXRATE DEC 6 2
L1_90_VICMSST Tax value J_1BTAXVAL CURR 15 2
N_IPI CHAR 1 0
N_CLENQ CHAR 5 0
N_CNPJPROD Tax Number 1 STCD1 CHAR 16 0
N_CSELO CHAR 60 0
N_QSELO NUMC 12 0
N_CENQ CHAR 3 0
N1_CST CHAR 2 0
N1_VBC Base amount J_1BBASE CURR 15 2
N1_QUNID DEC 15 4
N1_VUNID DEC 15 4
N1_PIPI Tax Rate J_1BTXRATE DEC 6 2
N1_VIPI Tax value J_1BTAXVAL CURR 15 2
N2_CST CHAR 2 0
O_II CHAR 1 0
O_VBC Base amount J_1BBASE CURR 15 2
O_VDESPADU DEC 15 2
O_VII DEC 15 2
O_VIOF DEC 15 2
P_PIS CHAR 1 0
P1_CST NUMC 2 0
P1_VBC Base amount J_1BBASE CURR 15 2
P1_PPIS Tax Rate J_1BTXRATE DEC 6 2
P1_VPIS Tax value J_1BTAXVAL CURR 15 2
P2_CST NUMC 2 0
P2_QBCPROD DEC 15 4
P2_VALIQPROD DEC 15 4
P2_VPIS Tax value J_1BTAXVAL CURR 15 2
P3_CST NUMC 2 0
P4_CST NUMC 2 0
P4_VBC Base amount J_1BBASE CURR 15 2
P4_PPIS Tax Rate J_1BTXRATE DEC 6 2
P4_QBCPROD DEC 15 4
P4_VALIQPROD DEC 15 4
P4_VPIS Tax value J_1BTAXVAL CURR 15 2
P5_VBC Base amount J_1BBASE CURR 15 2
P5_PPIS Tax Rate J_1BTXRATE DEC 6 2
P5_QBCPROD DEC 15 4
P5_VALIQPROD DEC 15 4
P5_VPIS Tax value J_1BTAXVAL CURR 15 2
Q_COFINS CHAR 1 0
Q1_CST NUMC 2 0
Q1_VBC Base amount J_1BBASE CURR 15 2
Q1_PCOFINS Tax Rate J_1BTXRATE DEC 6 2
Q1_VCOFINS Tax value J_1BTAXVAL CURR 15 2
Q2_CST NUMC 2 0
Q2_QBCPROD DEC 15 4
Q2_VALIQPROD DEC 15 4
Q2_VCOFINS Tax value J_1BTAXVAL CURR 15 2
Q3_CST NUMC 2 0
Q4_CST NUMC 2 0
Q4_VBC Base amount J_1BBASE CURR 15 2
Q4_PCOFINS Tax Rate J_1BTXRATE DEC 6 2
Q4_QBCPROD DEC 15 4
Q4_VALIQPROD DEC 15 4
Q4_VCOFINS Tax value J_1BTAXVAL CURR 15 2
Q5_VBC Base amount J_1BBASE CURR 15 2
Q5_PCOFINS Tax Rate J_1BTXRATE DEC 6 2
Q5_QBCPROD DEC 15 4
Q5_VALIQPROD DEC 15 4
Q5_VCOFINS Tax value J_1BTAXVAL CURR 15 2
X_VBC Base amount J_1BBASE CURR 15 2
X_VALIQ Tax Rate J_1BTXRATE DEC 6 2
X_VISSQN Tax value J_1BTAXVAL CURR 15 2
X_CMUNFG NUMC 7 0
X_CLISTSERV NUMC 4 0
INFADPROD STRG 0 0
OIL_CPRODANP NUMC 9 0
OIL_CODIF NUMC 21 0
OIL_GTEMP DEC 16 4
OIL_QBCPROD DEC 12 4
OIL_VALIGPROD DEC 11 4
OIL_VCIDE DEC 13 2
OIL_VBCICMS DEC 13 2
OIL_VICMS DEC 13 2
OIL_VBCICMSST DEC 13 2
OIL_VCICMSST DEC 13 2
OIL_VBCICMSSTDEST DEC 13 2
OIL_VICMSSTDEST DEC 13 2
OIL_VBCICMSSTCONS DEC 13 2
OIL_VICMSSTCONS DEC 13 2
OIL_UFCONS CHAR 2 0
H1_VOUTRO DEC 15 2
INDTOT NUMC 1 0
XPED CHAR 15 0
NITEMPED NUMC 6 0
CCORDEN NUMC 2 0
LOTA NUMC 3 0
TPREST NUMC 1 0
L1_40_VICMS Tax value J_1BTAXVAL CURR 15 2
L1_40_MOTDESICMS NUMC 1 0
X_CSITTRIB CHAR 1 0
QCOM_V20 Quantity in XML Layout J1B_NF_XML_QUANTITY QUAN 15 4
VUNCOM_V20 DEC 21 10
QTRIB_V20 Quantity in XML Layout J1B_NF_XML_QUANTITY QUAN 15 4
VUNTRIB_V20 DEC 21 10
L1_2R_ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
L1_2R_CST NUMC 2 0
L1_2R_MODBC NUMC 1 0
L1_2R_VBC Base amount J_1BBASE CURR 15 2
L1_2R_PREDBC DEC 5 2
L1_2R_PICMS Tax Rate J_1BTXRATE DEC 6 2
L1_2R_VICMS Tax value J_1BTAXVAL CURR 15 2
L1_2R_MODBCST NUMC 1 0
L1_2R_PMVAST DEC 5 2
L1_2R_PREDBCST DEC 5 2
L1_2R_VBCST Base amount J_1BBASE CURR 15 2
L1_2R_PICMSST Tax Rate J_1BTXRATE DEC 6 2
L1_2R_VICMSST Tax value J_1BTAXVAL CURR 15 2
L1_2R_PBCOP DEC 5 2
L1_2R_UFST Region (State, Province, County) REGIO CHAR 3 0
ORIG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
CST NUMC 2 0
VBCSTRET Base amount J_1BBASE CURR 15 2
VICMSSTRET Tax value J_1BTAXVAL CURR 15 2
VBCSTDEST Base amount J_1BBASE CURR 15 2
VICMSSTDEST Tax value J_1BTAXVAL CURR 15 2
VTOTTRIB Total Tax Value J_1BNFE_VTOTTRIB DEC 15 2
NFCI FCI Control Number J_1BNFE_NFCI CHAR 36 0