Delta Extraction Based on Changed records but not based on time in BW

[Former Member]

Hi,

We are extracting SALES ORDER header and item level data into 0SD_C03 Cube, for that we are using 2lis_11_vahdr and 2lis_11_vascl data sources.

we did initialize the data and doing deltas every day.

At the time of initialization, for the particular sales order sales manager is not assigned and later it is assigned. when we do delta extraction whatever the SALES ORDER assigned SALES MANAGER is not able to extract, how to rectify this issue.

i think when we do Delta loads it is based on time and Is it possible to do it on last changed instead?

can you provide me the solution to rectify this issue?

Regards

Venuscm

[former_member199691 · Accepted solution]

If assignement of Sales Manager is impacting header or schedule line data, it should be coming in delta but if it only impacts Order line item data, it may the reason that you are not getting it in delta as you are using VAHDR and VASCL data.

You might need to pick item level data from 2LIS_11_VAITM.

Regards,

Gaurav

[Former Member · Accepted solution]

Hi gaurav,

Thanks for the reply, this is not directly coming from the data source and the SALES MANAGER is enhanced from VBPA table, now whenever SALES MANAGER is assigned to the SALES ORDER after full load, when doing deltas i need to update SALES MANAGER to the SALES ORDER.

how can we achieve this??

Regards

venuscm

Edited by: venu WAD on Nov 14, 2011 9:49 AM

[Former Member · Accepted solution]

Hi Venu,

Why dont you handle this in customer exit at R/3 side. Definitely there should be a CMOD exit declared for the project, in that space, declare a case statement for this Data source, and there you can capture all the detla records, and for all those delta records try to check if sales manager is assigned by hitting the data base table in R/3 table, if not assigned try to fetch it from R/3 table, and moreover since it is an standard extractor, theere should be time stamp in few tables. So if the delats is happenign on daily bais, i.e once in a day, then apart from your delta records, try to hit the data base tables, only for the records from last run or only for the reocrds where the sales manager is filled and get it appended to the delta records which you get in Customer exit i_t_data or e_t_data internal table. But there we shoudl consider few scceanrios like your key figures avalues etc, and if this is getting directly loaded to cube, i think this may create a problem , so caution is required.

Hoping that there is an intermediate DSO , so this option may work out for you.

Regards,

Nanda.S

[Former Member · Accepted solution]

Hi nanda,

thanks for your solution.

here is the user exit i have written for my datasource.

SELECT SINGLE * FROM vbpa INTO vbpa

WHERE vbeln EQ wa_data13-vbeln

AND parvw EQ 'Y3'.

IF sy-subrc = 0.

wa_data13-zzpernr = vbpa-pernr.

ENDIF.

plz tell me how to modify my exit in order to achive.

and there is no DSO as a staging layer and it is directly 0SD_C03 info cube.

regards

venuscm

[Former Member · Accepted solution]

Hi,

I am using 2lis_11_vascl data source to extract CONFIRMED GI QTY(BMENG). the sales orders which were modified with CONFIRMED GI QTY are not coming into BW System.

how can i resolve this issue?

plz provide the solution.

regards

venuscm

Edited by: venu WAD on Nov 29, 2011 10:37 AM