Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Replacement to MSEG table

Former Member

‎2008 Apr 21 11:46 AM

0 Likes
856

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

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

Reply
1 REPLY 1
Read only

Jelena_Perfiljeva
Active Contributor

‎2008 Apr 21 10:06 PM

0 Likes
643

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