Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Index table for billing date in SD

Former Member
0 Kudos

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

1 REPLY 1

Former Member
0 Kudos

create a index on fplt table based on date

hope this will help u

regards

sateesh