Component Shop List
In ScopeTechnical: COMP_SHOP_LIST | ID: OR-ITM-COMP_SHOP_LIST-COMPONENT_SHOP_LIST
Stores competitor shopping lists at the item/competitor/competitor store/day level. This table will be downloaded to a PDA.
See how this object fits into Item Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- COMP_SHOP_LIST
Field Definitions(17)
Rules & Considerations(24)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | SHOPPERRPK | REF_ITEMRPK | SHOP_DATER | COMPETITORRPK | COMP_STORERPK | REC_DATE | COMP_NAME | ITEM_DESC | OFFER_TYPE | COMP_RETAIL | MULTI_UNITS | PROM_END_DATE | COMP_STORE_NAME | PROM_START_DATE | COMP_RETAIL_TYPE | MULTI_UNIT_RETAIL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | 2026-01-01 | 1 | 1 | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 1.0000 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SHOPPERRPK
- 1
- REF_ITEMRPK
- SAMPLE
- SHOP_DATER
- 2026-01-01
- COMPETITORRPK
- 1
- COMP_STORERPK
- 1
- REC_DATE
- 2026-01-01
- COMP_NAME
- SAMPLE
- ITEM_DESC
- SAMPLE
- OFFER_TYPE
- SAMPLE
- COMP_RETAIL
- 1.0000
- MULTI_UNITS
- 1.0000
- PROM_END_DATE
- 2026-01-01
- COMP_STORE_NAME
- SAMPLE
- PROM_START_DATE
- 2026-01-01
- COMP_RETAIL_TYPE
- SAMPLE
- MULTI_UNIT_RETAIL
- 1.0000
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 24