Skip to Content
0
Former Member
Feb 19, 2009 at 01:38 PM

Joining tables EKPO & MSEG

2867 Views

Hi All,

This is my code:

SELECT EKKO~EBELN

EKKO~LIFNR

EKKO~BUKRS

EKKO~EKORG

EKPO~EBELP

EKPO~TXZ01

EKPO~MATNR

EKPO~MENGE

EKPO~MEINS

EKPO~UNTTO

EKPO~PSTYP

FROM EKKO

INNER JOIN EKPO ON

EKKOEBELN = EKPOEBELN

INTO TABLE T_EKPO

UP TO P_MAX ROWS

WHERE EKKO~EBELN IN S_EBELN

AND EKKO~BSART IN S_BSART

AND EKKO~LIFNR IN S_LIFNR

AND EKKO~EKORG IN S_EKORG

AND EKKO~EKGRP IN S_EKGRP

AND EKKO~BEDAT IN S_BEDAT

AND EKPO~MATNR IN S_MATNR

AND EKPO~WERKS IN S_WERKS

AND EKPO~MATKL IN S_MATKL

AND EKPO~PSTYP IN R_PSTYP

AND EKPO~KNTTP IN S_KNTTP.

SELECT MBLNR

ZEILE

ERFMG

EBELN

EBELP

FROM MSEG

INTO TABLE T_MSEG

FOR ALL ENTRIES IN T_EKPO

WHERE EBELN = T_EKPO-EBELN

AND EBELP = T_EKPO-EBELP.

Now i am getting time out error. Can Any one suggest how can i solve this issue.