Information given by Users
User communicates new ship-to code and name.
- There is no Sales Order/M3 in SAP;
- So there is no Ship-to (to create related DFUs) > in BW flat files and in DynaSys.
This request comes when forecast needs to be inputed without/before creation of Sales Orders. This should not be an usual practice!
When a Sales Order will be created in SAP for this Ship-To, Dynamic Data will automatically be integrated to manual DFUs (related to this Ship-To).
Example: COMPANIA MINERA LAS TORRES SA DE CV. #2069867
Retrieve SAP Information
- Key in SAP T-Code = XD03;
- Key in the Ship-To code;
- Choose the correct Sales Area.
- All needed information are displayed
- Copy/Paste information as for the example below
Example: COMPANIA MINERA LAS TORRES SA DE CV. #2069867
General Data - Address
Sales Area Data - Partners Functions
Input data in Interface
- Connect to APP01;
- Open Microsoft SQL;
- Go to: Database > DynaSys ITF >
Table > dbo.SYS_TMP_ShipTo
- Right click on dbo.SYS_TMP_ShipTo;
- Click on “Edit Top 200 Rows”
- A new window appears with 13 fields.
- Click on the boxe 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!
Example: COMPANIA MINERA LAS TORRES SA DE CV. #2069867
Verify Data in DynaSys
- Connect to APP01 with an Administrator user;
- Go to Administration > Interface > Import >
9.1 Special Process > 9.1.02 Tmp_ShipTo.
- Right click and select “Execute Query”;
- Verify data in “ODBC Query: TMP_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.
Template file ：（for data preparation）
https://docs.google.com/spreadsheets/d/105xZhdakcknmTqZRYB2RQ5Iyl9MHDWMnn3ZPre95M5s/edit#gid=246662615
Information given by Users
User communicates new ship-to code and name.
- There is no Sales Order/M3 in SAP;
- So there is no Ship-to (to create related DFUs) > in BW flat files and in DynaSys.
This request comes when forecast needs to be inputed without/before creation of Sales Orders. This should not be an usual practice!
When a Sales Order will be created in SAP for this Ship-To, Dynamic Data will automatically be integrated to manual DFUs (related to this Ship-To).
Example: COMPANIA MINERA LAS TORRES SA DE CV. #2069867
Retrieve SAP Information
- Key in SAP T-Code = XD03;
- Key in the Ship-To code;
- Choose the correct Sales Area.
- All needed information are displayed
- Copy/Paste information as for the example below
Example: COMPANIA MINERA LAS TORRES SA DE CV. #2069867
General Data - Address
Sales Area Data - Partners Functions
Input data in Interface
- Connect to AP21;
- Open Microsoft SQL;
- Go to: Database > DynaSys ITF >
Table > dbo.SYS_TMP_ShipTo
- Right click on dbo.SYS_TMP_ShipTo;
- Click on “Edit Top 200 Rows”
- A new window appears with 13 fields.
- Click on the boxe 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!
Example: COMPANIA MINERA LAS TORRES SA DE CV. #2069867
Verify Data in DynaSys
- Connect to AP22/23 with an Administrator user;
- Go to Administration > Interface > Import >
9.1 Special Process > 9.1.02 Tmp_ShipTo.
- Right click and select “Execute Query”;
- Verify data in “ODBC Query: TMP_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.
Template file（for data preparation）