topic Display single value in Application Development and Automation Discussions

Display single value

Former Member — Mon, 29 Sep 2008 07:08:59 GMT

HI ALL,

i have a prob in displaying the records

im fetching resords from MARDH table. the records which r there in my criteria has the follw . strct.

matnr plant stl loc. stock

001 xxx aa 15

001 xxx bb 5

i m getting these values but in internal table i just wat the values like tis,

matnr plant stock

001 xxx 20

i dont have ny thing to do with sto. loc.

plzz help me out..

thanxx

Re: Display single value

Former Member — Mon, 29 Sep 2008 07:11:15 GMT

After getting the whole data into internal table sumup the stock by means of MATNR.

Re: Display single value

Former Member — Mon, 29 Sep 2008 07:11:25 GMT

Hi,

Just avoid writing it with write statment.

Write: WA-A1,

WA-A2,

WA-A3.

in case of ALV dont include the field in the fieldcat.

santhosh

Re: Display single value

GauthamV — Mon, 29 Sep 2008 07:12:40 GMT

HI,

use AT NEW option for material and plant and do

sum based on it for ur stock.

Re: Display single value

Former Member — Mon, 29 Sep 2008 07:18:06 GMT

its not just a matter of displying the data i want the filtered data in the internal table with stock added...

can u tel me in details how to add sum by the beans of MATNR..? as replied above..

Re: Display single value

Former Member — Mon, 29 Sep 2008 07:22:44 GMT

Hi,

After fetching the data, loop at internal table and use COLLECT statement.

See F1 help for Collect.

Regards

Karthik D

Re: Display single value

former_member755502 — Mon, 29 Sep 2008 07:25:48 GMT

Hi,

First of all donot retrieve the "slt. loc" field, while you are populating the internal table. Then use COLLECT statment, it will solve your query. For help check technical help of COLLECT statement.

Thank you.

Re: Display single value

Former Member — Mon, 29 Sep 2008 07:46:29 GMT

the reply send by Mr . Ajay was..

After getting the whole data into internal table sumup the stock by means of MATNR

can u tell me how can i do this..?

thanxxx

Edited by: NILESH SHELKE on Sep 29, 2008 9:46 AM

Re: Display single value

Former Member — Mon, 29 Sep 2008 07:52:57 GMT

Hi,

1. Define the key to your internal table as matnr

2. Loop at the internal table after data selection and

3. use the collect statement to collect the data in another intarnal table of the same structure.

regards,

Advait

Re: Display single value

Former Member — Mon, 29 Sep 2008 08:06:09 GMT

I M writing in the simple words that,

i dont want the repeated data in the internal table itself just the unique matnr plant and the sum of stock for those matnr and plant.

so why to loop the internal table and to make it complicated...?????

Re: Display single value

Former Member — Mon, 29 Sep 2008 08:22:38 GMT

Hi NILESH SHELKE,

We can do like this,



  SELECT MATNR WERKS LGORT SUM( LABST ) FROM MARDH
         INTO TABLE GT_SUM GROUP BY MATNR WERKS LGORT.

Regards,

R.Nagarajan.

Re: Display single value

christine_evans — Mon, 29 Sep 2008 09:07:52 GMT


> I M writing in the simple words that,
> i dont want the repeated data in the internal table itself just the unique matnr plant and the sum of stock for those matnr and plant.
> so why to loop  the internal table and to make it complicated...?????

What is so complicated about doing a simple loop? The key word in that post and in a number of the others above is COLLECT, which is the standard way of summing values from an internal table via a loop; you then append the summary data to another itab.

Re: Display single value

Former Member — Mon, 29 Sep 2008 09:41:47 GMT

but it will be more easy if we have got the complete data as we required rather than collecting it & then rearranging or formatting it.

now if we have got the complete data in our internal table we can directly disply it...

Re: Display single value

Former Member — Tue, 30 Sep 2008 19:29:11 GMT


> its not just a matter of displying the data i want the filtered data in the internal table with stock added...
> can u tel me in details how to add sum by the beans of MATNR..? as replied  above..

You will get what you ask for.

regards,

Advait

Re: Display single value

Former Member — Wed, 22 Jul 2009 11:32:39 GMT