Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Index table for billing date in SD

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

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question