OIA12I

Movement Based Netting document item | #transactional | Component: Exchanges
Column Name Description
MANDT Client
BUKRS Company Code
NETNUM Exchange - netting document number
ITMNO Exchange - netting document item number
Column Name Description
💲 Currency Key (T001.WAERS):
DMBTR Amount in local currency
WRBTR Amount in document currency
Column Name Description
📏 Output unit of measure (for exchange and netting statement) (OIAQA.DISPME):
OIAOBAL Opening exchange balance
📏 Base Unit of Measure (MEINS):
MENGE Movement quantity
Column Name Description
BUDAT Posting Date in the Document
_DATAAGING Data Filter Value for Data Aging
Column Name Description
SELKZ Selection flag Show values
ITCAT Exchange - netting document item type Show values
SHKZG Debit/Credit Indicator Show values
BOMCON Indicator: BOM continuation item Show values
OICLRDCYC Item already cleared in all cycles under process (X/ ) Show values
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) Show values
Column Name Description Domain name
OIEXGNUM Exchange agreement number OIA_EXGNUM
MBLNR Number of Material Document BELNR
MJAHR Material Document Year GJAHR
ZEILE Item number OIA_ITEM
MATNR Material Number MATNR
WERKS Plant WERKS
EBELN Purchasing Document Number EBELN
EBELP Item Number of Purchasing Document EBELP
OIVBELN Delivery VBELN
OIPOSNR Delivery Item POSNR
KDAUF Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
BELNR Document Number of an Accounting Document BELNR
GJAHR Fiscal Year GJAHR
BUZEI Number of Line Item Within Accounting Document BUZEI
CLRNO Doc. number of the netting document clearing the item/cycle OIA_PREQNO
OIBASPROD Base product number MATNR
OIMATREF Material group reference for exchange balance reporting OIA_MATREF
OIC_PORGIN Tax origin OIC_PORGIN
OIC_PDESTN Tax destination OIC_PDESTN
OIC_PTRIP Pipeline trip number (external) OIC_PTRIP
OIC_PBATCH Pipeline operator´s external batch number OIC_PBATCH
OIC_AORGIN Alternate origin OIC_PORGIN
OIC_ADESTN Alternate destination OIC_PDESTN
OIC_TRUCKN Truck number OIC_TRUCKN
OIA_BASELO Base location OIA_BASELO
OID_EXTBOL External bill of lading OID_EXTBOL
OID_MISCDL Miscellaneous delivery number OID_MISCDL
Master Data Relations Join Conditions
Destination city code
  • Destination region
  • Destination city code
  • Client
  • Destination country/Region
  • OIA12I.OIC_DREGIO == T005G.REGIO
  • OIA12I.OIC_DCITYC == T005G.CITYC
  • OIA12I.MANDT == T005G.MANDT
  • OIA12I.OIC_DLAND1 == T005G.LAND1
Destination county code
  • Destination county code
  • Destination country/Region
  • Destination region
  • OIA12I.MANDT == T005E.MANDT
  • OIA12I.OIC_DCOUNC == T005E.COUNC
  • OIA12I.OIC_DLAND1 == T005E.LAND1
  • OIA12I.OIC_DREGIO == T005E.REGIO
Destination country/Region
  • Destination country/Region
  • Client
  • OIA12I.OIC_DLAND1 == T005.LAND1
  • OIA12I.MANDT == T005.MANDT
Destination region
  • Destination country/Region
  • Destination region
  • OIA12I.MANDT == T005S.MANDT
  • OIA12I.OIC_DLAND1 == T005S.LAND1
  • OIA12I.OIC_DREGIO == T005S.BLAND
Account Number of Supplier
  • OIA12I.MANDT == LFA1.MANDT
  • OIA12I.OIC_LIFNR == LFA1.LIFNR
IS-OIL MAP external details mode of transport
  • OIA12I.MANDT == TVTR.MANDT
  • OIA12I.OIC_MOT == TVTR.VKTRA
Origin city code
  • Origin region
  • Origin city code
  • Client
  • Origin Country/Region
  • OIA12I.OIC_OREGIO == T005G.REGIO
  • OIA12I.OIC_OCITYC == T005G.CITYC
  • OIA12I.MANDT == T005G.MANDT
  • OIA12I.OIC_OLAND1 == T005G.LAND1
Origin county code
  • Origin county code
  • Origin Country/Region
  • Origin region
  • OIA12I.MANDT == T005E.MANDT
  • OIA12I.OIC_OCOUNC == T005E.COUNC
  • OIA12I.OIC_OLAND1 == T005E.LAND1
  • OIA12I.OIC_OREGIO == T005E.REGIO
Origin Country/Region
  • Origin Country/Region
  • Client
  • OIA12I.OIC_OLAND1 == T005.LAND1
  • OIA12I.MANDT == T005.MANDT
Origin region
  • Origin Country/Region
  • Origin region
  • OIA12I.MANDT == T005S.MANDT
  • OIA12I.OIC_OLAND1 == T005S.LAND1
  • OIA12I.OIC_OREGIO == T005S.BLAND