select statement for fields in dictionary

[Former Member]

Hi Experts,

I am having a select statement as

SELECT ZPRZ1 ZTAG1 FROM V_T052 INTO TABLE NETAMT WHERE ZTERM = V_T052-ZTERM.

The error I am getting is:

V_T052 is not defined in the ABAP dictionary as a table.

When I go to se11 and see for this table.I get V_T052 as a dictionary and not as a table.Wht is the best way you recommend to solve this problem.

Thanks

Kumar..

[Former Member]

Hi Kumar ,

Is that defined as a directory or as a view, because in my system it is defined as a Maint. view.

and i dont think you can select data from a maintanence view , you will have to use joins to select data from the tables used in the view

Regards

Arun

Message was edited by:

Arun R

[Former Member]

Change your code as below:

SELECT ZPRZ1 ZTAG1 FROM T052 INTO TABLE NETAMT WHERE ZTERM = T052-ZTERM.

manoj

[Former Member]

Thanks Manoj,

This has solved my problem,but now wht it says is : The field T052 is unknown.

Have you got any idea on this.

Thanks

Kumar.

[Former Member]

dclare TABLES tables statement at the top

TABLES : T052