SE11 ABAP Dictionary SE11 MSEG

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

MSEG

Document Segment: Material

SAP MM Transparent Table 193 Fields

Primary Key:

MANDT MBLNR MJAHR ZEILE

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	MBLNR	KEY	Mat. Doc.	CHAR	10	-	-	Number of Material Document
3	MJAHR	KEY	Mat. Year	NUMC	4	-	-	Material Document Year
4	ZEILE	KEY	Item	NUMC	4	-	-	Item in Material Document
5	LINE_ID	-	ID	NUMC	6	-	-	Unique identification of document line
6	PARENT_ID	-	PID	NUMC	6	-	-	Identifier of immediately superior line
7	LINE_DEPTH	-	Lvl	NUMC	2	-	-	Hierarchy level of line in document
8	BWART	-	Mvmt Type	CHAR	3	-	-	Movement Type (Inventory Management)
9	XAUTO	-	Auto.creat	CHAR	1	-	-	Item automatically created
10	MATNR	-	Material	CHAR	18	-	MARA	Material Number
11	WERKS	-	Plant	CHAR	4	-	T001W	Plant
12	LGORT	-	Stor. Loc.	CHAR	4	-	T001L	Storage Location
13	CHARG	-	Batch	CHAR	10	-	-	Batch Number
14	INSMK	-	Stock Type	CHAR	1	-	-	Stock Type
15	ZUSCH	-	Stat.ky	CHAR	1	-	-	Batch status key
16	ZUSTD	-	Restricted	CHAR	1	-	-	Batch in Restricted-Use Stock
17	SOBKZ	-	Spec.Stock	CHAR	1	-	-	Special Stock Indicator
18	LIFNR	-	Vendor	CHAR	10	-	LFA1	Vendor Account Number
19	KUNNR	-	Customer	CHAR	10	-	KNA1	Account Number of Customer
20	KDAUF	-	Sales Ord.	CHAR	10	-	-	Sales Order Number
21	KDPOS	-	SO Item	NUMC	6	-	-	Item Number in Sales Order
22	KDEIN	-	SO Sched.	NUMC	4	-	-	Delivery Schedule for Sales Order
23	PLPLA	-	Distribut.	CHAR	10	-	-	Distribution of Differences
24	SHKZG	-	D/C indic.	CHAR	1	-	-	Debit/Credit Indicator
25	WAERS	-	Currency	CUKY	5	-	TCURC	Currency Key
26	DMBTR	-	Amount LC	CURR	13	2	-	Amount in Local Currency
27	BNBTR	-	Del. costs	CURR	13	2	-	Delivery costs in local currency
28	BUALT	-	Amount	CURR	13	2	-	Amount posted in alternative price control
29	SHKUM	-	D/C reval.	CHAR	1	-	-	Debit/credit indicator in revaluation
30	DMBUM	-	Reval.	CURR	13	2	-	Revaluation amount on back-posting to a previous period
31	BWTAR	-	Val. Type	CHAR	10	-	-	Valuation Type
32	MENGE	-	Quantity	QUAN	13	3	-	Quantity
33	MEINS	-	Unit	UNIT	3	-	-	Base Unit of Measure
34	ERFMG	-	Qty in UnE	QUAN	13	3	-	Quantity in Unit of Entry
35	ERFME	-	Entry Unit	UNIT	3	-	-	Unit of Entry
36	BPMNG	-	Qty OPUn	QUAN	13	3	-	Quantity in Purchase Order Price Unit
37	BPRME	-	OrderPr.Un	UNIT	3	-	-	Order Price Unit (Purchasing)
38	EBELN	-	PO	CHAR	10	-	EKKO	Purchase Order Number
39	EBELP	-	Item	NUMC	5	-	-	Item Number of Purchasing Document
40	LFBJA	-	FiscYrRefD	NUMC	4	-	-	Fiscal Year of a Reference Document
41	LFBNR	-	Ref. Doc.	CHAR	10	-	-	Document No. of a Reference Document
42	LFPOS	-	Item	NUMC	4	-	-	Item of a Reference Document
43	SJAHR	-	Mat. Year	NUMC	4	-	-	Material Document Year
44	SMBLN	-	Mat. Doc.	CHAR	10	-	-	Number of Material Document
45	SMBLP	-	Item	NUMC	4	-	-	Item in Material Document
46	ELIKZ	-	Del. Cmpl.	CHAR	1	-	-	"Delivery Completed" Indicator
47	SGTXT	-	Text	CHAR	50	-	-	Item Text
48	EQUNR	-	Equipment	CHAR	18	-	-	Equipment Number
49	WEMPF	-	Recipient	CHAR	12	-	-	Goods Recipient/Ship-To Party
50	ABLAD	-	Unl. Point	CHAR	25	-	-	Unloading Point
51	GSBER	-	Bus. Area	CHAR	4	-	-	Business Area
52	KOKRS	-	CO Area	CHAR	4	-	-	Controlling Area
53	PARGB	-	Tr.part.BA	CHAR	4	-	-	Trading partner's business area
54	PARBU	-	Clr.CoCode	CHAR	4	-	-	Clearing company code
55	KOSTL	-	Cost Ctr	CHAR	10	-	-	Cost Center
56	PROJN	-	not in use	CHAR	16	-	-	Old: Project number : No longer used --> PS_POSNR
57	AUFNR	-	Order	CHAR	12	-	-	Order Number
58	ANLN1	-	Asset	CHAR	12	-	-	Main Asset Number
59	ANLN2	-	Subnumber	CHAR	4	-	-	Asset Subnumber
60	XSKST	-	CCtr stat.	CHAR	1	-	-	Indicator: Statistical posting to cost center
61	XSAUF	-	Or stat.	CHAR	1	-	-	Indicator: Posting to order is statistical
62	XSPRO	-	ProjStat	CHAR	1	-	-	Indicator: Posting to project is statistical
63	XSERG	-	PrA stat	CHAR	1	-	-	Indicator: Posting to prof.analysis is statistical
64	GJAHR	-	Fiscal Yr	NUMC	4	-	-	Fiscal Year
65	XRUEM	-	Post to PP	CHAR	1	-	-	Allow Posting to Previous Period (Backposting)
66	XRUEJ	-	PstToPrvYr	CHAR	1	-	-	Indicator: post to previous year
67	BUKRS	-	CoCode	CHAR	4	-	T001	Company Code
68	BELNR	-	DocumentNo	CHAR	10	-	-	Accounting Document Number
69	BUZEI	-	Item	NUMC	3	-	-	Number of Line Item Within Accounting Document
70	BELUM	-	DocumentNo	CHAR	10	-	-	Accounting Document Number
71	BUZUM	-	Item	NUMC	3	-	-	Number of Line Item Within Accounting Document
72	RSNUM	-	Reserv.No.	NUMC	10	-	-	Number of Reservation/Dependent Requirement
73	RSPOS	-	Item	NUMC	4	-	-	Item Number of Reservation/Dependent Requirement
74	KZEAR	-	Fin.Iss	CHAR	1	-	-	Final Issue for This Reservation
75	PBAMG	-	Quantity	QUAN	13	3	-	Quantity
76	KZSTR	-	Stat.relev	CHAR	1	-	-	Transaction/event is relevant to statistics
77	UMMAT	-	Rec. Mat.	CHAR	18	-	-	Receiving/Issuing Material
78	UMWRK	-	Rec. Plant	CHAR	4	-	-	Receiving/Issuing Plant
79	UMLGO	-	Rec. SLoc.	CHAR	4	-	-	Receiving/Issuing Storage Location
80	UMCHA	-	Rec. Batch	CHAR	10	-	-	Receiving/Issuing Batch
81	UMZST	-	Restricted	CHAR	1	-	-	Status of Transfer Batch
82	UMZUS	-	StKyTfBtch	CHAR	1	-	-	Status key of transfer batch
83	UMBAR	-	Val. Type	CHAR	10	-	-	Valuation Type of Transfer Batch
84	UMSOK	-	Stock Tfr	CHAR	1	-	-	Special Stock Indicator for Physical Stock Transfer
85	KZBEW	-	Mvt ind.	CHAR	1	-	-	Movement Indicator
86	KZVBR	-	Consumpt.	CHAR	1	-	-	Consumption Posting
87	KZZUG	-	Receipt	CHAR	1	-	-	Receipt Indicator
88	WEUNB	-	GR Non-Val	CHAR	1	-	-	Goods Receipt, Non-Valuated
89	PALAN	-	Pallets	DEC	11	-	-	WMS Number of pallets
90	LGNUM	-	Whse No.	CHAR	3	-	-	Warehouse Number / Warehouse Complex
91	LGTYP	-	Stge Type	CHAR	3	-	-	Storage Type
92	LGPLA	-	StorageBin	CHAR	10	-	-	Storage Bin
93	BESTQ	-	Stck.Cat.	CHAR	1	-	-	Stock Category in the Warehouse Management System
94	BWLVS	-	Mvmt Type	NUMC	3	-	-	Movement Type for Warehouse Management
95	TBNUM	-	TR No.	NUMC	10	-	-	Transfer Requirement Number
96	TBPOS	-	TR Item	NUMC	4	-	-	Transfer Requirement Item
97	XBLVS	-	WM	CHAR	1	-	-	Indicator: posting in warehouse management system
98	VSCHN	-	Int.st.pst	CHAR	1	-	-	Ind: interim storage posting for source stor.type and bin
99	NSCHN	-	Inter.dest	CHAR	1	-	-	Ind.: interim storage posting for dest.stor.type and bin
100	DYPLA	-	Dyn. bin	CHAR	1	-	-	Indicator: dynamic storage bin
101	UBNUM	-	Post.Ch.No	NUMC	10	-	-	Posting Change Number
102	TBPRI	-	Trfr Prio.	CHAR	1	-	-	Transfer Priority
103	TANUM	-	TO Number	NUMC	10	-	-	Transfer Order Number
104	WEANZ	-	No. of GR	NUMC	3	-	-	Number of GR/GI Slips to Be Printed
105	GRUND	-	Reason	NUMC	4	-	-	Reason for Movement
106	EVERS	-	Shipping	CHAR	2	-	-	Shipping Instructions
107	EVERE	-	Compliance	CHAR	2	-	-	Compliance with Shipping Instructions
108	IMKEY	-	RE Key	CHAR	8	-	-	Internal Key for Real Estate Object
109	KSTRG	-	CostObject	CHAR	12	-	-	Cost Object
110	PAOBJNR	-	Prof.Segmt	NUMC	10	-	-	Profitability Segment Number (CO-PA)
111	PRCTR	-	Profit Ctr	CHAR	10	-	-	Profit Center
112	PS_PSP_PNR	-	WBS Elem.	NUMC	8	-	-	Work Breakdown Structure Element (WBS Element)
113	NPLNR	-	Network	CHAR	12	-	-	Network Number for Account Assignment
114	AUFPL	-	Plan no.	NUMC	10	-	-	Routing number of operations in the order
115	APLZL	-	Counter	NUMC	8	-	-	Internal counter
116	AUFPS	-	Item No.	NUMC	4	-	-	Order Item Number
117	VPTNR	-	Partner	CHAR	10	-	-	Partner account number
118	FIPOS	-	Cmmt Item	CHAR	14	-	-	Commitment Item
119	SAKTO	-	G/L acct	CHAR	10	-	-	G/L Account Number
120	BSTMG	-	Qty OUn	QUAN	13	3	-	Goods receipt quantity in order unit
121	BSTME	-	Order Unit	UNIT	3	-	-	Purchase Order Unit of Measure
122	XWSBR	-	RevGR IR	CHAR	1	-	-	Reversal of GR allowed for GR-based IV despite invoice
123	EMLIF	-	Vendor	CHAR	10	-	-	Vendor to be supplied/who is to receive delivery
124	ZZSPREG	-	SpecREG	CHAR	5	-	-	Special Region
125	ZZBUSPARTN	-	Bus.partn.	CHAR	10	-	-	Business partner
126	ZZPRODUCT	-	ProductGrp	CHAR	10	-	-	Product group
127	ZZLOCA	-	City	CHAR	4	-	-	City
128	ZZCHAN	-	Dist. chan	CHAR	4	-	-	Distribution channel
129	ZZLOB	-	BUSINESS L	CHAR	7	-	-	BUSINESS LINE
130	ZZNFAL	-	ZZNFAL	CHAR	10	-	-
131	ZZUSERFLD1	-	Territory	CHAR	9	-	-	Territory
132	ZZUSERFLD2	-	Ownr/Cntr	CHAR	12	-	-	Owner/Cont.
133	ZZUSERFLD3	-	Vein	CHAR	22	-	-	Vein
134	ZZREGION	-	Location	CHAR	3	-	-	Location
135	ZZSTATE	-	State/Prov	CHAR	3	-	-	State/Province Code
136	EXBWR	-	ExtAmnt LC	CURR	13	2	-	Externally Entered Posting Amount in Local Currency
137	VKWRT	-	SV inc VAT	CURR	13	2	-	Value at Sales Prices Including Value-Added Tax
138	AKTNR	-	Promotion	CHAR	10	-	-	Promotion
139	ZEKKN	-	SqNoAccAss	NUMC	2	-	-	Sequential Number of Account Assignment
140	VFDAT	-	SLED/BBD	DATS	8	-	-	Shelf Life Expiration or Best-Before Date
141	CUOBJ_CH	-	IntObjNo.	NUMC	18	-	-	Internal object number of the batch classification
142	EXVKW	-	Sales Val.	CURR	13	2	-	Externally Entered Sales Value in Local Currency
143	PPRCTR	-	Partner PC	CHAR	10	-	-	Partner Profit Center
144	RSART	-	Rec. type	CHAR	1	-	-	Record type
145	GEBER	-	Fund	CHAR	10	-	-	Fund
146	FISTL	-	Funds Ctr	CHAR	16	-	-	Funds Center
147	MATBF	-	Material	CHAR	18	-	-	Material in Respect of Which Stock is Managed
148	UMMAB	-	Rec. Mat.	CHAR	18	-	-	Receiving/Issuing Material
149	BUSTM	-	Qty string	CHAR	4	-	-	Posting string for quantities
150	BUSTW	-	Value str.	CHAR	4	-	-	Posting string for values
151	MENGU	-	Qty update	CHAR	1	-	-	Quantity Updating in Material Master Record
152	WERTU	-	Val.Update	CHAR	1	-	-	Value Update in Material Master Record
153	LBKUM	-	Val. stock	QUAN	13	3	-	Total valuated stock before the posting
154	SALK3	-	Total val.	CURR	13	2	-	Value of total valuated stock before the posting
155	VPRSV	-	Price ctrl	CHAR	1	-	-	Price control indicator
156	FKBER	-	Func. Area	CHAR	16	-	-	Functional Area
157	DABRBZ	-	Ref. Date	DATS	8	-	-	Reference Date for Settlement
158	VKWRA	-	SV w/o VAT	CURR	13	2	-	Value at sales prices excluding value-added tax
159	DABRZ	-	Ref. Date	DATS	8	-	-	Reference Date for Settlement
160	XBEAU	-	Autom. PO	CHAR	1	-	-	Purchase order created at time of goods receipt
161	LSMNG	-	DN Qty	QUAN	13	3	-	Quantity in Unit of Measure from Delivery Note
162	LSMEH	-	Del.NoteUn	UNIT	3	-	-	Unit of Measure From Delivery Note
163	KZBWS	-	Valuation	CHAR	1	-	-	Valuation of Special Stock
164	QINSPST	-	GR Status	CHAR	1	-	-	Status of Goods Receipt Inspection
165	URZEI	-	OrigLneItm	NUMC	4	-	-	Original line in material document
166	J_1BEXBASE	-	Base amnt.	CURR	13	2	-	Alternate base amount in document currency
167	MWSKZ	-	Tax Code	CHAR	2	-	-	Sales Tax Code
168	TXJCD	-	Tax Jur.	CHAR	15	-	-	Tax Jurisdiction
169	EMATN	-	MPN Mat.	CHAR	18	-	-	Material Number Corresponding to Manufacturer Part Number
170	J_1AGIRUPD	-	GI-reval.	CHAR	1	-	-	Goods issue revaluation performed
171	VKMWS	-	Tax Code	CHAR	2	-	-	Sales Tax Code
172	HSDAT	-	Manuf. Dte	DATS	8	-	-	Date of Manufacture
173	BERKZ	-	Stg.Ind.	CHAR	1	-	-	Material Staging Indicator for Production Supply
174	MAT_KDAUF	-	Sales Ord.	CHAR	10	-	-	Sales Order Number of Valuated Sales Order Stock
175	MAT_KDPOS	-	SO item	NUMC	6	-	-	Sales Order Item of Valuated Sales Order Stock
176	MAT_PSPNR	-	WBS Elem.	NUMC	8	-	-	Valuated Sales Order Stock WBS Element
177	XWOFF	-	Value open	CHAR	1	-	-	Calculation of val. open
178	BEMOT	-	AcctIndic	CHAR	2	-	-	Accounting Indicator
179	PRZNR	-	BusProcess	CHAR	12	-	-	Business Process
180	LLIEF	-	Suppl.Vndr	CHAR	10	-	-	Supplying Vendor
181	LSTAR	-	Acty Type	CHAR	6	-	-	Activity Type
182	XOBEW	-	Vendor stk	CHAR	1	-	-	Vendor Stock Valuation Indicator
183	GRANT_NBR	-	Grant	CHAR	20	-	-	Grant
184	ZUSTD_T156M	-	StckTypMod	CHAR	1	-	-	Stock Type Modification (Read from Table T156M)
185	SPE_GTS_STOCK_TY	-	GTS Stock	CHAR	1	-	-	GTS Stock Type
186	/BEV2/ED_KZ_VER	-	ED Status	CHAR	1	-	-	Processing Status of Material Document for Excise Duties
187	/BEV2/ED_USER	-	User	CHAR	12	-	-	User Name
188	/BEV2/ED_AEDAT	-	Chngd	DATS	8	-	-	Changed On
189	/BEV2/ED_AETIM	-	Time	TIMS	6	-	-	Current Time of Application Server
190	DISUB_OWNER	-	Owner	CHAR	10	-	-	Owner of stock
191	OINAVNW	-	Non-deductible input tax	CURR	13	2	-	Non-deductible input tax
192	OICONDCOD	-	CondKey	CHAR	2	-	-	Joint Venture Indicator (Condition Key)
193	CONDI	-	CondKey	CHAR	2	-	-	Joint Venture Indicator (Condition Key)

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk MSEG.

Interactive ERD Diagrams

SAP MM - Goods Receipt Relation → SAP Procurement & MM Document Flow - MIRO Service PO Clearing →

Standard T-Codes

MIGO MB51 MB52 MMBE

Related Tables

MARA T001W T001L LFA1 KNA1 TCURC EKKO T001

ANSI SQL Query

SELECT a.MBLNR,
       a.MJAHR,
       a.ZEILE,
       a.LINE_ID,
       a.PARENT_ID,
       a.LINE_DEPTH,
       a.BWART
FROM MSEG AS a
WHERE a.MBLNR = '0001'
  AND a.MJAHR = '0001';

ABAP OpenSQL (7.40+)

SELECT a~mblnr,
       a~mjahr,
       a~zeile,
       a~line_id,
       a~parent_id,
       a~line_depth,
       a~bwart
  FROM mseg AS a
  WHERE a~mblnr = '0001'
  and a~mjahr = '0001'
  INTO TABLE @DATA(lt_mseg)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 MSEG

MSEG

Dictionary Fields Fields

Related References & SQL