Function Module reading all details of any Material

Introduction

Case 1 – Create a material with reference to some existing material in the ECC system.

Case 2 – Create a report with data from MARC, MARD, MVKE, MBEW, etc.

Case 3 – Get the existing Purchase Order text of any material.

To suit the above needs, SAP has given a wonderful Function Module ‘CRS_MATERIAL_READ_ALL’. Using this function module we can pass the Material Number and get all the details of that material.

Code example for the same is :-

Form get_material_details.

DATA :

*-for CRS_MATERIAL_READ_ALL Function Module ————–*

*– Sales Data

               lt_mvke    TYPE STANDARD TABLE OF    mvke,

*– Valuation Data

               lt_mbew    TYPE STANDARD TABLE OF    mbew,

*– Plant Data

               lt_marc    TYPE STANDARD TABLE OF    marc,

*– Storage Location Data

               lt_mard    TYPE STANDARD TABLE OF    mard,

*– Material Description Data

               lt_makt    TYPE STANDARD TABLE OF    makt,

*– Units oF Measure Data

               lt_marm    TYPE STANDARD TABLE OF    marm,

*– International Article Numbers Data

               lt_mean    TYPE STANDARD TABLE OF    mean,

*– Tax Classifications Data

               lt_mlan    TYPE STANDARD TABLE OF    mlan,

*– Purchase Order Text Data

               lt_cdtxt   TYPE STANDARD TABLE OF    cdtxt.

CALL FUNCTION ‘CRS_MATERIAL_READ_ALL’

   EXPORTING

     iv_matnr           = ‘000000000000000010’  ” Pass the material Number here.

   TABLES

     et_mvke            = lt_mvke

     et_mbew            = lt_mbew

     et_marc            = lt_marc

     et_mard            = lt_mard

     et_makt            = lt_makt

     et_marm            = lt_marm

     et_mean            = lt_mean

     et_mlan            = lt_mlan

     et_icdtxt_material = lt_cdtxt.

Endform.

Disclaimer :- The simple reason for posting this was that i was unable to find proper example of this very powerful function module. It can reduce lots of Inner Joins and FAE on the concerned tables.

Also if you are planning to use this for Case 1 it can be used a sub step for it.

Thanks.