I m makin a report for pending migo for miro

[Former Member]

Please I need the code for this condition.

7.Pass IR FI document (BELNR) to BSEG and get BSEG-DMBTR (Amount) if the field “MWSKZ” is initial. -if the field "MWSKZ" is NOT INITIAL, Pass the same FI document to BSET and get the Amount as per this logic, BSET- HWBAS+HWSTE = Total invoice amount. Based on TXGRP indicator should equal from BSEG = BSET and get the amount total if multiple line items.

[satyapriyanka_vana]

If I understand your requirement correctly, in case of tax line items you need to calculate the local amount from BSET table. In case of multiple tax lines you need to loop based on the tax group. Please refer these two screenshots. Tax group 1 indicates P7 and 2 refers TS. If you sum up BSEG line items of tax group 1 it will give you total amount in the first line of BSET(HWBAS + HWSTE). Please post your code so that we can help you better.

Regards,

Priyanka.