topic Re: DDIC Tables and database table in Application Development and Automation Discussions

DDIC Tables and database table

Former Member — Mon, 06 Aug 2007 11:09:37 GMT

hi,

could u explain the diffrence betwen DDIC Tables and database table?

how many selection -screen can be maintained in a report?

regards

eswar.

Re: DDIC Tables and database table

Former Member — Mon, 06 Aug 2007 11:14:25 GMT

DDIC - Data Dictionary Information Centre

u can have as many selection screen as u want in u'r program

one main selection screen n other created using 'AS WINDOW' addition.

Sameer

Re: DDIC Tables and database table

varma_narayana — Mon, 06 Aug 2007 11:14:44 GMT

Hi..

Tables are defined in Data dictionary and their Physical storage is in Database.

So DDIC table and DB Table are Same.

In Report there are 2 types of selection Screens.

1. Standard selection screen

Eg:

PARAMETERS : P_MATNR TYPE MARA-MATNR.

this will create a Standard selection screen with a number 1000.

It is called automatically after the INITIALIZATION event.

2. Customized Selection screen: We can Create many.

SELECTION-SCREEN: BEGIN OF SCREEN 10.

PARAMETERS: P_MATNR LIKE MARA-MATNR.

SELECTION-SCREEN: END OF SCREEN 10.

they must be called using the statement

CALL SELECTION-SCREEN 10.

Reward if Helpful

Re: DDIC Tables and database table

Former Member — Mon, 06 Aug 2007 11:15:51 GMT

Only one STANDARD SELECTION SCREEN can be mainteined,but you can solve this problem by DIALOG programming or "window" option.

Regards

Yossi

Message was edited by:

Yossi Rozenberg

Re: DDIC Tables and database table

Former Member — Mon, 06 Aug 2007 11:16:36 GMT

DDIC stands for Data Dictionary

There exist ONE TO ONE relationship between ddic table and transparent table..

It means :

There is a physical table on the database for each transparent table. The names of the physical tables and the logical table definition in the ABAP/4 Dictionary correspond and

one field in dictionary correspond to one field in physical database.

When the table is activated, a physical table definition is created in the database for the table definition stored in the ABAP Dictionary. The table definition is translated from the ABAP Dictionary to a definition of the particular database in One to One Relationship..

Pooled table

Pooled tables can be used to store control data (e.g. screen sequences, program parameters or temporary data). 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.

Cluster table

Cluster tables contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least parts of the keys must agree. Several cluster tables are stored in one corresponding table on the database.

Regards

Re: DDIC Tables and database table

Former Member — Mon, 06 Aug 2007 11:16:59 GMT

Hi,

DDIC stands for Data Dictionary.

In DDIC there are two types of tables,

1.Transparent Tables

2.Pooled and Clustered Tables

There exist ONE TO ONE relationship between ddic table and transparent table..

It means :

There is a physical table on the database for each transparent table. The names of the physical tables and the logical table definition in the ABAP/4 Dictionary correspond and

one field in dictionary correspond to one field in physical database.

Pooled table

Cluster table

Regards,

Padmam.