topic Re: Table view in Application Development and Automation Discussions

Table view

Former Member — Tue, 05 Jun 2007 06:41:22 GMT

Hi,

I have to add fields into an existing view, in sm30 custom table contains material, the requirement is to add material description and validity dates. How can I do that? Material descriptions will be coming from MAKT.

Thanks in advance.

Re: Table view

Former Member — Tue, 05 Jun 2007 06:44:13 GMT

Hi,

If you have to change the VIEW directly from Se11 then chage this and add the fieds and activate the view, or else do the Append Structure to add the new fields

Regards

Sudheer

Re: Table view

Former Member — Tue, 05 Jun 2007 06:46:31 GMT

yes the add the table MAKT in the view write the join condition

customtable-MATNR = MAKT-MATNR ...

then in the newxt tabl field list add the field description from the Table MAKT ....

active and execute ...

reward points if it is usefull ....

Girish

Re: Table view

Former Member — Tue, 05 Jun 2007 06:47:22 GMT

Add the Table MAKT in the Table /JOIN conditions with proper condition such that MARA-MATNR = MAKT-MATNR and equate MANDT field of both tables

and in the fields define the Extra fields like DESCRIPTION and DATEs and activate the view.

Reward points if useful

Regards

Anji

Re: Table view

Former Member — Tue, 05 Jun 2007 06:48:57 GMT

adding new feilds in the table can be done in SE11, in SM30 we can create entries.

regards

prabhu

Re: Table view

Former Member — Tue, 05 Jun 2007 07:33:19 GMT

Thanks. I have successfully add new fields. How can i automatically display material description when the user enter new material number? Existing table used in view is a transparent table, it seems i cannot use JOIN. Also, not all fields is displayed in SM30, how can i display validation dates eventhough they're not key fields?

Re: Table view

Former Member — Thu, 25 Sep 2008 08:44:55 GMT

closing this thread