topic Re: select Query in Application Development and Automation Discussions

select Query

Former Member — Fri, 14 Mar 2008 09:31:25 GMT

SELECT A~EBELN

B~EBELP

B~LOEKZ

A~BUKRS

A~WKURS

A~LIFNR

A~EKORG

A~EKGRP

A~WAERS

A~BEDAT

B~EBELP

B~TXZ01

B~MENGE

B~MEINS

B~NETPR

B~ELIKZ

B~EREKZ

B_{WEPOS B}WEUNB

B_{REPOS B}WEBRE B~MATKL

C~EINDT

FROM EKKO AS A

INNER JOIN EKPO AS B

ON A_{EBELN EQ B}EBELN

INNER JOIN EKET AS C ON B_{EBELN EQ C}EBELN AND B_{EBELP EQ C}EBELP

INTO CORRESPONDING FIELDS OF TABLE T_EKKO_EKPO

FOR ALL ENTRIES IN T_EKKN

WHERE A~EBELN EQ T_EKKN-EBELN

AND B~EBELP EQ T_EKKN-EBELP

AND A~BUKRS IN S_BUKRS

AND LIFNR IN S_LIFNR

AND EKORG IN S_EKORG

AND EKGRP IN S_EKGRP

AND A~BEDAT IN S_BEDAT

AND C~EINDT IN S_EINDT.

Please help me with a select query without joins for the above one. Points will be rewarded.

Regards,

srik

Re: select Query

Former Member — Fri, 14 Mar 2008 09:41:34 GMT

SELECT EBELN BUKRS WKURS

LIFNR

EKORG

EKGRP

WAERS

BEDAT

FROM EKKO

INTO CORRESPONDING FIELDS OF TABLE T_EKKO_EKPO

FOR ALL ENTRIES IN T_EKKN

WHERE EBELN EQ T_EKKN-EBELN

AND BUKRS IN S_BUKRS

AND LIFNR IN S_LIFNR

AND EKORG IN S_EKORG

AND EKGRP IN S_EKGRP

AND BEDAT IN S_BEDAT.

SELECT EBELN EBELP LOEKZ

EBELP

TXZ01

MENGE

MEINS

NETPR

ELIKZ

EREKZ

WEPOS

WEUNB

REPOS

WEBRE

MATKL

FROM EKPO

INTO CORRESPONDING FIELDS OF TABLE

T_EKKO_EKPO1

FOR ALL ENTRIES IN T_EKKN

WHERE EBELN EQ T_EKKN-EBELN

AND EBELP EQ T_EKKN-EBELP.

SELECT EBELN

EINDT

from EKET

INTO CORRESPONDING FIELDS OF

TABLE T_EKKO_EKPO2

FOR ALL ENTRIES IN T_EKKN

WHERE EBELN EQ T_EKKN-EBELN

AND C~EINDT IN S_EINDT.

Re: select Query

Former Member — Fri, 14 Mar 2008 09:45:13 GMT

take data from one table say EKKO in internal table it_A.

Eg.

Then use for all entries in IT_A for firing select on EKPO

WHERE EBELN = IT_A-EBELN.

Take this data in internal table IT_C.

SElect data fron EKES into IT_C for all entries in IT_B

WHERE EBELN = IT_B-EBELN and

EBELP = IT_B-EBELP

Re: select Query

Former Member — Fri, 14 Mar 2008 09:47:12 GMT

Hi ,

Pls explain what the problem with ur query.what is the error or

have u faced any problem with ur logic,what do u actually want to fetch.Pls Be more Clear and Specfic.

Regards,

Balakumar.G.

Re: select Query

Former Member — Fri, 14 Mar 2008 09:51:15 GMT

first u select the data ekko by passing ebeln for all entries in t_table( then table u mention)

secondly select from ekpo by ekko-ebeln for all entries in ekko

and then from eket by passing ekpo-ebeln and ekpoebelp for all entries in ekpo.