4.6.2 - How to manually upload Materials

Information given by Users

Retrieve SAP Information - 1/2

• Key in T-Code = VA03 / MM03;
• Key in the Material code;
• Choose the correct Sales Area.

Retrieve SAP Information - 2/2

• All needed information are displayed
• Copy/Paste information as for the example below

• Connect to APP01;
• Open Microsoft SQL;
• Go to: Database > DynaSys ITF > Table > dbo. sys_Tmp_MaterialSYS_TMP_ShipTo

• Right click on dbo. sys_Tmp_MaterialhipTo;
• Click on “Edit Top 200 Rows”

• Click on the box with the arrow;
• Right click and Delete;
• Select the empty lines;
• Copy/Paste the lines with the new retrieved Information.! Close the window without saving!

• Connect to AP22/23 with an Administrator user;
• Go to Administration > Interface > Import > 9.1 Special Process > 9.1.03- Tmp_Material.

• Right click and select “Execute Query”;
• Verify data in “ODBC Query: TMP_Material_ShipTo;
• Close the window without further actions.

Activate Action in Static Import (daily)

• Go to Macros > TECH: Static Import (Weekday);
• Right click > Display Text;
• CTRL+F “9.1.02”;
• Delete the apostrophe > line appears in RED;
• Save the changes.

The following Day...

• Verify that the new Ship-To appears in the master data table;
• Add the apostrophe again in the macro;
• Save.

Information given by Users

Retrieve SAP Information - 1/2

• Key in T-Code = VA03 / MM03;
• Key in the Material code;
• Choose the correct Sales Area.

Retrieve SAP Information - 2/2

• All needed information are displayed
• Copy/Paste information as for the example below

• Connect to APP01;
• Open Microsoft SQL;
• Go to: Database > DynaSys ITF > Table > dbo. sys_Tmp_MaterialSYS_TMP_ShipTo

• Right click on dbo. sys_Tmp_MaterialhipTo;
• Click on “Edit Top 200 Rows”

• Click on the box with the arrow;
• Right click and Delete;
• Select the empty lines;
• Copy/Paste the lines with the new retrieved Information.! Close the window without saving!

• Connect to AP22/23 with an Administrator user;
• Go to Administration > Interface > Import > 9.1 Special Process > 9.1.03- Tmp_Material.

• Right click and select “Execute Query”;
• Verify data in “ODBC Query: TMP_Material_ShipTo;
• Close the window without further actions.

Activate Action in Static Import (daily)

• Go to Macros > TECH: Static Import (Weekday);
• Right click > Display Text;
• CTRL+F “9.1.02”;
• Delete the apostrophe > line appears in RED;
• Save the changes.

The following Day...

• Verify that the new Ship-To appears in the master data table;
• Add the apostrophe again in the macro;
• Save.