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

Material master details report

hi all,

what is material master details report ,do we have any sap defined report for this,if not can anybody plz tell me wat r the select-options parameters tables for this n also if possible send me the codfe for the same.

Thanks in advance

Santosh R

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Posted on Aug 31, 2007 at 11:22 AM

    Dear Santosh,

    For material master there is only MM60 which give plant wise material list. For details report you have to create new one, Tables used will be "MARA - General Data ","MAKT - Description","MARC - Plant data ","MVKE - Sales Org.","MBEW - Valuation data".

    -Alpesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2007 at 11:41 AM

    Hi,

    try simple this:

    TABLES: MARA.

    *

    SELECT-OPTIONS: S_MATNR FOR MARA-MATNR.

    *

    DATA: IMARA TYPE TABLE OF MARA.

    *

    START-OF-SELECTION.

    *

    SELECT * FROM MARA INTO TABLE IMARA WHERE MATNR IN S_MATNR.

    *

    CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

    EXPORTING

    I_STRUCTURE_NAME = 'MARA'

    TABLES

    T_OUTTAB = IMARA.

    *

    Regards, Dieter

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2007 at 11:43 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2007 at 11:54 AM

    Hi

    http://sapbrainsonline.com/TUTORIALS/FUNCTIONAL/MM_tutorial.html

    see this site

    in this you wil find document about MM

    reward if usefull

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2007 at 12:38 PM

    Hi Santosh

    selection parameters are material no

    so you write it as

    select-options: S_matnr for mara-matnr.

    select.......................(fields)..... from mara into .........(internal table) where matnr in S_matnr.

    Then write statements.

    Reward if useful

    It will help to answer more questios.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2007 at 04:09 PM

    Look at the link below for the Various MM Tables and Relationships between them.

    http://www.erpgenie.com/abap/tables_mm.htm

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2007 at 04:28 PM

    Check the below sap standard transactions :

    You can see bold one ( You can implement same logic in case you want to create new transaction)

    <b>Material list - MM60

    Material Analysis(SIS) - MCTC</b>

    Material Analysis-Incoming orders - MC(E

    Material Returns-Analysis - MC+M

    Material Analysis- Invoiced Sales - MC+Q

    Thanks

    Seshu

    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.