cancel
Showing results for 
Search instead for 
Did you mean: 

finding material doc given delivery no ( without using VBFA table )

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Jelena
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

hi

try

MKPF Header: Material Document