I_BR_NFPartnerWthMainPartner_C

Brazil Nota Fiscal Partner | view: IBRNFPARTWMAINP | Extraction: Not supported | Component: Logistics Brazil
Tables used: J_1BNFDOCJ_1BNFNADT001TKA02KNA1LFA1
Column Name Description
BR_NotaFiscal Document Number
BR_NFPartnerFunction FK Nota Fiscal Partner Function
Column Name Description
Column Name Description
Column Name Description
Column Name Description
BR_NFPartnerType Type Show values
BR_NFPartnerIsNaturalPerson Natural Person Show values
BR_CTeFiscalDocumentPartner CT-e Partner in Fiscal Document Show values
BR_NFPartnerPlaceType Nota Fiscal Partner Place Type Show values
Column Name Description Domain name
BR_NFPartner Partner ID (Customer, Vendor, Business Place) J_1BPARID
BR_NFPartnerName1 Name 1 NAME
BR_NFPartnerName2 Name 2 NAME
BR_NFPartnerName3 Name 3 NAME
BR_NFPartnerName4 Name 4 NAME
BR_NFPartnerStreetName Street and House Number TEXT35
BR_NFPartnerCityName City TEXT35
BR_NFPartnerDistrictName District TEXT35
BR_NFPartnerPostalCode Postal Code PSTLZ
BR_NFPartnerCNPJ CNPJ Number LOGBR_CNPJ
BR_NFPartnerCPF CPF number LOGBR_CPF
PhoneNumber Addresses: telephone no. TEXT30
BR_NFPartnerStateTaxNumber State Tax Number J_1BSTAINS
BR_NFPartnerMunicipalTaxNumber Municipal Tax Number J_1BMUNINS
Master Data Relations Join Conditions
Country/Region Key
  • Client
  • Country/Region Key
  • I_BR_NFPARTNERWTHMAINPARTNER_C.MANDT == T005.MANDT
  • I_BR_NFPARTNERWTHMAINPARTNER_C.BR_NFPARTNERCOUNTRYCODE == T005.LAND1
Nota Fiscal Partner Function
  • Nota Fiscal Partner Function
  • Client
  • I_BR_NFPARTNERWTHMAINPARTNER_C.BR_NFPARTNERFUNCTION == J_1BAD.PARVW
  • I_BR_NFPARTNERWTHMAINPARTNER_C.MANDT == J_1BAD.MANDT
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_BR_NFPARTNERWTHMAINPARTNER_C.MANDT == T005S.MANDT
  • I_BR_NFPARTNERWTHMAINPARTNER_C.BR_NFPARTNERREGIONCODE == T005S.BLAND
  • I_BR_NFPARTNERWTHMAINPARTNER_C.BR_NFPARTNERCOUNTRYCODE == T005S.LAND1
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • I_BR_NFPARTNERWTHMAINPARTNER_C.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_BR_NFPARTNERWTHMAINPARTNER_C.MANDT == TTXJ.MANDT
  • I_BR_NFPARTNERWTHMAINPARTNER_C.BR_NFPARTNERTAXJURISDICTION == TTXJ.TXJCD