08-31-2007 12:10 PM
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
08-31-2007 12:22 PM
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
08-31-2007 12:31 PM
thanks for the immediate response if u donn mind can u send me the code for that.....
08-31-2007 12:41 PM
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
08-31-2007 12:43 PM
08-31-2007 12:54 PM
Hi
http://sapbrainsonline.com/TUTORIALS/FUNCTIONAL/MM_tutorial.html
see this site
in this you wil find document about MM
reward if usefull
08-31-2007 1: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.
08-31-2007 5:09 PM
Look at the link below for the Various MM Tables and Relationships between them.
08-31-2007 5: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