OIAQA SAP (Exchange Statement Print Requests) Table details

Dictionary Type: Table
Description: Exchange Statement Print Requests




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




Table field list including key, data, relationships and ABAP select examples

OIAQA is a standard SAP Table which is used to store Exchange Statement Print Requests data and is available within R/3 SAP systems depending on the version and release level.

The OIAQA table consists of various fields, each holding specific information or linking keys about Exchange Statement Print Requests data available in SAP. These include PREQNO (Exchange statement print request document number), NETDOC (Movement-based netting document), PREQTYP (Exchange statement print request document type), EXGPTR (Exchange partner (vendor number)).. 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 OIAQA 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 MANDTCLNT3T000MANDT
PREQNOExchange statement print request document number OIA_PREQNOCHAR10ALPHAOIA_PREQNOESR
NETDOCMovement-based netting document OIA_NETDOCCHAR1XFELD
PREQTYPExchange statement print request document type OIA_PREQTYCHAR4TVFKFKART
EXGPTRExchange partner (vendor number) OIA_EXGPTRCHAR10LFA1ALPHALIFNRLIFKREDO
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
WAERSCurrency for exchange statement OIA_DWAERSCUKY5TCURCWAERS
VEXGNUMFrom exchange agreement number OIA_VEXNUMCHAR10OIA01ALPHAOIA_EXGNUM
BEXGNUMTo exchange agreement number OIA_BEXNUMCHAR10OIA01ALPHAOIA_EXGNUM
VEXGTYPFrom exchange type OIA_VEXTYPCHAR4TOIA2OIA_EXGTYP
BEXGTYPTo exchange type OIA_BEXTYPCHAR4TOIA2OIA_EXGTYP
VMATREFFrom mat. group reference for exchange balance reporting OIA_VMATRFCHAR20ALPHAOIA_MATREF
BMATREFTo - mat. group reference for exchange balance reporting OIA_BMATRFCHAR20ALPHAOIA_MATREF
VMATNRFrom material number OIA_VMATNRCHAR18MARAMATN1MATNR
BMATNRTo material number OIA_BMATNRCHAR18MARAMATN1MATNR
VOIBASPRODFrom base product number OIA_VSBMATCHAR18Assigned to domainMATN1MATNR
BOIBASPRODTo base product number OIA_BSBMATCHAR18Assigned to domainMATN1MATNR
VWERKSFrom plant OIA_VWERKSCHAR4T001WWERKS
BWERKSTo plant OIA_BWERKSCHAR4T001WWERKS
VSPMONFrom period to analyze - month OIA_VSPMONNUMC6PERI6RSCALMONTH
BSPMONTo period to analyze - month OIA_BSPMONNUMC6PERI6RSCALMONTH
VSPTAGFrom period to analyze -daytime reference OIA_VSPTAGDATS8DATUM
BSPTAGTo period to analyze - day OIA_BSPTAGDATS8DATUM
VSPWOCFrom period to analyze - week OIA_VSPWOCNUMC6PERIMCPERIOD
BSPWOCTo period to analyze - week OIA_BSPWOCNUMC6PERIMCPERIOD
VSPBUPFrom period to analyze - posting period OIA_VSPBUPNUMC6PERIMCPERIOD
BSPBUPTo period to analyze - posting period OIA_BSPBUPNUMC6PERIMCPERIOD
DOCSTATExchange - netting document status OIA_DOCSTACHAR1OIA_DOCSTA
NJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
MAPPESession name MAPPECHAR12MAPPE
BICNTCounter created batch inputs per netting document OIA_BICNTDEC6OIA_BICNT
NETBALNet balance check TOTAL OIA_NETBALCURR13(2) WERT7
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERTIMTime of creation OI0_ERTIMTIMS6UZEIT
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AETIMTime of day the record was changed OI0_AETIMTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
OIINVCYC1Invoice cycle included indicator active (X/ ) OIA_INCYCICHAR1KREUZ
OIINVCYC2Invoice cycle included indicator active (X/ ) OIA_INCYCICHAR1KREUZ
OIINVCYC3Invoice cycle included indicator active (X/ ) OIA_INCYCICHAR1KREUZ
OIINVCYC4Invoice cycle included indicator active (X/ ) OIA_INCYCICHAR1KREUZ
OIINVCYC5Invoice cycle included indicator active (X/ ) OIA_INCYCICHAR1KREUZ
OIINVCYC6Invoice cycle included indicator active (X/ ) OIA_INCYCICHAR1KREUZ
OIINVCYC7Invoice cycle included indicator active (X/ ) OIA_INCYCICHAR1KREUZ
OIINVCYC8Invoice cycle included indicator active (X/ ) OIA_INCYCICHAR1KREUZ
OIINVCYC9Invoice cycle included indicator active (X/ ) OIA_INCYCICHAR1KREUZ
OIINCLIALIA included indicator (X/ ) OIA_INCLIACHAR1KREUZ
OIINCPFAPFA included indicator (X/ ) OIA_INCPFACHAR1KREUZ
DISPMEOutput unit of measure (for exchange and netting statement) OIA_OUTMEIUNIT3T006CUNITMEINS
OIAMWOFIMovements without financials indicator OIA_MWOFICHAR1OI0_SELKZ
OIABALANInclude balances indicator OIA_BALANCHAR1OI0_SELKZ

Key field Non-key field



How do I retrieve data from SAP table OIAQA using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIAQA to SELECT all data from the table
DATA: WA_OIAQA TYPE OIAQA.

SELECT SINGLE *
FROM OIAQA
INTO CORRESPONDING FIELDS OF WA_OIAQA
WHERE...

How to access SAP table OIAQA

Within an ECC or HANA version of SAP you can also view further information about OIAQA 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!