Runtime Error

[Former Member]

Hi Frds

Im displaying the material details based on Plant and Storage.

while executeing the program ,its taking too much time to select the material .

I hv put inner join for the table MARA,MARD,MAKT,MARC,MLGN. For displaying ROL,UOM,Warehouse,Material Code,Material Desc.,

This is my select statement ,pls correct my mistake.

SELECT MARA_{MATNR MARA}MEINS

MAKT~MAKTX

MARC~MINBE

MARD_{WERKS MARD}LGORT

MLGN~LGNUM

INTO CORRESPONDING FIELDS OF TABLE IMAT

FROM MARA INNER JOIN MAKT ON MAKT_{MATNR = MARA}MATNR

INNER JOIN MARC ON MARC_{MATNR = MARA}MATNR

INNER JOIN MARD ON MARD_{MATNR = MARA}MATNR

INNER JOIN MLGN ON MLGN_{MATNR = MARA}MATNR

WHERE MARA~MATNR IN MATERIAL AND

MARD~WERKS IN PLANT AND

MARD~LGORT IN STORAGE.

IF SY-SUBRC <> 0.

message 'No data Found for the selection ' type 'E'.

EXIT.

ENDIF.

Thanks

Pari

[Former Member]

Hi Frds

Im displaying the material details based on Plant and Storage.

while executeing the program ,its taking too much time to select the material .

I hv put inner join for the table MARA,MARD,MAKT,MARC,MLGN. For displaying ROL,UOM,Warehouse,Material Code,Material Desc.,

This is my select statement ,pls correct my mistake.

SELECT MARA_{MATNR MARA}MEINS

MAKT~MAKTX

MARC~MINBE

MARD_{WERKS MARD}LGORT

MLGN~LGNUM

INTO CORRESPONDING FIELDS OF TABLE IMAT

FROM MARA INNER JOIN MAKT ON MAKT_{MATNR = MARA}MATNR

INNER JOIN MARC ON MARC_{MATNR = MARA}MATNR

INNER JOIN MARD ON MARD_{MATNR = MARA}MATNR

INNER JOIN MLGN ON MLGN_{MATNR = MARA}MATNR

WHERE MARA~MATNR IN MATERIAL AND

MARD~WERKS IN PLANT AND

MARD~LGORT IN STORAGE.

IF SY-SUBRC <> 0.

message 'No data Found for the selection ' type 'E'.

EXIT.

ENDIF.

Thanks

Pari

[Former Member]

Hi,

are you sure, that you have datas inside MLGN?

Regards

Nicole

[Former Member]

first u use inner join for 2 table MARA,MARD and then for other table use for all entries in i_mara_mard( join of 2 table nmara & mard)

it will solved ur problem and improve the performance also