SAP ABAP Table OIAQA (Exchange Statement Print Requests)
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
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIA (Package) Exg exchanges
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIAQA | Table Relationship Diagram |
Short Description | Exchange Statement Print Requests |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | PREQNO | OIA_PREQNO | OIA_PREQNO | CHAR | 10 | 0 | Exchange statement print request document number | ||
3 | NETDOC | OIA_NETDOC | XFELD | CHAR | 1 | 0 | Movement-based netting document | ||
4 | PREQTYP | OIA_PREQTY | FKART | CHAR | 4 | 0 | Exchange statement print request document type | TVFK | |
5 | EXGPTR | OIA_EXGPTR | LIFNR | CHAR | 10 | 0 | Exchange partner (vendor number) | LFA1 | |
6 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
7 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
8 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
9 | WAERS | OIA_DWAERS | WAERS | CUKY | 5 | 0 | Currency for exchange statement | TCURC | |
10 | VEXGNUM | OIA_VEXNUM | OIA_EXGNUM | CHAR | 10 | 0 | From exchange agreement number | OIA01 | |
11 | BEXGNUM | OIA_BEXNUM | OIA_EXGNUM | CHAR | 10 | 0 | To exchange agreement number | OIA01 | |
12 | VEXGTYP | OIA_VEXTYP | OIA_EXGTYP | CHAR | 4 | 0 | From exchange type | TOIA2 | |
13 | BEXGTYP | OIA_BEXTYP | OIA_EXGTYP | CHAR | 4 | 0 | To exchange type | TOIA2 | |
14 | VMATREF | OIA_VMATRF | OIA_MATREF | CHAR | 20 | 0 | From mat. group reference for exchange balance reporting | ||
15 | BMATREF | OIA_BMATRF | OIA_MATREF | CHAR | 20 | 0 | To - mat. group reference for exchange balance reporting | ||
16 | VMATNR | OIA_VMATNR | MATNR | CHAR | 18 | 0 | From material number | MARA | |
17 | BMATNR | OIA_BMATNR | MATNR | CHAR | 18 | 0 | To material number | MARA | |
18 | VOIBASPROD | OIA_VSBMAT | MATNR | CHAR | 18 | 0 | From base product number | * | |
19 | BOIBASPROD | OIA_BSBMAT | MATNR | CHAR | 18 | 0 | To base product number | * | |
20 | VWERKS | OIA_VWERKS | WERKS | CHAR | 4 | 0 | From plant | T001W | |
21 | BWERKS | OIA_BWERKS | WERKS | CHAR | 4 | 0 | To plant | T001W | |
22 | VSPMON | OIA_VSPMON | RSCALMONTH | NUMC | 6 | 0 | From period to analyze - month | ||
23 | BSPMON | OIA_BSPMON | RSCALMONTH | NUMC | 6 | 0 | To period to analyze - month | ||
24 | VSPTAG | OIA_VSPTAG | DATUM | DATS | 8 | 0 | From period to analyze -daytime reference | ||
25 | BSPTAG | OIA_BSPTAG | DATUM | DATS | 8 | 0 | To period to analyze - day | ||
26 | VSPWOC | OIA_VSPWOC | MCPERIOD | NUMC | 6 | 0 | From period to analyze - week | ||
27 | BSPWOC | OIA_BSPWOC | MCPERIOD | NUMC | 6 | 0 | To period to analyze - week | ||
28 | VSPBUP | OIA_VSPBUP | MCPERIOD | NUMC | 6 | 0 | From period to analyze - posting period | ||
29 | BSPBUP | OIA_BSPBUP | MCPERIOD | NUMC | 6 | 0 | To period to analyze - posting period | ||
30 | DOCSTAT | OIA_DOCSTA | OIA_DOCSTA | CHAR | 1 | 0 | Exchange - netting document status | ||
31 | NJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
32 | MAPPE | MAPPE | MAPPE | CHAR | 12 | 0 | Session name | ||
33 | BICNT | OIA_BICNT | OIA_BICNT | DEC | 6 | 0 | Counter created batch inputs per netting document | ||
34 | NETBAL | OIA_NETBAL | WERT7 | CURR | 13 | 2 | Net balance check TOTAL | ||
35 | .INCLUDE | 0 | 0 | Date, time and name of creation and change in txn-data | |||||
36 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
37 | ERTIM | OI0_ERTIM | UZEIT | TIMS | 6 | 0 | Time of creation | ||
38 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
39 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
40 | AETIM | OI0_AETIM | UZEIT | TIMS | 6 | 0 | Time of day the record was changed | ||
41 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
42 | .INCLUDE | 0 | 0 | Invoice cycle included indicator active 1-n (grouped) | |||||
43 | OIINVCYC1 | OIA_INCYCI | KREUZ | CHAR | 1 | 0 | Invoice cycle included indicator active (X/ ) | ||
44 | OIINVCYC2 | OIA_INCYCI | KREUZ | CHAR | 1 | 0 | Invoice cycle included indicator active (X/ ) | ||
45 | OIINVCYC3 | OIA_INCYCI | KREUZ | CHAR | 1 | 0 | Invoice cycle included indicator active (X/ ) | ||
46 | OIINVCYC4 | OIA_INCYCI | KREUZ | CHAR | 1 | 0 | Invoice cycle included indicator active (X/ ) | ||
47 | OIINVCYC5 | OIA_INCYCI | KREUZ | CHAR | 1 | 0 | Invoice cycle included indicator active (X/ ) | ||
48 | OIINVCYC6 | OIA_INCYCI | KREUZ | CHAR | 1 | 0 | Invoice cycle included indicator active (X/ ) | ||
49 | OIINVCYC7 | OIA_INCYCI | KREUZ | CHAR | 1 | 0 | Invoice cycle included indicator active (X/ ) | ||
50 | OIINVCYC8 | OIA_INCYCI | KREUZ | CHAR | 1 | 0 | Invoice cycle included indicator active (X/ ) | ||
51 | OIINVCYC9 | OIA_INCYCI | KREUZ | CHAR | 1 | 0 | Invoice cycle included indicator active (X/ ) | ||
52 | OIINCLIA | OIA_INCLIA | KREUZ | CHAR | 1 | 0 | LIA included indicator (X/ ) | ||
53 | OIINCPFA | OIA_INCPFA | KREUZ | CHAR | 1 | 0 | PFA included indicator (X/ ) | ||
54 | DISPME | OIA_OUTMEI | MEINS | UNIT | 3 | 0 | Output unit of measure (for exchange and netting statement) | T006 | |
55 | OIAMWOFI | OIA_MWOFI | OI0_SELKZ | CHAR | 1 | 0 | Movements without financials indicator | ||
56 | OIABALAN | OIA_BALAN | OI0_SELKZ | CHAR | 1 | 0 | Include balances indicator |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIAQA | BEXGNUM | OIA01 | EXGNUM | KEY | 1 | CN |
2 | OIAQA | BEXGTYP | TOIA2 | EXGTYP | KEY | 1 | CN |
3 | OIAQA | BMATNR | MARA | MATNR | REF | 1 | CN |
4 | OIAQA | BWERKS | T001W | WERKS | KEY | 1 | CN |
5 | OIAQA | DISPME | T006 | MSEHI | |||
6 | OIAQA | EXGPTR | LFA1 | LIFNR | KEY | 1 | CN |
7 | OIAQA | MANDT | T000 | MANDT | KEY | 1 | CN |
8 | OIAQA | PREQTYP | TVFK | FKART | KEY | 1 | CN |
9 | OIAQA | SPART | TSPA | SPART | REF | 1 | CN |
10 | OIAQA | VEXGNUM | OIA01 | EXGNUM | KEY | 1 | CN |
11 | OIAQA | VEXGTYP | TOIA2 | EXGTYP | KEY | 1 | CN |
12 | OIAQA | VKORG | TVKO | VKORG | REF | 1 | CN |
13 | OIAQA | VMATNR | MARA | MATNR | REF | 1 | CN |
14 | OIAQA | VTWEG | TVTW | VTWEG | REF | 1 | CN |
15 | OIAQA | VWERKS | T001W | WERKS | KEY | 1 | CN |
16 | OIAQA | WAERS | TCURC | WAERS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20050520 |
SAP Release Created in |