topic Re: SELECT STATEMENT in Application Development and Automation Discussions

SELECT STATEMENT

Former Member — Thu, 15 Mar 2007 14:54:26 GMT

HELLO EXPERT,

HERE IS MY SELECTION SCREEN...

SELECTION-SCREEN BEGIN OF BLOCK BLC1 WITH FRAME TITLE TEXT-B01.

SELECT-OPTIONS: P_LIFNR FOR EKKO-LIFNR,

P_MATNR FOR EKPO-MATNR,

P_EBELN FOR EKKO-EBELN,

P_EKGRP FOR EKKO-EKGRP,

P_AEDAT FOR EKKO-AEDAT,

P_EINDT FOR EKET-EINDT,

P_ERNAM FOR EKKO-ERNAM.

PARAMETERS: BLIND as checkbox.

SELECTION-SCREEN END OF BLOCK BLC1.

BASED ON THE VALUES GIVEN IN THOSE SELECTION FIELDS I HAVE TO RETRIEVE THE DATA HERE IS MY SELECT STATEMENT..

SELECT EKKO_{EBELN EKKO}AEDAT EKKO_{EKGRP EKKO}EKORG EKKO~LIFNR INTO corresponding fields of TABLE it_ekko

FROM ekko INNER JOIN EKPO ON EKKO_{EBELN = EKPO}EBELN

INNER JOIN EKET ON EKKO_{EBELN = EKET}EBELN

where lifnr in p_lifnr

and EKKO~ebeln in p_ebeln

and EKKO~ekgrp in p_ekgrp

and EKKO~aedat in p_aedat

and EKKO~ernam in p_ernam

AND EKPO~EBELN IN P_MATNR

AND EKET~EINDT IN P_EINDT.

WITH THIS CODE ONLY EKKO TABLES SELECTION FIELDS WORKING PROPERLY WHERE AS, VALUES GIVEN IN THE OTHER FIELDS P_AEDAT, P_EINDT, P_EARNM NOT WORKING PROPERLY THAT MEANS RECORDS IN THAT RANGE ONLY NOT DISPLAYING IN THE OUT PUT.

I DONNO Y.. CAN ANYONE GUIDE ME PLZ

SIRI

Re: SELECT STATEMENT

Former Member — Thu, 15 Mar 2007 15:02:29 GMT

Siri,

In your selection, you are specifying the fields that you are selecting in this line:

SELECT EKKO~EBELN EKKO~AEDAT EKKO~EKGRP EKKO~EKORG EKKO~LIFNR

There are only fields from EKKO in this list, and this is why they are the only fields being selected. You need to select some fields from EKPO and EKET in this list, too.

Good Luck

Lyal

Re: SELECT STATEMENT

Former Member — Thu, 15 Mar 2007 15:06:25 GMT

chk this one:

SELECT EKKO_{EBELN EKKO}AEDAT EKKO_{EKGRP EKKO}EKORG EKKO~LIFNR INTO corresponding fields of TABLE it_ekko

FROM ekko INNER JOIN EKPO ON EKKO_{EBELN = EKPO}EBELN

INNER JOIN EKET ON EKKO_{EBELN = EKET}EBELN

where <b>ekko~</b>lifnr in p_lifnr

and EKKO~ebeln in p_ebeln

and EKKO~ekgrp in p_ekgrp

and EKKO~aedat in p_aedat

and EKKO~ernam in p_ernam

AND EKPO~EBELN IN P_MATNR

AND EKET~EINDT IN P_EINDT.

******reward if helpful

regards,

madhu

Re: SELECT STATEMENT

Former Member — Thu, 15 Mar 2007 15:20:30 GMT

MY SELF SOLVED THE PROBLEM

ANY HOW THANKS A LOT FOR YOUR ANTICIPATION...

POINTS GIVEN....

SIRI