Skip to Content
0
Former Member
Sep 19, 2007 at 02:45 PM

Select statement spliting

13 Views

Hi Gurus,

How can i split this select statement..can you please tell me .its veru urgent.

SELECT MARA~MATNR

MAKT~MAKTX

MARA~MEINS

MCHA~WERKS

MCH1~CHARG

MCH1~LICHA

MCH1~VFDAT

MCH1~ERSDA

MCH1~LWEDT

MCH1~HSDAT

INTO TABLE TB_BATCH

FROM MCH1 INNER JOIN MCHA ON

MCHAMATNR = MCH1MATNR AND

MCHACHARG = MCH1CHARG

INNER JOIN MARA ON

MARAMATNR = MCH1MATNR

INNER JOIN MAKT ON

MAKTMATNR = MCH1MATNR

WHERE MCH1~MATNR IN S_MATNR AND

MCHA~WERKS = P_WERKS AND

MARA~MTART IN R_MTART AND

MAKT~SPRAS = SY-LANGU.