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