Hi All,
I'm working on one issue where same sql only for 1 record working fine on quality server but giving dump on production server..i'm unable to check the sap dump as it's on client server...
Can this is related something to Mass data in production server?
GV_QLIST = 'BSEGBELNR BSEGGJAHR BKPF~BUKRS'
GV_QFROM = 'BSEG'.
GV_QWHERE = ''.
SELECT (gv_qlist) FROM (gv_qfrom)
INTO CORRESPONDING FIELDS OF TABLE <itab> UP TO 1 ROWS
WHERE (gv_qwhere).
Regards,
Anuj jain
Hi,
BKPF-BUKRS is not in BSEG, you should use BSEGBUKRS.
The empty WHERE-clause may also be a problem! You can use WHERE-option GJAHR > 0" for example.
Regards,
Klaus
Edited by: Klaus Babl on Apr 27, 2011 9:27 AM
Hi,
U have to use inner join here as u are selecting from two tables BSEG and BKPF.
check the correct query.,
GV_QLIST = 'BSEGBELNR BSEGGJAHR BKPF~BUKRS'
GV_QFROM = 'BSEG'.
GV_QFROM1 = 'BKPF'.
GV_QWHERE = ''.
SELECT (gv_qlist) FROM (gv_qfrom)
INNERJOIN (gv_qfrom1) on <common field>
INTO CORRESPONDING FIELDS OF TABLE <itab> UP TO 1 ROWS
WHERE (gv_qwhere).
or change BKPFBUKRS to BSEGBUKRS in GV_QLIST = 'BSEGBELNR BSEGGJAHR BKPF~BUKRS'
hope this helps.,
Thanks & Regards
Kiran
Sorry guys,
This was just a writing mistake
Actual sql is
GV_QLIST = 'BSEGBELNR BSEGGJAHR BSEG~BUKRS'
GV_QFROM = 'BSEG'.
GV_QWHERE = ''. means no value in where clause
SELECT (gv_qlist) FROM (gv_qfrom)
INTO CORRESPONDING FIELDS OF TABLE <itab> UP TO 1 ROWS
WHERE (gv_qwhere).
and I have to use BSEG table without any inner join..... n remember this query is working fine in Quality server but not in Production.
Regards,
Anuj jain
Dear Klaus,
Dynamic internal table has right structure and all three fields are key fields of bseg which must be present in all server and important thing this is working on quality server....
My Only one concern is suppose if table BSEG has a very very huge data in production server but still in this case it should not me give time_out or any database dump for getting only one record.
Regards,
Anuj jain
Anuj,
as the production users to send you the screen dump, dont reach to any kind of conclusion without looking at the dump,
I can see many reasons of DUMP.
Can be tim out,
Can be because of the Empty where clause. etc etc...
can even be because the buffer is full
So first check the DUMP.. then it wll be very easy to analyse..
Add a comment