I_BR_NFItem

Brazil Nota Fiscal Item | view: IBRNFITEM | Extraction: Not supported | Component: Logistics Brazil
Tables used: J_1BNFDOC, J_1BNFLIN, J_1BNFNAD, T001, TKA02, KNA1, LFA1
Column Name Description
BR_NotaFiscal FK Document Number
BR_NotaFiscalItem Document Item Number
Column Name Description
💲 SD Document Currency (SalesDocumentCurrency):
BR_WithholdingICMSSTBaseAmount Withholding ICMS ST Base
BR_WithholdingICMSSTAmount Withholding ICMS ST Amount
BR_NFNetFreightAmount Net freight value in document currency
BR_NFNetInsuranceAmount Net insurance value in document currency
BR_NFNetOtherExpensesAmount Net expenses in document currency
NetValueAmount Net Amount
BR_NFTotalAmount Net value/Freight/Insurance/Expenses/Discount
BR_NFValueAmountWithTaxes Net Value including taxes
BR_NFDiscountAmountWithTaxes Discount value including taxes
BR_NFFreightAmountWithTaxes Freight value including taxes
BR_NFInsuranceAmountWithTaxes Insurance value including taxes
BR_NFExpensesAmountWithTaxes Expenses including taxes
BR_NFTotalAmountWithTaxes Net value/Freight/Insurance/Expenses/Discount
BR_EffctvCalcBasisAmount Effective Calculation Basis Amount
BR_EffectiveICMSAmount Effective ICMS Amount
BR_ICMSSTDestTaxBaseAmount ICMS ST Basis Destination State
BR_ICMSSTDestTaxAmount ICMS ST for Destination State
BR_FCPOnICMSSTWithheldBaseAmt Withheld FCP Calculation Basis
BR_PISSTTaxAmount PIS ST Value
BR_PISSTTaxIncludedTaxAmount PIS ST Value Including Taxes
BR_COFINSSTTaxAmount COFINS ST Value
BR_COFINSSTTxIncludedTaxAmount COFINS ST Value Including Taxes
Column Name Description
📏 Base unit of measure (BaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
Column Name Description
BR_ICMSTaxSituation ICMS Tax Situation Show values
BR_ICMSBaseDetn ICMS Base Determination Show values
BR_ICMSSTBaseDetermination ICMS ST Base Determination Show values
BR_ICMSExemptionReason Exemption Reason Show values
BR_ICMSOrISSIsIncludedInPrice Value and price including ICMS/ISS Show values
BR_NFItemIsStatistical Statistical Item Show values
BR_NFIsServiceItem Service tax - no ICMS/IPI calculation Show values
BR_CFOPCategory Material CFOP category Show values
BR_CPRBIsRelevant CPRB Relevance Show values
BR_MaterialOrigin Material Origin Show values
BR_MaterialUsage Material Usage Show values
IsProducedInhouse Produced in-House Show values
BR_NFIsPhysicalMvtOfMaterial Material Movement Show values
BR_NFItemHasTaxIncentive Tax Incentive Show values
CreditCalculationBaseCode Credit Basis Show values
ProductionIsInRelevantScale Scale Production Indicator Show values
BR_NFFreightNature Freight Nature Indicator Show values
BR_NFIsPISSTInTotalAmount Indicator of PIS ST in the Nota Fiscal Total Show values
BR_NFIsCOFINSSTInTotalAmount Indicator of COFINS ST in the Nota Fiscal Total Show values
BR_ICMSSTExemptionReason ICMS ST Exemption Reason Show values
Column Name Description Domain name
BR_ISSTaxSituation ISS Tax Situation CHAR80
BR_COFINSTaxSituation COFINS Tax Situation J_1BTAXSI4
BR_PISTaxSituation PIS Tax Situation J_1BTAXSI5
BR_SubstituteICMSAmount Substitute ICMS Amount Charged in Previous Transaction J_1BNFE_VICMSSUBSTITUTO
BR_ICMSDefermentAmount Deferment Amount J_1BNFE_RFC_VICMSDIF
BR_ICMSDeferralTaxRate Tax Rate for ICMS Deferral J_1BNFE_PICMSDEF
BR_TobaccoBeverageIPIClassfctn IPI Tobacco/Beverage CHAR5
BR_IPIControlSealCode IPI Control Seal Code CHAR10
BR_IPIControlSealQuantityValue IPI Control Seal Quantity DEC12
CostCenter Cost Center KOSTL
ProfitCenter Profit Centers PRCTR
InternalOrder Order Number AUFNR
ProjectNetwork Network Number for Account Assignment AUFNR
WBSElementInternalID Work Breakdown Structure Element (WBS Element) PS_POSNR
CostObject Cost Objects KSTRG
Segment Segment for Segmental Reporting FB_SEGMENT
NetPriceAmount Net Price Including Tax J_1BNFPRI
MaterialName Material Description TEXT40
BR_NFSourceDocumentNumber Source Document Key J_1BREFKEY
BR_NFSourceDocumentItem Reference item to source document J_1BREFITM
BR_ReferenceNFItem NF Reference Item J_1BITMNUM
BR_NFPercentReturned Quantity Returned
BR_NFNetDiscountAmount Net Discount Amount DECV15_2
BR_ExemptedICMSAmount ICMS Exemption Amount
BR_ICMSStatisticalExemptionAmt Statistical Exemption Value of ICMS
BR_ICMSSTMarginAddedPercent Margin percentage of value Added from ICMS ST J_1BNFE_PMVAST
BR_NBSCode NBS Code J_1BNBS
BR_CSTISSCode CST for ISS Defined by Municipality LOGBR_MUNICIPAL_ISS_TAXSIT
BR_NFApproximateTotalTaxAmount Approximate Tax DECV15_2
BR_FCINumber FCI Number
GLAccount G/L Account Number SAKNR
PurchaseOrder Purchase Order Number CHAR15
PurchaseOrderItem Purchase Order Item CHAR6
InternationalArticleNumber European Article Number EAN11
BR_NFExternalItemNumber External Item Number NUMC3
BR_RECOPINumber Registro e Controle das Operações com o Papel Imune
BR_ISSSuspensionProcess Process Number CHAR30
BR_NFTributaryQuantity Tributary Quantity
BR_NFPriceAmountWithTaxes Net Price Including Tax J_1BNFPRI
BR_NFExemptedICMSWithTaxes Exemption Value of ICMS Including Taxes
BR_TaxCode Tax on sales/purchases code MWSKZ
BR_ReducnPctEffctvCalcBasis Reduction Percentage of Effective Calculation Basis J_1BNFE_PREDBCEFET
BR_EffectiveICMSRate Effective ICMS Rate J_1BNFE_PICMSEFET
BR_ManufacturerCNPJ Manufacturer CNPJ LOGBR_CNPJ
BR_FCPonICMSSTWithheldRate Withheld FCP ST J_1BNFE_PFCPSTRET
CustomsChargesAmount Customs Expense Amount
BR_FCPOnICMSSTWithheldAmount Withheld FCP ST Amount J_1BNFE_VFCPSTRET
BR_IOFTaxAmount IOF Amount
BR_ICMSSTRateIncludingFCP Final Consumer Rate J_1BNFE_PST
BR_NFeStatisticalAmount Statistical Amount J_1BNFE_VOUTRO
BR_InternalBarcode Internal Barcode J_1BNFE_CBARRA
BR_InternalTributaryBarcode Internal Tributary Barcode J_1BNFE_CBARRA_TRIB
BR_ICMSDefermentPercent ICMS Deferral Percentage J_1BNFE_PDIF
BR_FCPOnICMSDefermentAmount Deferred FCP Value J_1BNFE_VFCPDIF
BR_FCPOnICMSDeferralTaxRate Tax Rate for FCP Deferral J_1BNFE_PFCPDEF
BR_FCPOnICMSDefermentPercent FCP Deferral Percentage J_1BNFE_PFCPDIF
BR_ExemptedICMSSTAmount Exemption Value of ICMS ST J_1BNFE_VICMSSTDESON
Master Data Relations Join Conditions
Activity Number
  • Activity Number
  • Client
  • I_BR_NFITEM.ACTIVITYNUMBER == ASMD.ASNUM
  • I_BR_NFITEM.MANDT == ASMD.MANDT
Base unit of measure
  • Client
  • Base unit of measure
  • I_BR_NFITEM.MANDT == T006.MANDT
  • I_BR_NFITEM.BASEUNIT == T006.MSEHI
Batch Number
  • Material Number
  • Batch Number
  • Client
  • I_BR_NFITEM.MATERIAL == MCH1.MATNR
  • I_BR_NFITEM.BATCH == MCH1.CHARG
  • I_BR_NFITEM.MANDT == MCH1.MANDT
CNAE Business Place Code
  • CNAE Business Place Code
  • Client
  • I_BR_NFITEM.BR_BUSINESSPLACECNAE == J_1BTCNAE.J_1BCNAE
  • I_BR_NFITEM.MANDT == J_1BTCNAE.MANDT
CFOP Code and Extension
  • ?
  • CFOP Code and Extension
  • Client
  • I_BR_NFITEM.[column in domain "J_1BCFOP_VER"] == J_1BAGN.VERSION
  • I_BR_NFITEM.BR_CFOPCODE == J_1BAGN.CFOP
  • I_BR_NFITEM.MANDT == J_1BAGN.MANDT
COFINS Tax Law
  • Client
  • COFINS Tax Law
EFD-REINF Service Type Code
  • Client
  • EFD-REINF Service Type Code
ICMS ST Legal Classification Code
  • ICMS ST Legal Classification Code
  • Client
  • I_BR_NFITEM.BR_ICMSSTLEGALCLASSFCTN == J_1BTCEST.CEST
  • I_BR_NFITEM.MANDT == J_1BTCEST.MANDT
Tax Law ICMS
  • Tax Law ICMS
  • Client
  • I_BR_NFITEM.BR_ICMSTAXLAW == J_1BATL1.TAXLAW
  • I_BR_NFITEM.MANDT == J_1BATL1.MANDT
IPI Classification Code
  • IPI Classification Code
  • Client
  • I_BR_NFITEM.BR_IPILEGALCLASSIFICATION == J_1BTCENQ.CENQ
  • I_BR_NFITEM.MANDT == J_1BTCENQ.MANDT
Tax Law IPI
  • Client
  • Tax Law IPI
  • I_BR_NFITEM.MANDT == J_1BATL2.MANDT
  • I_BR_NFITEM.BR_IPITAXLAW == J_1BATL2.TAXLAW
IPI Tax Situation
  • IPI Tax Situation
  • Client
  • I_BR_NFITEM.BR_IPITAXSITUATION == J_1BAS.TAXSIT
  • I_BR_NFITEM.MANDT == J_1BAS.MANDT
Benefit Code for ISS Tax
  • ?
  • Benefit Code for ISS Tax
  • Client
ISS Tax Law
  • ISS Tax Law
  • Client
  • I_BR_NFITEM.BR_ISSTAXLAW == J_1BATL3.TAXLAW
  • I_BR_NFITEM.MANDT == J_1BATL3.MANDT
LC 116 Service Type Code
  • LC 116 Service Type Code
  • Client
NF Item Type
  • NF Item Type
  • Client
CNAE Code for Partner
  • CNAE Code for Partner
  • Client
Reference type I_BR_NFITEM.BR_NFSOURCEDOCUMENTTYPE == J_1BAB.REFTYP
Tax Law PIS
  • Tax Law PIS
  • Client
  • I_BR_NFITEM.BR_PISTAXLAW == J_1BATL5.TAXLAW
  • I_BR_NFITEM.MANDT == J_1BATL5.MANDT
Material Number
  • Material Number
  • Client
  • I_BR_NFITEM.MATERIAL == MARA.MATNR
  • I_BR_NFITEM.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • I_BR_NFITEM.MANDT == T023.MANDT
  • I_BR_NFITEM.MATERIALGROUP == T023.MATKL
Control Code
  • ?
  • Control Code
  • Client
  • I_BR_NFITEM.[column in domain "LAND1"] == T604F.LAND1
  • I_BR_NFITEM.NCMCODE == T604F.STEUC
  • I_BR_NFITEM.MANDT == T604F.MANDT
Plants
  • Plant
  • Client
  • I_BR_NFITEM.PLANT == T001W.WERKS
  • I_BR_NFITEM.MANDT == T001W.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • I_BR_NFITEM.SALESDOCUMENTCURRENCY == TCURC.WAERS
  • I_BR_NFITEM.MANDT == TCURC.MANDT
State Tax Incentive Code
  • ?
  • State Tax Incentive Code
  • Client
Valuation area
  • Valuation area
  • Client
  • I_BR_NFITEM.VALUATIONAREA == T001K.BWKEY
  • I_BR_NFITEM.MANDT == T001K.MANDT
Valuation Type
  • Material Number
  • Plant
  • Valuation Type
  • Client
  • I_BR_NFITEM.MATERIAL == MBEW.MATNR
  • I_BR_NFITEM.PLANT == MBEW.BWKEY
  • I_BR_NFITEM.VALUATIONTYPE == MBEW.BWTAR
  • I_BR_NFITEM.MANDT == MBEW.MANDT