topic Re: Material Master Extraction in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/material-master-extraction/m-p/2516323#M569315 <HTML><HEAD></HEAD><BODY><P>plz answer my queastion</P></BODY></HTML> Thu, 19 Jul 2007 09:09:04 GMT Former Member 2007-07-19T09:09:04Z Material Master Extraction https://community.sap.com/t5/application-development-and-automation-discussions/material-master-extraction/m-p/2516322#M569314 <HTML><HEAD></HEAD><BODY><P>using below tables how to geterate a report</P><P></P><P></P><P></P><P></P><P>SAP Tables:</P><P>Table name Description</P><P>MARA General Material Data</P><P>MARC Plant data </P><P>MARD Storage Location Data for Material</P><P>MVKE Sales Data for Material</P><P>MAKT Material Descriptions</P><P>EKKO Purchasing Document Header</P><P>EKPO Purchasing Document Item</P><P>VABK Sales Document: Header Data</P><P>VBAP Sales Document: Item Data</P><P></P><P></P><P>Inputs </P><P>A list of required inputs.</P><P>Inputs:</P><P>Field text Field name Reference table Parameter/Select-Option Mandatory/Optional</P><P>Material Number S_MATNR MARA Selection option Mandatory</P><P>Storage location S_LGORT MARD Selection option Optional</P><P>MRP Controller S_DISPO MARC Selection option Optional</P><P>Sales Organization S_VKORG MVKE Selection option Optional</P><P>Purchasing Document Number S_EBELN EKKO Selection option Optional</P><P>Plant P_WERKS MARC Parameter Mandatory</P><P>Display Out Put -- Parameter as Radio-Button </P><P>Download Out Put -- Parameter as Radio-Button </P><P>Both Display Download -- Parameter as Radio-Button </P><P></P><P>Out Puts</P><P>A list of required outputs.</P><P>Inputs:</P><P>Field text Field name Reference table</P><P>Material Number MATNR MARA</P><P>Plant WERKS MARC</P><P>Storage location LGORT MARD</P><P>Material Description MAKTX MAKT</P><P>MRP Controller DISPO MARC</P><P>Sales Organization VKORG MVKE</P><P>Material type MTART MARA</P><P>Material group MATKL MARA</P><P>Base Unit of Measure MEINS MARA</P><P>Purchasing Document Number EBELN EKKO</P><P>Purchasing Document Item EBELP EKPO</P><P>Sales Document VBELN VBAK</P><P>Sales Document Item VBELP VBAP</P><P></P><P></P><P></P><P>Report Functionality: </P><P></P><P>Program Description: Report is intended to get all the materials per plant and material, By giving this we will extract the storage location stock, total stock cross all storage locations per material with sales document and purchasing document related to the material in Report format. On the selection screen provided three radio buttons in order to display Out Put, Download Out Put and Both Display Download Respectively .The output of this report is redirected to Excel Sheet on Request.</P></BODY></HTML> Mon, 16 Jul 2007 14:49:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-master-extraction/m-p/2516322#M569314 Former Member 2007-07-16T14:49:30Z Re: Material Master Extraction https://community.sap.com/t5/application-development-and-automation-discussions/material-master-extraction/m-p/2516323#M569315 <HTML><HEAD></HEAD><BODY><P>plz answer my queastion</P></BODY></HTML> Thu, 19 Jul 2007 09:09:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-master-extraction/m-p/2516323#M569315 Former Member 2007-07-19T09:09:04Z