SAP Table J_1BNFLIN

Nota Fiscal line items

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table J_1BNFLIN (Nota Fiscal line items) is a standard table in SAP ERP. It belongs to the package J1BA.

Technical Information

Table J_1BNFLIN
Short Text Nota Fiscal line items
Package J1BA
Table Type Transparent Table

Fields for Table J_1BNFLIN

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
DOCNUM Document Number J_1BDOCNUM NUMC 10 J_1BNFDOC
ITMNUM Document Item Number J_1BITMNUM NUMC 6
MATNR Material Number MATNR CHAR 18 MARA
BWKEY Valuation Area BWKEY CHAR 4 T001K
BWTAR Valuation Type BWTAR_D CHAR 10 MBEW
CHARG Batch Number CHARG_D CHAR 10 MCH1
MATKL Material Group MATKL CHAR 9 T023
MAKTX Material Description (Short Text) MAKTX CHAR 40
DOCREF Reference to NF J_1BDOCREF NUMC 10 J_1BNFDOC
ITMREF Reference to item number (Return) J_1BITMREF NUMC 6
CFOP CFOP Code and Extension J_1BCFOP CHAR 10 J_1BAG
NBM Control code for consumption taxes in foreign trade STEUC CHAR 16 T604F
MATORG Origin of the material J_1BMATORG CHAR 1
TAXSIT Tax situation ICMS J_1BTAXSIT CHAR 1
TAXSI2 Tax situation IPI J_1BTAXSI2 NUMC 5 J_1BAS
OWNPRO Produced in-house J_1BOWNPRO CHAR 1
MATUSE Usage of the material J_1BMATUSE CHAR 1
REFTYP Reference type J_1BREFTYP CHAR 2 J_1BAB
REFKEY Reference to source document J_1BREFKEY CHAR 35
REFITM Reference item to source document J_1BREFITM NUMC 6
MENGE Quantity J_1BNETQTY QUAN 13
MEINS Base unit of measure J_1BNETUNT UNIT 3 T006
NETPR Net price J_1BNETPRI DEC 16
NETWR Net Value J_1BNETVAL CURR 15
TAXLW1 Tax law: ICMS J_1BTAXLW1 CHAR 3 J_1BATL1
TAXLW2 Tax law: IPI J_1BTAXLW2 CHAR 3 J_1BATL2
TMISS Service tax - no ICMS/IPI calculation J_1BTMISS CHAR 1
NETFRE Net freight value in document currency J_1BNETFRE CURR 15
NETINS Net insurance value in document currency J_1BNETINS CURR 15
NETOTH Net expenses in document currency J_1BNETOTH CURR 15
INDUS3 Material CFOP category J_1BINDUS3 CHAR 2
ITMTYP Nota Fiscal Item Type J_1BITMTYP CHAR 2 J_1BITEMTYPES
NETDIS Net discount value in document currency J_1BNETDIS CURR 15
SPCSTO Nota Fiscal Special Case for CFOP Determination J_1BSPCSTO CHAR 2
INCLTX Value and price including ICMS/ISS J_1BINCLTX CHAR 1
STATIT Indicator: Statistical item J_1BSTATIT CHAR 1
WERKS Plant WERKS_D CHAR 4 T001W
DIRECT Direction of the movement J_1BDIRECT CHAR 1
DSTCAT Destination category J_1BDSTCAT CHAR 1
INDUS2 Business Place CFOP Category J_1BINDUS2 CHAR 2
NFPRI Net Price Including Tax J_1BNFPRI DEC 16
NFNET Net Value including taxes J_1BNFNET CURR 15
NFDIS Discount value including taxes J_1BNFDIS CURR 15
NFFRE Freight value including taxes J_1BNFFRE CURR 15
NFINS Insurance value including taxes J_1BNFINS CURR 15
NFOTH Expenses including taxes J_1BNFOTH CURR 15
NETWRT Net value/Freight/Insurance/Expenses/Discount J_1BNFNETT CURR 15
NFNETT Net value/Freight/Insurance/Expenses/Discount J_1BNFNETT CURR 15
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 *
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 *
ICMSAVR Average ICMS on Stock Transfers J_1BICMSAVR CURR 15
SUBTAVR Average Substituição Tributária on Stock Transfers J_1BSUBTAVR CURR 15
LPPNET Last Purchase Price (Net) J_1BLPPNET CURR 15
LPPBRT Last Purchase Price (Gross) J_1BLPPBRT CURR 15
ICMSVALP ICMS on Last Purchase Price J_1BICMSVAL CURR 15
SUBTVALP Substituição Tributária on Last Purchase Price J_1BSUBTVAL CURR 15
TAXLW3 ISS Tax Law J_1BTAXLW3 CHAR 3 J_1BATL3
SRVNR Activity Number ASNUM CHAR 18 ASMD
TAXSI3 Tax Situation ISS J_1BTAXSI3 CHAR 2 *
TAXLW4 COFINS Tax Law J_1BTAXLW4 CHAR 3 J_1BATL4A
TAXSI4 Tax Situation COFINS J_1BTAXSI4 CHAR 2 *
TAXLW5 PIS Tax Law J_1BTAXLW5 CHAR 3 J_1BATL5
TAXSI5 Tax Situation PIS J_1BTAXSI5 CHAR 2 *
REFTYP_PREV Previously linked NF-e - type of source document J_1BREFTYP_PREV CHAR 2 *
REFKEY_PREV Previously linked NF-e - key of source document J_1BREFKEY_PREV CHAR 35
REFITM_PREV Previously linked NF-e - item of source document J_1BREFITM_PREV NUMC 6
NBS Brazilian Nomenclature Services code J_1BNBS CHAR 20 *
CEAN International Article Number (EAN/UPC) EAN11 CHAR 18
XPED Purchase Order Number J_1B_PURCH_ORDER_EXT CHAR 15
NITEMPED Purchase Order Item J_1B_PURCH_ORD_ITEM_EXT CHAR 6
MODBC ICMS Tax Base Determination Modality J_1B_ICMS_BASE_DET CHAR 1
MODBCST ICMS Sub Trib Tax Base Determination Modality J_1B_ICST_BASE_DET CHAR 1
MOTDESICMS ICMS Exemption Reason J_1B_ICMS_EXEM_REASON CHAR 1
CLENQ IPI Classification for Tobacco Products and Beverages J_1B_IPI_CLASS_TBC_BEV CHAR 5
CSELO IPI Control Seal Code J_1B_IPI_CONTR_SEAL_CODE CHAR 10
QSELO IPI Quantity of Control Seal J_1B_IPI_CONTR_SEAL_QUAN DEC 12
CENQ IPI Legal Classification Code J_1B_IPI_LEGAL_CLASS_CODE CHAR 3
NUM_ITEM External Item Number J_1B_EXT_ITEM_NUM NUMC 3
IND_MOV Physical Movement of Materials J_1B_PHYS_MOVE_MAT CHAR 1
COD_CTA G/L Account Number for Revenue/Expenses J_1B_GL_ACCOUNT CHAR 10 *
VTOTTRIB Approximate Total Tax Amount J_1BNF_VTOTTRIB CURR 15
NFCI FCI Control Number J_1BNFE_NFCI CHAR 36
KOSTL Cost Center J_1BKOSTL CHAR 10 *
AUFNR Order Number J_1BAUFNR CHAR 12 *
PRCTR Profit Centers J_1BPRCTR CHAR 10 *
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 *
KSTRG Cost Objects J_1BKSTRG CHAR 12 *
NPLNR Network Number for Account Assignment J_1BNPLNR CHAR 12 *
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 *