SAP ABAP View V_OIAQB (Exchange Movements Index - uncleared items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIA (Package) Exg exchanges

Basic Data

View Type	D	Database View
Database View	V_OIAQB
Short Description	Exchange Movements Index - uncleared items
Root table	OIAQB	Exchange Movements Index

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIAQB	OIAQB

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIAQB	CLRNO		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	OIAQB	MANDT		☐	MANDT	☐	Client
2	OIEXGPTR	OIAQB	OIEXGPTR		☐	OIA_EXGPTR	☐	Exchange partner (vendor number)
3	BUDAT	OIAQB	BUDAT		☐	BUDAT	☐	Posting Date in the Document
4	SPMON	OIAQB	SPMON		☐	SPMON	☐	Period to analyze - month
5	SPTAG	OIAQB	SPTAG		☐	SPTAG	☐	Period to analyze - current date
6	SPWOC	OIAQB	SPWOC		☐	SPWOC	☐	Period to analyze - week
7	SPBUP	OIAQB	SPBUP		☐	SPBUP	☐	Period to analyze - posting period
8	OIEXGNUM	OIAQB	OIEXGNUM		☐	OIA_EXGNUM	☐	Exchange agreement number
9	OIEXGTYP	OIAQB	OIEXGTYP		☐	OIA_EXGTYP	☐	Exchange type
10	OIMATREF	OIAQB	OIMATREF		☐	OIA_MATREF	☐	Material group reference for exchange balance reporting
11	MATNR	OIAQB	MATNR		☐	MATNR	☐	Material Number
12	OIBASPROD	OIAQB	OIBASPROD		☐	OIA_SBMAT	☐	Base product number
13	WERKS	OIAQB	WERKS		☐	WERKS_D	☐	Plant
14	MBLNR	OIAQB	MBLNR		☐	MBLNR	☐	Number of Material Document
15	MJAHR	OIAQB	MJAHR		☐	MJAHR	☐	Year of material document
16	ZEILE	OIAQB	ZEILE		☐	OIA_ITEM	☐	Item number
17	ITEM_TYPE	OIAQB	ITEM_TYPE		☐	OIA_UPEITM	☐	LIA item type
18	OINETCYC	OIAQB	OINETCYC		☐	OIA_NETCYC	☐	Netting cycle (FI blocking indicator)
19	SHKZG	OIAQB	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
20	OIASTBW	OIAQB	OIASTBW		☐	XSTBW	☐	Reversal transaction type
21	EBELN	OIAQB	EBELN		☐	EBELN	☐	Purchasing Document Number
22	EBELP	OIAQB	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
23	OIVBELN	OIAQB	OIVBELN		☐	VBELN_VL	☐	Delivery
24	OIPOSNR	OIAQB	OIPOSNR		☐	POSNR_VL	☐	Delivery Item
25	KDAUF	OIAQB	KDAUF		☐	KDAUF	☐	Sales Order Number
26	KDPOS	OIAQB	KDPOS		☐	KDPOS	☐	Item number in Sales Order
27	CLRNO	OIAQB	CLRNO		☐	OIA_CLRNO	☐	Doc. number of the netting document clearing the item/cycle
28	CLRNO1	OIAQB	CLRNO1		☐	OIA_CLRNO	☐	Doc. number of the netting document clearing the item/cycle
29	CLRNO2	OIAQB	CLRNO2		☐	OIA_CLRNO	☐	Doc. number of the netting document clearing the item/cycle
30	CLRNO3	OIAQB	CLRNO3		☐	OIA_CLRNO	☐	Doc. number of the netting document clearing the item/cycle
31	CLRNO4	OIAQB	CLRNO4		☐	OIA_CLRNO	☐	Doc. number of the netting document clearing the item/cycle
32	CLRNO5	OIAQB	CLRNO5		☐	OIA_CLRNO	☐	Doc. number of the netting document clearing the item/cycle
33	CLRNO6	OIAQB	CLRNO6		☐	OIA_CLRNO	☐	Doc. number of the netting document clearing the item/cycle
34	CLRNO7	OIAQB	CLRNO7		☐	OIA_CLRNO	☐	Doc. number of the netting document clearing the item/cycle
35	CLRNO8	OIAQB	CLRNO8		☐	OIA_CLRNO	☐	Doc. number of the netting document clearing the item/cycle
36	CLRNO9	OIAQB	CLRNO9		☐	OIA_CLRNO	☐	Doc. number of the netting document clearing the item/cycle

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in