topic Re: Logic in Application Development and Automation Discussions

Logic

Former Member — Mon, 25 Jun 2007 15:43:17 GMT

Hi,

I am getting data(LABST) from MARD. I am entering the Matnr, werks.

And also i have to compare with LGORT(it is also Key field). if Storage location first Char 'M' or 'G', it has to retreive data. How can i compare matnr wrks and lgort

regards,Ajay Ram

Re: Logic

Former Member — Mon, 25 Jun 2007 15:51:57 GMT

Hi,

In WHARE Class write like this:

whare LGORT like 'M%' or LGORT like 'G%'.

Regards,

Bhaskar

Re: Logic

ferry_lianto — Mon, 25 Jun 2007 15:51:59 GMT

Hi,

Please try this.


PARAMETERS: P_MATNR LIKE MARD-MATNR,
            P_WERKS LIKE MARD-WERKS.
                                     
DATA: WA_LGORT LIKE MARD-LGORT.
                                 
SELECT SINGLE LGORT INTO WA_LGORT
FROM MARD
WHERE MATNR = P_MATNR
  AND WERKS = P_WERKS
  AND ( LGORT LIKE 'M%' OR LGORT LIKE 'G%' ).

Regards,

Ferry Lianto

Re: Logic

Former Member — Mon, 25 Jun 2007 16:49:48 GMT

HI Ferry,

I want to retrieve the LABST (Total Stock ) from MARD.

regards,Ajay Ram

Re: Logic

Former Member — Mon, 25 Jun 2007 16:51:20 GMT

Use below code.

Select matnr LGORT WERKS LABST from mard into table itab

where matnr = P_matnr and

Werks = p_matnr and

Lgort = 'M' or lgort = 'G'.

Reward me if its helpful.

Regards

Ravi