EWBEZ need to bring Sq01

[Former Member]

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

[Former Member]

Hi Experts

any suggestions .

[Former Member]

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...

[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 .

[raymond_giuseppi]

• 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

[Former Member]

hi Raemond ,

My Query is based on table EKKN , EKKO , AUFK and PRPS . I we need a report for PO and material  withExternal material Group and text so that Business can do reporting and its easy for user to understand what is E13 there.

Many Thanks

[raymond_giuseppi]

Problem in your code : you select data using a criteria from a local work area, si I suppose mara-EXTWG is always initial, do you also read data from EKPO ?

Regards,

Raymond

[Former Member]

NO I wasn't using table EKPO.

BUt i tried to Add EKPO and then Link with mara and theat link to TWET .

system is displaying data for some of purchasing group but not for the purachsing group  I want  to display

Mnay Thanks

[raymond_giuseppi]

Then How do you intend to fill the local field mara-EXTWG ?

[Former Member]

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

[PeterJonker]

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.