Skip to Content
avatar image
Former Member

Question regarding select

Hi Expert ,

I have one Question .what is meaning of this three select statement and which types of data call from this select statement .

I m More concern about last one.

SELECT MATNR MTART MEINS INTO CORRESPONDING FIELDS OF ITAB FROM MARA WHERE MATNR IN S_MATNR.

SELECT MAKTX INTO ITAB-MAKTX FROM MAKT WHERE MATNR = ITAB-MATNR.

SELECT SUM( LABST ) INTO ITAB-LABST FROM MARD WHERE MATNR =

TAB-MATNR.

thanks ,

Ashish

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Oct 29, 2007 at 06:41 AM

    the first stmt fetches material number,material type and base unit of measure from table mara into fields with same name in internal table itab based on the material number entered by user on selection screen.

    da second select gets matrerial text from tab;e makt into internal table based on material number.

    da third stmt adds the values for Valuated Unrestricted-Use Stock on basis of material.

    plz reward points if dis helps

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2007 at 06:58 AM

    Hi Ashish,

    First select st. selects material no,material type and unit of measure from mara & populate into itab for the range in s_matnr.

    second selects material description for material in itab(instead u can use for all entries ,which will increase the performance).

    Third,gives the sum of stock for all materials.

    rewards if useful..

    kavitha

    Add comment
    10|10000 characters needed characters exceeded