Table view

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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

regards

prabhu

[Former Member]

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?

[Former Member]

closing this thread