topic Re: Storing Deep structure data in the Data Dictionary in Application Development and Automation Discussions

Storing Deep structure data in the Data Dictionary

mark_daley1 — Thu, 05 May 2011 08:11:41 GMT

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

Re: Storing Deep structure data in the Data Dictionary

kesavadas_thekkillath — Thu, 05 May 2011 09:13:08 GMT

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 )

Re: Storing Deep structure data in the Data Dictionary

Former Member — Fri, 06 May 2011 08:04:44 GMT

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.

Re: Storing Deep structure data in the Data Dictionary

VEPS — Fri, 06 May 2011 09:17:18 GMT

Hi Mark,

You may find the following link useful ...

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

Best regards,

-Derrick

Re: Storing Deep structure data in the Data Dictionary

mark_daley1 — Fri, 06 May 2011 10:00:46 GMT

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'

Re: Storing Deep structure data in the Data Dictionary

Former Member — Fri, 06 May 2011 10:24:10 GMT

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.

Re: Storing Deep structure data in the Data Dictionary

Former Member — Sun, 08 May 2011 07:30:39 GMT

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.