topic Re: Read MSEG based on EBELN / EBELP in Application Development and Automation Discussions

Read MSEG based on EBELN / EBELP

Former Member — Thu, 04 Oct 2012 07:18:41 GMT

Hi Experts,

Is there any function module available which reads the purchase order data and returns the relevent informations from MSEG table. I am getting a timeout dump while selecting from MSEG table. Is it a better option to create an index?

Thanks and regards,

Atanu

Re: Read MSEG based on EBELN / EBELP

RaymondGiuseppi — Thu, 04 Oct 2012 07:30:30 GMT

If there is no index on material movements (MSEG) by purchase order (EBELN/EBELP) active on your system (Is MSEG~B active), you could try to use history table per purchase document (EKBE) selecting material movements via a complementary selection on field Transaction/event type (EKBE-VGABE) - With some luck there will be enough information to fulfill you requirement without actually reading material movements.

(There is not much chance that a FM will perform better than a direct OPEN-SQL statement...)

Regards,

Raymond

Re: Read MSEG based on EBELN / EBELP

Former Member — Thu, 04 Oct 2012 07:31:34 GMT

try table: EKBE, u can pass PO number and PO item, get Number of Material Document and item.

Re: Read MSEG based on EBELN / EBELP

sandeep_katoch — Thu, 04 Oct 2012 07:39:55 GMT

Hi Atanu,

Please check these threads

http://scn.sap.com/thread/1435793

http://scn.sap.com/thread/754875

Hope this solves or atleast gives you some insight regarding your problem

Rgds,

Sandeep Katoch

Re: Read MSEG based on EBELN / EBELP

Former Member — Thu, 04 Oct 2012 07:58:29 GMT

Thanks Raymond and Bipin. EKBE will be a good option other that creating index. I have rewarded you points.

Thanks and regards,

Atanu