Skip to Content
0
Former Member
Jan 27, 2009 at 10:53 AM

Can we write select query using Maintenance view table

1034 Views

Hello,

Can we write Select query using Maintenanve view table ?

Table name is /SAPSLL/V_TCAV20 - This is Maintenenca view. 


TYPES : BEGIN OF TY_V_TCAV20,
        ATTRI    TYPE  /SAPSLL/ATTRI,    "Type of Product Attribute from Feeder System
        ATTRV20  TYPE  /SAPSLL/TCOATV20, "Attribute Value for Chars from Feeder System 
         TEXT1    TYPE  /SAPSLL/TEXT60,   "Text 60 Characters Long
        END OF TY_V_TCAV20.

DATA : T_V_TCAV20 TYPE STANDARD TABLE OF TY_V_TCAV20,
       WA_V_TCAV20 TYPE TY_V_TCAV20.

SELECT ATTRI
       ATTRV20
       FROM /sapsll/V_TCAV20
       INTO TABLE T_V_TCAV20.
       WHERE ATTR20A EQ T_PRGEN-ATTR20A.


When i write a select query as shown above it displays an error message as below : 

/SAPSLL/V_TCAV20 IS NOT DEFINED IN THE ABAP DICTIONARY AS A TABLE, 
PROJECTION VIEW OR DATRABASE VIEW.

Any suggestions will be apprecaited!

REgards,

Kittu