need logic addition account group wise

[Former Member]

hi firends,

i am calulating accumalated balance

accumulated balance is nthing but addition of

debit and credit.

sum is working fine with one account group.

but not for multiple aacount group.

account grp credit debit acc bal

17011101 100 200 300

40 40 80

17011101 10 10 20

thanks

[former_member404244]

Hi,

go for collect statement...

loop at itab.

at new account group.

collect itab1.

endat.

endloop.

Regards,

nagaraj

[Former Member]

Have u written SUM inside the AT-NEW <acct group>.

if not try gining AT-NEW betn LOOP/ENDLOOP...

Hope it helps..Reward if helpful

[Former Member]

I think you are using SUM command in AT LAST control break statement so it is working for only one a/c grp. Just use the SUM command in AT END OF control break statement. If I am wrong pls paste your code it will be easier for us.

Regards

shiba dutta

[Former Member]

hi this my code plz correct me

TABLES:FAGLFLEXT,

SKB1,

BKPF,

SKAT.

************INTERNAL TABLE DECLARATION**************************************

DATA:BEGIN OF FAGL OCCURS 0,

RACCT LIKE FAGLFLEXT-RACCT,

rbukrs like FAGLFLEXT-rbukrs,

DRCRk like FAGLFLEXT-DRCRk,

TSL01 LIKE FAGLFLEXT-TSL01,

TSL02 LIKE FAGLFLEXT-TSL02,

TSL03 LIKE FAGLFLEXT-TSL03,

TSL04 LIKE FAGLFLEXT-TSL04,

TSL05 LIKE FAGLFLEXT-TSL05,

TSL06 LIKE FAGLFLEXT-TSL06,

TSL07 LIKE FAGLFLEXT-TSL07,

TSL08 LIKE FAGLFLEXT-TSL08,

TSL09 LIKE FAGLFLEXT-TSL09,

TSL10 LIKE FAGLFLEXT-TSL10,

TSL11 LIKE FAGLFLEXT-TSL11,

TSL12 LIKE FAGLFLEXT-TSL12,

cumbal like FAGLFLEXT-TSL01,

• G_DEBIT LIKE FAGLFLEXT-TSL01,

• G_CREDIT LIKE FAGLFLEXT-TSL01,

MONAT LIKE BKPF-MONAT,

END OF FAGL.

data:fagl1 like standard table of fagl with header line.

data:cumbal like FAGLFLEXT-TSL01.

DATA:t4 TYPE c LENGTH 10 VALUE 'hsl',

TEMP TYPE STRING.

******************************************************************************

SELECTION-SCREEN BEGIN OF BLOCK account WITH FRAME.

SELECT-OPTIONS: RACCT FOR FAGLFLEXT-RACCT.

PARAMETERS:Ryear LIKE faglflext-ryear,

MONAT like BKPF-MONAT,

rbukrs LIKE bkpf-bukrs.

SELECTION-SCREEN END OF BLOCK account.

*********************************************************************************************

CONCATENATE T4 MONAT INTO TEMP.

if TEMP = 'hsl01'.

SELECT RACCT DRCRk rbukrs TSL01

FROM FAGLFLEXT

INTO CORRESPONDING FIELDS OF FAGL

WHERE RACCT IN RACCT

AND RBUKRS = RBUKRS

AND RYEAR = RYEAR.

append fagl.

endselect.

if temp = 'hsl02'.

SELECT RACCT rbukrs TSL02

FROM FAGLFLEXT

INTO CORRESPONDING FIELDS OF FAGL

WHERE RACCT IN RACCT

AND RBUKRS = RBUKRS

AND RYEAR = RYEAR.

append fagl.

endselect.

endif.

endif.

write:/1 'CoCode',

10 'AccNo',

42 'CumBal'.

sort fagl by racct.

loop at fagl.

CUMBAL = CUMBAL + FAGL-TSL01.

ENDLOOP.

sort fagl by racct.

loop at fagl.

write:/1 fagl-rbukrs ,

10 fagl-racct,

22 CumBal.

endloop.

[Former Member]

do like this...

sort fagl by racct.

loop at fagl.

write:/1 fagl-rbukrs ,

10 fagl-racct,

22 FAGL-TSL01.

AT END OF RACCT.

SUM.

write:/ 'Total', 22 FAGL-TSL01.

ENDAT.

endloop.

Regards

shiba dutta