Read MSEG based on EBELN / EBELP

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

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

[Former Member]

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

Thanks and regards,

Atanu

[sandeep_katoch]

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