topic Data Base table with deep structures (tables). in Application Development and Automation Discussions

Data Base table with deep structures (tables).

Former Member — Tue, 22 Sep 2009 15:24:40 GMT

Hi All,

I have a scenario where for a given return id (key) there could be multiple address values. The relationship is something like:

KEY1 --- Address1 -

AddLine11

AddLine12

AddLine13

--- Address2 -

AddLine21

AddLine22

AddLine23

--- Address3 -

AddLine31

AddLine32

AddLine33

Is it possible to create only one database table with deep structures (tables) to store the key value and the corresponding multiple addresses, as shown above?

Thanks,

Manohar Dubbaka.

Re: Data Base table with deep structures (tables).

Former Member — Tue, 22 Sep 2009 15:29:07 GMT

Ya this is possible. Take help on making a database table in SAP.

Re: Data Base table with deep structures (tables).

Former Member — Tue, 22 Sep 2009 15:32:28 GMT

Hi,

Thanks for the response. Could you please let me know, how to achieve the same? Like, should I make use of a table type, or a deep structure?

Thanks in advance!

Thanks,

Manohar Dubbaka.

Re: Data Base table with deep structures (tables).

Former Member — Tue, 22 Sep 2009 15:43:41 GMT

Hi ,

Sorry I tried , But we can only include Flat structures in a database table.Check at your end.

Deep structures not possible.

Re: Data Base table with deep structures (tables).

Former Member — Tue, 22 Sep 2009 16:21:16 GMT

Hi,

Thanks for the quick response. Even I tried to create a table type and use it in the table. But the system returns an error message during activation of the table

Field ADRSS: Structured type YST_ADRS cannot be used in DB table YTEST_TBOR

Field YADRS: Table type YTT_ADRS cannot be used in DB table YTEST_TBOR

Error in ALTER TABLE generation for table YTEST_TBOR

Table YTEST_TBOR (Statements could not be generated)

I think, it is not possible to create the deep structured database tables.

Just being optimistic: If anyone is successful in creating the scenario mentioned in this post. Please post your response to this post.

Thanks,

Manohar Dubbaka.

Re: Data Base table with deep structures (tables).

christine_evans — Wed, 23 Sep 2009 09:55:10 GMT

Not possible as far as I know. But in a relational database you shouldn't need to do this anyway. Hold the addresses in another table linked to the main table by the main table key. If you need a further breakdown of each address, you could add a third table.

Re: Data Base table with deep structures (tables).

Former Member — Wed, 30 Sep 2009 21:55:58 GMT

Deep structures not possible in database tables.