topic Re: select statement for fields in dictionary in Application Development and Automation Discussions

select statement for fields in dictionary

Former Member — Wed, 24 Jan 2007 08:38:15 GMT

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 — Wed, 24 Jan 2007 08:40:59 GMT

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 — Wed, 24 Jan 2007 08:41:21 GMT

Change your code as below:

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

manoj

Former Member — Wed, 24 Jan 2007 08:48:46 GMT

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 — Wed, 24 Jan 2007 08:51:51 GMT

dclare TABLES tables statement at the top

TABLES : T052