topic Replacement to MSEG table in Application Development and Automation Discussions

Replacement to MSEG table

Former Member — Mon, 21 Apr 2008 10:46:04 GMT

HI,

The fields RSNUM and RSPOS are from the reservation table RESB. Based on these two fields I am fetching MBLNR MJAHR and ZEILE from MSEG table. But the select query is taking a lot of time. Could anyone please give me a replacement for MSEG Table .

Thanks,

Chinmaye

Re: Replacement to MSEG table

Jelena_Perfiljeva — Mon, 21 Apr 2008 21:06:15 GMT

You should avoid reading MSEG if you don't know the document number (MBLNR). Check if you can get to that number in table EKBE via table EKET. See this site for an illustration of how the tables are connected:

http://www.erpgenie.com/sap/abap/tables_mm.htm#Purchasing%20Tables