Populating Data after Enhancing the Data Source from LO Cockpit

[former_member296925]

Hi Experts,

I am enhancing the DS 2LIS_04_P_MATNR , two field i am adding one is segment (from MVKE table) and other is shift Definition (from AFRU table) i have enhanced the extract structure in RSA6 and activated too. Now i want to populate the data from enahced DS and replicate into BI side??? Please Guide.

[Former Member · Accepted solution]

HI Vikrant,

To populate data for the enhanced fields you need to write the required ABAP logic in CMOD.

Go to Transaction code -> CMOD -> Search for the project created for BI enhancements -> Go to Components -> Double click on Function Exit : EXIT_SAPLRSAP_001 -> Now double click on Include zxrsau01.

case i_datasource

when '2LIS_04_P_MATNR'

---> Write your ABAP logic here.

ENDCASE.

After this replicate the data source in BI.

Regards,

Hemant Khemani

[former_member296925 · Accepted solution]

dear hemant,

thanx for the prompt reply but still one more query i have that is, where we r going to write the abap code ... does the logic differes for evry field except the table n field name or it is same for enahcnement.

and one more thing,

after writing the logic i need to delete the setuo tables and take statistical run for data... are correct steps ??

[Former Member · Accepted solution]

Hi,

one more query i have that is, where we r going to write the abap code ...does the logic differes for evry field except the table n field name or it is same for enahcnement.

The way of coding would remain same but logic for every enhanced field may differ as you would be extracting them for different selection conditions and probably from different database tables. As such the internal table name to which finally the data would be passed to would remain remain same in all your coding. which is c_t_data.

and one more thing,

after writing the logic i need to delete the setuo tables and take statistical run for data... are correct steps ??

After writing the logic, you would have to load the setup tables for fetching the historical data for these appended fields. The sequence for the steps will be

1. Enhance the datasource.

2. Replicate the datasource and activate in BI

3. Lock all the users in source system.

4. Clear LBWQ/ RSA7 queues by pulling the data to BI

5. Fill setup tables

6. Reinitialise the deltas for this datasource

7. Unlock the users.

8. The deltas would start to come in the normal way.

[Former Member · Accepted solution]

Hi Vikrant,

1. The place where you need to write the code is clearly mentioned in my earlier reply.

2. Yes, the logic would differ for various enhanced fields based on your requirements.

3. Regarding setup tables fill up after enhancement - Yes, it will be required if you want to update the historical data in BW with the data for enhanced fields. Otherwise, it is not required. The new records (new delta) would have data for the new fields.

Hope this helps.

Regards,

Hemant Khemani

[Former Member]

Hi,

The below document would give you all the steps for enhancing an LO datasource.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c09d5356-d8c4-2d10-8b84-d24723fc1...

As you have already appended the datasource with the required fields, you may also start from page 7 of this document.

Please note that the document shows the path for coding youe enhancement as SE37->EXIT_SAPLRSAP_001.

This is similar to going through CMOD tcode because ultimately you are calling function module only.

Hope this was helpful.