Can any body explain How to derive following scenario
I have following characterstics & kefigure from 0FI_AP_04 and DSO is 0FIAP_O03
Key figure: Dr/cr amount
Charactestics: Company code, 0FISCPER, 0PMTTRMS, 0PMT_BLK ,posting date and Clearing date
I have restrictions on amount like some values from pmt terms and pmt block. The conditions are for a given fiscal period(like jan 2007 to dec 2007) with posting date <= month end date and clearing date >month end date or blank. as per this scenario i have to get values for all the 12 months. I am putting an example here
Comp code 0FISCPER(jan 2007 to DEC2007) dr/CRAmount(with above said restrictions)
01 DEC2006 600
LIKE this Upto december2007. Assume that for the month of january there are some posting dates which are posted in december but not cleared in jan2007 all that accumulate and show in Jan2007 closing balance(1i.e 1000). After this threre might be some clearing entries in january(for open items of dec06 and jan07) those amounts should not appear in FEB. but the items which are opened in dec jan feb which are not cleared till end february should appear in bebruary. Like this manner I have to calculate for an user specified period.
Can any body can explain how to achieve this. any can mail me at firstname.lastname@example.org
points will be awarded.
Thanks in advance