OIAQA

Exchange Statement Print Requests | #masterdata | Component: Exchanges

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (7)
☰ Categorical (15)
Other (15)
🔗 Relations (16)

Column Name	Description
MANDT FK	Client
PREQNO	Exchange statement print request document number

Column Name	Description
💲 Currency Key (T001.WAERS):
NETBAL	Net balance check TOTAL

Column Name	Description

Column Name	Description
VSPTAG	From period to analyze -daytime reference
BSPTAG	To period to analyze - day
ERDAT	Date on which the record was created
ERTIM	Time of creation
AEDAT	Last Changed On
AETIM	Time of day the record was changed
_DATAAGING	Data Filter Value for Data Aging

Column Name	Description
NETDOC	Movement-based netting document	Show values
DOCSTAT	Exchange - netting document status	Show values
OIINVCYC1	Invoice cycle included indicator active (X/ )	Show values
OIINVCYC2	Invoice cycle included indicator active (X/ )	Show values
OIINVCYC3	Invoice cycle included indicator active (X/ )	Show values
OIINVCYC4	Invoice cycle included indicator active (X/ )	Show values
OIINVCYC5	Invoice cycle included indicator active (X/ )	Show values
OIINVCYC6	Invoice cycle included indicator active (X/ )	Show values
OIINVCYC7	Invoice cycle included indicator active (X/ )	Show values
OIINVCYC8	Invoice cycle included indicator active (X/ )	Show values
OIINVCYC9	Invoice cycle included indicator active (X/ )	Show values
OIINCLIA	LIA included indicator (X/ )	Show values
OIINCPFA	PFA included indicator (X/ )	Show values
OIAMWOFI	Movements without financials indicator	Show values
OIABALAN	Include balances indicator	Show values

Column Name	Description	Domain name
VMATREF	From mat. group reference for exchange balance reporting	OIA_MATREF
BMATREF	To - mat. group reference for exchange balance reporting	OIA_MATREF
VOIBASPROD	From base product number	MATNR
BOIBASPROD	To base product number	MATNR
VSPMON	From period to analyze - month	RSCALMONTH
BSPMON	To period to analyze - month	RSCALMONTH
VSPWOC	From period to analyze - week	MCPERIOD
BSPWOC	To period to analyze - week	MCPERIOD
VSPBUP	From period to analyze - posting period	MCPERIOD
BSPBUP	To period to analyze - posting period	MCPERIOD
NJAHR	Fiscal Year	GJAHR
MAPPE	Session name	MAPPE
BICNT	Counter created batch inputs per netting document	OIA_BICNT
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM

Master Data Relations	Join Conditions
To exchange agreement number To exchange agreement number Client	`OIAQA.BEXGNUM == OIA01.EXGNUM` `OIAQA.MANDT == OIA01.MANDT`
To exchange type	`OIAQA.MANDT == TOIA2.MANDT` `OIAQA.BEXGTYP == TOIA2.EXGTYP`
To material number To material number Client	`OIAQA.BMATNR == MARA.MATNR` `OIAQA.MANDT == MARA.MANDT`
To plant	`OIAQA.MANDT == T001W.MANDT` `OIAQA.BWERKS == T001W.WERKS`
Output unit of measure (for exchange and netting statement)	`OIAQA.MANDT == T006.MANDT` `OIAQA.DISPME == T006.MSEHI`
Exchange partner (vendor number)	`OIAQA.MANDT == LFA1.MANDT` `OIAQA.EXGPTR == LFA1.LIFNR`
Client	`OIAQA.MANDT == T000.MANDT`
Exchange statement print request document type	`OIAQA.MANDT == TVFK.MANDT` `OIAQA.PREQTYP == TVFK.FKART`
Distribution channel	`OIAQA.MANDT == TSPA.MANDT` `OIAQA.SPART == TSPA.SPART`
From exchange agreement number From exchange agreement number Client	`OIAQA.VEXGNUM == OIA01.EXGNUM` `OIAQA.MANDT == OIA01.MANDT`
From exchange type	`OIAQA.MANDT == TOIA2.MANDT` `OIAQA.VEXGTYP == TOIA2.EXGTYP`
Sales Organisation	`OIAQA.MANDT == TVKO.MANDT` `OIAQA.VKORG == TVKO.VKORG`
From material number From material number Client	`OIAQA.VMATNR == MARA.MATNR` `OIAQA.MANDT == MARA.MANDT`
Distribution Channel Distribution Channel Client	`OIAQA.VTWEG == TVTW.VTWEG` `OIAQA.MANDT == TVTW.MANDT`
From plant	`OIAQA.MANDT == T001W.MANDT` `OIAQA.VWERKS == T001W.WERKS`
Currency	`OIAQA.MANDT == TCURC.MANDT` `OIAQA.WAERS == TCURC.WAERS`