Skip to Content

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

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. 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

    (0) 

Leave a Reply