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

Field Description Data Type Length Decimals Checktable Data Element
MODBCST ICMS Sub Trib Tax Base Determination Modality CHAR 1 0 J_1B_ICST_BASE_DET
0 Tabled Price or Suggested Maximum
1 Negative List (Value)
2 Positive List (Value)
3 Neutra List (Value)
4 Added Value Margin (%)
5 Pauta (Value)
6 Operation Value
DOCNUM Document Number NUMC 10 0 J_1BDOCNUM
ITMNUM Document Item Number NUMC 6 0 J_1BITMNUM
NITEM NUMC 3 0
CPROD Material Number CHAR 40 0 MATNR
CEAN International Article Number (EAN/UPC) CHAR 18 0 EAN11
XPROD CHAR 120 0
NCM Control code for consumption taxes in foreign trade CHAR 16 0 STEUC
EXTIPI CHAR 3 0
GENERO CHAR 2 0
CFOP CFOP Code and Extension CHAR 10 0 * J_1BCFOP
UTRIB Base Unit of Measure UNIT 3 0 * MEINS
UCOM Sales unit UNIT 3 0 * VRKME
QTRIB Quantity QUAN 13 3 MENGE_D
QCOM Actual quantity delivered (in sales units) QUAN 13 3 LFIMG
VPROD Total value including all taxes CURR 15 2 J_1BNFTOT
VFRETE Freight value including taxes CURR 15 2 J_1BNFFRE
VSEG Insurance value including taxes CURR 15 2 J_1BNFINS
VDESC Discount value including taxes CURR 15 2 J_1BNFDIS
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
CBARRA Internal Barcode CHAR 30 0 J_1BNFE_CBARRA
CBARRATRIB Internal Tributary Barcode CHAR 30 0 J_1BNFE_CBARRA_TRIB
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 CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CURR 15 2 J_1BBASE
L1_00_PICMS Tax Rate DEC 6 2 J_1BTXRATE
L1_00_VICMS Tax value CURR 15 2 J_1BTAXVAL
L1_10_ORIG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CURR 15 2 J_1BBASE
L1_10_PICMS Tax Rate DEC 6 2 J_1BTXRATE
L1_10_VICMS Tax value CURR 15 2 J_1BTAXVAL
L1_10_MODBCST NUMC 1 0
L1_10_PMVAST DEC 5 2
L1_10_PREDBCST DEC 5 2
L1_10_VBCST Base amount CURR 15 2 J_1BBASE
L1_10_PICMSST Tax Rate DEC 6 2 J_1BTXRATE
L1_10_VICMSST Tax value CURR 15 2 J_1BTAXVAL
L1_20_ORIG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CURR 15 2 J_1BBASE
L1_20_PICMS Tax Rate DEC 6 2 J_1BTXRATE
L1_20_VICMS Tax value CURR 15 2 J_1BTAXVAL
L1_30_ORIG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CURR 15 2 J_1BBASE
L1_30_PICMSST Tax Rate DEC 6 2 J_1BTXRATE
L1_30_VICMSST Tax value CURR 15 2 J_1BTAXVAL
L1_40_ORIG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CURR 15 2 J_1BBASE
L1_51_PICMS Tax Rate DEC 6 2 J_1BTXRATE
L1_51_VICMS Tax value CURR 15 2 J_1BTAXVAL
L1_60_ORIG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CURR 15 2 J_1BBASE
L1_60_VICMSST Tax value CURR 15 2 J_1BTAXVAL
L1_70_ORIG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CURR 15 2 J_1BBASE
L1_70_PICMS Tax Rate DEC 6 2 J_1BTXRATE
L1_70_VICMS Tax value CURR 15 2 J_1BTAXVAL
L1_70_MODBCST NUMC 1 0
L1_70_PMVAST DEC 5 2
L1_70_PREDBCST DEC 5 2
L1_70_VBCST Base amount CURR 15 2 J_1BBASE
L1_70_PICMSST Tax Rate DEC 6 2 J_1BTXRATE
L1_70_VICMSST Tax value CURR 15 2 J_1BTAXVAL
L1_90_ORIG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CURR 15 2 J_1BBASE
L1_90_PICMS Tax Rate DEC 6 2 J_1BTXRATE
L1_90_VICMS Tax value CURR 15 2 J_1BTAXVAL
L1_90_MODBCST NUMC 1 0
L1_90_PMVAST DEC 5 2
L1_90_PREDBCST DEC 5 2
L1_90_VBCST Base amount CURR 15 2 J_1BBASE
L1_90_PICMSST Tax Rate DEC 6 2 J_1BTXRATE
L1_90_VICMSST Tax value CURR 15 2 J_1BTAXVAL
N_IPI CHAR 1 0
N_CLENQ CHAR 5 0
N_CNPJPROD Tax Number 1 CHAR 16 0 STCD1
N_CSELO CHAR 60 0
N_QSELO NUMC 12 0
N_CENQ CHAR 3 0
N1_CST CHAR 2 0
N1_VBC Base amount CURR 15 2 J_1BBASE
N1_QUNID DEC 15 4
N1_VUNID DEC 15 4
N1_PIPI Tax Rate DEC 6 2 J_1BTXRATE
N1_VIPI Tax value CURR 15 2 J_1BTAXVAL
N2_CST CHAR 2 0
O_II CHAR 1 0
O_VBC Base amount CURR 15 2 J_1BBASE
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 CURR 15 2 J_1BBASE
P1_PPIS Tax Rate DEC 6 2 J_1BTXRATE
P1_VPIS Tax value CURR 15 2 J_1BTAXVAL
P2_CST NUMC 2 0
P2_QBCPROD DEC 15 4
P2_VALIQPROD DEC 15 4
P2_VPIS Tax value CURR 15 2 J_1BTAXVAL
P3_CST NUMC 2 0
P4_CST NUMC 2 0
P4_VBC Base amount CURR 15 2 J_1BBASE
P4_PPIS Tax Rate DEC 6 2 J_1BTXRATE
P4_QBCPROD DEC 15 4
P4_VALIQPROD DEC 15 4
P4_VPIS Tax value CURR 15 2 J_1BTAXVAL
P5_VBC Base amount CURR 15 2 J_1BBASE
P5_PPIS Tax Rate DEC 6 2 J_1BTXRATE
P5_QBCPROD DEC 15 4
P5_VALIQPROD DEC 15 4
P5_VPIS Tax value CURR 15 2 J_1BTAXVAL
P5_CST NUMC 2 0
Q_COFINS CHAR 1 0
Q1_CST NUMC 2 0
Q1_VBC Base amount CURR 15 2 J_1BBASE
Q1_PCOFINS Tax Rate DEC 6 2 J_1BTXRATE
Q1_VCOFINS Tax value CURR 15 2 J_1BTAXVAL
Q2_CST NUMC 2 0
Q2_QBCPROD DEC 15 4
Q2_VALIQPROD DEC 15 4
Q2_VCOFINS Tax value CURR 15 2 J_1BTAXVAL
Q3_CST NUMC 2 0
Q4_CST NUMC 2 0
Q4_VBC Base amount CURR 15 2 J_1BBASE
Q4_PCOFINS Tax Rate DEC 6 2 J_1BTXRATE
Q4_QBCPROD DEC 15 4
Q4_VALIQPROD DEC 15 4
Q4_VCOFINS Tax value CURR 15 2 J_1BTAXVAL
Q5_VBC Base amount CURR 15 2 J_1BBASE
Q5_PCOFINS Tax Rate DEC 6 2 J_1BTXRATE
Q5_QBCPROD DEC 15 4
Q5_VALIQPROD DEC 15 4
Q5_VCOFINS Tax value CURR 15 2 J_1BTAXVAL
Q5_CST NUMC 2 0
X_VBC Base amount CURR 15 2 J_1BBASE
X_VALIQ Tax Rate DEC 6 2 J_1BTXRATE
X_VISSQN Tax value CURR 15 2 J_1BTAXVAL
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 CURR 15 2 J_1BTAXVAL
L1_40_MOTDESICMS NUMC 1 0
X_CSITTRIB CHAR 1 0
QCOM_V20 Quantity in XML Layout QUAN 15 4 J1B_NF_XML_QUANTITY
VUNCOM_V20 DEC 21 10
QTRIB_V20 Quantity in XML Layout QUAN 15 4 J1B_NF_XML_QUANTITY
VUNTRIB_V20 DEC 21 10
L1_2R_ORIG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CURR 15 2 J_1BBASE
L1_2R_PREDBC DEC 5 2
L1_2R_PICMS Tax Rate DEC 6 2 J_1BTXRATE
L1_2R_VICMS Tax value CURR 15 2 J_1BTAXVAL
L1_2R_MODBCST NUMC 1 0
L1_2R_PMVAST DEC 5 2
L1_2R_PREDBCST DEC 5 2
L1_2R_VBCST Base amount CURR 15 2 J_1BBASE
L1_2R_PICMSST Tax Rate DEC 6 2 J_1BTXRATE
L1_2R_VICMSST Tax value CURR 15 2 J_1BTAXVAL
L1_2R_PBCOP DEC 5 2
L1_2R_UFST Region (State, Province, County) CHAR 3 0 * REGIO
ORIG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CURR 15 2 J_1BBASE
VICMSSTRET Tax value CURR 15 2 J_1BTAXVAL
VBCSTDEST Base amount CURR 15 2 J_1BBASE
VICMSSTDEST Tax value CURR 15 2 J_1BTAXVAL
VTOTTRIB Total Tax Value DEC 15 2 J_1BNFE_VTOTTRIB
NFCI FCI Number CHAR 36 0 J_1BNFE_NFCI
BICO Nozzle Number NUMC 3 0 J_1B_BICO
BOMBA Fuel Pump Number NUMC 3 0 J_1B_BOMBA
TANQUE Fuel Tank Number NUMC 3 0 J_1B_TANQUE
ENCINI Start Value of Fuel Pump Gauge DEC 12 3 J_1B_ENCINI_D
ENCFIN End Value of Fuel Pump Gauge DEC 12 3 J_1B_ENCFIN_D
CEST ICMS ST Legal Classification Code CHAR 9 0 J_1BCEST
UTRIBL Tributary Unit of Measure CHAR 6 0 J_1BNFE_UTRIB
CPRODANVISA ANVISA Product Code CHAR 13 0 J_1BNFE_ANVISA_PRODUCT_CODE
VPMC Consumer Max. Price of Medicines and Pharmac. Raw Materials CURR 15 2 J_1B_CONSUMER_MAX_PRICE
PST Final Consumer Rate DEC 7 4 J_1BNFE_PST
VBCFCPSTRET FCP Calculation Basis withheld for Tributary Substitution CURR 15 2 J_1BNFE_VBCFCPSTRET
PFCPSTRET Percentage of Tributary Substitution withheld from FCP DEC 7 4 J_1BNFE_PFCPSTRET
VFCPSTRET Tributary Substitution amount withheld from FCP DEC 15 2 J_1BNFE_VFCPSTRET
INDESCALA Relevant Scale Indicator CHAR 1 0 J_1BNFE_INDESCALA
N No
S Yes
CNPJFAB Producer CNPJ NUMC 14 0 J_1BNFE_CNPJFAB
CBENEF State Fiscal Benefit Code CHAR 10 0 * J_1BNFE_CBENEF
PREDBCEFET Reduction Percentage of Effective Calculation Basis DEC 7 4 J_1BNFE_PREDBCEFET
VBCEFET Effective Calculation Basis Amount CURR 15 2 J_1BNFE_VBCEFET
PICMSEFET Effective ICMS Rate DEC 7 4 J_1BNFE_PICMSEFET
VICMSEFET Effective ICMS Amount CURR 15 2 J_1BNFE_VICMSEFET
XMOTIVOISENCAO ANVISA Exemption Reason CHAR 255 0 J_1BNFE_EXEMP_REASON
VICMSSUBSTITUTO Substitute ICMS Value Charged in Previous Transaction DEC 15 2 J_1BNFE_VICMSSUBSTITUTO
VICMSSTDESON Exemption Value of ICMS ST DEC 15 2 J_1BNFE_VICMSSTDESON
MOTDESICMSST ICMS ST Exemption Reason CHAR 2 0 J_1BNFE_MOTDESICMSST
12 Dep for Agricultural and Livestock Promotion and Development
3 Agricultural Producer
9 Others
INDSOMACOFINSST Indicator of COFINS ST in the Nota Fiscal Total CHAR 1 0 J_1BNFE_INDSOMACOFINSST
Not applicable
0 COFINS ST amount not considered in total amount of the NF-e
1 COFINS ST amount considered in total amount of the NF-e
INDSOMAPISST Indicator of PIS ST in the Nota Fiscal Total CHAR 1 0 J_1BNFE_INDSOMAPISST
Not applicable
0 PIS ST amount not considered in total amount of the NF-e
1 PIS ST amount considered in total amount of the NF-e
PFCP Tax Rate for FCP Deferral DEC 7 4 J_1BNFE_PFCPDEF
VFCP FCP Value CURR 15 2 J_1BNFE_VFCP
PFCPDIF FCP Deferral Percentage DEC 7 4 J_1BNFE_PFCPDIF
VFCPDIF Deferred FCP Value DEC 15 2 J_1BNFE_VFCPDIF
VFCPEFET Due ICMS Value Related to Fundo de Combate à Pobreza (FCP) CURR 15 2 J_1BNFE_VFCPEFET
VICMSOP Value of operation of ICMS DEC 15 2 J_1BNFE_RFC_VICMSOP
PICMSDIF Percentage of deferral DEC 7 4 J_1BNFE_RFC_PDIF
VICMSDIF Value of deferment ICMS DEC 15 2 J_1BNFE_RFC_VICMSDIF
P_MVAST Margin percentage of value Added from ICMS ST DEC 7 4 J_1BNFE_PMVAST
PICMSDEF Tax Rate for ICMS Deferral DEC 7 4 J_1BNFE_PICMSDEF