Skip to Content

0fi_gl_4 data source enhancement with KONV and VBRP fields

Hello everyone,

I have gotten the requirement to create SAP AFO report.We need fields from the following tables,VBRP,VBRK,BSEG,BKPF,KONV,MARA.

For BSEG & BKPF they have customized DSO in SAP BW and this dso is getting data through the standard data source "0fi_gl_4".

The remaining tables will be directly replicated in HANA from SAP ECC through SLT.

Now client is telling that,they don't want to replicate the tables "VBRP" and "KONV" in HANA directly because the no.of.records in VBRP and KONV is high.

So they suggested us to enhance the data source 0fi_gl_4 with the VBRP and KONV required fields(10 fields).

So the queries are:

Is the right way i am following?Can we do the ds enhancement like this?( FI data source with billing fields?)

So am afraid,in their future project,if someone uses this data source they will be getting the billing info along with the FI data source.

How to proceed this?

Regards,

Santhanalakshmi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 04, 2017 at 03:09 PM

    Hi Santhanalakshmi

    Because of the large volume of data in VBRP & KONV I would enhance the data source 0fi_gl_4 with the VBRP and KONV required fields(10 fields). Populate the fields via ABAP exit program ZXRSAU01 with efficient ABAP code as you are dealing with large cluster table KONV.

    For the future project,if someone wants this data source 0fi_gl_4 they can use this DSO to extract the required information within BW (its faster than extracting from ECC system and the data is already in the BW system so why create more network traffic).

    Hope this helps.

    Francis

    Add comment
    10|10000 characters needed characters exceeded