Skip to Content
0
Former Member
Mar 18, 2009 at 03:32 PM

What is wrong in my select statement -for all entries

214 Views

Hi,

What is wrong in my select statement.I have a problem with 3rd select statement.This is not bringiing up correct entries which I can bring it up via SE16.

DATA: it_proj TYPE TABLE OF proj.



  TYPES: t_prps TYPE prps.
  DATA: it_prps TYPE STANDARD TABLE OF t_prps.


  TYPES: BEGIN OF t_coss ,
  kstar TYPE coss-kstar,
wtg001 TYPE coss-wtg001,
     wtg002 TYPE coss-wtg002,
     wtg003 TYPE coss-wtg003,
     wtg004 TYPE coss-wtg004,
     wtg005 TYPE coss-wtg005,
     wtg006 TYPE coss-wtg006,
     wtg007 TYPE coss-wtg007,
     wtg008 TYPE coss-wtg008,
     wtg009 TYPE coss-wtg009,
  wtg010 TYPE coss-wtg010,
  wtg011 TYPE coss-wtg011,
  wtg012 TYPE coss-wtg012,
    total type coss-wtg004,


  END OF t_coss.


DATA: it_coss TYPE STANDARD TABLE OF t_coss.


I am not getting all entries in second table
which I can get it through SE16

  SELECT pspid objnr post1 vernr verna astnr astna  FROM proj
    INTO CORRESPONDING FIELDS OF TABLE it_header
    WHERE pspid = p_pspid.--- this is pulling right entries when compared via SE16



    SELECT * FROM prps  INTO CORRESPONDING FIELDS OF TABLE it_prps
    FOR ALL ENTRIES IN it_proj
    WHERE psphi = it_proj-pspnr.-- this is pulling right entries when compared via SE16


SELECT kstar wtg001 wtg002 wtg003 wtg004 wtg005 wtg006 wtg007 wtg008 
wtg009 wtg010 wtg011 wtg012 FROM coss INTO CORRESPONDING FIELDS OF TABLE it_coss
      FOR ALL ENTRIES IN it_prps
      WHERE coss~objnr = it_prps-objnr.

rgds

Praveen