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