Material master details report

[Former Member]

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

[Former Member]

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

[alpesh_saparia3]

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

[Former Member]

thanks for the immediate response if u donn mind can u send me the code for that.....

[Former Member]

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

[Former Member]

take help of this link:

http://erpgenie.com/abaptips/content/view/32/61/

[Former Member]

Hi

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

see this site

in this you wil find document about MM

reward if usefull

[Former Member]

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.

[Former Member]

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

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

[Former Member]

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