Skip to Content
Author's profile photo Raman Korrapati

3 Ways to find PSA Table Name

Hi All,

This doc will help you how to find psa table name.

We have 3 ways to find PSA table name.

1.  Use table at SE11 , Table – RSDSTS: click on display, choose, contents , you can
give data source name and execute. You will see below details in a row.

/wp-content/uploads/2013/06/1_235776.jpg

2. At RSA1, left side select info provider or Data source, go to respective data source ,select your data source(showed
in green circle), select on wrinch symbol, marked in red circle. Below screen
comes up. There you can see PSA Table.

/wp-content/uploads/2013/06/233_235775.jpg

My 2ns step and below screens shows same. but way is different. in below link, we need to go data source, from menu –> Go To–> Technical attributes.

http://rahulursbw.wordpress.com/2010/03/21/find-the-psa-database-table-and-data/

3.  At RSA1, left side choose  info provider, right side, go to respective data source, right click–> manage, there one pop screen comes, there on
top you may see request for psa /BIC/B0000XXX. For this name you need to add 3 ‘0’ at end. That will indicate psa name. i.e my below screen show as /BIC/B0000574, so my psa name will be /BIC/B000574000. You can see the same name in below 2nd screen.

/wp-content/uploads/2013/06/4_235777.jpg

From below my screen PSA Table name – /BIC/B0000574000:

/wp-content/uploads/2013/06/5_235786.jpg

Very small information but might be useful.

Thanks for reading…..

Assigned Tags

      109 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Pretty good Ram.  Keep going.  🙂

      Author's profile photo Former Member
      Former Member

      Thanks Raman!!You are providing very useful info buddy!! 🙂

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Your Welcome Raj

      Author's profile photo Former Member
      Former Member

      Hello Raman!!

      Can  you Please explain me the following topic

      1) Temporary storage area in DTP?

      Thanks,

      Raj

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Actually when we set error dtp setting this option will be useful to use. there are best pdfs on this usage. refer the below one. it may clear your doubts.

      Temporary storage area in DTP

      How to view temporary storage area view. check below discussion.

      http://scn.sap.com/thread/1000402

      Author's profile photo Former Member
      Former Member

      Hi Raman,

      Very useful information.

      Thanks,

      Somesh

      Author's profile photo Former Member
      Former Member

      Very good document

      Author's profile photo Former Member
      Former Member

      This is small but very useful information.

      Thanks

      Jitin

      Author's profile photo Former Member
      Former Member

      Hi!

      I couldn't find datasource 0FI_AP_4 in RSDSTS table. What does this mean?

      Despite this, I could run al extraction without any problem.

      I tried replicating datasource but didn't appear in table RSDSTS.

      Any comment will be helpfull.

      Thanks in advance.

      Best regards,

      Ana

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      is your data source in 3.x and active version at bw side then it would be there.As my guess your data source migrated to 7.x(RSDS).

      if your data source in 7.x then you can check table RSDS.

      Author's profile photo Former Member
      Former Member

      That's right. It's a migrated datasource. I finally found PSA table name following this link:

      http://rahulursbw.wordpress.com/2010/03/21/find-the-psa-database-table-and-data/

      Thanks for your help.

      Regards,

      Ana

      Author's profile photo Renjith Kumar Palaniswamy
      Renjith Kumar Palaniswamy

      Hi Raman,

      Nice document!

      Wish you to write more documents like this in SCN 🙂

      Renjith

      BW Forum moderator.

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Hi,

      its Great feeling to receive comments form you Renjit.

      Surely i will try to full fill your statement.

      Thanks

      Raman

      Author's profile photo Shyamala Kalluri
      Shyamala Kalluri

      Informative document,

      Thanks for Sharing Ram

      BR,

      Shyamala.

      Author's profile photo Former Member
      Former Member

      Wonderful!

      Very, very useful and easy explained!

      Author's profile photo Aparajit Banik
      Aparajit Banik

      Master Document
      Thanks for the KT always Rama 🙂

      Author's profile photo venkat yerva
      venkat yerva

      Its simple and good .But in latest versions this technical name is not required since PSA Deletion step directly accepts data source name .

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Its depend on situation we may need psa name.

      PSA Deletion is not the only one.

      After the data source activation also we may have some inconsistencies.

      in such cases we can activate PSA table name by using SE14.

      Author's profile photo venkat yerva
      venkat yerva

      Ok.

      Author's profile photo Naveen Pathipaka
      Naveen Pathipaka

      Useful information

      ---

      Naveen

      Author's profile photo Former Member
      Former Member

      good document, Nice info for beginners..

      Author's profile photo Hello PAMARTHI
      Hello PAMARTHI

      Hi Raman,

      Thanks a lot, it is very nice, in some times where there are complex coding requires we can use the first one..

      Very Nice Raman.

      Thanks & Regards.

      P Sriram.

      Author's profile photo Murlli Maraati
      Murlli Maraati

      Thanks for sharing this... It was a time saver..

      Author's profile photo Former Member
      Former Member

      Superb..

      Regards,

      Santhana...