0ID_BR_NF_2

Nota Fiscal Document Line Item | #TRAN | Extraction method: V | No Delta | Component: Nota Fiscal for Brazil
Tables used: J_1BNFLIN, J_1BNFDOC → show details
Column Name Description
PSTDAT Posting date
BUKRS FK Company Code
BRANCH FK Business Place
DOCNUM FK Document Number
ITMNUM Document Item Number
Column Name Description
💲 SD Document Currency (WAERK):
NETWR Net Value
NETFRE Net freight value in document currency
NETINS Net insurance value in document currency
NETOTH Net expenses in document currency
NETDIS Net discount value in document currency
Column Name Description
📏 Base unit of measure (MEINS):
MENGE Quantity
Column Name Description
PSTDAT Posting date
Column Name Description
MATORG Origin of the material Show values
TAXSIT Tax situation ICMS Show values
OWNPRO Produced in-house Show values
MATUSE Usage of the material Show values
TMISS Service tax - no ICMS/IPI calculation Show values
INDUS3 Material CFOP category Show values
SPCSTO Nota Fiscal Special Case for CFOP Determination Show values
INCLTX Value and price including ICMS/ISS Show values
STATIT Indicator: Statistical item Show values
Column Name Description Domain name
MAKTX Material Description TEXT40
ITMREF Reference to item number (Return) J_1BITMNUM
REFKEY Reference to source document J_1BREFKEY
REFITM Reference item to source document J_1BREFITM
NETPR Net price J_1BNFPRI
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • 0ID_BR_NF_2.BUKRS == T001.BUKRS
  • 0ID_BR_NF_2.MANDT == T001.MANDT
Valuation area
  • Client
  • Valuation area
  • 0ID_BR_NF_2.MANDT == T001K.MANDT
  • 0ID_BR_NF_2.BWKEY == T001K.BWKEY
Valuation Type
  • Valuation Type
  • Plant
  • Material Number
  • Client
  • 0ID_BR_NF_2.BWTAR == MBEW.BWTAR
  • 0ID_BR_NF_2.WERKS == MBEW.BWKEY
  • 0ID_BR_NF_2.MATNR == MBEW.MATNR
  • 0ID_BR_NF_2.MANDT == MBEW.MANDT
CFOP Code and Extension
  • Client
  • CFOP Code and Extension
Batch Number
  • Batch Number
  • Client
  • Material Number
  • 0ID_BR_NF_2.CHARG == MCH1.CHARG
  • 0ID_BR_NF_2.MANDT == MCH1.MANDT
  • 0ID_BR_NF_2.MATNR == MCH1.MATNR
Nota Fiscal Item Type
  • Client
  • Nota Fiscal Item Type
Material Group
  • Material Group
  • Client
  • 0ID_BR_NF_2.MATKL == T023.MATKL
  • 0ID_BR_NF_2.MANDT == T023.MANDT
Material Number
  • Client
  • Material Number
  • 0ID_BR_NF_2.MANDT == MARA.MANDT
  • 0ID_BR_NF_2.MATNR == MARA.MATNR
Base unit of measure
  • Base unit of measure
  • Client
  • 0ID_BR_NF_2.MEINS == T006.MSEHI
  • 0ID_BR_NF_2.MANDT == T006.MANDT
Control code for consumption taxes in foreign trade
  • Client
  • Control code for consumption taxes in foreign trade
  • 0ID_BR_NF_2.MANDT == T604F.MANDT
  • 0ID_BR_NF_2.NBM == T604F.STEUC
Reference type 0ID_BR_NF_2.REFTYP == J_1BAB.REFTYP
Tax law: ICMS
  • Tax law: ICMS
  • Client
Tax law: IPI
  • Tax law: IPI
  • Client
Tax situation IPI
  • Tax situation IPI
  • Client
  • 0ID_BR_NF_2.TAXSI2 == J_1BAS.TAXSIT
  • 0ID_BR_NF_2.MANDT == J_1BAS.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • 0ID_BR_NF_2.WAERK == TCURC.WAERS
  • 0ID_BR_NF_2.MANDT == TCURC.MANDT
Plants
  • Plant
  • Client
  • 0ID_BR_NF_2.WERKS == T001W.WERKS
  • 0ID_BR_NF_2.MANDT == T001W.MANDT