Skip to Content
author's profile photo Former Member
Former Member

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


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 20, 2008 at 09:17 AM

    On cube 0FIAR_C03 there is some queries "playing" with the posting date and clearing date. You can take them as model for your AP query.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.