calculate vendor balance code

[Former Member]

Hi guys,

I need help on calculating vendor balances grouped by vendor no. (lifnr) and and company code (bukrs).

Please see my code bellow... Gt_output contains all the vendor numbers that are requested and t_bsik is a table type of bsik.

LOOP AT gt_output INTO gwa_output.

LOOP AT t_bsik INTO w_bsik

WHERE lifnr = gwa_output-lifnr

AND bukrs = gwa_output-bukrs.

IF sy-subrc = 0.

AT END OF lifnr.

AT END OF bukrs.

SUM.

gwa_output-balance = w_bsik-dmbtr.

MODIFY gt_output FROM gwa_output.

ENDAT.

ENDAT.

ENDIF.

ENDLOOP.

endloop.

this code adds all the balances onto one vendor only even when the vendor numbers and company codes are different.

Please help.

[tanuja_wa]

Hi,

You can use COLLECT statement for this purpose

[Former Member]

Collect statement is giving me an error because collect works only for numbers, vendor number and company code are type c.

[Former Member]

Hi

Try using

AT END OF lifnr.

AT NEW bukrs.

Regards

Sowbhagya

[Former Member]

I have tried it, but it is displaying incorrect results,

Please check my code:

LOOP AT gt_output INTO gwa_output.

LOOP AT t_bsik INTO w_bsik.

IF sy-subrc = 0.

AT END OF lifnr.

AT new bukrs.

sum.

gwa_output-pre_dmbtr = w_bsik-dmbtr.

MODIFY gt_output FROM gwa_output.

ENDAT.

ENDAT.

ENDIF.

ENDLOOP.

endloop.

[Former Member]

Thank you so much so your responses