Loading Data from R/3 Production Backup Server to BW 3.5

[Former Member]

hi all

I am working on SAP BW 3.5 Version

my Requirement is Activating the Business Contents and Load Data from R/3 Production Backup Server to Bw 3.5 Version

for Standard Cube : 0SD_C03 ( Sales;Overview) and

Customised Cube : ZSD_C03 (Sales:Overview Detail)

These are Data Sources for 2 Cubes

I need to load Data for only 2 month (April, May)

Sales Order Item Data (As of 2.0B) 2LIS_11_VAITM

Sales Order Header Data (As of 2.0B 2LIS_11_VAHDR

Billing Document Data: Items (As of 2.0B) 2LIS_13_VDITM

Billing Document Header Data (As of 2.0B) 2LIS_13_VDHDR

In Info Package level, Data Selection I findout the Date field for Restricting the Date for

Sales Order Item Data (As of 2.0B) 2LIS_11_VAITM

Sales Order Header Data (As of 2.0B 2LIS_11_VAHDR

but I am not finding the Date field for following Data Sources in Info Package level(BW 3.5)

Billing Document Data: Items (As of 2.0B) 2LIS_13_VDITM

Billing Document Header Data (As of 2.0B) 2LIS_13_VDHDR

now how I will Load Data for( April,May) without Restricting the Date field

Please let me Know,Urgent Requirement.

thanks in advance

[raju_saravanan · Accepted solution]

Hi SKR

It depends to your business senario. If you don't want to restrcit , remove the selection condition, and schedule the package.

Those data sources propably your colleages made some initial restrcitions.

Regards

Saravanan.ar

[Former Member · Accepted solution]

Hi Raju

for these two Info Sources I have already loaded Data for April and May

Sales Order Item Data (As of 2.0B) 2LIS_11_VAITM

Sales Order Header Data (As of 2.0B 2LIS_11_VAHDR

and here I need to load data for April and may, but I am not finding the Date field for following Data Sources in Info Package level(BW 3.5)

Billing Document Data: Items (As of 2.0B) 2LIS_13_VDITM

Billing Document Header Data (As of 2.0B) 2LIS_13_VDHDR

now how I will Load Data for( April,May) without Date field

Please let me know

I will Assign full points

[raju_saravanan · Accepted solution]

Hi

I could able to understand.

The Problem is with your Extraction structure.

Go to LBWE, In the data source generation (Extraction Structure),

Select respective date field which you are looking for "Billing Document Item Data" (2LIS_13_VDITM).

Check the selection check box near by the field &

Generate the data source.

Than you can find it in the respective object in info package for restricting your selection entries.

The same thing has to be done for 2LIS_13_VDHDR

also.

Hope now you will be clear. update me if you had any problem.

Regards

Saravanan.ar

[Former Member · Accepted solution]

Hi Raju

thanks for ur excellent Response

I have solved my problem.I assigned full points to u

Suma

[raju_saravanan · Accepted solution]

Dear SKR

Thanks for your valuable points

Regards

Saravanan.ar