OIAQB is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of OIAQB in SAP.
- Table description : Exchange Movements Index
- Module : CRM
- Parent Module : CRM
- Package : OIA
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP OIAQB Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
OIEXGPTR | Exchange partner (vendor number) | OIA_EXGPTR | LIFNR |
BUDAT | Posting Date in the Document | BUDAT | DATUM |
SPMON | Period to analyze - month | SPMON | MCPERIOD |
SPTAG | Period to analyze - current date | SPTAG | DATUM |
SPWOC | Period to analyze - week | SPWOC | MCPERIOD |
SPBUP | Period to analyze - posting period | SPBUP | MCPERIOD |
OIEXGNUM | Exchange agreement number | OIA_EXGNUM | OIA_EXGNUM |
OIEXGTYP | Exchange type | OIA_EXGTYP | OIA_EXGTYP |
OIMATREF | Material group reference for exchange balance reporting | OIA_MATREF | OIA_MATREF |
MATNR | Material Number | MATNR | MATNR |
OIBASPROD | Base product number | OIA_SBMAT | MATNR |
WERKS | Plant | WERKS_D | WERKS |
MBLNR | Number of Material Document | MBLNR | BELNR |
MJAHR | Year of material document | MJAHR | GJAHR |
ZEILE | Item number | OIA_ITEM | OIA_ITEM |
ITEM_TYPE | LIA item type | OIA_UPEITM | OIA_UPEITM |
OINETCYC | Netting cycle (FI blocking indicator) | OIA_NETCYC | ZAHLS |
SHKZG | Debit/Credit Indicator | SHKZG | SHKZG |
OIASTBW | Reversal transaction type | XSTBW | XFELD |
EBELN | Purchasing Document Number | EBELN | EBELN |
EBELP | Item Number of Purchasing Document | EBELP | EBELP |
OIVBELN | Delivery | VBELN_VL | VBELN |
OIPOSNR | Delivery Item | POSNR_VL | POSNR |
KDAUF | Sales Order Number | KDAUF | VBELN |
KDPOS | Item number in Sales Order | KDPOS | NUM06 |
CLRNO | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | OIA_PREQNO |
.INCLUDE | Origin, Destination, Trip and ex Batch No for Pipeline | ||
OIPIPEVAL | Validation indicator for pipeline fields (X=ON, blank=OFF) | OID_PIPEV | X |
OIC_LIFNR | Account Number of Vendor or Creditor | LIFNR | LIFNR |
.INCLUDE | Destination/Origin: City,County,Region,Country + Tax | ||
OIC_DCITYC | Destination city code | OIC_DCITYC | CITYC |
OIC_DCOUNC | Destination county code | OIC_DCOUNC | COUNC |
OIC_DREGIO | Destination region | OIC_DREGIO | REGIO |
OIC_DLAND1 | Destination country | OIC_DLAND1 | LAND1 |
OIC_OCITYC | Origin city code | OIC_OCITYC | CITYC |
OIC_OCOUNC | Origin county code | OIC_OCOUNC | COUNC |
OIC_OREGIO | Origin region | OIC_OREGIO | REGIO |
OIC_OLAND1 | Origin country | OIC_OLAND1 | LAND1 |
OIC_PORGIN | Tax origin | OIC_PORGIN | OIC_PORGIN |
OIC_PDESTN | Tax destination | OIC_PDESTN | OIC_PDESTN |
OIC_PTRIP | Pipeline trip number (external) | OIC_PTRIP | OIC_PTRIP |
OIC_PBATCH | Pipeline operator ´s external batch number | OIC_PBATCH | OIC_PBATCH |
OIC_MOT | IS-OIL MAP external details mode of transport | OIC_MOT | VKTRA |
OIC_AORGIN | Alternate origin | OIC_AORGIN | OIC_PORGIN |
OIC_ADESTN | Alternate destination | OIC_ADESTN | OIC_PDESTN |
OIC_TRUCKN | Truck number | OIC_TRUCKN | OIC_TRUCKN |
OIA_BASELO | Base location | OIA_BASELO | OIA_BASELO |
CLRNO1 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | OIA_PREQNO |
CLRNO2 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | OIA_PREQNO |
CLRNO3 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | OIA_PREQNO |
CLRNO4 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | OIA_PREQNO |
CLRNO5 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | OIA_PREQNO |
CLRNO6 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | OIA_PREQNO |
CLRNO7 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | OIA_PREQNO |
CLRNO8 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | OIA_PREQNO |
CLRNO9 | Doc. number of the netting document clearing the item/cycle | OIA_CLRNO | OIA_PREQNO |
.INCLUDE | Customer modifications to OIAQB | ||
PDUMMY | Dummy function in length 1 | DUMMY | DUMMY |
.INCLUDE | External Bill of Lading and Misc. Deliv. No | ||
OID_EXTBOL | External bill of lading | OID_EXTBOL | OID_EXTBOL |
OID_MISCDL | Miscellaneous delivery number | OID_MISCDL | OID_MISCDL |
NOCYC1 | Invoice cycle not used indicator | OIA_NOCYC | OI0_SELKZ |
NOCYC2 | Invoice cycle not used indicator | OIA_NOCYC | OI0_SELKZ |
NOCYC3 | Invoice cycle not used indicator | OIA_NOCYC | OI0_SELKZ |
NOCYC4 | Invoice cycle not used indicator | OIA_NOCYC | OI0_SELKZ |
NOCYC5 | Invoice cycle not used indicator | OIA_NOCYC | OI0_SELKZ |
NOCYC6 | Invoice cycle not used indicator | OIA_NOCYC | OI0_SELKZ |
NOCYC7 | Invoice cycle not used indicator | OIA_NOCYC | OI0_SELKZ |
NOCYC8 | Invoice cycle not used indicator | OIA_NOCYC | OI0_SELKZ |
NOCYC9 | Invoice cycle not used indicator | OIA_NOCYC | OI0_SELKZ |
OIAQB related tables
Table | Note |
---|---|
OIAQB | Exchange Movements Index |
/BA1/TF4_FXCVFCT | Exchange Rate Factors for Exchange Rates |
BSIW | Index table for customer bills of exchange used |
BSIX | Index table for customer bills of exchange used |
OIA10E | Index table to find netting docs. by exchange number |
TPROFIT_POPUP | Define Simulated Exchange Rate Index (Profit Simulation) |
AFFW | Goods Movements with Errors from Confirmations |
AFWD | Deliveries for Confirmation Goods Movements in EWM |
AFWI | Subsequently posted goods movements for confirmations |
AUFM | Goods movements for order |
COWB180PAR | Parameters for Request for Triggering WM Goods Movements |
EKRS | ERS Procedure: Goods (Merchandise) Movements to be Invoiced |
FAIBSV03 | Logistical Goods Movements |
J_1AAWAYBL | Way Bills for asset movements |
J_1ASNRDT2 | Branch determination for material movements |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP