OIAFE

Fee history table | #transactional | Component: Exchanges
Column Name Description
MANDT FK Client
EBELN FK Purchasing Document Number
EBELP FK Item Number of Purchasing Document
GJAHR Fiscal Year
LFBNR Number of goods receipt document
LFPOS Item of a Reference Document
BELNR Document Number of an Accounting Document
BLPOS Item of a Reference Document
VGABE Transaction/event type, purchase order history Show values
Column Name Description
💲 Currency Key (T001.WAERS):
OIDMBTR Fee amount in local currency
OIWRBTR Fee amount in document currency
AREWR GR/IR account clearing value in local currency
REEWR Invoice fee value entered in local currency
REFWR Invoice fee value entered in document currency
Column Name Description
📏 Purchase Order Unit of Measure (EKPO.MEINS):
MENGE Quantity
Column Name Description
BUDAT Posting Date in the Document
ERDAT Date on which the record was created
ERTIM Time of creation
_DATAAGING Data Filter Value for Data Aging
Column Name Description
VGABE Transaction/event type, purchase order history Show values
SHKZG Debit/Credit Indicator Show values
OINEGPSTG Negative posting line (exchange fees) Show values
Column Name Description Domain name
KNUMV Number of the Document Condition KNUMV
XBLNR External delivery note number XBLNR1
FRBNR Number of Bill of Lading at Time of Goods Receipt XBLNR1
Master Data Relations Join Conditions
Purchase Order History Category
  • OIAFE.MANDT == T163B.MANDT
  • OIAFE.BEWTP == T163B.BEWTP
Account Number of Supplier
  • OIAFE.MANDT == LFA1.MANDT
  • OIAFE.LIFNR == LFA1.LIFNR
Client OIAFE.MANDT == T000.MANDT
Currency Key
  • OIAFE.MANDT == TCURC.MANDT
  • OIAFE.WAERS == TCURC.WAERS