Select Stmt

[Former Member]

Hi,

I have material Document number, from this i need to retrieve the sales oder,sales order item , and delivery number. How can i write select stmet for this Query

regards,ram

[Former Member]

Hi,

SELECT <F1,F2...>

INTO TABLE <ITAB Internal Table>

FROM <DB TABLE NAME>

WHERE <Condition that u want>.

Regards,

Ranjit Thakur.

<b>Please Mark The Helpful Answer.</b>

[Former Member]

Hi,

Material Document coming from MSEG and 3 fileds from LIPS.

regards,ram

[Former Member]

HI Ram,

SELECT LIPS_{FLD1 LIPS}FLD2 LIPS_{FLD3 INTO CORRESPONDING FIELDS OF TABLE ITAB FROM MSEG INNER JOIN LIPS ON MSEG}MATNR = LIPS_{MATNR AND MSEG}WERKS = LIPS_{WERKS WHERE MSEG}MBLNR IN SO_MBLNR AND...UR CONDITIONS.

Regards

SAB

[Former Member]

I think there is no stright forward ,

get the data from mseg and do compare with VBAP like where matnr and werks..

Now you will get multiple sales order for each material ..