topic Re: Query on COSS table in Application Development and Automation Discussions

Query on COSS table

Former Member — Wed, 06 Jan 2010 09:04:13 GMT

Hi Friends

Am querying COSS table for posting details based on all primary keys available.

i want to select only particular field WTGXXX (XXX- is the period ranging from 001 till 016) in the select clause.

Is it possible, if yes how is the approach.

Thanks

Lavanya

Re: Query on COSS table

Former Member — Wed, 06 Jan 2010 09:31:59 GMT

Hello

Try like this:


PARAMETERS: P_PERIO(3).
DATA: IFIELDS LIKE RSFS_STRUC OCCURS 0 WITH HEADER LINE.
DATA: BEGIN OF ITAB OCCURS 0,
      DMBTR TYPE WTGXXX,
      END OF ITAB.
CONCATENATE 'WTG' P_PERIO INTO IFIELDS-LINE. APPEND IFIELDS.

SELECT (IFIELDS) INTO TABLE ITAB FROM COSS
       WHERE LEDNR EQ ... " set conditions
         AND OBJNR EQ ...
         AND GJAHR EQ ...

You set P_PERIO value (f.e. 001) and run. In table itab you will have all values of field WTG001 for particular conditions.

Re: Query on COSS table

Former Member — Thu, 28 Jan 2010 10:51:37 GMT

thanks, it works