OIAQB SAP (Exchange Movements Index) Table details
Dictionary Type: Table
Description: Exchange Movements Index
Description: Exchange Movements Index
Table field list including key, data, relationships and ABAP select examples
OIAQB is a standard SAP Table which is used to store Exchange Movements Index data and is available within R/3 SAP systems depending on the version and release level.
The OIAQB table consists of various fields, each holding specific information or linking keys about Exchange Movements Index data available in SAP. These include OIEXGPTR (Exchange partner (vendor number)), BUDAT (Posting Date in the Document), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIAQB table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
OIEXGPTR | Exchange partner (vendor number) | OIA_EXGPTR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KREDO |
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
OIEXGNUM | Exchange agreement number | OIA_EXGNUM | CHAR | 10 | Assigned to domain | ALPHA | OIA_EXGNUM | OI1 | OIAE |
OIEXGTYP | Exchange type | OIA_EXGTYP | CHAR | 4 | Assigned to domain | OIA_EXGTYP | OI3 | ||
OIMATREF | Material group reference for exchange balance reporting | OIA_MATREF | CHAR | 20 | ALPHA | OIA_MATREF | |||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
OIBASPROD | Base product number | OIA_SBMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
ZEILE | Item number | OIA_ITEM | NUMC | 6 | OIA_ITEM | ||||
ITEM_TYPE | LIA item type | OIA_UPEITM | CHAR | 1 | OIA_UPEITM | ||||
OINETCYC | Netting cycle (FI blocking indicator) | OIA_NETCYC | CHAR | 1 | Assigned to domain | ZAHLS | NTG | ||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
OIASTBW | Reversal movement type | XSTBW | CHAR | 1 | XFELD | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
OIVBELN | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
OIPOSNR | Delivery Item | POSNR_VL | NUMC | 6 | Assigned to domain | POSNR | |||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
CLRNO | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | CHAR | 10 | ALPHA | OIA_PREQNO | |||
OIPIPEVAL | Validation indicator for pipeline fields (X=ON, blank=OFF) | OID_PIPEV | CHAR | 1 | X | ||||
OIC_LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
OIC_DCITYC | Destination city code | OIC_DCITYC | CHAR | 4 | T005G | CITYC | |||
OIC_DCOUNC | Destination county code | OIC_DCOUNC | CHAR | 3 | T005E | COUNC | |||
OIC_DREGIO | Destination region | OIC_DREGIO | CHAR | 3 | T005S | REGIO | |||
OIC_DLAND1 | Destination country | OIC_DLAND1 | CHAR | 3 | T005 | LAND1 | |||
OIC_OCITYC | Origin city code | OIC_OCITYC | CHAR | 4 | T005G | CITYC | |||
OIC_OCOUNC | Origin county code | OIC_OCOUNC | CHAR | 3 | T005E | COUNC | |||
OIC_OREGIO | Origin region | OIC_OREGIO | CHAR | 3 | T005S | REGIO | |||
OIC_OLAND1 | Origin country | OIC_OLAND1 | CHAR | 3 | T005 | LAND1 | |||
OIC_PORGIN | Tax origin | OIC_PORGIN | CHAR | 15 | OIC_PORGIN | ||||
OIC_PDESTN | Tax destination | OIC_PDESTN | CHAR | 15 | OIC_PDESTN | ||||
OIC_PTRIP | Pipeline trip number (external) | OIC_PTRIP | CHAR | 16 | OIC_PTRIP | ||||
OIC_PBATCH | Pipeline operatorĀ“s external batch number | OIC_PBATCH | CHAR | 16 | OIC_PBATCH | ||||
OIC_MOT | IS-OIL MAP external details mode of transport | OIC_MOT | CHAR | 2 | TVTR | VKTRA | |||
OIC_AORGIN | Alternate origin | OIC_AORGIN | CHAR | 15 | OIC_PORGIN | ||||
OIC_ADESTN | Alternate destination | OIC_ADESTN | CHAR | 15 | OIC_PDESTN | ||||
OIC_TRUCKN | Truck number | OIC_TRUCKN | CHAR | 10 | OIC_TRUCKN | ||||
OIA_BASELO | Base location | OIA_BASELO | CHAR | 15 | OIA_BASELO | ||||
CLRNO1 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | CHAR | 10 | ALPHA | OIA_PREQNO | |||
CLRNO2 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | CHAR | 10 | ALPHA | OIA_PREQNO | |||
CLRNO3 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | CHAR | 10 | ALPHA | OIA_PREQNO | |||
CLRNO4 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | CHAR | 10 | ALPHA | OIA_PREQNO | |||
CLRNO5 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | CHAR | 10 | ALPHA | OIA_PREQNO | |||
CLRNO6 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | CHAR | 10 | ALPHA | OIA_PREQNO | |||
CLRNO7 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | CHAR | 10 | ALPHA | OIA_PREQNO | |||
CLRNO8 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | CHAR | 10 | ALPHA | OIA_PREQNO | |||
CLRNO9 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | CHAR | 10 | ALPHA | OIA_PREQNO | |||
PDUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
OID_EXTBOL | External bill of lading | OID_EXTBOL | CHAR | 16 | OID_EXTBOL | ||||
OID_MISCDL | Miscellaneous delivery number | OID_MISCDL | CHAR | 16 | OID_MISCDL | ||||
NOCYC1 | Invoice cycle not used indicator | OIA_NOCYC | CHAR | 1 | OI0_SELKZ | ||||
NOCYC2 | Invoice cycle not used indicator | OIA_NOCYC | CHAR | 1 | OI0_SELKZ | ||||
NOCYC3 | Invoice cycle not used indicator | OIA_NOCYC | CHAR | 1 | OI0_SELKZ | ||||
NOCYC4 | Invoice cycle not used indicator | OIA_NOCYC | CHAR | 1 | OI0_SELKZ | ||||
NOCYC5 | Invoice cycle not used indicator | OIA_NOCYC | CHAR | 1 | OI0_SELKZ | ||||
NOCYC6 | Invoice cycle not used indicator | OIA_NOCYC | CHAR | 1 | OI0_SELKZ | ||||
NOCYC7 | Invoice cycle not used indicator | OIA_NOCYC | CHAR | 1 | OI0_SELKZ | ||||
NOCYC8 | Invoice cycle not used indicator | OIA_NOCYC | CHAR | 1 | OI0_SELKZ | ||||
NOCYC9 | Invoice cycle not used indicator | OIA_NOCYC | CHAR | 1 | OI0_SELKZ |
Key field | Non-key field |
How do I retrieve data from SAP table OIAQB using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIAQB to SELECT all data from the tableDATA: WA_OIAQB TYPE OIAQB.
SELECT SINGLE *
FROM OIAQB
INTO CORRESPONDING FIELDS OF WA_OIAQB
WHERE...
How to access SAP table OIAQB
Within an ECC or HANA version of SAP you can also view further information about OIAQB and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects