Information Systems:Items included in the POS catalog (ECU base file generation logic)
This page discusses the very specific topic of how ECU generates the base catalog.
As part of the catalog generation process, ECU first creates an item base file, ECUIBAP in UWDASWPRDD. The entries in this file become the full catalog in the full catalog run, and the basis for change comparisons in the weekly change file run. ECUIBAP (and the full catalog) only has about 28,000 entries in it, while our items total approximately 121,000. Even excluding discontinued items, the list sits at 62,000, so there is obviously additional logic into building the base file. This page notes this logic, which has been interpreted from RPG. Note: this is for the regular catalog (ECUREGULAR) run. The promo catalog is generated with different criteria, but is less relevant now.
This is the logic for building the list of items for the ECU base file:
- Start with the ASW item master (SROPRG)
- Exclude items where item category 1 is greater than (but not equal to) '549'. (Promo?)
- Exclude items that are fictitious except fictitious and generic items.
- Exclude items where item category 1 is blank.
- Exclude inactivated items Note: This only checks for PGSTAT, which is one of the 3 known 'discontinued' flags. This is the reason that many discontinued items exist in the catalog (because they have been discontinued by Buying through another flag, and not PGSTAT).
- Exclude items that have the NOEOB flag. Specifically, these are items defined in RSVILIP (restriction file?) with the flags RICLAS='NOEOB', RIVITY='I', RISTAT='AC', and with an active start and end date (respective to the current/run date).
- This logic has been reproduced via SQL (and saved in 'Saved SQL Scripts') and verified to yield the same list and number of items (~28,000).
- This is only one of the many steps in ECU catalog generation. It is noted here for reference as the program will need to be refactored in the future, and we will likely keep the same logic above to create a list of items to export in the catalog, or at least use it as a starting point.