Question Re: Re-initializing LIS datasource in Technology Q&A

Re-initializing LIS datasource

Former Member — Mon, 30 Mar 2009 06:56:31 GMT

Dear All,

We are pulling data into purchasing info cube 0PUR_C01 through the datasources 2LIS_02_ITM and 2LIS_02_SCL. We need to do a re-init of the data starting from 1st march 2009. When we do this via the info pack the systems returns a message "no data available for selection".

I am not sure whether its necessary to fill the setup tables prior to the init run and if so can anyone let me know whether the setup table can be filled from the 1st of march only.

Re: Re-initializing LIS datasource

shanthi_bhaskar — Mon, 30 Mar 2009 07:30:43 GMT

you can do setup tables based upon any date say 01.03.2009. (X)

that means if do filling of the setup tables based on X date then the data which is there in the setup tables will be the records what ever posted up to that X date. It doesnt mean that X date should be there in the extractor field which you are trying to filter in the IP.

I hope you got the differenec between setup tabels filling date and IP selection date.

These two entirely different.... the second one speaks abt the data in the extractor and where as first speaks about the time stamp.

Edited by: shanthi bhaskar on Mar 30, 2009 3:06 PM

Re: Re-initializing LIS datasource

andrea_previati — Mon, 30 Mar 2009 07:44:17 GMT

In r/3 you should delete the purchasing set up tables with transaction code LBWG

after this you can fill the setup table of purchasing in SBIW ~~> MCNB~~-> purchasing

ofter this you can set in R/3 the daily job that pulls the delta in transaction code LBWE

After this you can load the infopackage in BW

Hope it helps

Re: Re-initializing LIS datasource

Former Member — Mon, 30 Mar 2009 08:39:55 GMT

Hi Andrea,

Thanks for the reply. Is it always necessary to fill the setup table before you re- initialize the data ? Cant we do anythong without filling the setup table ? As at now the setup tables are filled until Feb 2008.

Re: Re-initializing LIS datasource

Former Member — Mon, 30 Mar 2009 09:35:13 GMT

Yes, during re-init the data is pulled from setup tables.If there is no data in setup tables, we will not get any data during reinit.Hence we will have to always fill setup tables with required data before reinit.