Skip to Content
author's profile photo Former Member
Former Member

please check this very urgent

i have two fields like marc-eisbe and mbew-stprs i want to multiply this two fileds and get the values in some other new fields.

regards

sat

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 02:27 PM

    Hi,

    TABLES marc.
    TABLES mbew.
    DATA field1 LIKE marc-eisbe VALUE '5.5'.
    DATA field2 LIKE mbew-stprs VALUE '6.7'.
    DATA result LIKE marc-eisbe.
    result = field1 * field2.
    WRITE result.
    

    Regards Rudi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 18, 2008 at 02:31 PM

    Get the record from MARC

    For the record in MARC get corresponding record from MBEW where

    MARC-MATNR = MBEW-MATNR

    MARC-WERKS = MBEW-BWKEY

    * Assuming the I_TAB has the following fields
    Being of I_TAB with header line
    matnr like marc-matnr
    werks like marc-werks
    eisbe like marc-eisbe
    stprs like mbew-stprs
    calc like marc-eisbe
    End of I_tab.
    
    Select a~matnr a~werks a~eisbe b~stprs
    from MARC as a
    into tabel i_tab
    inner join MBEW as b
    on a~matnr = b~matnr
    and a~werks = b~bwkey.
    
    
    * Then 
    loop at i_tab
    i_tab-calc = i_tab-eisbe * i_tab-stprs .
    modify i_tab.
    endloop.
    

    Hope this helps.

    Francis

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 18, 2008 at 02:34 PM

    Hi Satheesh.

    You can increase the number of people reading your question by using a better subject. Describe your issue and more people get interested in reading your posting. In fact I heard of people not reading postings that have words like 'urgent' in the subject.

    Please have a look into our community guidelines which will explain some other things you should know as a member of SDN.

    Best regards,

    Jan Stallkamp

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 02:35 PM

    do like this..

    select matnr eisbe

    from marc

    into table itab

    where werks in s_werks.

    if not itab[] is initial.

    select matnr stprs

    from mbew

    into table itab1

    for all entries in itab

    where matnr = itab-matnr

    endif.

    loop at itab .

    read table itab1 with key matnr = itab-matnr .

    v_sum = itab-eisbe * itab1-stprs.

    write:/ v_sum.

    endloop.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.