Skip to Content
Former Member
Feb 20, 2008 at 08:50 AM

FI_AP Query Help required


Hi gurus

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

JAN2007 1000

FEB2007 1200

MAR2007 400

APRIL 1500

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

points will be awarded.

Thanks in advance