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

Dictionary Type: Structure
Description: Nota Fiscal Eletronica / NF-e Data - Item (1:n)




ABAP Code to SELECT data from J1B_NF_XML_ITEM
Related tables to J1B_NF_XML_ITEM
Access table J1B_NF_XML_ITEM




Structure field list including key, data, relationships and ABAP select examples

J1B_NF_XML_ITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Nota Fiscal Eletronica / NF-e Data - Item (1:n)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_J1B_NF_XML_ITEM TYPE J1B_NF_XML_ITEM.

The J1B_NF_XML_ITEM table consists of various fields, each holding specific information or linking keys about Nota Fiscal Eletronica / NF-e Data - Item (1:n) data available in SAP. These include ITMNUM (Document Item Number), NITEM (Number of items), CPROD (Material Number), CEAN (International Article Number (EAN/UPC)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP J1B_NF_XML_ITEM structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
DOCNUMDocument Number J_1BDOCNUMNUMC10Assigned to domainJ_1BDOCNUMJEF
ITMNUMDocument Item Number J_1BITMNUMNUMC6J_1BITMNUMJ_1BITMNUM
NITEM Number of items0
CPRODMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
CEANInternational Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
XPROD Material Text0
NCMControl code for consumption taxes in foreign trade STEUCCHAR16Assigned to domainSTEUC
EXTIPI EXTIPI0
GENERO Firtst 2 digits of NCM code0
CFOPCFOP Code and Extension J_1BCFOPCHAR10Assigned to domainCFOBRJ_1BCFOP
UTRIBBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
UCOMSales unit VRKMEUNIT3Assigned to domainCUNITMEINS
QTRIBQuantity MENGE_DQUAN13(3) MENG13
QCOMActual quantity delivered (in sales units) LFIMGQUAN13(3) MENG13
VPRODTotal value including all taxes J_1BNFTOTCURR15(2) WERTV8
VFRETEFreight value including taxes J_1BNFFRECURR15(2) WERTV8
VSEGInsurance value including taxes J_1BNFINSCURR15(2) WERTV8
VDESCDiscount value including taxes J_1BNFDISCURR15(2) WERTV8
VUNCOM Commercial Unit Value0
CEANTRIB Global Trade Item Number0
VUNTRIB Taxation Unit Value0
NDI Import declaration number DI/DSI/DA0
DDI Registration date of the DI/DSI/DA0
XLOCDESEMB Location where goods are released0
UFDESEMB Region where the goods have been released0
DDESEMB Date when goods have been released0
CEXPORTADOR Code of the Export Company0
NADICAO Number of the addition0
NSEQADIC Sequential number of the item in the addition0
CFABRICANTE Code of the foreign producer in the system0
VDESCDI Discount value of the DI item - addition0
I_TPOP Type of Operation0
I_CHASSI Vehicle Chassis0
I_COR Code for Each Assembly Plant0
I_XCOR Color Description0
I_POT Engine Power0
I_CM3 CM3 (Power)0
I_PESOL Net Weight0
I_PESOB Gross Weight0
I_NSERIE Serial (série)0
I_TPCOMB Type of Fuel0
I_NMOTOR Engine Number0
I_CMKG CMKG0
I_DIST Distance Between Axles0
I_RENAVAM RENAVAM0
I_ANOMOD Year of Manufacturing Model0
I_ANOFAB Production Year0
I_TPPINT Type of Painting0
I_TPVEIC Type of Vehicle0
I_ESPVEIC Sort of Vehicle0
I_VIN Condition of VIN0
I_CONDVEIC Condition of the Vehicle0
I_CMOD Code Brand Model0
K_TPARMA Indicator of Firearm Type0
K_NSERIE Gun Serial number0
K_NCANO Barrel Serial Number0
K_DESCR Full Description of the Gun0
L1_ICMS Tag ICMS0
L1_00_ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
L1_00_CST Tax situation0
L1_00_MODBC Base Determination rule0
L1_00_VBCBase amount J_1BBASECURR15(2) J_1BBASE
L1_00_PICMSTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_00_VICMSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_10_ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
L1_10_CST Tax situation0
L1_10_MODBC Base Determination rule ICMS0
L1_10_VBCBase amount J_1BBASECURR15(2) J_1BBASE
L1_10_PICMSTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_10_VICMSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_10_MODBCST Base Determination rule ICMSST0
L1_10_PMVAST Surcharge rate0
L1_10_PREDBCST Base reduction rate0
L1_10_VBCSTBase amount J_1BBASECURR15(2) J_1BBASE
L1_10_PICMSSTTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_10_VICMSSTTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_20_ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
L1_20_CST Tax situation0
L1_20_MODBC Base Determination rule0
L1_20_PREDBC Base reduction rate0
L1_20_VBCBase amount J_1BBASECURR15(2) J_1BBASE
L1_20_PICMSTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_20_VICMSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_30_ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
L1_30_CST Tax situation0
L1_30_MODBCST Base Determination rule0
L1_30_PMVAST Surcharge rate0
L1_30_PREDBCST Base reduction rate0
L1_30_VBCSTBase amount J_1BBASECURR15(2) J_1BBASE
L1_30_PICMSSTTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_30_VICMSSTTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_40_ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
L1_40_CST Tax situation0
L1_51_ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
L1_51_CST Tax situation0
L1_51_MODBC Base Determination rule0
L1_51_PREDBC Base reduction rate0
L1_51_VBCBase amount J_1BBASECURR15(2) J_1BBASE
L1_51_PICMSTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_51_VICMSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_60_ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
L1_60_CST Tax situation0
L1_60_VBCSTBase amount J_1BBASECURR15(2) J_1BBASE
L1_60_VICMSSTTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_70_ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
L1_70_CST Tax situation0
L1_70_MODBC Base Determination rule ICMS0
L1_70_PREDBC Base reduction rate0
L1_70_VBCBase amount J_1BBASECURR15(2) J_1BBASE
L1_70_PICMSTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_70_VICMSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_70_MODBCST Base Determination rule ICMSST0
L1_70_PMVAST Surcharge rate0
L1_70_PREDBCST Base reduction rate0
L1_70_VBCSTBase amount J_1BBASECURR15(2) J_1BBASE
L1_70_PICMSSTTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_70_VICMSSTTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_90_ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
L1_90_CST Tax situation0
L1_90_MODBC Base Determination rule ICMS0
L1_90_PREDBC Base reduction rate0
L1_90_VBCBase amount J_1BBASECURR15(2) J_1BBASE
L1_90_PICMSTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_90_VICMSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_90_MODBCST Base Determination rule ICMSST0
L1_90_PMVAST Surcharge rate0
L1_90_PREDBCST Base reduction rate0
L1_90_VBCSTBase amount J_1BBASECURR15(2) J_1BBASE
L1_90_PICMSSTTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_90_VICMSSTTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
N_IPI 0
N_CLENQ IPI class0
N_CNPJPRODTax Number 1 STCD1CHAR16STCD1
N_CSELO IPI control code from selo0
N_QSELO Quantity from selo control0
N_CENQ Enquadramento code0
N1_CST Subtrib code for IPI0
N1_VBCBase amount J_1BBASECURR15(2) J_1BBASE
N1_QUNID Pauta quantity0
N1_VUNID Pauta unit value0
N1_PIPITax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
N1_VIPITax value J_1BTAXVALCURR15(2) J_1BTAXVAL
N2_CST Subtrib code for IPI0
O_II Tag II0
O_VBCBase amount J_1BBASECURR15(2) J_1BBASE
O_VDESPADU Customs Expenses Amount0
O_VII Import Tax Amount0
O_VIOF Tax on Financial Operations Amount0
P_PIS Tag PIS0
P1_CST Subtrib code for PIS0
P1_VBCBase amount J_1BBASECURR15(2) J_1BBASE
P1_PPISTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
P1_VPISTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
P2_CST Subtrib code for PIS0
P2_QBCPROD Sold quantity0
P2_VALIQPROD Pis rate in reais0
P2_VPISTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
P3_CST Subtrib code for PIS0
P4_CST Subtrib code for PIS0
P4_VBCBase amount J_1BBASECURR15(2) J_1BBASE
P4_PPISTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
P4_QBCPROD Sold quantity0
P4_VALIQPROD Pis rate in reais0
P4_VPISTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
P5_VBCBase amount J_1BBASECURR15(2) J_1BBASE
P5_PPISTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
P5_QBCPROD Sold quantity0
P5_VALIQPROD Pis rate in reais0
P5_VPISTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
Q_COFINS Tag Cofins0
Q1_CST Subtrib code for COFINS0
Q1_VBCBase amount J_1BBASECURR15(2) J_1BBASE
Q1_PCOFINSTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
Q1_VCOFINSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
Q2_CST Subtrib code for COFINS0
Q2_QBCPROD Sold quantity0
Q2_VALIQPROD COFINS rate in reais0
Q2_VCOFINSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
Q3_CST Subtrib code for COFINS0
Q4_CST Subtrib code for COFINS0
Q4_VBCBase amount J_1BBASECURR15(2) J_1BBASE
Q4_PCOFINSTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
Q4_QBCPROD Sold quantity0
Q4_VALIQPROD COFINS rate in reais0
Q4_VCOFINSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
Q5_VBCBase amount J_1BBASECURR15(2) J_1BBASE
Q5_PCOFINSTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
Q5_QBCPROD Sold quantity0
Q5_VALIQPROD COFINS rate in reais0
Q5_VCOFINSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
X_VBCBase amount J_1BBASECURR15(2) J_1BBASE
X_VALIQTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
X_VISSQNTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
X_CMUNFG Municipio Code0
X_CLISTSERV ISS service type code according to law LC 116/030
INFADPROD 0
OIL_CPRODANP Product Code0
OIL_CODIF Registration/Authorization Code0
OIL_GTEMP Quantity of fuel at Room temperature0
OIL_QBCPROD CIDE Calculation Base0
OIL_VALIGPROD Invoiced at Room temperature0
OIL_VCIDE CIDE Value0
OIL_VBCICMS ICMS Base0
OIL_VICMS ICMS Value0
OIL_VBCICMSST Subtrib. Base0
OIL_VCICMSST Subtrib. Value0
OIL_VBCICMSSTDEST Subtrib. Base Destination0
OIL_VICMSSTDEST Subtrib. value Destination0
OIL_VBCICMSSTCONS Subtrib. Base Consumption0
OIL_VICMSSTCONS Subtrib. value Consumption0
OIL_UFCONS Region of the consumption0
H1_VOUTRO Other accessory costs0
INDTOT Indic. of whether item value is accounted in the NF-e total0
XPED Purchase Order number0
NITEMPED Purchase Order item number0
CCORDEN Color code0
LOTA Maximum capacity0
TPREST Restriction0
L1_40_VICMSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_40_MOTDESICMS ICMS exemption reason0
X_CSITTRIB ISSQN taxation code0
QCOM_V20Quantity in XML Layout J1B_NF_XML_QUANTITYQUAN15(4)
VUNCOM_V20 Comercialized Unitary Value0
QTRIB_V20Quantity in XML Layout J1B_NF_XML_QUANTITYQUAN15(4)
VUNTRIB_V20 Taxable Unitary Value0
L1_2R_ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
L1_2R_CST Tax situation0
L1_2R_MODBC Base Determination rule ICMS0
L1_2R_VBCBase amount J_1BBASECURR15(2) J_1BBASE
L1_2R_PREDBC Base reduction rate0
L1_2R_PICMSTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_2R_VICMSTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_2R_MODBCST Base Determination rule ICMSST0
L1_2R_PMVAST Surcharge rate0
L1_2R_PREDBCST Base reduction rate0
L1_2R_VBCSTBase amount J_1BBASECURR15(2) J_1BBASE
L1_2R_PICMSSTTax Rate J_1BTXRATEDEC6(2) J_1BTXRATE
L1_2R_VICMSSTTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
L1_2R_PBCOP Own operation tax base0
L1_2R_UFSTSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
ORIGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
CST Tax situation0
VBCSTRETBase amount J_1BBASECURR15(2) J_1BBASE
VICMSSTRETTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
VBCSTDESTBase amount J_1BBASECURR15(2) J_1BBASE
VICMSSTDESTTax value J_1BTAXVALCURR15(2) J_1BTAXVAL
VTOTTRIBTotal Tax Value J_1BNFE_VTOTTRIBDEC15(2)
NFCIFCI Control Number J_1BNFE_NFCICHAR36

Key field Non-key field



How do I retrieve data from SAP structure J1B_NF_XML_ITEM using ABAP code?

As J1B_NF_XML_ITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on J1B_NF_XML_ITEM as there is no data to select.

How to access SAP table J1B_NF_XML_ITEM

Within an ECC or HANA version of SAP you can also view further information about J1B_NF_XML_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!