Skip to Content
avatar image
Former Member

EWBEZ need to bring Sq01

HI ,

I Have done below coding to get EWBEZ get in additional field i have defined.


data :mara-EXTWG like mara-EXTWG.
Clear : EXT_MATERIALGROUPTEXT.
SELECT single EWBEZ
into EXT_MATERIALGROUPTEXT
from TWEWT
where EXTWG = mara-EXTWG
and SPRAS = sy-langu.



But when I run query field is Blank .


Please help me .


Many Thnaks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Sep 19, 2014 at 07:01 AM

    Did you pass the vales in the selection screen...

    data : v_mara type maar-extwg.

    select-options : s_mara for v_mara.

    Clear : EXT_MATERIALGROUPTEXT.

    SELECT single EWBEZ

    into EXT_MATERIALGROUPTEXT

    from TWEWT

    where EXTWG in s_mara.

    and SPRAS = sy-langu.


    try this...


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for this its working but not giving correct result.

      I am getting Text of group but only The First text .

      So with Eg :

      If my Po Material has E11 the text is PUblication

      if PO material has E13 then ALso Publication

      Many Thnaks .

      Please help me more .

  • avatar image
    Former Member
    Sep 19, 2014 at 06:56 AM

    Hi Experts

    any suggestions .

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 19, 2014 at 07:06 AM
    • Do you read MARA in your dataset (SQ02), cause were you required to (re ?)define a work field for MARA-EXTWG
    • Why do you add a text field, wouldn't SAP Query append it itself ?

    Regards,

    Raymond

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Raymond Giuseppi

      I have added mara table to query but till not getting correct data .

      Is there is another way to fill this filed without having Mara table in Query . As I donot need mara table

  • Sep 19, 2014 at 09:39 AM

    You are defining data :mara-EXTWG like mara-EXTWG.

    and then you use this in your select, but it will be empty. I do not see it getting filled anywhere.

    Add comment
    10|10000 characters needed characters exceeded