| # | Steps | Description | Screenshot |
|---|
| 1 | Information given by Users | User communicates new material code and name. |
|
| 2 | Retrieve SAP Information - 1/2 | - Key in T-Code = VA03 / MM03;
- Key in the Material code;
- Choose the correct Sales Area.
| |
| 3 | Retrieve SAP Information - 2/2 | - All needed information are displayed
- Copy/Paste information as for the example below
| for example, 
|
| 4 | Input data in Interface - 1/3 | - Connect to AP21;
- Open Microsoft SQL;
- Go to: Database > DynaSys ITF > Table > dbo. sys_Tmp_MaterialSYS_TMP_ShipTo
| |
| 5 | Input data in Interface - 2/3 | - Right click on dbo. sys_Tmp_MaterialhipTo;
- Click on “Edit Top 200 Rows”
A new window appears with 13 fields. | |
| 6 | Input data in Interface - 3/3 | - 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!
|
|
| 7 | Verify Data in DynaSys | - 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.
| |
| 8 | 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.
| |
| 9 | The following Day... | - Verify that the new Ship-To appears in the master data table;
- Add the apostrophe again in the macro;
- Save.
| |
| # | Steps | Description | Screenshot |
|---|
| 1 | Information given by Users | User communicates new material code and name. |
|
| 2 | Retrieve SAP Information - 1/2 | - Key in T-Code = VA03 / MM03;
- Key in the Material code;
- Choose the correct Sales Area.
| |
| 3 | Retrieve SAP Information - 2/2 | - All needed information are displayed
- Copy/Paste information as for the example below
| for example,
|
| 4 | Input data in Interface - 1/3 | - Connect to AP21;
- Open Microsoft SQL;
- Go to: Database > DynaSys ITF > Table > dbo. sys_Tmp_MaterialSYS_TMP_ShipTo
| |
| 5 | Input data in Interface - 2/3 | - Right click on dbo. sys_Tmp_MaterialhipTo;
- Click on “Edit Top 200 Rows”
A new window appears with 13 fields. | |
| 6 | Input data in Interface - 3/3 | - 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!
|
|
| 7 | Verify Data in DynaSys | - 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.
| |
| 8 | 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.
| |
| 9 | The following Day... | - Verify that the new Ship-To appears in the master data table;
- Add the apostrophe again in the macro;
- Save.
| |
