Request for Definition of PVC_ACTRESVIEW

[Former Member]

Hi,

This is another try to get hold of a <b>view definition

for PVC_ACTRESVIEW</b>

(or another solution to my problems with using scenario 2+ with NWDI).

Lots of you people seem to be past the point where I'm stuck,

so maybe someone can spare a couple of minutes and look up this view definition for me?

For those interested detailed problem descriptions can be found here

Thanks a lot

Markus

[Former Member]

Hi,

This seems not to be my problem because the view exists in the new Sneakpreview (2004s SP7) but still the same error.

Now in case somebody ever needs to know the definition of that view this is how to get it (using MaxDB):

SELECT definition

FROM DOMAIN.VIEWDEFS

WHERE owner = user

AND viewname = 'PVC_ACTVERSVIEW'

And this is the result:

CREATE VIEW "PVC_ACTVERSVIEW" AS (

SELECT VSE."OBJECTID", VSE."VERSIONID", VO."OBJECTTYPE", VSE."VERSIONSETID",

VSE."DEACTIVATED", VSE."LASTMODIFIED" AS MODIFICATIONTIME,

VSE.ACTIVATIONSEQNO

FROM SAPJ2EDB."PVC_VSETELEMENT" VSE

JOIN SAPJ2EDB."PVC_VERSIONEDOBJ" VO

ON (VSE."OBJECTID" = VO."OBJECTID"))

I'll continue the problem threads with my new knowledge and see if somebody can help me out.

Cheers

Markus