SAP ABAP Table OIASEE (Exchange Movements View for Exchange Statement)
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 INTTAB    Structure 
Structure OIASEE   Table Relationship Diagram
Short Description Exchange Movements View for Exchange Statement    
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 LOCTOTAL_F KWERT WERTV7 CURR 13   2   Condition Value  
2 SUBPRTOT_F KWERT WERTV7 CURR 13   2   Condition Value  
3 BASPRTOT_F KWERT WERTV7 CURR 13   2   Condition Value  
4 EXGTOTAL_F KWERT WERTV7 CURR 13   2   Condition Value  
5 EXGTOTSA_F KWERT WERTV7 CURR 13   2   Condition Value  
6 EXGTOTPU_F KWERT WERTV7 CURR 13   2   Condition Value  
7 EXGTOTFI_F KWERT WERTV7 CURR 13   2   Condition Value  
8 TYPETOT_F KWERT WERTV7 CURR 13   2   Condition Value  
9 BALANCE MENGE_D MENG13 QUAN 13   3   Quantity  
10 LOCTOTAL MENGE_D MENG13 QUAN 13   3   Quantity  
11 SUBPRTOTAL MENGE_D MENG13 QUAN 13   3   Quantity  
12 BASPRTOTAL MENGE_D MENG13 QUAN 13   3   Quantity  
13 MVTYPE OIA_MVTYPE OIA_MVTYPE CHAR 1   0   Movement type (in exchange statement)  
14 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
15 .INCLUDE       0   0   Document Segment: Material  
16 MANDT MANDT MANDT CLNT 3   0   Client *
17 MBLNR MBLNR BELNR CHAR 10   0   Number of Material Document  
18 MJAHR MJAHR GJAHR NUMC 4   0   Year of material document  
19 ZEILE MBLPO MBLPO NUMC 4   0   Item in material document  
20 .INCLUDE       0   0   Docmt Structure  
21 LINE_ID MB_LINE_ID MB_LINE_ID NUMC 6   0   Unique identification of document line  
22 PARENT_ID MB_PARENT_ID MB_LINE_ID NUMC 6   0   Identifier of immediately superior line  
23 LINE_DEPTH MB_LINE_DEPTH MB_LINE_DEPTH NUMC 2   0   Hierarchy level of line in document  
24 MAA_URZEI MAA_URZEI MBLPO NUMC 4   0   Original Line for Account Assignment Item in Material Doc.  
25 BWART BWART BWART CHAR 3   0   Movement type (inventory management) T156
26 XAUTO MB_XAUTO MB_XAUTO CHAR 1   0   Item automatically created  
27 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
28 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
29 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
30 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCHA
31 INSMK MB_INSMK MB_INSMK CHAR 1   0   Stock Type  
32 ZUSCH DZUSCH ZUSCH CHAR 1   0   Batch status key  
33 ZUSTD DZUSTD XFELD CHAR 1   0   Batch in Restricted-Use Stock  
34 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
35 LIFNR ELIFN LIFNR CHAR 10   0   Vendor's account number LFA1
36 KUNNR EKUNN KUNNR CHAR 10   0   Account number of customer KNA1
37 KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
38 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
39 KDEIN KDEIN NUM04 NUMC 4   0   Delivery schedule for sales order  
40 PLPLA PLPLA PLPLA CHAR 10   0   Distribution of Differences  
41 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
42 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
43 DMBTR DMBTR WERT7 CURR 13   2   Amount in local currency  
44 BNBTR BNBTR WERT13N CURR 13   2   Delivery costs in local currency  
45 BUALT BUALT WERTV7 CURR 13   2   Amount posted in alternative price control  
46 SHKUM SHKUM SHKZG CHAR 1   0   Debit/credit indicator in revaluation  
47 DMBUM DMBUM WERT7 CURR 13   2   Revaluation amount on back-posting to a previous period  
48 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type T149D
49 MENGE MENGE_D MENG13 QUAN 13   3   Quantity  
50 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
51 ERFMG ERFMG MENG13 QUAN 13   3   Quantity in unit of entry  
52 ERFME ERFME MEINS UNIT 3   0   Unit of entry T006
53 BPMNG BPMNG MENG13 QUAN 13   3   Quantity in order price quantity unit  
54 BPRME BBPRM MEINS UNIT 3   0   Order Price Unit (purchasing) T006
55 EBELN BSTNR EBELN CHAR 10   0   Purchase order number EKKO
56 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
57 LFBJA LFBJA GJAHR NUMC 4   0   Fiscal Year of a Reference Document  
58 LFBNR LFBNR BELNR CHAR 10   0   Document number of a reference document  
59 LFPOS LFPOS MBLPO NUMC 4   0   Item of a reference document  
60 SJAHR MJAHR GJAHR NUMC 4   0   Year of material document  
61 SMBLN MBLNR BELNR CHAR 10   0   Number of Material Document  
62 SMBLP MBLPO MBLPO NUMC 4   0   Item in material document  
63 ELIKZ ELIKZ XFELD CHAR 1   0   "Delivery Completed" Indicator  
64 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
65 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number *
66 WEMPF WEMPF WEMPF CHAR 12   0   Goods recipient  
67 ABLAD ABLAD TEXT25 CHAR 25   0   Unloading Point  
68 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
69 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
70 PARGB PARGB GSBER CHAR 4   0   Trading partner's business area TGSB
71 PARBU PARBU BUKRS CHAR 4   0   Clearing company code T001
72 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
73 PROJN PROJN PROJN CHAR 16   0   Old: Project number : No longer used --> PS_POSNR  
74 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
75 ANLN1 ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
76 ANLN2 ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
77 XSKST XSKST XFELD CHAR 1   0   Indicator: Statistical Posting to Cost Center  
78 XSAUF XSAUF XFELD CHAR 1   0   Indicator: Posting to Order Is Statistical  
79 XSPRO XSPRO XFELD CHAR 1   0   Indicator: Posting to Project Is Statistical  
80 XSERG XSERG XFELD CHAR 1   0   Indicator: Posting to Profitability Analysis Is Statistical  
81 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
82 XRUEM XRUEM XFELD CHAR 1   0   Allow Posting to Previous Period (Backposting)  
83 XRUEJ XRUEJ XFELD CHAR 1   0   Indicator: post to previous year  
84 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
85 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
86 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
87 BELUM BELNR_D BELNR CHAR 10   0   Accounting Document Number  
88 BUZUM BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
89 RSNUM RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements *
90 RSPOS RSPOS RSPOS NUMC 4   0   Item Number of Reservation / Dependent Requirements  
91 KZEAR KZEAR XFELD CHAR 1   0   Final issue for this reservation  
92 PBAMG MENGE_D MENG13 QUAN 13   3   Quantity  
93 KZSTR KZSTR KZSTR CHAR 1   0   Transaction/event is relevant to statistics  
94 UMMAT UMMAT MATNR CHAR 18   0   Receiving/issuing material MARA
95 UMWRK UMWRK WERKS CHAR 4   0   Receiving plant/issuing plant T001W
96 UMLGO UMLGO LGORT CHAR 4   0   Receiving/issuing storage location T001L
97 UMCHA UMCHA CHARG CHAR 10   0   Receiving/issuing batch MCHA
98 UMZST UMZST ZUSTD CHAR 1   0   Status of receiving batch  
99 UMZUS UMZUS ZUSCH CHAR 1   0   Status key of transfer batch  
100 UMBAR UMBAR BWTAR CHAR 10   0   Valuation type of transfer batch T149D
101 UMSOK UMSOK SOBKZ CHAR 1   0   Special stock indicator for physical stock transfer T148
102 KZBEW KZBEW KZBEW CHAR 1   0   Movement Indicator  
103 KZVBR KZVBR KZVBR CHAR 1   0   Consumption posting  
104 KZZUG KZZUG KZZUG CHAR 1   0   Receipt indicator  
105 WEUNB WEUNB XFELD CHAR 1   0   Goods Receipt, Non-Valuated  
106 PALAN PALAN PALAN DEC 11   0   WMS Number of pallets  
107 LGNUM LGNUM LGNUM CHAR 3   0   Warehouse Number / Warehouse Complex T300
108 LGTYP LGTYP LGTYP CHAR 3   0   Storage Type T301
109 LGPLA LGPLA LGPLA CHAR 10   0   Storage Bin LAGP
110 BESTQ BESTQ BESTQ CHAR 1   0   Stock Category in the Warehouse Management System  
111 BWLVS BWLVS BWLVS NUMC 3   0   Movement Type for Warehouse Management T333
112 TBNUM TBNUM TBNUM NUMC 10   0   Transfer Requirement Number LTBK
113 TBPOS TBPOS TBPOS NUMC 4   0   Transfer Requirement Item  
114 XBLVS XBLVS XFELD CHAR 1   0   Indicator: posting in warehouse management system  
115 VSCHN T333_VSCHN XFELD CHAR 1   0   Ind: interim storage posting for source stor.type and bin  
116 NSCHN T333_NSCHN XFELD CHAR 1   0   Ind.: interim storage posting for dest.stor.type and bin  
117 DYPLA DYPLA XFELD CHAR 1   0   Indicator: dynamic storage bin  
118 UBNUM UBNUM UBNUM NUMC 10   0   Posting Change Number  
119 TBPRI TBPRI TBPRI CHAR 1   0   Transfer Priority  
120 TANUM TANUM TANUM NUMC 10   0   Transfer Order Number  
121 WEANZ WEANZ NUM3 NUMC 3   0   Number of GR/GI slips to be printed  
122 GRUND MB_GRBEW MB_GRBEW NUMC 4   0   Reason for movement T157D
123 EVERS EVERS EVERS CHAR 2   0   Shipping Instructions T027A
124 EVERE EVERE EVERE CHAR 2   0   Compliance with Shipping Instructions T027C
125 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
126 KSTRG KSTRG KSTRG CHAR 12   0   Cost Object *
127 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
128 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
129 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
130 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment AUFK
131 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
132 APLZL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
133 AUFPS CO_POSNR CO_POSNR NUMC 4   0   Order item number  
134 VPTNR JV_PART KUNNR CHAR 10   0   Partner account number KNA1
135 FIPOS FIPOS FIPOS CHAR 14   0   Commitment Item FMFPO
136 SAKTO SAKNR SAKNR CHAR 10   0   G/L Account Number SKA1
137 BSTMG MB_BSTMG MENG13 QUAN 13   3   Goods receipt quantity in order unit  
138 BSTME BSTME MEINS UNIT 3   0   Order unit *
139 XWSBR XWSBR XFELD CHAR 1   0   Reversal of GR allowed for GR-based IV despite invoice  
140 EMLIF EMLIF LIFNR CHAR 10   0   Vendor to be supplied/who is to receive delivery *
141 .INCLUDE       0   0    
142 EXBWR EXBWR WERT7 CURR 13   2   Externally Entered Posting Amount in Local Currency  
143 VKWRT VKWRT WERT7 CURR 13   2   Value at sales prices including value-added tax  
144 AKTNR WAKTION WAKTION CHAR 10   0   Promotion *
145 ZEKKN DZEKKN NUM02 NUMC 2   0   Sequential Number of Account Assignment  
146 VFDAT VFDAT DATUM DATS 8   0   Shelf Life Expiration or Best-Before Date  
147 CUOBJ_CH CUOBJ_CH CUOBJ NUMC 18   0   Internal object number of the batch classification  
148 EXVKW EXVKW WERT7 CURR 13   2   Externally Entered Sales Value in Local Currency  
149 PPRCTR PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
150 RSART RSART RSART CHAR 1   0   Record type  
151 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
152 FISTL FISTL FISTL CHAR 16   0   Funds Center *
153 MATBF MATBF MATNR CHAR 18   0   Material in Respect of Which Stock is Managed *
154 UMMAB UMMAT MATNR CHAR 18   0   Receiving/issuing material *
155 BUSTM BUSTM BUSTM CHAR 4   0   Posting string for quantities  
156 BUSTW BUSTW BUSTW CHAR 4   0   Posting string for values  
157 MENGU MENGU XFELD CHAR 1   0   Quantity Updating in Material Master Record  
158 WERTU WERTU XFELD CHAR 1   0   Value Updating in Material Master Record  
159 LBKUM LBKUM_MSEG MENGV13 QUAN 13   3   Total valuated stock before the posting  
160 SALK3 SALK3_MSEG WERT13N CURR 13   2   Value of total valuated stock before the posting  
161 VPRSV VPRSV VPRSV CHAR 1   0   Price control indicator  
162 FKBER FKBER FKBER CHAR 16   0   Functional Area *
163 DABRBZ DABRBEZ DDAT DATS 8   0   Reference date for settlement  
164 VKWRA VKWRA WERT7 CURR 13   2   Value at sales prices excluding value-added tax  
165 DABRZ DABRBEZ DDAT DATS 8   0   Reference date for settlement  
166 XBEAU XBEAU XFELD CHAR 1   0   Purchase order created at time of goods receipt  
167 LSMNG LSMNG MENG13 QUAN 13   3   Quantity in Unit of Measure from Delivery Note  
168 LSMEH LSMEH MEINS UNIT 3   0   Unit of Measure From Delivery Note T006
169 KZBWS KZBWS KZBWS CHAR 1   0   Valuation of Special Stock  
170 QINSPST QINSPST QINSPST CHAR 1   0   Status of Goods Receipt Inspection  
171 URZEI URZEI MBLPO NUMC 4   0   Original line in material document  
172 J_1BEXBASE J_1BEXBASE WERT7 CURR 13   2   Alternate base amount in document currency  
173 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
174 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
175 EMATN EMATN MATNR CHAR 18   0   Material number corresponding to manufacturer part number *
176 J_1AGIRUPD J_1AGIRUPD J_1AGIRUPD CHAR 1   0   Goods issue revaluation performed  
177 VKMWS MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
178 HSDAT HSDAT DATUM DATS 8   0   Date of Manufacture  
179 BERKZ BERKZ LVS_BERKZ CHAR 1   0   Material Staging Indicator for Production Supply  
180 MAT_KDAUF MAT_KDAUF VBELN CHAR 10   0   Sales order number of valuated sales order stock *
181 MAT_KDPOS MAT_KDPOS NUM06 NUMC 6   0   Sales Order Item of Valuated Sales Order Stock  
182 MAT_PSPNR MAT_PSPNR PS_POSNR NUMC 8   0   Valuated customer stock WBS element *
183 XWOFF XWOFF XFELD CHAR 1   0   Calculation of val. open  
184 BEMOT BEMOT BEMOT CHAR 2   0   Accounting Indicator TBMOT
185 PRZNR CO_PRZNR CO_PRZNR CHAR 12   0   Business Process *
186 LLIEF LLIEF LIFNR CHAR 10   0   Supplying Vendor *
187 LSTAR LSTAR LSTAR CHAR 6   0   Activity Type *
188 XOBEW XOBEW XFELD CHAR 1   0   Vendor Stock Valuation Indicator  
189 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
190 ZUSTD_T156M BAMOK_MSEG BAMOK_MSEG CHAR 1   0   Stock Type Modification (Read from Table T156M)  
191 SPE_GTS_STOCK_TY /SPE/GTS_STOCK_TYPE /SPE/GTS_STOCK_TYPE CHAR 1   0   GTS Stock Type  
192 KBLNR KBLNR_FI KBLNR CHAR 10   0   Document number for earmarked funds *
193 KBLPOS KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item *
194 XMACC XMACC CHAR1 CHAR 1   0   Multiple Account Assignment  
195 VGART_MKPF VGART VGART CHAR 2   0   Transaction/Event Type *
196 BUDAT_MKPF BUDAT DATUM DATS 8   0   Posting Date in the Document  
197 CPUDT_MKPF CPUDT DATUM DATS 8   0   Accounting document entry date  
198 CPUTM_MKPF CPUTM UZEIT TIMS 6   0   Time of data entry  
199 USNAM_MKPF USNAM XUBNAME CHAR 12   0   User name *
200 XBLNR_MKPF XBLNR XBLNR CHAR 16   0   Reference Document Number  
201 TCODE2_MKPF TCODE TCODE CHAR 20   0   Transaction Code *
202 VBELN_IM VBELN_VL VBELN CHAR 10   0   Delivery *
203 VBELP_IM POSNR_VL POSNR NUMC 6   0   Delivery Item *
204 .INCLU--AP       0   0   Fields for Excise Duties in Material Document (MSEG)  
205 /BEV2/ED_KZ_VER /BEV2/EDKZ_VER /BEV2/EDKZ_VER CHAR 1   0   Processing Status of Material Document for Excise Duties  
206 /BEV2/ED_USER USNAM XUBNAME CHAR 12   0   User name *
207 /BEV2/ED_AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
208 /BEV2/ED_AETIM SYUZEIT SYTIME TIMS 6   0   System Time  
209 .INCLU--AP       0   0   Joint Venture Fields  
210 OINAVNW NAVNW WERT7 CURR 13   2   Non-deductible input tax  
211 OICONDCOD JV_CONDCOD JV_CONDCOD CHAR 2   0   Joint Venture Indicator (Condition Key) *
212 CONDI JV_CONDCOD JV_CONDCOD CHAR 2   0   Joint Venture Indicator (Condition Key) *
213 .INCLUDE       0   0   Customer defined fields for exchange Receipts Section  
214 PDUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
215 DOCTEXT OIA_TEXT TEXT20 CHAR 20   0   Text field  
216 SHIPDATE OIA_SHIP DATUM DATS 8   0   Shipping date  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIASEE ANLN1 ANLH ANLN1 REF C CN
2 OIASEE ANLN2 ANLA ANLN2 REF C CN
3 OIASEE AUFNR AUFK AUFNR REF C CN
4 OIASEE BEMOT TBMOT BEMOT    
5 OIASEE BPRME T006 MSEHI REF C CN
6 OIASEE BUKRS T001 BUKRS REF C CN
7 OIASEE BWART T156 BWART REF 1 CN
8 OIASEE BWLVS T333 BWLVS REF C CN
9 OIASEE BWTAR T149D BWTAR REF C CN
10 OIASEE CHARG MCHA CHARG REF C CN
11 OIASEE EBELN EKKO EBELN REF C CN
12 OIASEE EBELP EKPO EBELP REF C CN
13 OIASEE ERFME T006 MSEHI REF 1 N
14 OIASEE EVERE T027C EVERE    
15 OIASEE EVERS T027A EVERS    
16 OIASEE FIPOS FMFPO FIPOS REF C CN
17 OIASEE GRUND T157D GRUND REF C CN
18 OIASEE GSBER TGSB GSBER REF C CN
19 OIASEE KDAUF VBUK VBELN REF C CN
20 OIASEE KOKRS TKA01 KOKRS REF C CN
21 OIASEE KOSTL CSKS KOSTL REF C CN
22 OIASEE KUNNR KNA1 KUNNR REF C CN
23 OIASEE LGNUM T300 LGNUM REF C CN
24 OIASEE LGORT T001L LGORT REF C CN
25 OIASEE LGPLA LAGP LGPLA REF C CN
26 OIASEE LGTYP T301 LGTYP REF C CN
27 OIASEE LIFNR LFA1 LIFNR REF C CN
28 OIASEE LSMEH T006 MSEHI REF 1 N
29 OIASEE MATNR MARA MATNR REF C CN
30 OIASEE MEINS T006 MSEHI REF C CN
31 OIASEE MWSKZ T007A MWSKZ    
32 OIASEE NPLNR AUFK AUFNR REF 1 CN
33 OIASEE PARBU T001 BUKRS REF C CN
34 OIASEE PARGB TGSB GSBER REF C CN
35 OIASEE SAKTO SKA1 SAKNR REF C CN
36 OIASEE SOBKZ T148 SOBKZ REF C CN
37 OIASEE TBNUM LTBK TBNUM REF C CN
38 OIASEE TXJCD TTXJ TXJCD    
39 OIASEE UMBAR T149D BWTAR REF C CN
40 OIASEE UMCHA MCHA CHARG REF C CN
41 OIASEE UMLGO T001L LGORT REF C CN
42 OIASEE UMMAT MARA MATNR REF C CN
43 OIASEE UMSOK T148 SOBKZ REF C CN
44 OIASEE UMWRK T001W WERKS REF C CN
45 OIASEE VPTNR KNA1 KUNNR REF C CN
46 OIASEE WAERS TCURC WAERS REF 1 CN
47 OIASEE WERKS T001W WERKS REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in