topic Needed Report Solution in Application Development and Automation Discussions

Needed Report Solution

Former Member — Thu, 25 Dec 2008 08:35:24 GMT

Hi ,

I need solution for the following requirement;

Input

Vendor Stock debit/credit indicator

10 S

25 H

5 S

10 H

I need to add the vendor stock based on S or H, if s add ,h subtract .

output - should display only data with indicator S and not with H.

output

Vendor Stock debit/credit indicator

10 S

0 S

Thanks in advance

Re: Needed Report Solution

jayakummar — Thu, 25 Dec 2008 08:40:32 GMT

Please give some what clear for my reply....Means give u r formula and examples

Re: Needed Report Solution

former_member585060 — Thu, 25 Dec 2008 08:44:21 GMT

Hi,

LOOP AT it_itab INTO wa_itab.
      IF wa_itab-indic = 'S'.
     WRITE :/ wa_itab-vendor, wa_itab-indic,
      ENDIF.
ENDLOOP.

too add use COLLECT statement.

Regards

Bala Krishna

Re: Needed Report Solution

Former Member — Thu, 25 Dec 2008 09:20:06 GMT

Hi Rajeev,

in your scenario based on the indicator you need to add the vendor details.

so while looping the use the authermetic condtions.

data: l_vendor_s type i.

clear l_vendor_s.

loop at the i_vendordetails into wa_vendor details

if wa_vendordetais-indicator = 'S'.

l_vendor_s = l_vendor_s + wa_vendordetais-indicator.

endif.

endloop.

while displaying you can use the l_vendor_s in the final output.

and show remaing details as zero.

Hope it will be useful to you.

Regards,

Prasanth.

Re: Needed Report Solution

Former Member — Thu, 25 Dec 2008 09:58:15 GMT

If my data is like this

Vendor st

10 S

20 S

10 H

Then o/p shud b

Vendor st

10 in 1sr row

20 in 2nd row .( 10+20 -10 ).

This code works only for 1 material thatu2019s the last 1. not for multiple products

My code is like this

Loop at it_data into wa_data.

<<<,if indicator is S I have to add to exsisting vendor stock >>>

if wa_data-shkzg EQ 'S'.

lv_vendor_stock = lv_vendor_stock + wa_data-menge.

ELSEif..

<<<,if indicator is H I have to subtract from exsisting vendor stock >>>

wa_data-shkzg EQ 'H'.

lv_vendor_stock = lv_vendor_stock - wa_data-menge.

ENDIF.

<<<< need to display records only with S indicator >>>

If wa_data-shkzg EQ 'S'

Lv_count = lv_count +1.

Wa_data-matnr = Wa_final-matnr

Wa_data-lifnr = Wa_final-lifnr.

Wa_data-lv_vendor_stock = Wa_final-lv_vendor_stock.

Wa_data-trans_qty = Wa_final- trans_qty.

APPEND wa_final to it_final.

Elseif.

wa_data-shkzg EQ 'H'.

Wa_data-matnr = Wa_final-matnr

Wa_data-lifnr = Wa_final-lifnr.

Wa_data-lv_vendor_stock = Wa_final-lv_vendor_stock.

Wa_data-trans_qty = Wa_final- trans_qty

<<<<<<this is to show the last record with subtracted value .>>>>>>>

Modify wa_final index lv_ctount transporting matnr lifnr lv_vendor_stock trans_qty.

Endloop.

Re: Needed Report Solution

former_member585060 — Thu, 25 Dec 2008 10:07:01 GMT

Hi,

Modify this u have to fill into wa_final so it must be left side.

if wa_data-shkzg EQ 'S'
Lv_count = lv_count +1.
 Wa_final-matnr = Wa_data-matnr.
 Wa_final-lifnr = Wa_data-lifnr.
 Wa_final-lv_vendor_stock = Wa_data-lv_vendor_stock.
 Wa_final- trans_qty = Wa_data-trans_qty.

APPEND wa_final to it_final.

Elseif.
wa_data-shkzg EQ 'H'.
Wa_final-matnr = Wa_data-matnr.
 Wa_final-lifnr = Wa_data-lifnr.
 Wa_final-lv_vendor_stock = Wa_data-lv_vendor_stock.
 Wa_final- trans_qty = Wa_data-trans_qty.

<<<<<<this is to show the last record with subtracted value .>>>>>>>
Modify wa_final index lv_ctount transporting matnr lifnr lv_vendor_stock trans_qty.

Endloop.

Regards

Bala Krishna