Question Re: Pulling data from PSA in Technology Q&A

Pulling data from PSA

Former Member — Tue, 12 Jun 2012 06:56:04 GMT

Hello gurus

Is there any way in BI where I can pull data from PSA table directly instead of staging it to a dso or infocube.

The situation is that I want to perform a look up on the psa table data.

I hope my statement is clear.

can any one please let me know with a specific example?

regards

krishna

Re: Pulling data from PSA

Former Member — Tue, 12 Jun 2012 08:01:19 GMT

you really need to be more specific if you want an answer...

where do you want to do the lookup? in a query, in a transformation, from another system?

Re: Pulling data from PSA

Former Member — Tue, 12 Jun 2012 08:35:23 GMT

Hello

I want to do a lookup at the transformation level i.e in the start routine.

regards

krishna

Re: Pulling data from PSA

Former Member — Tue, 12 Jun 2012 08:50:00 GMT

search the net...there a million examples available...

eg http://scn.sap.com/thread/2076011

Re: Pulling data from PSA

former_member188080 — Tue, 12 Jun 2012 09:21:09 GMT

Hi,

You need to stage the data from PSA to some data target..say DSO..

If it is standard DSO you can do look up from say active table data and change log table as well..

I have hardly used direct look up from PSA but normally you should have say write optimised DSO ,so we should not change the data when u are loading write optimised DSO..so from this DSO you can do look up instead of PSA?

also once PSA is deleted it is difficult to track what value you looked up and you have to go to source system all the way..

Thanks and regards

Kiran

Re: Pulling data from PSA

Former Member — Tue, 12 Jun 2012 11:56:32 GMT

Pls refer to my initial question. I do not want to stage the data even to a write optimized dso.

Can I still perform a lookup or write some kind of select query/

regards

krishna

Re: Pulling data from PSA

former_member188080 — Tue, 12 Jun 2012 12:08:49 GMT

Hi Krishna,

you can select the data from PSA directly,

there should not be any issue..I never tried..it is PSA table only so /BIC/...YOU can try selecting table..(I never tried this,but think all the points I mentioned above)

Thanks and regards

Kiran

Re: Pulling data from PSA

Former Member — Tue, 12 Jun 2012 12:28:57 GMT

yes you can. as the name of the psa table can change, you need to have a dynamic selection statement. i assume you know how to do this, else search on the net. Now you just need an entry in table TVARV where you create a variable holding the name of the psa table.

in the start routine select then this table name and use it in the dynamic selection

you can change the parameter (psa table name) in every system