09-18-2014 4:56 PM
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
09-19-2014 7:56 AM
09-19-2014 8: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...
09-19-2014 8:17 AM
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 .
09-19-2014 8:06 AM
Regards,
Raymond
09-19-2014 8:23 AM
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
09-19-2014 9:18 AM
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
09-19-2014 10:29 AM
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
09-19-2014 12:07 PM
09-19-2014 2:34 PM
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
09-19-2014 10: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.