0ID_BR_NF_6

Nota Fiscal One-Time Customers | #TRAN | Extraction method: V | No Delta | Component: Nota Fiscal for Brazil
Tables used: J_1BNFCPD, J_1BNFDOC → show details
Column Name Description
PSTDAT Posting date
BUKRS FK Company Code
BRANCH FK Business Place
DOCNUM FK Document Number
PARVW FK Nota Fiscal Partner Function
Column Name Description
Column Name Description
Column Name Description
PSTDAT Posting date
Column Name Description
STKZU Liable for VAT Show values
STKZA Indicator: Business Partner Subject to Equalization Tax? Show values
DTAMS Report key for data medium exchange Show values
XCPDK Indicator: Is the account a one-time account? Show values
STKZN Natural Person Show values
Column Name Description Domain name
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
PSTLZ Postal Code PSTLZ
ORT01 City TEXT35
STRAS Street and House Number TEXT35
PFACH PO Box PFACH
PSTL2 P.O. Box Postal Code PSTLZ
PSKTO PO Bank Current Acct No. or Building Society Ref. No. PSKTO
BANKN Bank account number BANKN
BANKL Bank Keys BANKK
STCD1 Tax Number 1 STCD1
STCD2 Tax Number 2 STCD2
BKONT Bank Control Key BKONT
EMPFG Payment Recipient Code EMPFG
J_1BSTAINS State Tax Number J_1BSTAINS
J_1BMUNINS Municipal Tax Number J_1BMUNINS
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • 0ID_BR_NF_6.MANDT == T005.MANDT
  • 0ID_BR_NF_6.BANKS == T005.LAND1
Company Code
  • Company Code
  • Client
  • 0ID_BR_NF_6.BUKRS == T001.BUKRS
  • 0ID_BR_NF_6.MANDT == T001.MANDT
Instruction Key for Data Medium Exchange
  • Client
  • Instruction Key for Data Medium Exchange
  • Country/Region Key of Bank
  • 0ID_BR_NF_6.MANDT == T015W.MANDT
  • 0ID_BR_NF_6.DTAWS == T015W.DTAWS
  • 0ID_BR_NF_6.BANKS == T015W.BANKS
Country/Region Key
  • Client
  • Country/Region Key
  • 0ID_BR_NF_6.MANDT == T005.MANDT
  • 0ID_BR_NF_6.LAND1 == T005.LAND1
Nota Fiscal Partner Function
  • Nota Fiscal Partner Function
  • Client
  • 0ID_BR_NF_6.PARVW == J_1BAD.PARVW
  • 0ID_BR_NF_6.MANDT == J_1BAD.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Country/Region Key
  • Client
  • 0ID_BR_NF_6.REGIO == T005S.BLAND
  • 0ID_BR_NF_6.LAND1 == T005S.LAND1
  • 0ID_BR_NF_6.MANDT == T005S.MANDT
Language Key 0ID_BR_NF_6.SPRAS == T002.SPRAS