on 09-11-2008 1:59 PM
Dear friends ,
I need to find out material document no given delivery document no, using data base tables . Using VBFA table is ruled out due to performance issues .
What is the way to do this ?
Regards
Mahesh.
As an ABAPer, I can assure you that you will get much better performance with VBFA than with any other table. In VBFA you'll be searching by the VBELV and POSNV, which are the primary key. This should work quite fast, as long as the SELECT statement has been programmed correctly. I bet the poor performance has been caused by an inefficient SELECT statement. If you post the code fragment here, I might be able to suggest some improvements.
In MKPF you'll have to search by LE_VBELN field, which is not part of the primary key or any standard indexes. This will be very inefficient and I would not recommend that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
try
MKPF Header: Material Document
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.