Deep structure in database table (not table type)

[Former Member]

Hi

Is it possible to use a deep structure in a DB table. Till now I have seen only deep structure being used as table type. Actually I want to store a matnr range table

as a data field of a custom table. Now the problem is how to define the data type. Which data element to be used and how table maintainence generator would react to it

[Former Member]

Hi Saurav,

You can not use a deep structure in a database table. If you want to store a matnr range table in the database, you can use a cluster table and save your data in that table.But you can not change the data in cluster table using table maintenance generator. If you want to save a matnr range table for each line of your main table, then you must create a new DB table with a foreign key relationship to the main table, in which you can add one record(maybe with a counter) for each line of the matnr range table.

Regards,

Sükrü

[Former Member]

HI

Suekrue

Thanks a lot for your suggestion. But there are some sap notes which do talk about deep structure being used in db tables. Like consider the note 725729 (Help view for tables with deep structure). This means that deep structure is possible.

Regards

Saurav