Account Recievables Extractor and Profit Center

[Former Member]

Hi Gurus,

I have a requirement of creating an Aging report ( which i am planning will be based on AR DataSource , 0fi_ar_4).

Now , i have a requirement to show the Profit Center data in this report.

I am not sure how to go ahead with this. If anybody has any suggestions please pass it on.

Regards,

Dennis

[Former Member]

Dennis,

I think you are not on new gl functionality. Bcoz we are getting the profit centres from FAGLFLEXA table.

Regards

Renu

[Former Member]

Hi Renu

Did you then enhance the FI-AP and FI-AR line items extractors or only the FI-GL line item extractor ?

Do you need the EHP3 implemented to get that information ?

PY

[Former Member]

Hi Renu

Did you then enhance the FI-AP and FI-AR line items extractors or only the FI-GL line item extractor ?

Do you need the EHP3 implemented to get that information ?

PY

[Former Member]

Got a reply for another thread.

[Former Member]

Hi

You can refer the following standard report.

IDES_FI_AR_C03_Q0005

Regards,

chandra.

[Former Member]

Hi Guys,

None of these things is helpful, i am not building my stuff on COPA so that is not what i am looking at.

Chadrashekhar, I am not able to find the details of the query you mentioned. Could you please let me know any standard help documents for that.

Gurus please help.

I need profit center data in AR aging reports.

Regards,

Dennis.

[Former Member]

Hi Gurus,

Any suggestions here. My issues is still open.

Regards,

Dennis.

[Former Member]

Dears,

If somebody tried and got successful in staging any such flow from R/3, please let me know about the same.

Best Regards,

Dennis

[Former Member]

Somebody please answer

[Former Member]

Dennis we are going to need some more info on this

Have you got ECC6 segment ledgers set up for AR and does those post the AR side of the posting to the individual profit centres

IF you are not using segment ledgers then because of the way FI documents are posted you CANNOT add profit centre to the report

This is the reason why

Example FI journal

dr Customer  117.50
cr VAT        17.50 default profit centre
cr revenue    50.00 profit centre A
cr revenue    50.00 profit centre B

Now all you have in the AR4 extractor is the 117.50

The way R3 handles this is that you have a special job which posts via 1KEK or 1KES (I forget which) at month end into the PCA ledger the net balance but not aged per profit centre for the AR sub ledger

(this month end job is one of the reasons that PCA is being replaced by segment ledgers in ECC6 - 30 days is too late to produce a "segmented" balance sheet as per the IAS 14 and SoX regulations) anyway....

Unless your process says - there is a 1:1 mapping between each debtor posting and a revenue posting and that revenue posting cannot to be more than 1 profit centre (HIGHLY unlikely)..

then unfortunately you cannot produce the report

Somebody has seriously messed up the FICO config andd esign if they request this at the end of the project and haven't designed segment ledgers to handle this...

(you could have a look at the 0EC_PCA_1 extractors for the PRC4 activity type for the month end postings - but i seriously dount whether the month end PCA jobs are posting document by document - 99% of the time they post by total customer balance and that is not aged)

Sorry!

(note: I have had a similar requirement in one of my past projects - the way I did it was to allocate a customer to a "profit centre" - this I did by utisling one of the user defined fields on the customer master and allocating that customer to that "grouping" - ie not physically a profit centre but some sort of grouping that resembled a profit centre - this of course can only happen if logically you can do this irrsptive of the revenue postings to other "profit centres")

[Former Member]

Hi Simon,

Thanks for you reply. I totally agree with you.

Unfortunately i have the scenario which you mentioned is one which i happening in my system.

My Invoice has more than 1 line items which can correspond to Multiple Profit centers and BSID / BSAD (AR EXTRACTOR) has one line item for this. So i cannot do anything at extractor or by lookin up GL data.

I am not sure whether taking GL and AR data in an DSO will solve my problem but thats the last option i have. Let me know if you have any other solution for this.

Regards,

Dennis

[Former Member]

Dennis there is no solution to it - even by putting GL data in - well you could but the overhead will be huge!

Basically you could derive the profit centres for unallocated cash and invoices each time you load the changes - ie based on a lookup to the GL DSO

ie basically doing the normal month end GL to PCA per document in BW for all changelog entries

However with my volumes - 40 million AR records and 500 million GL records I dont have time in the night to do this (well I dont have a night I have a worldwide 24/7 no downtime!)

Tho be quite honest the ECC segment ledgers are built to handle this

THe background to that is that IAS14 required balance sheets per segment of a legal entity if the segment was more that 25% of turnover ina different business sector or geographical area (hence the use of profit centres and business areas in SAP to handle this) - problem was this was a monthly jon in R3 to provide it. Which was ok until SOX came in with a 14 days give me your accounts rule!

SAPs use of real time segment ledgers in R3 to replace the monthly PCA job will do this and it will do it on a line item level

Unfortunately this really is the only way to go

[Former Member]

Thanks a lot for your response Simon.

I will check what i can do and let you know if i find some intersting solution.

Regards,

Dennis

[mr_v]

Last year one of my client had same requirement (inluding Profit Center), in both AP (Vendor Spend Report) and AR (Overdue Debt report).

We investgated all financial related tables, to enhance those AP & AR datasources to incorporate Profit Center, and finally fould that not possible to do that and delivered the reports without Profit Center.

[Former Member]

Hello All,

Thanks for your valuable replies.

I have another question if you have seen this transaction in ECC side.

S_AC0_52000887

This gives you the breakup by Profit Center in case of recievables by customers.

Can we use this transaction somehow to get profit center in AR Reports.

Simon / Mr. V Your response will be higly appreciated.

Regards,

Dennis.

[Former Member]

Any suggestions ??

[Former Member]

Hi,

Go through this links:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/g-i/how%20to%2...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/fb07ab90-0201-0010-c489-d527d39c...

hope it helpful.

Ajay

[Former Member]

Hi,

see this links......

http://help.sap.com/saphelp_nw04s/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

http://help.sap.com/search/highlightContent.jsp

http://help.sap.com/search/highlightContent.jsp

http://help.sap.com/search/highlightContent.jsp

http://help.sap.com/search/highlightContent.jsp

http://help.sap.com/search/highlightContent.jsp

http://help.sap.com/search/highlightContent.jsp