topic View Creation in Application Development and Automation Discussions

View Creation

Former Member — Wed, 19 May 2010 04:51:28 GMT

Hi Experts,

Need help on View Creation.

Basically I'm creating a view on below tables:

GLPCA

PRPS

PROJ

i would like to know the relationship between the above mentioned tables.

From GLPCA, I'm getting WBS element PS_PSP_PNR. I would to know from this how to get project details.

please help..

-Praveen

Former Member — Wed, 19 May 2010 04:59:28 GMT

hi,

look at this

<moderator message: please do not post link farms>

Thanks.

Edited by: Thomas Zloch on May 19, 2010 9:11 AM

Former Member — Wed, 19 May 2010 07:53:32 GMT

Hi,

Try following links

GLPCA-PS_PSP_PNR = PRPS-PSPNR
PRPS-PSPHI = PROJ-PSPNR.

Regards

Vinod

Former Member — Wed, 19 May 2010 08:22:29 GMT

Hi Vinod,

thnaks for the inputs.

I tried that, but after creating the view, if I click on "number of entries" button, its giving me the short-dump error.

SQL error in the database when accessing a table.

please help.

regards,

Praveen