Datasource Enhancement

[Former Member]

Hi All,

I need to enhance a particular datasource with a view.This view has to be created from three tables and a structure.These tables have MATNR as the primary key and the structure also has the field MATNR.Could somebody guide me whether I can create a view on three tables and the structure mentioned above.

Regards,

Shravani

[mansi_dandavate · Accepted solution]

HI,

You cant create view on a structure. It has to be a database table.

Regards,

Mansi

[Former Member · Accepted solution]

Hi Mansi,

Even I was doubtful whether a view can be created on a structure or not.But my requirement demands the same.Otherwise I have to create a view from three tables MBEW,MARC and MAKT which have MATNR as the primary key and another table STPO which doesnot have MATNR as the primary key.Could you please tell me how can I proceed with this requirement.

Regards,

Shravani

[mansi_dandavate · Accepted solution]

Hi Shravani,

You can create the view on the three tables MBEW,MARC and MAKT.

And then you can append the fields that you need from STPO table as append structure.

THen popoulate those in the exit.

Regards,

Mansi

[shanthi_bhaskar]

shravani,

append that structure to one of three table so that it can used in the view..