Skip to Content
0
Former Member
Oct 03, 2008 at 06:41 AM

Index table for billing date in SD

36 Views

Hi,

I want to select records based on billing date as selection criteria. Right now i'm joining as below :

SELECT f1fplnr f1nfdat f1fkdat f1afdat f1fakwr f1fksaf

f2vbeln f2autte v1spart v1vkbur v1~objnr

FROM fplt AS f1

INNER JOIN fpla AS f2

ON f1fplnr EQ f2fplnr

INNER JOIN vbak AS v1

ON f2vbeln EQ v1vbeln

INTO CORRESPONDING FIELDS OF TABLE it_data1

WHERE f1~afdat IN so_fkdat AND

f1~fksaf NE space AND

f1~faksp EQ space AND

v1~auart IN (c_1, c_2) AND

v1~vkorg EQ c_vkorg AND

v1~vtweg EQ c_vtweg.

Performance wise this is very slow.

B'cz i didn't find any table based on biling date as index.

Kindly suggest me correct solution.

All correct answers will be definitely rewarded.

Regards,

S@meer

Edited by: Sameer Sharma on Oct 3, 2008 8:42 AM