View Creation

[Former Member]

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]

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]

Hi,

Try following links

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

Regards

Vinod

[Former Member]

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