topic Re: Accessing material data through mseg in Application Development and Automation Discussions

Accessing material data through mseg

Former Member — Wed, 30 Jun 2010 08:19:43 GMT

Hi guys,

I have been working on a subcontracting Purchase Order. I have a problem that I want to access material information at the item level in the material tab under component button where that material exist. My data Exist at Mseg Table. But the problem is this that there is no Ebeln value exist in the Mseg table. Can someone tell me how to retrieve this material data from it.

Regards,

Zahid Hameed.

Re: Accessing material data through mseg

Sandeep_Panghal — Wed, 30 Jun 2010 08:29:11 GMT

Check EKKO-EBELN and MSEG-MBLNR.

Re: Accessing material data through mseg

Former Member — Wed, 30 Jun 2010 08:38:43 GMT

I already have told you that ebeln does not exist over there.

Re: Accessing material data through mseg

RaymondGiuseppi — Wed, 30 Jun 2010 08:42:43 GMT

Use table EKBE "History per Purchasing Document" which links EKKO/EKPO and MKPF/MSEG.

Regards,

Raymond

Re: Accessing material data through mseg

Former Member — Wed, 30 Jun 2010 08:53:41 GMT

Thnx,

My ebeln dosnt exist over there as well. I think I might have tell the Functional consultant to made another P.O for me.

if u have any other suggestion do tell me.

Thanks,

Zahid Hameed.

Re: Accessing material data through mseg

Former Member — Wed, 30 Jun 2010 10:19:50 GMT

Hi,

From table MSEG take field for Mat. Doc. - MBLNR

Place it in table EKBE for field BELNR.

In EKBE itself you'll find related EBELN.

Try this.

If not working please Reply with you Movement types. I'll give you another links.

Re: Accessing material data through mseg

Former Member — Wed, 30 Jun 2010 10:23:05 GMT

Hi guys ,

My functional Consultant have made another P.O but still I m not getting any data in any of the above mentioned tables. I m not getting any kind of data against Ebeln in the Mseg, Ekbe, or any other mentioned above tables plz help me out.

Regards,

Zahid Hameed.

Re: Accessing material data through mseg

Former Member — Wed, 30 Jun 2010 10:47:54 GMT

Check based upon fields MSEG-LFBNR (enter your PO number agaist this field) and BWART (enter your movement type under this)

Re: Accessing material data through mseg

Former Member — Wed, 30 Jun 2010 11:15:20 GMT

hi,

That's the problem brother. My ebeln is not exist in the whole table. I have tried all the above mentioned options but no success yet. It seems to be one material and then it consist of its components. e,g in my senario is this

under components overview.

header data under component view

material: 5000000271 "BATTERY 3.6V 2,1 AH

plant: 2000. Release Date: 15.06.2010

qunatity: 5.000: Delivery Date: 15.06.2010

Component Overview

material Mat. Deacription Qty

5000000034 (PVC) EMPELLER 6* FOR WATER PUMP 1

5000000041 ABRO TAPE 1* 2

5000000050 ACEESSORIES FOR ERECTION 3

__________________ ________________________________________ .__.___.___,___V

Regards,

Zahid Hameed.

Edited by: ZAHID HAMEED on Jun 30, 2010 6:06 PM

Re: Accessing material data through mseg

Former Member — Wed, 30 Jun 2010 13:40:39 GMT

hi gys,

Thnx for ur cooperation. TheTABLE for the component material is RESB. Here u will find ur required Material with ebeln.

Thnx every body,.

Regards,

Zahid Hameed.

Edited by: ZAHID HAMEED on Jun 30, 2010 6:55 PM

Edited by: ZAHID HAMEED on Jun 30, 2010 7:02 PM

Re: Accessing material data through mseg

kesavadas_thekkillath — Wed, 30 Jun 2010 14:09:32 GMT

Did you check table RESB

Sorry Im late

Edited by: Keshav.T on Jun 30, 2010 7:41 PM

Re: Accessing material data through mseg

Former Member — Tue, 13 Sep 2011 08:42:21 GMT

aswered