Skip to Content
0
Former Member
Feb 23, 2010 at 04:46 AM

At new statement for Summary report

13 Views

Hi,

I have made a vendor balance report having debit and credit entry in on eintrenal table IT_BSIK, with all line item detail in another table IT_TAB1 i want to make summry report by adding all the amount of of line item it is also working fine but i wan tto change the summary report i want summary for debit and credit entery seperate How to do it find Below the code part for summary how to use AT NEW SHKZG then append the IT_TAB1

find the code here.

**********************summarised part

loop at it_lfnr.

Clear : VTOTBAL, vNtdue, vDue, vDue0, vDue31, vDue61, vDue91,V1TOTBAL.

loop at it_bsik where lifnr = it_lfnr-lifnr.

IT_TAB1-LIFNR = IT_BSIK-LIFNR.

IT_TAB1-BUKRS = IT_BSIK-BUKRS.

IT_TAB1-SAKNR = IT_BSIK-SAKNR.

IT_tab1-NAME1 = IT_bsik-NAME1.

ADD IT_BSIK-dmbtr TO V1TOTBAL.

move V1TOTBAL TO IT_TAB1-dmBTR.

ADD IT_BSIK-WRBTR TO VTOTBAL.

move VTOTBAL TO IT_TAB1-WRBTR.

MOVE IT_BSIK-WAERS TO IT_TAB1-WAERS.

ADD IT_BSIK-NTDUE TO VNTDUE.

move VNTDUE TO IT_TAB1-NTDUE.

ADD IT_BSIK-DUE TO VDUE.

move VDUE TO IT_TAB1-DUE.

ADD IT_BSIK-DUE0 TO VDUE0.

move VDUE0 TO IT_TAB1-DUE0.

ADD IT_BSIK-DUE31 TO VDUE31.

move VDUE31 TO IT_TAB1-DUE31.

ADD IT_BSIK-DUE61 TO VDUE61.

move VDUE61 TO IT_TAB1-DUE61.

ADD IT_BSIK-DUE91 TO VDUE91.

move VDUE91 TO IT_TAB1-DUE91.

endloop.

append it_tab1.

endloop.

***********************************end of summarised vendor part ***************************