topic Re: Table creation with deep table in Application Development and Automation Discussions

Table creation with deep table

Former Member — Fri, 01 Oct 2010 05:48:28 GMT

Hi Experts,

I am creating a table which will have sales order header details and the BAPI return messages for every order.

Order header details will be single line and BAPI return messages will be multiple lines. I wanted to give this result in the table.

For capturing return messages, I created a table type with return structure. Again I went to the order details table and I appended a structure, which will have this table type as a component. But, When I activate, it says table type cannot be in DB table.

Is it not possible?

In that case should I go to only views. Can't I try with deep tables.

Thanks and regards,

Venkat.

Re: Table creation with deep table

Former Member — Fri, 01 Oct 2010 05:55:00 GMT

Hello Venkat,

You cannot create a nested table within a table.

What you can do is create a structure with the nested table type in it.

Then in your code, you can create an internal table for the same.

Hope it helps,

Regards,

Himanshu

Re: Table creation with deep table

JoffyJohn — Fri, 01 Oct 2010 05:59:41 GMT

In a table you cannot include a table type.

here in you case a sales order item will have multiple return messages.

that cannot be stored in the existing item table.

Are you using Sales order create bapi...?

IF that is the case what is the use of storing all that return messages.

If sucessful sales order no will be generated. for all other cases...some error messages will be returned.

IF you are using a program, which is sheduled, and if these message are shown as o/p using write.

then that can be seen in log.

Re: Table creation with deep table

Former Member — Fri, 01 Oct 2010 06:09:34 GMT

Hi,

I am creating one document type(ZS05) sales order against another document type(ZRR1) sales order. So, even if I have error messages, I can have ZRR1 sales order as an entry in the table and I can store the error messages against it.

This is purely developed for future reference purpose.

Thanks and regards,

Venkat.

Re: Table creation with deep table

Former Member — Fri, 01 Oct 2010 08:57:05 GMT

Why re-invent the wheel? Make use of the application log. (see transaction SLG1).