cancel
Showing results for 
Search instead for 
Did you mean: 

Quick question, Is PSA a transparent physical table?

Former Member
0 Kudos

HI all,

I know this question has been repeated a lot. But I have always known that PSA replicates the structure on the R/3 system and it holds the data in the in

TRANSPARENT table. This is a bit confusing jargon to me.

So please correct me if I am wrong in assuming that PSA is a physical table which is transparent from the user/ or something.

Can someone tell me what " Transparent "means in this context.

Thanks,

Raj

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Yes. PSA has the same structure of the source..it has some extra columns like..record number, packet id, request id...

It is the physical storage of records..it can be maintained to as many days as u wish after that to reduce the disk sapce u can delete the PSA data(via..PC) and schedule it to run periodically....It is not used for reporting..it is just a used for staging purpose for datatarget..Ok is PSA transparent??..In BI i believe every thing is transparent..the users are not concerned from where they are getting the data(may be ODS or Cube)..they are just bothered about the retrival time of the result...

Regards,

B

Former Member
0 Kudos

Thanks BR for the reply again.

I know the details of how PSA functions but I needed to know in a deep level like where exactly it resides.

Is there a connection between PRA segment or is it called PSA segment 1 through 10. Cos usually that gives ORA 1555 and such other errors. Am I thinking in the right direction.

THanks

Raj

Answers (1)

Answers (1)

chemicala_srimallikarjuna
Active Contributor
0 Kudos

Hi,

The term "transparent" refer here, to the category of a table. It defines how the logical table (in the ABAP dictionary) is represented in the underlying database (Oracle, MSSQL, Informix...)

transparent: a physical table exist in the DB for each transparent table of the ABAP dictionary. Their names are the same and their definition as well.

Hope this helps,

Regards

CSM Reddy

Former Member
0 Kudos

Hello CSM,

So the other tables must be pool and cluster if I am not wrong.

Bottomline. This table is located on the Oracle Db or am I mistaken.

Please clarify

Thanks

Raj

Former Member
0 Kudos

Yes.. All the tables in BI are lying in the underlying DB...even PSA tables are...

Regards,

B

Former Member
0 Kudos

B,

What are the other types of table then.?

when we say it is transparent to the user? which user is it refering to. Cos we can check the data in PSA just as we can an ODS or ICUBE.

Well I would like to add that

there are three types of tables in all in RDMS

Transparent tables

Pooled tables

Cluster

Transparent tables have 1 - 1 cardinality b/w Data Dictionary and Database, and non transparent ( Cluster and Pooled) tables have Many - 1 cardinality. Transparent

Its just a type of table. My bad for asking this on SDN instead of researching a bit on my own then again, I guess I just wanted to create a discussion.

Thanks

Raj

Former Member
0 Kudos

Users i am referring to the business users ..who are just concerned about the report output..All the tables in BI are grouped to table space in DB..mostly it is grouped logically like PSA tables are grouped together to some number of table space..You can chk the table space in SE11 or DB02...

Regards,

B