Initilization for 2lis_11_vahdr

[Former Member]

Hi Experts,

I'm extracting data from 2lis_11_vaitm and 2lis_11_vahdr datasources. As I've huge data in production system. I want data from January 2009 to till data. I can able to get month wise sales orders.

1. I'm extracting data by giving the selection for sales orders (Sales order 1 to sales order 1000 in January month, SO1001 to SO 2000 in Feb month, SO2001 to SO 3000 in March Month like that)

2. I've extracted data till July month like that by giving sales order numbers.

Now I need to do initilization and need to set up for deltas.

Can I fill the set up tables with sales order range from Jan to July and do initilization without data transfer then scedule delta?

then Can I get the August records in delta with changed records for Jan to July properly?

Is it the correct apporach.

could you please through an ideas.

[shanthi_bhaskar]

harsha,

I hope you will get the delta records from Aug if they are posted in this month itself...Carry the steps that you indicated..

[Former Member]

Hi,

Can you through a light on this.

[Former Member]

Is it possible to do multiple initializations to one data source let us 2lis_11_vaitm.

I donu2019t need all the data from R/3, it contains for the past 1 year. I need only last 6 months of data into SAP BW. How can I do initialization only for past 6 months of data.

Iu2019ve company code, sales organizations and sales document number as selection for initialization.

There are different types of sales documents are there. Let us say some documents will start form 20005001 to 200089000 and another type of documents will start from 80000001 to 80009999 for the past 6 months.

I do initialization based on company code it will do for the past 1 year.

If go with document numbers there two different number ranges can I do multiple initializations? How it works?

[dennis_scoville4]

You can execute the setup job for this DataSource multiple times, once for each set of document number ranges. These can also execute concurrently.

So, in your first setup you would put in the selection criteria:

Sales Document: 20005001 to 200089000

Name of Run: LIS1101 (or whatever you want to name it)

New Run: Checked

As soon as you have executed that one in background, you can do the other:

Sales Document: 80000001 to 80009999

Name of Run: LIS1102 (or whatever you want to name it but different than the first)

New Run: Checked

Then execute that one in background.

Be sure to set the termination date and time so that it won't timeout prior to extracting all of the data. I usually use whatever is populated in that field and add one day to it.

[Former Member]

Hi,

Hence Multiple inilizations are possible. correct me If I'm wrong.

I've loaded from January to July by giving that document numbers in selection. If I initilize multiple times with the same document number range which are from Jan to July. Then If I schedule delta, I think it will bring today let us say 25th of Aug onwards and changes to Jan to July documents only correct??

or it will bring the August 1st to August 25 th documents as well and changes to Jan to July doc.???

[dennis_scoville4]

I wouldn't put it as multiple initializations, because that would refer to executing an Init InfoPackage multiple times. Multiple setups for Full loads, then yes, multiple setup jobs can be executed to fill the setup table is possible.

After you have scheduled the delta in LBWE and have executed an Init InfoPackage in BW, at that time the delta queue would be determined. Therefore, if you just scheduled the delta job and not executed the Init in BW, you won't have any deltas.

You stated that you ran the setup job multiple times for the same document numbers. Did I get that correct? If so, then you're going to have duplicate entries in the setup table and when you extract that you're going to get inconsistent results in BW. If you meant that you executed it multiple times with the various document ranges for that timefreame, then you're fine.

[Former Member]

Hi Experts,

As mentioned I've loaded data from January to July into SAP BW. But I've deleted set up tables. And I'm doing initialization with out data transfer and going to schedule the delta. Is it works?

Do I need to fill the set up tables in order to get the proper delta records or not necessary filling the set up table even you deleted but data is in SAP BW. And directly I can schedule delta.

thank you very much for your valueable ideas and experiece.

[Former Member]

Hi SHarsha,

Data in Setup table and intializing delta is nowhere inter related. You dont need to have data in setup tables to fetch delta.

As in your case you have mentioned that you have data filled in setup only till July. So data only till July will be BI and if you do intialize delta the august month records will not be pulled in delta as those are historic records. Only new records will be captured.

Generally when going for any setup in BI, first we will fill the setup tables for that datasource and pull the history records from R/3 to BI for the interval range required. Then on a outage time we will intialize a delta. So going forward you will be able to get delta.

You have mentioned to have a data from 2009 to till date and moving on the delta also. For this you need to have a outage time since it is an sales datasource.

Fill up the setup tables till date data and pull into BI and do intialization without data transfer with date or peirod in selection condition(ex. 01/01/2009 to 12/31/9999). Going forward any changes happens to the records created on this interval or any new records will be captured in delta.

Hope this gives you an idea.

Akhan.