cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding table name which link in between CR Number & Material Number

Former Member
0 Kudos

Experts,

   By using "usmd120c" table we can get the CR number and CR type details which is created in MDG. Now, I am looking for a table which will link CR Number & Material Number.

   Through NWBC, CR Documentation we can get this details but that I am not looking for. I am looking for table name which will help me to link CR number & Material Number.

Accepted Solutions (0)

Answers (2)

Answers (2)

bavinash1
Explorer
0 Kudos

Hello Victor,

Easiest way out is to ask read_char_value itself.

    CALL METHOD cl_usmd_model_ext=>get_instance

           EXPORTING

             i_usmd_model = 'MM'

           IMPORTING

             eo_instance  = lo_model_ext

             et_message   = et_message.

    lo_model_ext->read_char_value(

       EXPORTING

         i_fieldname       = if_mdg_gw_fiori_constants=>gc_usmd_crequest

         it_sel            = lt_sel " Pass the Crequest data in this select options table

         i_readmode        = if_usmd_model_ext=>gc_readmode_all_inact    " Read mode

       IMPORTING

         et_data           = lt_objlist

         et_message        = et_message

     ).


et_data will return the required material details locked in the CR supplied.


BR,

Avinash

Former Member
0 Kudos

Yes, we have this way to get the material details, however I was looking for some table if it helps me to get the details within MDG and ECC too.

former_member193063
Active Participant
0 Kudos

Hello Victor ,

You can find the link b/w Material Number & CR Number with Respective tables :

/1MD/MD______04L  &  USMD1213

in USMD1213 you put there CR number there you are getting Value  .

Take that Value as Technical key in Table  : /1MD/MD______04L

Thanks

Nikhilesh

Former Member
0 Kudos

Hi Nikhilesh,

   As you said, Physical table "/1MD/MD______04L" is available for 0G domain not for Material. USMD1213 gives me CR Number & Entity type And usmd120c gives me CR Number along with CR type. But here, I am looking for CR Number & Material Number. So, looking for some useful table.

former_member193063
Active Participant
0 Kudos

Hi Victor,

Plz check with this Description Name : MM Mapping Table MATERIAL.. There some different table name

Thanks

Nikhilesh

Former Member
0 Kudos

Hello Nikhilesh,

Checked as you said, but not getting the solution. Thanks