OIAQB SAP (Exchange Movements Index) Table details

Dictionary Type: Table
Description: Exchange Movements Index




ABAP Code to SELECT data from OIAQB
Related tables to OIAQB
Access table OIAQB




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
OIEXGPTRExchange partner (vendor number) OIA_EXGPTRCHAR10Assigned to domainALPHALIFNRLIFKREDO
BUDATPosting Date in the Document BUDATDATS8DATUM
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
OIEXGNUMExchange agreement number OIA_EXGNUMCHAR10Assigned to domainALPHAOIA_EXGNUMOI1OIAE
OIEXGTYPExchange type OIA_EXGTYPCHAR4Assigned to domainOIA_EXGTYPOI3
OIMATREFMaterial group reference for exchange balance reporting OIA_MATREFCHAR20ALPHAOIA_MATREF
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
OIBASPRODBase product number OIA_SBMATCHAR18Assigned to domainMATN1MATNR
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
ZEILEItem number OIA_ITEMNUMC6OIA_ITEM
ITEM_TYPELIA item type OIA_UPEITMCHAR1OIA_UPEITM
OINETCYCNetting cycle (FI blocking indicator) OIA_NETCYCCHAR1Assigned to domainZAHLSNTG
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
OIASTBWReversal movement type XSTBWCHAR1XFELD
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
OIVBELNDelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
OIPOSNRDelivery Item POSNR_VLNUMC6Assigned to domainPOSNR
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
CLRNODoc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
OIPIPEVALValidation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEVCHAR1X
OIC_LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
OIC_DCITYCDestination city code OIC_DCITYCCHAR4T005GCITYC
OIC_DCOUNCDestination county code OIC_DCOUNCCHAR3T005ECOUNC
OIC_DREGIODestination region OIC_DREGIOCHAR3T005SREGIO
OIC_DLAND1Destination country OIC_DLAND1CHAR3T005LAND1
OIC_OCITYCOrigin city code OIC_OCITYCCHAR4T005GCITYC
OIC_OCOUNCOrigin county code OIC_OCOUNCCHAR3T005ECOUNC
OIC_OREGIOOrigin region OIC_OREGIOCHAR3T005SREGIO
OIC_OLAND1Origin country OIC_OLAND1CHAR3T005LAND1
OIC_PORGINTax origin OIC_PORGINCHAR15OIC_PORGIN
OIC_PDESTNTax destination OIC_PDESTNCHAR15OIC_PDESTN
OIC_PTRIPPipeline trip number (external) OIC_PTRIPCHAR16OIC_PTRIP
OIC_PBATCHPipeline operatorĀ“s external batch number OIC_PBATCHCHAR16OIC_PBATCH
OIC_MOTIS-OIL MAP external details mode of transport OIC_MOTCHAR2TVTRVKTRA
OIC_AORGINAlternate origin OIC_AORGINCHAR15OIC_PORGIN
OIC_ADESTNAlternate destination OIC_ADESTNCHAR15OIC_PDESTN
OIC_TRUCKNTruck number OIC_TRUCKNCHAR10OIC_TRUCKN
OIA_BASELOBase location OIA_BASELOCHAR15OIA_BASELO
CLRNO1Doc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
CLRNO2Doc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
CLRNO3Doc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
CLRNO4Doc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
CLRNO5Doc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
CLRNO6Doc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
CLRNO7Doc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
CLRNO8Doc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
CLRNO9Doc. number of the netting document clearing the item/cycle OIA_CLRNOCHAR10ALPHAOIA_PREQNO
PDUMMYDummy function in length 1 DUMMYCHAR1DUMMY
OID_EXTBOLExternal bill of lading OID_EXTBOLCHAR16OID_EXTBOL
OID_MISCDLMiscellaneous delivery number OID_MISCDLCHAR16OID_MISCDL
NOCYC1Invoice cycle not used indicator OIA_NOCYCCHAR1OI0_SELKZ
NOCYC2Invoice cycle not used indicator OIA_NOCYCCHAR1OI0_SELKZ
NOCYC3Invoice cycle not used indicator OIA_NOCYCCHAR1OI0_SELKZ
NOCYC4Invoice cycle not used indicator OIA_NOCYCCHAR1OI0_SELKZ
NOCYC5Invoice cycle not used indicator OIA_NOCYCCHAR1OI0_SELKZ
NOCYC6Invoice cycle not used indicator OIA_NOCYCCHAR1OI0_SELKZ
NOCYC7Invoice cycle not used indicator OIA_NOCYCCHAR1OI0_SELKZ
NOCYC8Invoice cycle not used indicator OIA_NOCYCCHAR1OI0_SELKZ
NOCYC9Invoice cycle not used indicator OIA_NOCYCCHAR1OI0_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!