topic select statement in FM in Application Development and Automation Discussions

select statement in FM

waqar_ahmed — Tue, 29 Oct 2013 09:46:30 GMT

Hi All,

I am extracting data from two tables (EKKO,EKPO)using Function module. I have created extract structure on these tables, there is component AEDAT in both tables with same name and I am not able to create field in structure with same name. So I created one as zAEDAT, If I create one with zAEDAT than I am not able to use select as there is not standard component as ZAEDAT.

Can some please tell me the select statement to fetch both of these dates in single select, below statement will not work as there is no component as ZAEDAT. I am using cursors to fetch this data, not using any internal tables.

Please suggest.

SELECT EKKO~EBELN EKKO~AEDAT EKPO~ZAEDAT

          FROM EKKO
          INNER JOIN EKPO ON EKKO~EBELN= EKPO~EBELN

           Where EKKO~EBELN IN PONO.

Regards,

Ray

Re: select statement in FM

Former Member — Tue, 29 Oct 2013 09:49:28 GMT

SELECT EKKO~AEDAT as ZAEDAT
FROM ekko

INNER JOIN EKPO ON EKKO~EBELN= EKPO~EBELN

Where EKKO~EBELN IN PONO.

Regards
Shaik

Re: select statement in FM

nabheetscn — Tue, 29 Oct 2013 09:52:26 GMT

SELECT EKKO~EBELN EKKO~AEDAT as ZEDAT EKPO~ZAEDAT as ZEDAT1

          FROM EKKO
          INNER JOIN EKPO ON EKKO~EBELN= EKPO~EBELN

           Where EKKO~EBELN IN PONO.

Re: select statement in FM

Former Member — Tue, 29 Oct 2013 10:01:56 GMT

Hello Ray,

first thing is you can create a field AEDAT in your table or structure with same name .

i dono why you going with zaedat field .

As above suggested you can use,

SELECT EKKO~AEDAT as ZAEDAT
FROM ekko

INNER JOIN EKPO ON EKKO~EBELN= EKPO~EBELN

Where EKKO~EBELN IN PONO.

Re: select statement in FM

Former Member — Tue, 29 Oct 2013 10:02:55 GMT

types : begin of ty_tab,

ebeln type ebeln,

aedat type aedat,

zaedat type aedat,

end of ty_tab.

data: itab type standard table of ty_tab.

since AEDAT is in both tables u can write join as below

SELECT EKKO~EBELN EKKO~AEDAT EKPO~AEDAT

FROM EKKO
INNER JOIN EKPO ON EKKO~EBELN = EKPO~EBELN

INTO TABLE itab
WHERE EKKO~EBELN IN PONO.