OIAQA - Exchange Statement Print Requests
Exchange Statement Print Requests information is stored in SAP table OIAQA.
It is part of development package OIA in software component IS-OIL-DS-EXG. This development package consists of objects that can be grouped under "EXG Exchanges".
It is part of development package OIA in software component IS-OIL-DS-EXG. This development package consists of objects that can be grouped under "EXG Exchanges".
Fields for table OIAQA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
PREQNO | Exchange statement print request document number | X | OIA_PREQNO | CHAR | 20 | |
NETDOC | Movement-based netting document | OIA_NETDOC | CHAR | 2 | ||
PREQTYP | Exchange statement print request document type | OIA_PREQTY | CHAR | 8 | TVFK | |
EXGPTR | Exchange partner (vendor number) | OIA_EXGPTR | CHAR | 20 | LFA1 | |
VKORG | Sales Organization | VKORG | CHAR | 8 | TVKO | |
SPART | Division | SPART | CHAR | 4 | TSPA | |
VTWEG | Distribution Channel | VTWEG | CHAR | 4 | TVTW | |
WAERS | Currency for exchange statement | OIA_DWAERS | CUKY | 10 | TCURC | |
VEXGNUM | From exchange agreement number | OIA_VEXNUM | CHAR | 20 | OIA01 | |
BEXGNUM | To exchange agreement number | OIA_BEXNUM | CHAR | 20 | OIA01 | |
VEXGTYP | From exchange type | OIA_VEXTYP | CHAR | 8 | TOIA2 | |
BEXGTYP | To exchange type | OIA_BEXTYP | CHAR | 8 | TOIA2 | |
VMATREF | From mat. group reference for exchange balance reporting | OIA_VMATRF | CHAR | 40 | ||
BMATREF | To - mat. group reference for exchange balance reporting | OIA_BMATRF | CHAR | 40 | ||
VMATNR | From material number | OIA_VMATNR | CHAR | 80 | MARA | |
BMATNR | To material number | OIA_BMATNR | CHAR | 80 | MARA | |
VOIBASPROD | From base product number | OIA_VSBMAT | CHAR | 80 | ||
BOIBASPROD | To base product number | OIA_BSBMAT | CHAR | 80 | ||
VWERKS | From plant | OIA_VWERKS | CHAR | 8 | T001W | |
BWERKS | To plant | OIA_BWERKS | CHAR | 8 | T001W | |
VSPMON | From period to analyze - month | OIA_VSPMON | NUMC | 12 | ||
BSPMON | To period to analyze - month | OIA_BSPMON | NUMC | 12 | ||
VSPTAG | From period to analyze -daytime reference | OIA_VSPTAG | DATS | 16 | ||
BSPTAG | To period to analyze - day | OIA_BSPTAG | DATS | 16 | ||
VSPWOC | From period to analyze - week | OIA_VSPWOC | NUMC | 12 | ||
BSPWOC | To period to analyze - week | OIA_BSPWOC | NUMC | 12 | ||
VSPBUP | From period to analyze - posting period | OIA_VSPBUP | NUMC | 12 | ||
BSPBUP | To period to analyze - posting period | OIA_BSPBUP | NUMC | 12 | ||
DOCSTAT | Exchange - netting document status | OIA_DOCSTA | CHAR | 2 | ||
NJAHR | Fiscal Year | GJAHR | NUMC | 8 | ||
MAPPE | Session name | MAPPE | CHAR | 24 | ||
BICNT | Counter created batch inputs per netting document | OIA_BICNT | DEC | 4 | ||
NETBAL | Net balance check TOTAL | OIA_NETBAL | CURR | 7 | ||
.INCLUDE | OI0_ERDAT | 0 | ||||
ERDAT | Date on which the record was created | ERDAT | DATS | 16 | ||
ERTIM | Time of creation | OI0_ERTIM | TIMS | 12 | ||
ERNAM | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
AETIM | Time of day the record was changed | OI0_AETIM | TIMS | 12 | ||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
.INCLUDE | OIA_INVCYC_INV | 0 | ||||
OIINVCYC1 | Invoice cycle included indicator active (X/ ) | OIA_INCYCI | CHAR | 2 | ||
OIINVCYC2 | Invoice cycle included indicator active (X/ ) | OIA_INCYCI | CHAR | 2 | ||
OIINVCYC3 | Invoice cycle included indicator active (X/ ) | OIA_INCYCI | CHAR | 2 | ||
OIINVCYC4 | Invoice cycle included indicator active (X/ ) | OIA_INCYCI | CHAR | 2 | ||
OIINVCYC5 | Invoice cycle included indicator active (X/ ) | OIA_INCYCI | CHAR | 2 | ||
OIINVCYC6 | Invoice cycle included indicator active (X/ ) | OIA_INCYCI | CHAR | 2 | ||
OIINVCYC7 | Invoice cycle included indicator active (X/ ) | OIA_INCYCI | CHAR | 2 | ||
OIINVCYC8 | Invoice cycle included indicator active (X/ ) | OIA_INCYCI | CHAR | 2 | ||
OIINVCYC9 | Invoice cycle included indicator active (X/ ) | OIA_INCYCI | CHAR | 2 | ||
OIINCLIA | LIA included indicator (X/ ) | OIA_INCLIA | CHAR | 2 | ||
OIINCPFA | PFA included indicator (X/ ) | OIA_INCPFA | CHAR | 2 | ||
DISPME | Output unit of measure (for exchange and netting statement) | OIA_OUTMEI | UNIT | 6 | T006 | |
OIAMWOFI | Movements without financials indicator | OIA_MWOFI | CHAR | 2 | ||
OIABALAN | Include balances indicator | OIA_BALAN | CHAR | 2 | ||
_DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 |