topic Re: Select Stmt in Application Development and Automation Discussions

Select Stmt

Former Member — Thu, 17 May 2007 13:19:35 GMT

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

Re: Select Stmt

Former Member — Thu, 17 May 2007 13:22:14 GMT

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>

Re: Select Stmt

Former Member — Thu, 17 May 2007 13:22:59 GMT

Hi,

Material Document coming from MSEG and 3 fileds from LIPS.

regards,ram

Re: Select Stmt

Former Member — Thu, 17 May 2007 13:25:17 GMT

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

Re: Select Stmt

Former Member — Thu, 17 May 2007 13:26:12 GMT

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 ..