Skip to Content
avatar image
Former Member

0FI_AP_4 / 0FI_AR_4 - Enhancement - CMOD

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 13, 2016 at 12:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded