0ID_BR_NF_1

Nota Fiscal Header | #TRAN | Extraction method: V | No Delta | Component: Nota Fiscal for Brazil
Tables used: J_1BNFDOC → show details
Column Name Description
DOCNUM Document Number
Column Name Description
💲 SD Document Currency (WAERK):
WITHA Total withholding amount of Nota Fiscal
Column Name Description
📏 Weight Unit (GEWEI):
BRGEW Gross weight
NTGEW Net weight
Column Name Description
DOCDAT Document date
PSTDAT Posting date
CREDAT Create date
CRETIM Creation time
CHADAT Change date
CHATIM Change time
CANDAT Cancellation Date
ZFBDT Baseline Date for Due Date Calculation
Column Name Description
DIRECT Direction of the movement Show values
MODEL Model of Nota Fiscal Show values
ENTRAD Nota Fiscal Entrada Show values
FATURA Fatura Show values
PRINTD Printed Show values
MANUAL Created manually Show values
FOLLOW Follow up activity made Show values
PARXCPDK Indicator: Is the account a one-time account? Show values
PARTYP Nota Fiscal Partner Type Show values
CANCEL Canceled Show values
SUBSEQ Follow-On Document Exists Show values
Column Name Description Domain name
CRENAM Name of the user USNAM
CHANAM Name of the user USNAM
SERIES Series J_1BSERIES
SUBSER Sub series J_1BSUBSER
NFNUM Nota Fiscal Number J_1BNFNUMB
ZTERM Terms of Payment Key ZTERM
BELNR Document Number of an Accounting Document BELNR
GJAHR Fiscal Year GJAHR
PARID Partner ID (Customer, Vendor, Business Place) J_1BPARID
TRAID Means of Transport ID TRAID
INCO2 Incoterms (Part 2) INCO2
ANZPK Total Number of Packages in Delivery ANZPK
SHPMRK Mark of the shipping unit TEXT20
SHPNUM Number of the shipping unit TEXT20
OBSERVAT Legal Books Mod. 1 + 2: Header text for observations column J_1BLBOBS
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • 0ID_BR_NF_1.BUKRS == T001.BUKRS
  • 0ID_BR_NF_1.MANDT == T001.MANDT
Document type
  • Client
  • Document type
Form of Electronic Fiscal Document
  • Form of Electronic Fiscal Document
  • Client
  • 0ID_BR_NF_1.FORM == J_1BAQ.FORM
  • 0ID_BR_NF_1.MANDT == J_1BAQ.MANDT
Weight Unit
  • Weight Unit
  • Client
  • 0ID_BR_NF_1.GEWEI == T006.MSEHI
  • 0ID_BR_NF_1.MANDT == T006.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • 0ID_BR_NF_1.MANDT == TINC.MANDT
  • 0ID_BR_NF_1.INCO1 == TINC.INCO1
Nota Fiscal Type
  • Client
  • Nota Fiscal Type
  • 0ID_BR_NF_1.MANDT == J_1BAA.MANDT
  • 0ID_BR_NF_1.NFTYPE == J_1BAA.NFTYPE
Nota Fiscal Partner Function
  • Nota Fiscal Partner Function
  • Client
  • 0ID_BR_NF_1.PARVW == J_1BAD.PARVW
  • 0ID_BR_NF_1.MANDT == J_1BAD.MANDT
Shipping unit (especie)
  • Shipping unit (especie)
  • Client
  • 0ID_BR_NF_1.SHPUNT == T006.MSEHI
  • 0ID_BR_NF_1.MANDT == T006.MANDT
Means-of-Transport Type
  • Means-of-Transport Type
  • Client
  • 0ID_BR_NF_1.TRATY == TVTY.TRATY
  • 0ID_BR_NF_1.MANDT == TVTY.MANDT
Foreign Key for Shipping Point
  • Shipping Point / Receiving Point
  • Client
  • 0ID_BR_NF_1.VSTEL == TVST.VSTEL
  • 0ID_BR_NF_1.MANDT == TVST.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • 0ID_BR_NF_1.WAERK == TCURC.WAERS
  • 0ID_BR_NF_1.MANDT == TCURC.MANDT