Skip to Content
0
Former Member
Nov 01, 2012 at 07:41 PM

calculate starting balance for material & plant combination

37 Views

Hi,

  • Starting balance month is a one month previous to "From" Month entered on Selection screen (e.g. If selection screen Start month is 08 and Year 2012,

search month is 07 and Year 2012)

  • For each of selected Materials-Plant, search and select all record in s from internal table IT_MARD for starting Balance Month (LFMON) /Year (LFGJA) (e.g. 07/2012)
  • If there is no record found in IT_MARD for the starting Balance Month (LFMON)/Year (LFGJA) (e.g. 07/2012), keep searching for the immediate previous periods (e.g.06/2012, 05/2012, 04/2012 and so on) unless all the records for Material-Plant-Storage Location combination are searched for.
  • how should we go and search each month? and how many months do we search for..?
  • is there any simple logic to get the same ?

Thanks.