Logic

[Former Member]

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

[Former Member]

Hi,

In WHARE Class write like this:

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

Regards,

Bhaskar

[ferry_lianto]

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

[Former Member]

HI Ferry,

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

regards,Ajay Ram

[Former Member]

Hi

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