J_1BNFLIN - Nota Fiscal line items

Nota Fiscal line items information is stored in SAP table J_1BNFLIN.
It is part of development package J1BA in software component FI-LOC-LO-BR. This development package consists of objects that can be grouped under "Localization Brazil".

Fields for table J_1BNFLIN

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
DOCNUM	Document Number	X	J_1BDOCNUM	NUMC	20	J_1BNFDOC
ITMNUM	Document Item Number	X	J_1BITMNUM	NUMC	12
MATNR	Material Number		MATNR	CHAR	80	MARA
BWKEY	Valuation area		BWKEY	CHAR	8	T001K
BWTAR	Valuation Type		BWTAR_D	CHAR	20	MBEW
CHARG	Batch Number		CHARG_D	CHAR	20	MCH1
MATKL	Material Group		MATKL	CHAR	18	T023
MAKTX	Material Description		MAKTX	CHAR	80
DOCREF	Reference to NF		J_1BDOCREF	NUMC	20	J_1BNFDOC
ITMREF	Reference to item number (Return)		J_1BITMREF	NUMC	12
CFOP	CFOP Code and Extension		J_1BCFOP	CHAR	20	J_1BAGN
NBM	Control code for consumption taxes in foreign trade		STEUC	CHAR	32	T604F
MATORG	Origin of the material		J_1BMATORG	CHAR	2
TAXSIT	Tax situation ICMS		J_1BTAXSIT	CHAR	2
TAXSI2	Tax situation IPI		J_1BTAXSI2	NUMC	10	J_1BAS
OWNPRO	Produced in-house		J_1BOWNPRO	CHAR	2
MATUSE	Usage of the material		J_1BMATUSE	CHAR	2
REFTYP	Reference type		J_1BREFTYP	CHAR	4	J_1BAB
REFKEY	Reference to source document		J_1BREFKEY	CHAR	70
REFITM	Reference item to source document		J_1BREFITM	NUMC	12
MENGE	Quantity		J_1BNETQTY	QUAN	7
MEINS	Base unit of measure		J_1BNETUNT	UNIT	6	T006
NETPR	Net price		J_1BNETPRI	DEC	9
NETWR	Net Value		J_1BNETVAL	CURR	8
TAXLW1	Tax law: ICMS		J_1BTAXLW1	CHAR	6	J_1BATL1
TAXLW2	Tax law: IPI		J_1BTAXLW2	CHAR	6	J_1BATL2
TMISS	Service tax - no ICMS/IPI calculation		J_1BTMISS	CHAR	2
NETFRE	Net freight value in document currency		J_1BNETFRE	CURR	8
NETINS	Net insurance value in document currency		J_1BNETINS	CURR	8
NETOTH	Net expenses in document currency		J_1BNETOTH	CURR	8
INDUS3	Material CFOP category		J_1BINDUS3	CHAR	4
ITMTYP	Nota Fiscal Item Type		J_1BITMTYP	CHAR	4	J_1BITEMTYPES
NETDIS	Net discount value in document currency		J_1BNETDIS	CURR	8
SPCSTO	Nota Fiscal Special Case for CFOP Determination		J_1BSPCSTO	CHAR	4
INCLTX	Value and price including ICMS/ISS		J_1BINCLTX	CHAR	2
STATIT	Indicator: Statistical item		J_1BSTATIT	CHAR	2
WERKS	Plant		WERKS_D	CHAR	8	T001W
DIRECT	Direction of the movement		J_1BDIRECT	CHAR	2
DSTCAT	Destination category		J_1BDSTCAT	CHAR	2
INDUS2	Business Place CFOP Category		J_1BINDUS2	CHAR	4
NFPRI	Net Price Including Tax		J_1BNFPRI	DEC	9
NFNET	Net Value including taxes		J_1BNFNET	CURR	8
NFDIS	Discount value including taxes		J_1BNFDIS	CURR	8
NFFRE	Freight value including taxes		J_1BNFFRE	CURR	8
NFINS	Insurance value including taxes		J_1BNFINS	CURR	8
NFOTH	Expenses including taxes		J_1BNFOTH	CURR	8
NETWRT	Net value/Freight/Insurance/Expenses/Discount		J_1BNFNETT	CURR	8
NFNETT	Net value/Freight/Insurance/Expenses/Discount		J_1BNFNETT	CURR	8
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4
KALSM	Procedure (Pricing, Output Control, Acct. Det., Costing,...)		KALSM_D	CHAR	12
ICMSAVR	Average ICMS on Stock Transfers		J_1BICMSAVR	CURR	8
SUBTAVR	Average Substitui��o Tribut�ria on Stock Transfers		J_1BSUBTAVR	CURR	8
LPPNET	Last Purchase Price (Net)		J_1BLPPNET	CURR	8
LPPBRT	Last Purchase Price (Gross)		J_1BLPPBRT	CURR	8
ICMSVALP	ICMS on Last Purchase Price		J_1BICMSVAL	CURR	8
SUBTVALP	Substitui��o Tribut�ria on Last Purchase Price		J_1BSUBTVAL	CURR	8
TAXLW3	ISS Tax Law		J_1BTAXLW3	CHAR	6	J_1BATL3
SRVNR	Activity Number		ASNUM	CHAR	36	ASMD
.INCLUDE				J_1BPISCOFISS	0
TAXSI3	Tax Situation ISS		J_1BTAXSI3	CHAR	4	*
TAXLW4	COFINS Tax Law		J_1BTAXLW4	CHAR	6	J_1BATL4A
TAXSI4	Tax Situation COFINS		J_1BTAXSI4	CHAR	4	*
TAXLW5	PIS Tax Law		J_1BTAXLW5	CHAR	6	J_1BATL5
TAXSI5	Tax Situation PIS		J_1BTAXSI5	CHAR	4	*
REFTYP_PREV	Previously linked NF-e - type of source document		J_1BREFTYP_PREV	CHAR	4
REFKEY_PREV	Previously linked NF-e - key of source document		J_1BREFKEY_PREV	CHAR	70
REFITM_PREV	Previously linked NF-e - item of source document		J_1BREFITM_PREV	NUMC	12
NBS	Brazilian Nomenclature Services code		J_1BNBS	CHAR	40
.INCLUDE				J_1BNFLIN_ADD	0
CEAN	International Article Number (EAN/UPC)		EAN11	CHAR	36
XPED	Purchase Order Number		J_1B_PURCH_ORDER_EXT	CHAR	30
NITEMPED	Purchase Order Item		J_1B_PURCH_ORD_ITEM_EXT	CHAR	12
MODBC	ICMS Tax Base Determination Modality		J_1B_ICMS_BASE_DET	CHAR	2
MODBCST	ICMS Sub Trib Tax Base Determination Modality		J_1B_ICST_BASE_DET	CHAR	2
MOTDESICMS	ICMS Exemption Reason		J_1B_ICMS_EXEM_REASON	CHAR	4
CLENQ	IPI Classification for Tobacco Products and Beverages		J_1B_IPI_CLASS_TBC_BEV	CHAR	10
CSELO	IPI Control Seal Code		J_1B_IPI_CONTR_SEAL_CODE	CHAR	20
QSELO	IPI Quantity of Control Seal		J_1B_IPI_CONTR_SEAL_QUAN	DEC	7
CENQ	IPI Legal Classification Code		J_1B_IPI_LEGAL_CLASS_CODE	CHAR	6	J_1BTCENQ
NUM_ITEM	External Item Number		J_1B_EXT_ITEM_NUM	NUMC	6
IND_MOV	Physical Movement of Materials		J_1B_PHYS_MOVE_MAT	CHAR	2
COD_CTA	G/L Account Number for Revenue/Expenses		J_1B_GL_ACCOUNT	CHAR	20	*
NRECOPI	RECOPI Number		J_1BNFE_NRECOPI	CHAR	40
INDINCENTIVO	Tax Incentive		J_1BNFE_INDINCENTIVO	NUMC	2
VICMSDESON	Exemption value of ICMS		J_1BNFE_VICMSDESON	DEC	8
NFICMSDESON	Exemption Value of ICMS Including Taxes		J_1BNFE_NFICMSDESON	DEC	8
VICMSDIF	Value of deferment ICMS		J_1BNFE_RFC_VICMSDIF	DEC	8
VICMSSTRET	Wth. ICMS ST Value already charged		J_1BNFE_RFC_ICMSSTRETTAXVAL	CURR	8
VBCSTRET	WTH. ICMS ST Base already charged		J_1BNFE_RFC_ICMSSTRETBASE	CURR	8
MEINS_TRIB	Tributary Unit of Measure		J_1B_UNTTRB	UNIT	6	*
MENGE_TRIB	Tributary Quantity of Material		J_1B_QTDTRB	DEC	8
CEST	ICMS ST Legal Classification Code		J_1BCEST	CHAR	18	J_1BTCEST
VDESPADU	Customs Expense Value		J_1BNFE_VDESPADU	DEC	8
VIOF	IOF Value		J_1BNFE_VIOF	DEC	8
CEAN_TRIB	Tributary International Article Number (EAN/UPC)		J_1B_EAN_TRIB	CHAR	36
UTRIB	Tributary Unit of Measure		J_1BNFE_UTRIB	CHAR	12
PST	Final Consumer Rate		J_1BNFE_PST	DEC	4
VBCFCPSTRET	FCP Calculation Basis withheld for Tributary Substitution		J_1BNFE_VBCFCPSTRET	CURR	8
PFCPSTRET	Percentage of Tributary Substitution withheld from FCP		J_1BNFE_PFCPSTRET	DEC	4
VFCPSTRET	Tributary Substitution amount withheld from FCP		J_1BNFE_VFCPSTRET	DEC	8
VBCSTDEST	ICMS ST Calculation Basis from UF Destination		J_1BNFE_VBCSTDEST	CURR	8
VICMSSTDEST	ICMS ST Value from UF Destination		J_1BNFE_VICMSSTDEST	CURR	8
INDESCALA	Relevant Scale Indicator		J_1BNFE_INDESCALA	CHAR	2
CNPJFAB	Producer CNPJ		J_1BNFE_CNPJFAB	NUMC	28
CBENEF	State Fiscal Benefit Code		J_1BNFE_CBENEF	CHAR	20	J_1BNFE_CB_ICMS
PREDBCEFET	Reduction Percentage of Effective Calculation Basis		J_1BNFE_PREDBCEFET	DEC	4
VBCEFET	Effective Calculation Basis Amount		J_1BNFE_VBCEFET	CURR	8
PICMSEFET	Effective ICMS Rate		J_1BNFE_PICMSEFET	DEC	4
VICMSEFET	Effective ICMS Amount		J_1BNFE_VICMSEFET	CURR	8
VOUTRO	Statistical Amount		J_1BNFE_VOUTRO	DEC	8
XPROD	Product or Service Description		J_1BNFE_XPROD	CHAR	240
TAX_INFO_SOURCE	Source of Tax Burden		J_1BNFSE_TAX_INFO_SOURCE	CHAR	20
TAX_RATE	Percentage of Tax Burden		J_1BNFSE_TAX_RATE	DEC	4
VICMSSUBSTITUTO	Substitute ICMS Value Charged in Previous Transaction		J_1BNFE_VICMSSUBSTITUTO	DEC	8
MUNICIPAL_ISS_TAXSIT	CST for ISS Defined by Municipality		LOGBR_MUNICIPAL_ISS_TAXSIT	CHAR	6	*
CPRB	CPRB Relevance		LOGBR_CPRB	CHAR	2
REINF_SERVICE_CODE	EFD-REINF Service Type Code		LOGBR_REINF_CODE	CHAR	18	LOGBR_REINF
LC116_SERVICE_CODE	LC 116 Service Type Code		LOGBR_ABRASF_CODE	CHAR	10	LOGBR_ABRASF
COD_CTA_PIS	G/L Account Number for Revenue/Expenses for PIS		J_1BNFE_COD_CTA_PIS	CHAR	20	*
COD_CTA_COFINS	G/L Account Number for Revenue/Expenses for COFINS		J_1BNFE_COD_CTA_COFINS	CHAR	20	*
CBENEF_ISS	Benefit Code for ISS Tax		J_1BNFE_CBENEF_ISS	CHAR	20	J_1BNFSE_CBENEF
STSTCL_VICMSDESON	Statistical Exemption Value of ICMS		J_1BNFE_STSTCL_VICMSDESON	DEC	8
P_MVAST	Margin percentage of value Added from ICMS ST		J_1BNFE_PMVAST	DEC	4
PICMSDEF	Tax Rate for ICMS Deferral		J_1BNFE_PICMSDEF	DEC	4
ITEM_CNAE_PARTNER	CNAE Code for Partner		LOGBR_ITEM_CNAE_PARTNER	CHAR	14	J_1BTCNAE
ITEM_CNAE_BUPLA	CNAE Business Place Code		LOGBR_ITEM_CNAE_BUPLA	CHAR	14	J_1BTCNAE
IND_NAT_FRT	Freight Nature Indicator		LOGBR_IND_NAT_FRT	CHAR	2
CBARRA	Internal Barcode		J_1BNFE_CBARRA	CHAR	60
CBARRA_TRIB	Internal Tributary Barcode		J_1BNFE_CBARRA_TRIB	CHAR	60
VICMSSTDESON	Exemption Value of ICMS ST		J_1BNFE_VICMSSTDESON	DEC	8
MOTDESICMSST	ICMS ST Exemption Reason		J_1BNFE_MOTDESICMSST	CHAR	4
PDIF	ICMS Deferral Percentage		J_1BNFE_PDIF	DEC	4
VFCPDIF	Deferred FCP Value		J_1BNFE_VFCPDIF	DEC	8
PFCPDEF	Tax Rate for FCP Deferral		J_1BNFE_PFCPDEF	DEC	4
PFCPDIF	FCP Deferral Percentage		J_1BNFE_PFCPDIF	DEC	4
COFINSST	COFINS ST Value		J_1BNFE_COFINSST	CURR	8
PISST	PIS ST Value		J_1BNFE_PISST	CURR	8
INDSOMACOFINSST	Indicator of COFINS ST in the Nota Fiscal Total		J_1BNFE_INDSOMACOFINSST	CHAR	2
INDSOMAPISST	Indicator of PIS ST in the Nota Fiscal Total		J_1BNFE_INDSOMAPISST	CHAR	2
NFCOFINSST	COFINS ST Value Including Taxes		J_1BNFE_NFCOFINSST	CURR	8
NFPISST	PIS ST Value Including Taxes		J_1BNFE_NFPISST	CURR	8
EXCLUDED_ICMS_FROM_PISCOFINS	ICMS Amount Excluded from the PIS/COFINS Calculation Base		J_1BNFE_EXC_ICMS_PISCOF	DEC	8
VTOTTRIB	Approximate Total Tax Amount		J_1BNF_VTOTTRIB	CURR	8
NFCI	FCI Number		J_1BNFE_NFCI	CHAR	72
.INCLUDE	J_1B_S_J1BNFLIN_ACC			J_1B_S_J1BNFLIN_ACC	0
KOSTL	Cost Center		J_1BKOSTL	CHAR	20	*
AUFNR	Order Number		J_1BAUFNR	CHAR	24	*
PRCTR	Profit Centers		J_1BPRCTR	CHAR	20
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	*
KSTRG	Cost Objects		J_1BKSTRG	CHAR	24	*
NPLNR	Network Number for Account Assignment		J_1BNPLNR	CHAR	24	*
SEGMENT	Segment for Segmental Reporting		FB_SEGMENT	CHAR	20	*
PIPIDEVOL	Quantity Returned (%)		J_1BNFE_PRET	DEC	3
NPROCESSO	Judicial or Administrative Process Number which Suspends ISS		J_1BNFE_NPROCESSO	CHAR	60
.INCLUDE				ITMF_J_1BNFLIN_ADD	0
NAT_BC_CRED	Credit Basis		ITMF_NAT_BC_CRED	CHAR	4