custom trable/ tarnsparent table

[Former Member]

What is custom program? And y do we use transparent table most. What is the importance of using tarnsparent table a lot.

Thanks & regards......

[Former Member]

A Custom program is a program written by a customer (consultants like us) and these programs start with a Z / Y.

Transparent table, is nothing but a table in the data dictionary and allows writing SELECTS using JOINS. That is one of the reasons why they are most used.

Regards,

Ravi

Note - Please mark all the helpful answers

[Former Member]

hi Abhey,

Custom Program is the program developed by some developer which either starts with Z or Y( not a standard program ).....

Transparent table is like a normal data base table. There are 3 types of tables.

1) Transparent tables

2) Pool tables

3) Cluster tables

1) From user point of view, all tables are used to store data whatever be the type of table. There is no difference in the behavior or operation of these tables. All of them can be managed by using standard OPEN SQL.

2) However from an administrator point of view transparent table do exists with the same structure both in the dictionary as well as in the database, exactly with the same data and fields. While other two are not transparent in the sense that they are not manageable directly using database system tools.

3) You can access these tables in R/3 environment from the ABAP/4 dictionary. You cannot use native SQL on these tables. Pool or cluster tables are logical tables, which are arranged as records of transparent table.

Regards,

Santosh