ReSA Store Price History (Temporary)
Out of ScopeTechnical: SA_STORE_PRICE_HIST_TEMP | ID: OR-RSA-SA_STORE_PRICE_HIST_TEMP-SA_STORE_PRICE_HIST_TEMP
This global temporary table is referenced by saexprdw.pc. It is used to derive the most recent retail type of an item/store combination, and is joined to as opposed to querying...
See how this object fits into Sales Audit
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- gtt
Target Structure
- Load Approach
- Table
- Target Objects
- SA_STORE_PRICE_HIST_TEMP
Field Definitions(3)
Rules & Considerations(7)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | STORERPK | RETAIL_TYPER |
|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE |
| default | SA Store Price Hist Temp- | 1003 | SA Store Price Hist |
| default | SA Store Price Hist Temp- | 1005 | SA Store Price Hist |
Example values from field definitions
- ITEMR
- SAMPLE
- STORERPK
- 1
- RETAIL_TYPER
- SAMPLE
default
- ITEMR
- SA Store Price Hist Temp-
- STORERPK
- 1003
- RETAIL_TYPER
- SA Store Price Hist
default
- ITEMR
- SA Store Price Hist Temp-
- STORERPK
- 1005
- RETAIL_TYPER
- SA Store Price Hist
Rule Validation Summary
- Source Rule Count
- 17
- Governed Rule Count
- 7
