topic Re: Complex ZTable ? in Application Development and Automation Discussions

Complex ZTable ?

Former Member — Thu, 05 Aug 2010 12:28:58 GMT

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 !

Re: Complex ZTable ?

Former Member — Thu, 05 Aug 2010 12:35:00 GMT

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.

Re: Complex ZTable ?

Sandeep_Panghal — Thu, 05 Aug 2010 12:40:53 GMT

You have to add the descr field in the table .

Re: Complex ZTable ?

Former Member — Thu, 05 Aug 2010 12:44:08 GMT

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

Re: Complex ZTable ?

ThomasZloch — Thu, 05 Aug 2010 12:56:13 GMT

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