MM (Materials Management)

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.

MM (Materials Management)

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.

MM (Materials Management)

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

MM (Materials Management)

MM (Materials Management)

Example of Excel Filling

1. Basic Data

MM (Materials Management)

MM (Materials Management)

MM (Materials Management)

MM (Materials Management)

2. Plant Data

MM (Materials Management)

MM (Materials Management)

3. Storage Location Data

MM (Materials Management)

4. Accounting Data

MM (Materials Management)

5. Maintenance Status Settings

MM (Materials Management)

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.

MM (Materials Management)

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

MM (Materials Management)

MM (Materials Management)

That is all the whole steps filling excel template for LTMC.

Leave a Reply

Your email address will not be published. Required fields are marked *