10-03-2008 7:41 AM
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
10-03-2008 8:11 AM
create a index on fplt table based on date
hope this will help u
regards
sateesh