how to load data from PSA to data target

[Former Member]

hi, gurus,

Our customer is pharm company, and they

will buy a lot of sales and marketing information from external service firm, sort of AC Nieson. And they want to setup a user interface to correct the information by

their business people, so we develop a interactive report by ABAP in BW for them, to read data from PSA, let them correct data with this program, and then update the PSA directly.

So firstly we will load data from source to PSA, then start the abap program, however how to load data from PSA to data target, infocube/ods then?

do you have any good idea here? Thanks for any input.

regards, ls

[edwin_harpino · Accepted solution]

hi,

to load psa to data target,

have you try process type 'read psa and update data target', you can specify psa table name there. the process type is under 'load process and post processing'.

transaction RSPC -> create new process chain/edit your process chain, click 'process types', you will find that type there.

hope this helps.

[Former Member · Accepted solution]

Hi,

1) In info package make sure that the data targets are there in the "Data targets" tab page

2) In the "Processing" tab page , make sure the radio button " Only PSA" is selected

3) upload the data , ask the user to modify the PSA data

4) once you are sure that data in the request is corrected , you can schedule it to update the datatarget from the context menu of that request.or you can use process chins (As Mr A.H.P suggested)

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

if use process chain, i need to specify request number, so every time i need to modify the process chain to update data target, any good suggestion here with delta loading?

btw, could i start the interactive report in process chain?

[Former Member · Accepted solution]

I think maybe u wont be using process chains in this case..

Once the PSA is modified,go to the monitor entry of the related data load,and click on 'Read Everything in Manually' button..sort of looks like a green wheel..

Once clicked,it gives a message 'Further update of data packets has been started'.It will take care of load from PSA to the required data target.

cheers,

Vishvesh

[former_member184494 · Accepted solution]

LS,

Instead of that you could do something like...

1. Load the data into an ABAP table in the BW Server and then have your ABAP program work on the same and then load the data from the ABAP table into the ODS/Cube .

Advantages oif this would be :

1. Same table is used always - data can be overwritten, the PSA table name will change depending upon the load..

2. If required , on clicking the submit button , the data load can be automated and no need of process chains here or you could have a datasource on the same and look at regular updates

3. The ABAP program would become much simpler.

Disadvantages :

1. Duplication of data in the BW system - but this will be only for one days data

2. It is not recommended to use BW as a Source System

My 0.02

Arun

P.S Assigning points is a way fo saying thanks on SDN

[Former Member · Accepted solution]

hi, arun,

would you please detail on the point 2 of advantages? thanks.

yes, i also suggest that customer setup a staging area separate with BW system, and load data into this staging firstly, however if create Z-table in BW system, we need to create interface program by ABAP, and can not leverage BW provided etl tool. And if customer data format changes, we need to change abap program rather than just simply changing transfer structure.