C_BR_ReportingNFItemCube

EFD-C170-L012 - NF Document Item Cube | view: CBRNDOCITCUBE | TRAN | 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
💲 SD Document Currency (SalesDocumentCurrency):
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_NFIssuedBy Nota Fiscal Issued By Show values
BR_NFSituationCode Status Code of Fiscal Document Show values
BR_NFIsPhysicalMvtOfMaterial Material Movement Show values
Column Name Description Domain name
BR_NFeNumber Nine-Digit Number
BR_NFModel null
BR_NFExternalItemNumber External Item Number NUMC3
MaterialType null
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_REPORTINGNFITEMCUBE.COMPANYCODE == T001.BUKRS
  • C_BR_REPORTINGNFITEMCUBE.MANDT == T001.MANDT
Weight Unit
  • Client
  • Weight Unit
  • C_BR_REPORTINGNFITEMCUBE.MANDT == T006.MANDT
  • C_BR_REPORTINGNFITEMCUBE.HEADERWEIGHTUNIT == T006.MSEHI
CFOP Code and Extension
  • ?
  • Client
  • CFOP Code and Extension
  • C_BR_REPORTINGNFITEMCUBE.[column in domain "J_1BCFOP_VER"] == J_1BAGN.VERSION
  • C_BR_REPORTINGNFITEMCUBE.MANDT == J_1BAGN.MANDT
  • C_BR_REPORTINGNFITEMCUBE.NFOPERATIONNATURE == J_1BAGN.CFOP
SD Document Currency
  • Client
  • SD Document Currency
  • C_BR_REPORTINGNFITEMCUBE.MANDT == TCURC.MANDT
  • C_BR_REPORTINGNFITEMCUBE.SALESDOCUMENTCURRENCY == TCURC.WAERS