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