Short Dump

[Former Member]

Hi,

I'm having a problem, i have a program that selects data from a join of the table mkpf with the table mseg. what appens is that when i select a material with more data it gives a short dump, and i don't know how to solve it. Any ideas? Next i'm going to put the code where the short dump is called:

SELECT mkpf_{mblnr mkpf}mjahr mkpf~budat

mkpf_{cputm mkpf}xblnr mkpf~xabln

mkpf_{bktxt mkpf}frbnr

mseg_{matnr mseg}werks mseg~mblnr

mseg_{zeile mseg}mjahr mseg~bwart

mseg_{lgort mseg}meins mseg~shkzg

mseg_{menge mseg}kunnr

INTO CORRESPONDING FIELDS OF TABLE t_aux_pt

FROM mkpf JOIN mseg ON

( mseg_{mblnr = mkpf}mblnr ) AND

( mseg_{mjahr = mkpf}mjahr )

WHERE budat < datamv-low

AND matnr IN mat

AND werks = centro

AND lgort IN depos

AND bwart IN tpomov

AND sobkz IN stkesp

AND shkzg = 'H'.

and the short dump is:

DBIF_RSQL_INVALID_RSQL

CX_SY_OPEN_SQL_DB

[Former Member]

Hi,

I'm having a problem, i have a program that selects data from a join of the table mkpf with the table mseg. what appens is that when i select a material with more data it gives a short dump, and i don't know how to solve it. Any ideas? Next i'm going to put the code where the short dump is called:

SELECT mkpf_{mblnr mkpf}mjahr mkpf~budat

mkpf_{cputm mkpf}xblnr mkpf~xabln

mkpf_{bktxt mkpf}frbnr

mseg_{matnr mseg}werks mseg~mblnr

mseg_{zeile mseg}mjahr mseg~bwart

mseg_{lgort mseg}meins mseg~shkzg

mseg_{menge mseg}kunnr

INTO CORRESPONDING FIELDS OF TABLE t_aux_pt

FROM mkpf JOIN mseg ON

( mseg_{mblnr = mkpf}mblnr ) AND

( mseg_{mjahr = mkpf}mjahr )

WHERE budat < datamv-low

AND matnr IN mat

AND werks = centro

AND lgort IN depos

AND bwart IN tpomov

AND sobkz IN stkesp

AND shkzg = 'H'.

and the short dump is:

DBIF_RSQL_INVALID_RSQL

CX_SY_OPEN_SQL_DB

[seshatalpasai_madala]

Hi,

Use SELECT ENDSELCT and use PACKAGE SIZE option to retrive the data in packets.

SELECT mkpf_{mblnr mkpf}mjahr mkpf~budat

mkpf_{cputm mkpf}xblnr mkpf~xabln

mkpf_{bktxt mkpf}frbnr

mseg_{matnr mseg}werks mseg~mblnr

mseg_{zeile mseg}mjahr mseg~bwart

mseg_{lgort mseg}meins mseg~shkzg

mseg_{menge mseg}kunnr

<b>APPENDING</b> CORRESPONDING FIELDS OF TABLE t_aux_pt <b>PACKAGE SIZE 500</b>

FROM mkpf JOIN mseg ON

( mseg_{mblnr = mkpf}mblnr ) AND

( mseg_{mjahr = mkpf}mjahr )

WHERE budat < datamv-low

AND matnr IN mat

AND werks = centro

AND lgort IN depos

AND bwart IN tpomov

AND sobkz IN stkesp

AND shkzg = 'H'.

ENDSELECT.

Regards,

Sesh

[Former Member]

Hallo,

This can be due to too many entries in a range table or select option.

select * from table where field in MAT.

If MAT has too many entries the DB will choke on it.

So try with Select .. Appending ..

Regards,

Vasanth

[Former Member]

check the declarations in the internal table t_aux_pt if they are compatible with those fields used in the SELECT statement

[Former Member]

Hi!

I think the date format, you give can be a problem in the WHERE condition.

Try comment out (with *) the some part of the code to see is it working now?

You can find the problem quickly.

Regards

Tamá

[Former Member]

I tried every solutions and the shortdump continues.

[Former Member]

Hi Ricardo,

Try replacing the code:

<b>WHERE matnr IN Mat</b>

with the following:

<b>FOR ALL ENTRIES IN mat

WHERE matnr EQ mat-low.</b>