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


Article shifts from one assortment group to another


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


Creation of new/missing assortment 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.


Learn more!



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


Learn more!

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’);