topic Re: physical table? in Application Development and Automation Discussions

physical table?

Former Member — Thu, 26 Jun 2008 12:36:15 GMT

Hi experts,

I was going through some documentation and found that there is a concept of physical table in abap which is different from transparent table..

Can anyoneone please give me a clear idea of it?

Regards,

bhumika

Re: physical table?

Former Member — Thu, 26 Jun 2008 13:23:10 GMT

This message was moderated.

Re: physical table?

Former Member — Thu, 26 Jun 2008 13:28:55 GMT

Hi Bhumika.

This concept is more related to pooled tables.

Also, you can differentiate between pool and clustered tables.

Several pooled tables can be combined to form a table pool. The table pool corresponds to a physical table on the database in which all the records of the allocated pooled tables are stored.

That's how you can relate a physical table in other cases also.

Give points wisely.

Harsh

Re: physical table?

matt — Thu, 26 Jun 2008 14:24:23 GMT


> Hi experts,
> 
> I was going through some documentation and found that there is a concept of physical table in abap which is different from transparent table..
> 
> Can anyoneone please give me a clear idea of it?
> 
> Regards,
> bhumika

The physical table is how the data is stored in the database server. Fields may be in a different order in the transparent table, than from the server for example. There may be more than one physical table on the db for one transparent table -> this is how append structures work. Each append structure is, on the database, a seperate table, but with the same key as the parent table.

It is very rare that an ABAP developer needs to concern themselves with phyiscal tables.

matt

Re: physical table?

matt — Thu, 26 Jun 2008 14:24:57 GMT

Edited by: Matthew Billingham on Jun 27, 2008 9:57 AM Originally in response to an earlier response which has been deleted.

Re: physical table?

Former Member — Fri, 27 Jun 2008 04:51:09 GMT

thanks mathew