Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Incremental Refresh of Material Master Tables

want to pull data from following material master tables into an Oracle database on a daily basis. I am looking into an incremental refresh. Mara table will be the driving table. It has two fields ersda (creation date) and laeda (date of last change). I want to make use of these fields to decide what was added/changes since my last refresh. I will the take all the MATNR (material numbers) from MARA table corresponding to incremental change and then join with MARC table to get MARC information; join with MARD to get incremental changes for MARD etc. Will this approach work.

I am new to MM, If someone adds or modified a row in any of the tables below, will creation date or date of last change be updated in MARA table. Really appreciate your input.

Sr. No. SAP Tables for Material Masters Table Descriptions

1 MARA General Material Data

2 MARC Plant Data for Material

3 MARD Storage Location Data for Material

4 MARM Units of Measure for Material

5 MBEW Material Valuation

6 MLAN Tax Classification for Material

7 MVKE Sales Data for Material

8 MLGN Material Data for Each Warehouse Number

9 MLGT Material Data for Each Storage Type

10 MKAL Production Versions of Material

11 MEAN International Article Numbers (EANs) for Material

12 MAEX Material Master: Legal Control

13 MAKT Material Descriptions

14 QMAT Inspection type - material parameters

Former Member
Former Member replied

If anything is changed in mm01 or mm02 screen for a material will change the "last change date".

So you may take last change date as all the tables you mentioned are getting populated for material master workflow.

But if you trying for a delta load then join of these tables would be difficult. So full load would be a better option.

S

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question