Metro Employee

Data will only be interfaced if

• The planogram is connected to the right content receiver
• The planogram has the status ‘work in progress’
• The planogram is in the right folder structure
• The product ID is correct
• The product is in the right store
• The product is in the right assortment group/ planogram combination
• 2nd placements (in another planogram as the assortment group, will not be supported/ updated)
• A product ID can only exist once. Different products with the same ID will not be interfaced

• Update article information in MMS (e.g. assortment group, maintenance group)

• Create/activate the new/missing assortment group in MMS
• Add the new assortment group and respective sales period in the UDEF tables in MDW.

• Create the new/missing store in MMS
• Add the new store to the UDEF tables in MDW (blocking codes 0 or 2)

https://metrosystemsnew.freshdesk.com/en/support/solutions/articles/15000031542-how-to-add-a-new-missing-store-in-the-spaceman-hierarchy-spaceman-

Information regarding needed UDEF tables for Spaceman

DW_UDEF_SPACE_ASSORT_LIST     list for all assortment groups to deliver to Spaceman
DW_UDEF_SPACE_STORE_LIST        list for all stores, articles should be delivered for
DW_UDEF_SPACE_ACTIVE            blocking codes, articles belongs to (currently 0 ‘full free’ and 2 ‘temp blocked’ are in)
DW_UDEF_SPACE_PACK_TYPE           table where abbreviation for trays is defined

There is no application, maintenance has to be done directly on the (dialog) database with INSERTS/UPDATES or DELETE.
Examples: Please do not forget the client_cd for the country (example NL) in script / Assortment Group from MMS, not Presentation Category or SubCategory.

NEW assortment groups: INSERT INTO DW_UDEF_SPACE_ASSORT_LIST (co_assort_group_id, client_cd) VALUES (<assortmentgroupnumber>,<client_cd>);
Example: INSERT INTO DW_UDEF_SPACE_ASSORT_LIST (co_assort_group_id, client_cd) VALUES (90013,1560);

Company Hier ID means the internal Company Hier ID from MDW (or HIER_LFD from MMS), NOT store id!
INSERT INTO DW_UDEF_SPACE_STORE_LIST (company_hier_id, client_cd) VALUES (<company hier id>,<client_cd>);
Example: INSERT INTO DW_UDEF_SPACE_STORE_LIST (company_hier_id, client_cd) VALUES (7011,1560);

Articles with blocking code xyz will be delivered: INSERT INTO DW_UDEF_SPACE_ACTIVE (suppl_art_block_cd, active_status, client_cd) VALUES (<blocking code>, <active status>, <client_cd>); 
Example:INSERT INTO DW_UDEF_SPACE_ACTIVE (suppl_art_block_cd, active_status, client_cd) VALUES (2, 0, 1560);

Tray Abbrevation – in Germany for example it its ‘TY’
Example: INSERT INTO DW_UDEF_SPACE_PACK_TYPE (‘TY’);