cancel
Showing results for 
Search instead for 
Did you mean: 

Datasource Enhancement

Former Member
0 Kudos
32

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

Accepted Solutions (1)

Accepted Solutions (1)

mansi_dandavate
Active Contributor
0 Kudos

HI,

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

Regards,

Mansi

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

shanthi_bhaskar
Active Contributor
0 Kudos

shravani,

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