Transparent Table and Structures

[Former Member]

Hi,

Small question in regards to tables and structures. For my understanding, is this approach correct:

1. Transparent Table has a 1-1 relation to the database table and looks exactly as in the Data Dictionary. Its contained data is physically written in the database.

2. Structure: is a collection of fields from different (physical) tables and is temporary used in ABAP programs as a sort of variable to store data. It is a predefined 'structured' variable. Its data is not physically stored.

So in this respect, how is an include and/or append structure used? I understand that this is basically an extension to a database table, but where and how are the values stored as I assume this is not in the original transaprent database?

Is this correct?

Thanks,

Sebastiaan.

[RichHeilman]

I would say that you understand it correctly, but I would correct one statement.

Structure: is a collection of fields from different (physical) tables

The fields of the structure do NOT have to relate to transparent table fields, these fields could simply be apart of the structure only.

As for INCLUDE and APPEND structures, these are what they sound like. Say for example, you have 3 separate structures, and you also want a structure which includes all 3 of these, in this case, you don;t want to create the new structure by simply copy/pasting the fields, you INCLUDE them and this way, when a field is added to the one child structure, the same change is reflected in the parent structure. Make sense?

Regards,

Rich Heilman

[Former Member]

>So in this respect, how is an include and/or append structure used? I understand that this is basically an >extension to a database table, but where and how are the values stored as I assume this is not in the >original transaprent database?

physically you can see a structure, But when you consider a transparent table then you cannot spearate it from the table definition, since you included/appended the same to the main Transparent table.

Appendstructure/Include structure is used to enhance the table defintion, Though physically you add the additional fields using structure, all the fields are part of transparent table.

So the Data will be stored Directly to the Transparent table,

[Former Member]

Thanks for your replies.