Dear All,
I am getting this error.
Error in RSQL module of database interface. While i am giving the excise invoice date(j_1exchdr-exdat) more than 120 days i am getting this error.
SELECT VBRK~VBELN VBRK~FKART VBRK~WAERK VBRK~KNUMV VBRK~FKDAT VBRK~KURRF VBRK~KUNAG VBRK~FKSTO VBRP~POSNR VBRP~FKIMG VBRP~NETWR VBRP~VGBEL VBRP~MATNR VBRP~ARKTX VBRP~MATKL VBRP~WERKS VBRP~LGORT INTO CORRESPONDING FIELDS OF TABLE ITAB FROM VBRK INNER JOIN VBRP ON VBRK~VBELN = VBRP~VBELN WHERE VBRK~VBELN IN VBELN AND VBRK~FKART IN FKART AND VBRK~FKDAT IN FKDAT AND VBRK~FKSTO NE 'X' AND VBRP~MATKL IN MATKL AND VBRP~WERKS IN WERKS AND VBRP~LGORT IN LGORT.
what should i have to do? can i change this select query into selct for all entries what should i have to do?
Thanks,
Sankar M
What is the error exactly? Can you give short dump heading and section "error analysis" please.
Thomas
Dear Shankar,
Are you getting error only if date is gt 120 days??
if yes then
This is happening probably due to large number of data selection.Also you are not using primary index selection for both the tables.
Try selectiing data individually.select first from header table(vbrk) then use for all entries and select data from vbrp.
If you use primary key then only it will help to greater extent.
Also when you are using non primary key fields you should filter values which are less distinct.
for eg: WERKS is common for most of the entries so it should come first.
Check on the query if there is a missed ojbect from your structure .
Add a comment