Sap Query Link Tables

[Former Member]

Hi,

I badly need your help..

How can I link Table LIPS to VBEP using SAP QUERY? I have join these two tables using key field VGBEL = VBELN and VGPOS=POSNR but database access takes too long..

I need to get Schedule line delivery date(VBEP- EDATU ) where ETENR = '0001' only.

Please help me!

Thanks!

[Former Member]

Hi ,

get VBFA also in this loop ? or else search for LDB.

check LDB <b>ALV</b>

Regards

Prabhu

Message was edited by: Prabhu Peram

[Former Member]

Hi Melissa,

Try writing a Query with maximum number of condition(Use all posible Keys). By doing so it would increase the performance.I once had a performance issue with table AFRU where i used the KEY fields in Select Condition to Overcome and had a significant increase in performance.

Regards,

Prashanth

[Former Member]

Hi,

I don't know how am I going to use table VBFA to get line schedule date..