Storing Deep structure data in the Data Dictionary

[mark_daley1]

Hi folks,

I'm pretty sure this is not possible, but I want to know is there a way to store a deep data type in the dictionary...?

I know this is possible in internal tables but is it possible in dictionary?

By deep I mean a structure with sub structures/tables?

Cheers

Mark

[kesavadas_thekkillath]

You can only create a deep structure but not table. In relational database you have to create seperate ones and maintain the relation. You can include or append a structure to the existing tables.

What is the requirement ???

If the requiremnt is to provide data in one shot then you can go for mIntenance views/cluster views ( clubs more than one tables )

[Former Member]

Hello,

It is possible. Here is how:

As for the structure - you can include structure in another structure. You do this in the dictionary (SE11) by specifying INCLUDE under the component and the name of the structure you want to include under the component type.

As for the table inside the structure - you can specify a component of the table type. In SE11 specify your desired name under the component and in under the component type just provide the table type.

You can also create a table type with a structure which contains table type. In result you have a table of the structures of which one (or more) of the components is a table itself.

Hope this answers your question.

[mark_daley1]

Its not possiible to add a deep struc(ie with tables) or a table type to a database table, I get this error message in SE 11 when I generate..

'Table type MARA_TAB cannot be used in DB table'

[Former Member]

It is not possible to have the deep data type as the field of the database table.

You can only create deep data types and it is possible to store them in the dictionary.

[VEPS]

Hi Mark,

You may find the following link useful ...

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/cf/21ea31446011d189700000e8322d00/frameset.htm

Best regards,

-Derrick

[Former Member]

Hi Mark,

As everyone said here, it is not possible to have deep structure inside a table, instead you can create another table and store the data and then refer this table using some key relation ships this is how database will be built.

refer this link for further info: [;

- Kranthi.