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