topic Select Single in Application Development and Automation Discussions

Select Single

Kishore_ — Fri, 09 Mar 2012 08:40:28 GMT

Hi All,

I'm using select single matnr werks into (lv_matnr, lv_werks) from marc where matnr = matnr.

While executing it showing dump error.

I know to use workarea or table but i need to achieve in this way.If i use single field(matnr) its working fine.

Can you suggest

Regards

Kishore

Re: Select Single

rnb86 — Fri, 09 Mar 2012 08:47:43 GMT

HI,

check how the variable LV_WERKS is defined.

It can be defined in 2 ways:

data lv_werks type werks_d.

data lv_werks type mard-werks.

Re: Select Single

Former Member — Fri, 09 Mar 2012 08:48:31 GMT

Hi,

make sure that lv_werks is of type WERKS_D, not of type WERKS ....

Regards,

Klaus

Re: Select Single

Former Member — Fri, 09 Mar 2012 08:48:56 GMT

Hi,

Please debug and check at what line system is giving a dump error. I think you have created structures lv_matnr and lv_werks in case of variables or the target datatypes must be different. Also you shall not get single record with matnr in MARC table. You also need to give werks for selecting a unique record. Try this.


TYPES: BEGIN OF ty_marc,
       matnr TYPE marc-matnr,
       werks TYPE marc-werks,
       END OF ty_marc.

DATA: wa_marc TYPE ty_marc.

SELECT SINGLE matnr werks
  FROM marc
  INTO wa_marc
  WHERE matnr EQ p_matnr
  AND   werks EQ p_werks.
IF sy-subrc NE 0.
  MESSAGE 'No Data' TYPE 'S' DISPLAY LIKE 'E'.
  LEAVE LIST-PROCESSING.
ENDIF.

Regards,

Danish.

Re: Select Single

Former Member — Fri, 09 Mar 2012 08:49:22 GMT

For single matnr there are multiple werks in MARC .. so what werks u want to select ????

I have tried with your code but did not found any issue

data : lv_matnr type MATNR,
      lv_werks type WERKS_D.
select single matnr werks
  into (lv_matnr,lv_werks)
  from marc where matnr = '000000000013723112'.
  write  : lv_matnr, lv_werks.

Re: Select Single

former_member16553 — Fri, 09 Mar 2012 08:49:39 GMT

Can you please share the dump error you got.

Thanks

Girdhari

Re: Select Single

Kishore_ — Fri, 09 Mar 2012 09:04:44 GMT

Solved Thanks