What is *zv_pa0900 here?

[Former Member]

Hi Gems,

I am seeing a program (4.6c) i see few declarations as below:

data :

zv_pa0900, " DB view on PA0900 for security

*zv_pa0900, -

---

> what is this?

....etc..

SELECT SINGLE pernr FROM vbpa..

where ...

IF sy-subrc = 0.

SELECT SINGLE * FROM *zv_pa0900 WHERE pernr = vbpa-pernr

AND endda = '99991231'.

ELSE.

CLEAR: *zv_pa0900.

ENDIF.

When i dblc clik on *zv_pa0900 it not taking me anywhere nor there is syntax error

my question is What is *zv_pa0900 in above places and how it works?

Please help.

Thanks

Dan

When i dblc clik on *zv_pa0900 it not taking me anywhere nor there is syntax error

[Former Member]

Hi,

Here *zv_pa0900 is working as a work area ie structure.

*table is the convension for declaring work area.

[Former Member]

Hi Sujit,

Thanks

But what is that *zv_pa0900 in the select stmt.

SELECT SINGLE * FROM *zv_pa0900 WHERE pernr = vbpa-pernr

..etc

How is that working like a table? Thats shocking.:-)

thanks

[Former Member]

Hi,

pa0900 is an Infotype for Create sales data.

srik.

[Former Member]

Hi Dan,

Please check the documentation (Page 38) in this link you will get the details of usinf * in front of table.its Obsolete statement.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5ac31178-0701-0010-469a-b4d...

Hope it will help you.

[Former Member]

If you check your program a little further, you might find that this SELECT is nested within a SELECT of the regular view zv_pa0900. It allows two cursors to be open for a table at one time.

It's obsolete and documented in obsolete TABLES statement (F1).

Rob

Edited by: Rob Burbank on Sep 23, 2008 10:43 AM