Skip to Content
Technical Articles
Author's profile photo Suatcan Pekak

LTMC For Material Master Data

In this topic, the most important point to note is the filling of the field which is belong to Material Maintenance Status. Relevant tabs to be created in the material master data are created by this field. If this field is not filled properly, the tabs that should be opened will not open even if they are filled. Letters represent maintenance areas which means maintenance areas represent the tabs found in the material master data.

 

Possible values and combinations of them:

 

A = Work Scheduling

B = Accounting

D = MRP

E = Purchasing

F = PRT

G = Costing

K = Basic

L = Storage

P = Forecast

Q = QM

S = Warehouse managemen

V = Sales

 

In this excel template  K= Basic, E= Purchasing, L = Storage, B= Accounting

 

Tabs are selected.

 

Another important point is the field within the Plant Data tab in excel that named Plant Maintenance Status. The plant maintenance area inside the Plant Data tab is filled just like the field of material maintenance.

 

 

In the last step, the desired fields are selected by placing ‘x’ on their own fields in the Maintenance Status Settings tab.

 

 

Example of Excel Filling

 

  1. Basic Data

  2. Plant Data

  3. Storage Location Data
  4. Accounting Data
  5. Maintenance Status Settings

And the excel ready to upload. When the process of uploading the excel is done, connect the screen of display material and check the material that coded 30000075.

 

As you see on the screenshot, the related tabs created. Let’s check the Basic Data 1 and Accounting 1 tabs.

 

 

That is all the whole steps filling excel template for LTMC. I hope it will help you. Please ask me if you have any questions.

 

BR

Suatcan Pekak

Assigned tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      Good job Suat , keep it up !

      Brgds

      M.Ozgur Unal

      Author's profile photo Michelle Crapo
      Michelle Crapo

      Great job.   I would have really loved this a couple of months ago.  It took me a quite a bit of time to understand the maintenance status.

      If you are moving forward with a blog series on this.  One of the other interesting things was downloading and uploading files.  It was frustrating when I had to keep renaming them while testing.

      Another fun fact was that you need to clear out your buffer if you wanted to reload something.  For example I loaded the material and there was an issue with one of the views.  The material was created.   Now I delete the material, fix the data in the spreadsheet.  Upload to test.  And it says it's already been created.  It took me a bit to figure out I had to clear out the LTMC tables.

      Thank you for the good blog - much needed for anyone starting to use LTMC.

      Michelle

      Author's profile photo Suatcan Pekak
      Suatcan Pekak
      Blog Post Author

      Hi Michelle,

       

      I'm glad you like it, I hope it will be useful for after that

       

      BR

      Suatcan

      Author's profile photo Rajushan R
      Rajushan R

      Hi Suatcan,

       

      Could you please let me know why you have used "SCN" in Maintenance status settings tab what exactly it denotes.

       

      Thanks,

      Rajushan

      Author's profile photo Mahadev Shetty
      Mahadev Shetty

      SCN is an Identifier, so that we can assign it in the maintenance status setting sheet

      Author's profile photo Ibrahim Begdouri
      Ibrahim Begdouri

      Nicely done Suatcan Pekak !

       

      You made me save valuable time in searchs during critical project phase.

       

      Thank you, keep it up !

       

      Author's profile photo Suatcan Pekak
      Suatcan Pekak
      Blog Post Author

      Hello Ibrahim

      I'm very happy for that it is useful for you.

      BR

      Suatcan

      Author's profile photo Naga Venkata Raghavendra Kumar Seerla
      Naga Venkata Raghavendra Kumar Seerla

      Hello Suatcan,

       

      I am getting the following message during material load using LTMC:

      Missing key relationship in S_MBEW
      Message no. DMC_RT_MSG189

      I have not updated "Valuation Type" field in the upload template as the material is not split valuated. Could you please let me know if you can help me with this issue.

      Thanks,

      Naga

       

      Author's profile photo Suatcan Pekak
      Suatcan Pekak
      Blog Post Author

      Hi Naga,

      I think it is not releated with 'Valuation Type'. Can you tell me the fields you filled ?

      BR

      Author's profile photo Naga Seerla
      Naga Seerla

      Hello Suatcan,

       

      Please ignore my last message, even though the valuation type field has an asterisk on the upload template to indicate that it is mandatory, I was able to create materials without updating any values in that.

      However, I am getting the following error during the load:

      Material number too long for client setting in material mapping. (I have attached the error screenshot). If you notice, material number is 10 digits and is within the number range.

      Thanks.

       

      Author's profile photo Mohan Kishore
      Mohan Kishore

      Hello Suatcan

      Great Job

      I could not able to upload Materials with Multiple plants at single instance . System is considering only one plant which is in first row in sheet "Plant Data"

      Regards

      MK

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi

      Dear Pekak,

      One of the best reading blog. outstanding for the newbies.

       

       

      Best Regards

      Mohsin Abbasi

       

      Author's profile photo Stéphane Djounkam
      Stéphane Djounkam

      Hello Suatcan,

      Thanks of lot Suatcan Pekak for this tuto.

      I have an issue, I have loaded material master with ltmc only ''Basic'' view was created because the field 'Material Maintenance status' was populated with K(letter for Basic view).

      Now i want to extend a new view (tab) like  Purchasing (E) and Accounting (B) for existing material master records.

      Could you please help me how to do with LTMC?

      Thanks in advance

      Stéphane

       

      Author's profile photo Mahadev Shetty
      Mahadev Shetty

      Need to to it by Material Extension template in the LTMC. In LTMC we can find another template for material extension by new org levels

      Author's profile photo Santosh Gangurde
      Santosh Gangurde

      Very nice doc.

      Just quick question--- Can I use internal number range for material master data?

      If so, then how to maintain it in the template, as the material number is mandatory filed in the template.

      Kind Regards,

      Santosh G.

      Author's profile photo Mahadev Shetty
      Mahadev Shetty

      Suatcan Pekak .. very nice blog on the material maintenance status. It helps us to think the usage of this field. Till today, I was giving all the possible values and was relying on the automatic assignment.

      Appreciate your blog..!!!!

      Author's profile photo Srinivas Geminisetty
      Srinivas Geminisetty

      Hi Good Day,

       

      can any one please let me know ,can we load material master  internally using LTMC?

      If so please let me know more details about internally material master data loading using LTMC.Will much appreciated .

       

      Thanks

      srini