Data Base table with deep structures (tables).

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi ,

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

Deep structures not possible.

[Former Member]

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.

[christine_evans]

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.

[Former Member]

Deep structures not possible in database tables.