topic Inner Join short dump in Application Development and Automation Discussions

Inner Join short dump

Former Member — Fri, 19 Jun 2009 08:47:53 GMT

Any ideas why the following code dumps? The fields in the type are of the same type as the database fields.

TYPES:

BEGIN OF gy_ratings,

objid TYPE hrobjid,

scale_id LIKE t77tp-scale_id,

stext LIKE t77ts-stext,

rating LIKE t77tp-rating,

pstext LIKE t77tp-pstext,

END OF gy_ratings.

Data:

gt_ratings TYPE TABLE OF gy_ratings,

SELECT h_{objid a}scale_id a_{rating a}pstext b~stext

FROM hrp1033 AS h

INNER JOIN t77tp AS a ON a_{scale_id = h}scale

INNER JOIN t77ts AS b ON b_{scale_id = h}scale

AND b_{langu = a}langu

INTO TABLE gt_ratings

WHERE h~plvar = g_plvar

AND h~otype = c_qk

AND a~langu = sy-langu.

Re: Inner Join short dump

Former Member — Fri, 19 Jun 2009 08:50:43 GMT

Hi,

What does your Short dump say?

And the order of selection of fields should be in the same order as they are declared

Regards,

Shailaja

Re: Inner Join short dump

Former Member — Fri, 19 Jun 2009 08:52:35 GMT

Hi ,

Try with this,

TYPES:

BEGIN OF gy_ratings,

objid TYPE hrobjid,

scale_id LIKE t77tp-scale_id,

stext LIKE t77ts-stext,

rating LIKE t77tp-rating,

pstext LIKE t77tp-pstext,

END OF gy_ratings.

Data:

gt_ratings TYPE TABLE OF gy_ratings,

SELECT h_{objid a}scale_id b_{stext a}rating a~pstext

FROM hrp1033 AS h

INNER JOIN t77tp AS a ON a_{scale_id = h}scale

INNER JOIN t77ts AS b ON b_{scale_id = h}scale

AND b_{langu = a}langu

INTO TABLE gt_ratings

WHERE h~plvar = g_plvar

AND h~otype = c_qk

AND a~langu = sy-langu.

Please let me know if you still face problem.

Thanks and regards,

rajeshwar

Re: Inner Join short dump

Former Member — Fri, 19 Jun 2009 08:53:39 GMT

Hi,

Please change your order of selection...

Re: Inner Join short dump

Former Member — Fri, 19 Jun 2009 08:53:54 GMT

The order change did the trick, didn't think it was something so simple! Thanks

Re: Inner Join short dump

Former Member — Fri, 19 Jun 2009 08:56:11 GMT

try to use

INTO CORRESPONDING FIELDS OF TABLE

Thanks

Re: Inner Join short dump

Former Member — Fri, 19 Jun 2009 08:58:36 GMT

sequence of fields RATINGS, PSTEXT and STEXT does not match in select statement and in the Internal table defined.

Modify the internal table as

TYPES:
BEGIN OF gy_ratings,
  objid TYPE hrobjid,
  scale_id LIKE t77tp-scale_id,
* stext LIKE t77ts-stext,  "Comment this field
  rating LIKE t77tp-rating,
  pstext LIKE t77tp-pstext,
  stext LIKE t77ts-stext,  "Add field here
END OF gy_ratings.

Hope it will work.