s_alr_87013343

[Former Member]

Hi Alll,

I am running this report but I am not getting any data. What is the rule of Key date in this transaction? Are there any other criterias that need to be fullfilled before running this report?

Thanks in advance.

- Neha

[Former Member]

Hi,

I found out the solution of your problem-

It's because, In ECC 6.0, the report on Prtofit center payables and receivables was changed.

SAP no longer uses 8A tables for reporting if new GL is activated and instead uses FAGLFLEX* tables.

In your case try execution of report 0SAPRECIEV01 in T-Code FGI3.

Hope, you are clear now.

Regards

K Khatri

[Former Member]

Thanks a lot. FGI3 has served my purpose. But SAP doesnt show the accounting document date in output. Its displaying only following columns:

1) Local Currency

2) G/L account

3) Profit Centre

4) Customer

5) Company code

6) Doc No

7) Year

😎 Item

9) CO area

10) Receivables LC

I tried to change the layout also. But the doc date is not present in the layout.

[Former Member]

hi

check is there any customization settings needs to be done for adding the required fields in report.

[Former Member]

But exactly where should I do this customization setting?

[saikrishna_vallurupalli]

you can not change the standard report, you have to create your own report by coping the standard report by using FGI1/FGI6 and add your required characteristics like document date and any other characteristics.

for more information regarding how to create report painter please look at the below links

http://help.sap.com/erp2005_ehp_02/helpdata/en/56/32e339b62b3011e10000000a11402f/frameset.htm

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/erpfi/report+painter

[Former Member]

Hi,

Key Date checks against the posting date of the documents upto the key date given.

You can run this report using the Sets / individual values.

Prereq: Atleast there should be open receivables.

Below is the information about the report:

Purpose

Report group 8A98 allows you to check the origin of existing receivables for given profit centers or profit center groups.

The report also displays valuation differences arising from currency variations if the corresponding report was executed in Financial Accounting.

Integration

By double-clicking on the document numbers displayed, you can go to the corresponding accounting documents for the FI component.

Features

This is a report-painter report.

Activities

To execute the report, enter a company code and a key date.

You can also make selections according to profit centers, profit center groups, general ledger accounts, debitors and/or Accounting document numbers.

In the report, you can break down the receivables according to the following characteristics:

1st level: General ledger accounts

2nd level: Debitors

3rd level: Accounting document numbers

The report displays open receivables and valuation differences. In a third column, receivables and valuation differences are offset against each other.

VVR

[Former Member]

hi,

please check for the profit center accounting is active.

re-generate the report in transaction GR55 for the report group.