SAP ABAP Table OI0BW_EXGMOVEMENTS_S (Transfer structure: Exchange material movements to BW)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_BW (Package) Oil/BW Business Information Warehouse (extractors,..)

Basic Data

Table Category	INTTAB	Structure
Structure	OI0BW_EXGMOVEMENTS_S	Table Relationship Diagram
Short Description	Transfer structure: Exchange material movements to BW

Delivery and Maintenance

Pool/cluster
Delivery Class
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	OIEXGPTR	☐	OIA_EXGPTR	LIFNR	CHAR	10	0	Exchange partner (vendor number)	*
2	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
3	SPMON	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
4	SPTAG	☐	RSCALDAY	DATUM	DATS	8	0	Calendar day
5	SPWOC	☐	RSCALWEEK	RSCALWEEK	NUMC	6	0	Calendar year / week
6	SPBUP	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
7	OIEXGNUM	☐	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	*
8	OIEXGTYP	☐	OIA_EXGTYP	OIA_EXGTYP	CHAR	4	0	Exchange type	*
9	OIMATREF	☐	OIA_MATREF	OIA_MATREF	CHAR	20	0	Material group reference for exchange balance reporting
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
11	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
12	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
13	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
14	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
15	ZEILE	☐	OIA_ITEM	OIA_ITEM	NUMC	6	0	Item number
16	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
17	ITEM_TYPE	☐	OIA_UPEITM	OIA_UPEITM	CHAR	1	0	LIA item type
18	OINETCYC	☐	OIA_NETCYC	ZAHLS	CHAR	1	0	Netting cycle (FI blocking indicator)	*
19	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
20	OIASTBW	☐	XSTBW	XFELD	CHAR	1	0	Reversal transaction type
21	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
22	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
23	OIVBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
24	OIPOSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
25	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
26	OIPIPEVAL	☐	OID_PIPEV	X	CHAR	1	0	Validation indicator for pipeline fields (X=ON, blank=OFF)
27	OIC_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
28	.INCLUDE	☐				0	0	Destination/Origin: City,County,Region,Country + Tax
29	OIC_DCITYC	☐	OIC_DCITYC	CITYC	CHAR	4	0	Destination city code	T005G
30	OIC_DCOUNC	☐	OIC_DCOUNC	COUNC	CHAR	3	0	Destination county code	T005E
31	OIC_DREGIO	☐	OIC_DREGIO	REGIO	CHAR	3	0	Destination region	T005S
32	OIC_DLAND1	☐	OIC_DLAND1	LAND1	CHAR	3	0	Destination country	T005
33	OIC_OCITYC	☐	OIC_OCITYC	CITYC	CHAR	4	0	Origin city code	T005G
34	OIC_OCOUNC	☐	OIC_OCOUNC	COUNC	CHAR	3	0	Origin county code	T005E
35	OIC_OREGIO	☐	OIC_OREGIO	REGIO	CHAR	3	0	Origin region	T005S
36	OIC_OLAND1	☐	OIC_OLAND1	LAND1	CHAR	3	0	Origin country	T005
37	OIC_PORGIN	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
38	OIC_PDESTN	☐	OIC_PDESTN	OIC_PDESTN	CHAR	15	0	Tax destination
39	OIC_PTRIP	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
40	OIC_PBATCH	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
41	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	*
42	OIC_AORGIN	☐	OIC_AORGIN	OIC_PORGIN	CHAR	15	0	Alternate origin
43	OIC_ADESTN	☐	OIC_ADESTN	OIC_PDESTN	CHAR	15	0	Alternate destination
44	OIC_TRUCKN	☐	OIC_TRUCKN	OIC_TRUCKN	CHAR	10	0	Truck number
45	OIA_BASELO	☐	OIA_BASELO	OIA_BASELO	CHAR	15	0	Base location
46	OID_EXTBOL	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
47	OID_MISCDL	☐	OID_MISCDL	OID_MISCDL	CHAR	16	0	Miscellaneous delivery number
48	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
49	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
50	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
51	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
52	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
53	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	*
54	BPMNG	☐	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
55	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	*
56	BSTMG	☐	MB_BSTMG	MENG13	QUAN	13	3	Goods receipt quantity in order unit
57	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
58	XWSBR	☐	XWSBR	XFELD	CHAR	1	0	Reversal of GR allowed for GR-based IV despite invoice
59	OIFEETOT	☐	OIA_FEETOT	OIA_FEETOT	CURR	13	2	Fee total
60	OIFEEPST	☐	OIA_FEEPST	OIA_FEEPST	CHAR	1	0	Posting rules for fees
61	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	*
62	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	*
63	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
64	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OI0BW_EXGMOVEMENTS_S	OIC_DCITYC	T005G	CITYC
2	OI0BW_EXGMOVEMENTS_S	OIC_DCOUNC	T005E	COUNC
3	OI0BW_EXGMOVEMENTS_S	OIC_DLAND1	T005	LAND1
4	OI0BW_EXGMOVEMENTS_S	OIC_DREGIO	T005S	BLAND
5	OI0BW_EXGMOVEMENTS_S	OIC_OCITYC	T005G	CITYC
6	OI0BW_EXGMOVEMENTS_S	OIC_OCOUNC	T005E	COUNC
7	OI0BW_EXGMOVEMENTS_S	OIC_OLAND1	T005	LAND1
8	OI0BW_EXGMOVEMENTS_S	OIC_OREGIO	T005S	BLAND

History

Last changed by/on	SAP	20110901
SAP Release Created in