Skip to Content
0

0FI_AP_4 / 0FI_AR_4 - Enhancement - CMOD

Dec 09, 2016 at 06:45 AM

215

avatar image

Hi Experts,

I have a doubt related to the enhancement of 0FI_AR_4 and 0FI_AP_4 datasources. The client wants to have the reports for Debitors/Creditors to be analyzed on the basis of Material (0MATERIAL). Hence I need to enhace the datasources.

1. Enhancing 0FI_GL_14 datasource at ECC side in CMOD using Company Code,Document Number,Line Item ,and Fiscal Year from BSEG table and get the corresponding MATERIAL (MATNR) field. Then at the BW side, during loading of 0FI_AR_4/0FI_AP_4 in the respective DSO, I can lookup the value of MATERIAL from GL DSO.

2. Another way is if i can straight way enhance 0FI_AR_4 and 0FI_AP_4 datasources. But I am not aware of on what all criteria and tables should I use in order to get the MATERIAL field.

Please suggest the best approach that shoudl be used keepin in view the performance. Also, please suggest the appropriate tables and fields taht should be taken while considering point no.2.

I am very new to SAP BI and want to have a model that should be consistent and has good performance.

Thanks,

Atul

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

sumeet durgia Dec 13, 2016 at 12:15 PM
0

Hi Atul,

I will say go with approach 2.

Below is the reason.

0FI_GL_14 uses table BSEG which is a big table and is a cluster one contains data from below tables.

BSID , BSAD ,BSIS, BSIK, BSAS, BSAK

And if you see 0FI_AR_4(BSID, BSAD) and 0FI_AP_4(BSIK) datasources , uses tables BSID,BSAD and BSIK respectively

which anyways will have all the fields like Company Code,Document Number,Line Item ,and Fiscal Year.

So what you can do, is enhance these DS and fetch BSEG-MATNR based on Company Code,Document Number,Line Item ,and Fiscal Year using ABAP code.

If you directly enhance BSEG, it will be a slow extraction since its a huge table and performance will be slower as compared to approach 2.

Br

sd

Share
10 |10000 characters needed characters left characters exceeded