SD Report that combines SD-FI fields

[Former Member]

Hi,

I have a report requirement from the client, which looks like VA05 (status per line item), but contains the following fields:

- Billing Doc

- Billing status (paid or not)

- Billed Qty

- Billed Amount

- Unbilled Qty

- Unbilled Amount

Is there are standard SAP report that has this info?

Thanks!

[Manoj_Mahajan78 · Accepted solution]

Hi..

You can get some of these fields (Not all) in VF05N

Also use SE16 & VBKD Or VBRP Table.

Regds

MM

[Former Member]

follow-up question...

[Former Member]

There is no standard report for this. You will have to develop the report using ABAP.

Regards,

GSL.

[Former Member]

Is this possible with Report Painter or SQ01?

Thanks!

[Former Member]

Hi Migalbin,

Yes can create query coz data is flowing from sd to fi

Regards

San

[Former Member]

There is no functionality of report painter from SD side and I am not too sure of using the same from FI side.

You can use SAP query to meet the requirement to some extent. The two fields unbilled quantity and amount can be seen by adding two new fields in query and writing the necessary code in the fields. Take the help of ABAPer for writing the code.

A word of caution while using SAP query is that it will be an inner join so the sale orders which are billed will only be fetched in the query. All the sale orders which are not billed will not be seen in the report.

Regards,

GSL.

Edited by: GSL on Sep 22, 2008 5:04 PM