Init issue in 0FI_AR_4 & bringing sales data

[Former Member]

1) I have installed 0FI_AR_4 datasource. In ECC RSA3 brings records correctly, Full infopackage also brings data in BW. But whenever I do init it doesn't bring any data in BW. I tried doing init without data transfer & then delta also, but no success.

Is there any setting I need to do while fetching init for 0FI_AR_4? Just for testing I tried 0FI_AR_3 & it is bringing data. But I want to avoid using 0FI_AR_3 as 0FI_AR_4 is recommended.

2) I want to bring sales data in AR report like sales org. I see only customer comes in 0FI_AR_4 but I want attributes of cust_sales rather. How I can achieve it?

[Former Member · Accepted solution]

Hi,

Use 0cust_sales field in 0FIAR cube, then as usual from master will will get all the fields form 0cust_sales_attr master data. IN 0FIAR flow  0cus_sales filed must be mapped with source customer only.

still any help let me know?

Thanks & Regards,

Srinu.Rapolu

[Former Member · Accepted solution]

What will be logic for cust_sales in case to be included in datasource?  By default you don't get this field in the datasource. There's possibility of multiple sales orgs for 1 customer. FI entry is based on customer, how to get bifurcation at sales org level?

[former_member186399 · Accepted solution]

Hello Shail,

Try to get the sales order number from the AR document. If the AR document is an RV document you can directly fetch the sales document through the corresponding billing document.

once you have sales document through VBAK you can get the sales area.

Regards

Gajesh

[Former Member · Accepted solution]

Yes Nagesh I got the result through this method. I also got another easy method, I looked up on Sales index table, the result I found much faster than looking up on VBRP or VBAP etc..

Thanks for your help.

[sachin_kulshrestha2]

Dear Shail,

There could be multiple reason but looking at what you just described;

1. This could be because initialization of  0FI_AR_3 extractors might be still existing in ECC system and 0FI_AR_3 and 0FI_AR_4 extractors cannot exist together. For this, initialization of earlier extractions should be deleted from BW.

2. For your second requirement it looks to be more functional but you should still with Sales and Finance guys and found our the method of posting into FI module. You can look at Business Area may give you what you are looking at.

Hope this Help!!!

[Former Member]

Hi Sachin,

1) For init you are correct I've initialized 0FI_AR_3 before. So problem solved.

2) Business Area is a field in datasource 0FI_AR_4?

[sachin_kulshrestha2]

Dear Shail,

You will not get sales area (Sales Organization/Distribution Channel/Division) directly in AR to utilized 0CUST_SALES and its attribute.

You will have to derive it based on the reference document ( Billing document in case of Sales order Processing)

Business area translates to company code which is not relevant here in your case described.

Hope this should help in your analysis further.