topic Re: Get material document by reservation number function in Application Development and Automation Discussions

Get material document by reservation number function

berkuamit — Sun, 28 Aug 2011 09:16:33 GMT

Hello,

I need to get material documents from MSEG table by RSNUM (I have RSPOS),

I know that there is an index on RSNUM so I can do simple select from this

table without being afraid of performance problems.

My question is, is there any standard function to do this operation ?

If not, is it safe enough to do what I'm tring to do ?

Thank you,

Kind Regards,

Amit B.

Re: Get material document by reservation number function

Former Member — Sun, 28 Aug 2011 13:47:03 GMT

HI,

The SELECT on MSEG using RSNUM, RSPOS, MJAHR and BWART can be used.

Regards

Re: Get material document by reservation number function

Former Member — Mon, 29 Aug 2011 09:28:08 GMT

To avoid the performance issues you need to include the primary key of table MSEG in your SELECT statement or you can use the secondary index for your SELECT Query.