C_BR_ReportingNFItemQuery

EFD-C170-L012 - NF Document Item Query | view: CBRNDOCITQUERY | Extraction: Not supported | Component: Financials Brazil
Column Name Description
CompanyCode FK Company Code
BusinessPlace FK Business Place
BR_NotaFiscal FK Document Number
BR_NotaFiscalItem null
Column Name Description
BR_NFTotalAmount null
BR_NFDiscountAmountWithTaxes null
BR_ICMSTaxBaseAmount null
BR_ICMSTaxAmount null
BR_ICMSSTTaxBaseAmount null
BR_ICMSSTTaxAmount null
BR_IPITaxBaseAmount null
BR_IPITaxAmount null
BR_PISTaxBaseAmount null
BR_PISTaxAmount null
BR_COFINSTaxBaseAmount null
BR_COFINSTaxAmount null
Column Name Description
Column Name Description
BR_NFPostingDate Posting Date
Column Name Description
BR_NFIsPhysicalMvtOfMaterial Material Movement Show values
Column Name Description Domain name
BR_SPEDReportRegister null
Material Material Number MATNR
MaterialName Material Description TEXT40
QuantityInBaseUnit null
BaseUnit External Unit of Measurement in Commercial Format (3-Char.) MSEH3
BR_ICMSTaxSituation null
BR_CFOPCode null
BR_ICMSTaxRate null
BR_ICMSSTTaxRate null
BR_ReportingIsIPICalculation null
BR_IPITaxSituation null
IPILegalClassfctn null
BR_IPITaxRate null
BR_PISTaxSituation PIS Tax Situation J_1BTAXSI5
BR_PISTaxRate null
BR_PISQuantityBaseAmount null
BR_AppliedPISTaxAmount null
BR_COFINSTaxSituation COFINS Tax Situation J_1BTAXSI4
BR_COFINSTaxRate null
BR_COFINSQuantityBaseAmount null
BR_AppliedCOFINSTaxAmount null
GLAccount G/L Account Number SAKNR
ResourceSortText null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_BR_REPORTINGNFITEMQUERY.COMPANYCODE == T001.BUKRS
  • C_BR_REPORTINGNFITEMQUERY.MANDT == T001.MANDT
CFOP Code and Extension
  • ?
  • Client
  • CFOP Code and Extension
  • C_BR_REPORTINGNFITEMQUERY.[column in domain "J_1BCFOP_VER"] == J_1BAGN.VERSION
  • C_BR_REPORTINGNFITEMQUERY.MANDT == J_1BAGN.MANDT
  • C_BR_REPORTINGNFITEMQUERY.NFOPERATIONNATURE == J_1BAGN.CFOP