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