Complex ZTable ?

[Former Member]

Hi Gurus !

I would like to build following ZTABLE:

MANDT TYPE MANDT

MATNR TYPE MATNR

MATNR_1 TYPE MATNR

MATNR_2 TYPE MATNR

MATNR_3 TYPE MATNR

my goal would be , to see the output with material discription like this example:

100 1234 glass 3234 wood 3243 water 3223 fire

(Material Discription should come from makt !)

many thanks for your help !

[Former Member]

Hello,

I don't understand your requirement exactly.Do you want this to be done at database level or at prigram level?Can you pleae explaint it.

Thanks.

Ramya.

[Sandeep_Panghal]

You have to add the descr field in the table .

[Former Member]

I would like to do it on database level ... but i dont want to save x - times the discription of the material in the database. I would like to make an multi connection to the texttable makt ... but i dont know how

[ThomasZloch]

For this you would need a database view joining your ZTABLE with n aliases of table MAKT (n = number of MATNRs in ZTABLE).

This cannot be done via the ABAP DDIC, as far as I know, so you have to go for a programming solution, e.g. using table maintenance events.

Thomas