SAP ABAP Table OIA12I (Movement Based Netting document item)
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
Table Category | TRANSP | Transparent table |
Transparent table | OIA12I |
![]() |
Short Description | Movement Based Netting document item |
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 | CLNT | 3 | 0 | Client | * | |
2 | ![]() |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
3 | ![]() |
OIA_NETNUM | OIA_NETNUM | CHAR | 10 | 0 | Exchange - netting document number | ||
4 | ![]() |
OIA_ITNO | OIA_ITNO | NUMC | 5 | 0 | Exchange - netting document item number | ||
5 | ![]() |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
6 | ![]() |
SELKZ | SELKZ | CHAR | 1 | 0 | Selection flag | ||
7 | ![]() |
OIA_EXGNUM | OIA_EXGNUM | CHAR | 10 | 0 | Exchange agreement number | * | |
8 | ![]() |
OIA_ITCAT | OIA_MVTYPE | CHAR | 1 | 0 | Exchange - netting document item type | ||
9 | ![]() |
MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
10 | ![]() |
MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
11 | ![]() |
OIA_ITEM | OIA_ITEM | NUMC | 6 | 0 | Item number | ||
12 | ![]() |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
13 | ![]() |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
14 | ![]() |
EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
15 | ![]() |
EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
16 | ![]() |
VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
17 | ![]() |
POSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | * | |
18 | ![]() |
KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
19 | ![]() |
KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
20 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
21 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
22 | ![]() |
BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
23 | ![]() |
OIA_DMBTR1 | WERTV7 | CURR | 13 | 2 | Amount in local currency | ||
24 | ![]() |
OIA_WRBTR1 | WERTV7 | CURR | 13 | 2 | Amount in document currency | ||
25 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
26 | ![]() |
SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
27 | ![]() |
OIA_CLRNO | OIA_PREQNO | CHAR | 10 | 0 | Doc. number of the netting document clearing the item/cycle | ||
28 | ![]() |
OIA_SBMAT | MATNR | CHAR | 18 | 0 | Base product number | * | |
29 | ![]() |
OIA_BOMCON | OI0_SELKZ | CHAR | 1 | 0 | Indicator: BOM continuation item | ||
30 | ![]() |
OIA_CLRCYC | KREUZ | CHAR | 1 | 0 | Item already cleared in all cycles under process (X/ ) | ||
31 | ![]() |
OIA_MATREF | OIA_MATREF | CHAR | 20 | 0 | Material group reference for exchange balance reporting | ||
32 | ![]() |
0 | 0 | Origin, Destination, Trip and ex Batch No for Pipeline | |||||
33 | ![]() |
OID_PIPEV | X | CHAR | 1 | 0 | Validation indicator for pipeline fields (X=ON, blank=OFF) | ||
34 | ![]() |
LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
35 | ![]() |
0 | 0 | Destination/Origin: City,County,Region,Country + Tax | |||||
36 | ![]() |
OIC_DCITYC | CITYC | CHAR | 4 | 0 | Destination city code | T005G | |
37 | ![]() |
OIC_DCOUNC | COUNC | CHAR | 3 | 0 | Destination county code | T005E | |
38 | ![]() |
OIC_DREGIO | REGIO | CHAR | 3 | 0 | Destination region | T005S | |
39 | ![]() |
OIC_DLAND1 | LAND1 | CHAR | 3 | 0 | Destination country | T005 | |
40 | ![]() |
OIC_OCITYC | CITYC | CHAR | 4 | 0 | Origin city code | T005G | |
41 | ![]() |
OIC_OCOUNC | COUNC | CHAR | 3 | 0 | Origin county code | T005E | |
42 | ![]() |
OIC_OREGIO | REGIO | CHAR | 3 | 0 | Origin region | T005S | |
43 | ![]() |
OIC_OLAND1 | LAND1 | CHAR | 3 | 0 | Origin country | T005 | |
44 | ![]() |
OIC_PORGIN | OIC_PORGIN | CHAR | 15 | 0 | Tax origin | ||
45 | ![]() |
OIC_PDESTN | OIC_PDESTN | CHAR | 15 | 0 | Tax destination | ||
46 | ![]() |
OIC_PTRIP | OIC_PTRIP | CHAR | 16 | 0 | Pipeline trip number (external) | ||
47 | ![]() |
OIC_PBATCH | OIC_PBATCH | CHAR | 16 | 0 | Pipeline operator´s external batch number | ||
48 | ![]() |
OIC_MOT | VKTRA | CHAR | 2 | 0 | IS-OIL MAP external details mode of transport | TVTR | |
49 | ![]() |
OIC_AORGIN | OIC_PORGIN | CHAR | 15 | 0 | Alternate origin | ||
50 | ![]() |
OIC_ADESTN | OIC_PDESTN | CHAR | 15 | 0 | Alternate destination | ||
51 | ![]() |
OIC_TRUCKN | OIC_TRUCKN | CHAR | 10 | 0 | Truck number | ||
52 | ![]() |
OIA_BASELO | OIA_BASELO | CHAR | 15 | 0 | Base location | ||
53 | ![]() |
0 | 0 | External Bill of Lading and Misc. Deliv. No | |||||
54 | ![]() |
OID_EXTBOL | OID_EXTBOL | CHAR | 16 | 0 | External bill of lading | ||
55 | ![]() |
OID_MISCDL | OID_MISCDL | CHAR | 16 | 0 | Miscellaneous delivery number | ||
56 | ![]() |
OIA_OBAL | MENGV15 | QUAN | 15 | 3 | Opening exchange balance | ||
57 | ![]() |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
58 | ![]() |
OIA_QUAN | OIA_MENGE | QUAN | 13 | 3 | Movement quantity | ||
59 | ![]() |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * |
Foreign Keys
![]() |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
---|---|---|---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
1 | OIA12I | OIC_DCITYC | ![]() |
![]() |
|||
2 | OIA12I | OIC_DCOUNC | ![]() |
![]() |
|||
3 | OIA12I | OIC_DLAND1 | ![]() |
![]() |
|||
4 | OIA12I | OIC_DREGIO | ![]() |
![]() |
|||
5 | OIA12I | OIC_LIFNR | ![]() |
![]() |
|||
6 | OIA12I | OIC_MOT | ![]() |
![]() |
|||
7 | OIA12I | OIC_OCITYC | ![]() |
![]() |
|||
8 | OIA12I | OIC_OCOUNC | ![]() |
![]() |
|||
9 | OIA12I | OIC_OLAND1 | ![]() |
![]() |
|||
10 | OIA12I | OIC_OREGIO | ![]() |
![]() |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |