Information About The Need
Out of ScopeTechnical: ALC_CALC_NEED_TEMP | ID: OR-ALLOC-ALC_CALC_NEED_TEMP-ALC_CALC_NEED_TEMP
Temporary table used in the calculation process. This table holds information about the need.
See how this object fits into Allocations
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
- ALC_CALC_NEED_TEMP
Field Definitions(5)
Rules & Considerations(37)
validation
constraint
Sample Load Data(4)
| _scenario | ALLOC_IDR | DEPT | CLASS | TO_LOC | WEIGHT | EOW_DATE | PACK_QTY | SUBCLASS | PLAN_NEED | TRAN_ITEM | IWOS_WEEKS | RULE_LEVEL | REPLAN_NEED | SOURCE_ITEM | SISTER_STORE | FORECAST_NEED | TRAN_DIFF1_ID | TRAN_DIFF2_ID | TRAN_DIFF3_ID | TRAN_DIFF4_ID | TRAN_PACK_IND | CORP_RULE_NEED | SALES_HIST_NEED | SOURCE_DIFF1_ID | SOURCE_DIFF2_ID | SOURCE_DIFF3_ID | SOURCE_DIFF4_ID | SOURCE_PACK_IND | TRAN_ITEM_LEVEL | TRAN_TRAN_LEVEL | SIZE_PROFILE_QTY | RECEIPT_PLAN_NEED | SOURCE_ITEM_LEVEL | SOURCE_TRAN_LEVEL | TOTAL_PROFILE_QTY | PLAN_REPROJECT_NEED | RULE_MANY_TO_ONE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1.0000 | 2026-01-01 | 1.0000 | 1 | 1.0000 | SAMPLE | 1.0000 | 1 | 1.0000 | SAMPLE | 1 | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1.0000 | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1 | 1 | 1.0000 | 1.0000 | 1 | 1 | 1.0000 | 1.0000 | 1 |
| default | 1000000003 | 1003 | 1103 | 3 | 12.5000 | 2026-01-03 | 12.5000 | 1113 | 12.5000 | Alc Calc Need Temp-002-AL | 12.5000 | 3 | 12.5000 | Alc Calc Need Temp-002-AL | 1003 | 12.5000 | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | A | 12.5000 | 12.5000 | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | A | 3 | 3 | 12.5000 | 12.5000 | 3 | 3 | 12.5000 | 12.5000 | 1000000003 |
| default | 1000000005 | 1005 | 1105 | 5 | 14.0000 | 2026-01-05 | 14.0000 | 1115 | 14.0000 | Alc Calc Need Temp-003-ED | 14.0000 | 5 | 14.0000 | Alc Calc Need Temp-003-ED | 1005 | 14.0000 | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | A | 14.0000 | 14.0000 | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | A | 5 | 5 | 14.0000 | 14.0000 | 5 | 5 | 14.0000 | 14.0000 | 1000000005 |
Example values from field definitions
- ALLOC_IDR
- 1
- DEPT
- 1
- CLASS
- 1
- TO_LOC
- 1
- WEIGHT
- 1.0000
- EOW_DATE
- 2026-01-01
- PACK_QTY
- 1.0000
- SUBCLASS
- 1
- PLAN_NEED
- 1.0000
- TRAN_ITEM
- SAMPLE
- IWOS_WEEKS
- 1.0000
- RULE_LEVEL
- 1
- REPLAN_NEED
- 1.0000
- SOURCE_ITEM
- SAMPLE
- SISTER_STORE
- 1
- FORECAST_NEED
- 1.0000
- TRAN_DIFF1_ID
- SAMPLE
- TRAN_DIFF2_ID
- SAMPLE
- TRAN_DIFF3_ID
- SAMPLE
- TRAN_DIFF4_ID
- SAMPLE
- TRAN_PACK_IND
- S
- CORP_RULE_NEED
- 1.0000
- SALES_HIST_NEED
- 1.0000
- SOURCE_DIFF1_ID
- SAMPLE
- SOURCE_DIFF2_ID
- SAMPLE
- SOURCE_DIFF3_ID
- SAMPLE
- SOURCE_DIFF4_ID
- SAMPLE
- SOURCE_PACK_IND
- S
- TRAN_ITEM_LEVEL
- 1
- TRAN_TRAN_LEVEL
- 1
- SIZE_PROFILE_QTY
- 1.0000
- RECEIPT_PLAN_NEED
- 1.0000
- SOURCE_ITEM_LEVEL
- 1
- SOURCE_TRAN_LEVEL
- 1
- TOTAL_PROFILE_QTY
- 1.0000
- PLAN_REPROJECT_NEED
- 1.0000
- RULE_MANY_TO_ONE_ID
- 1
default
- ALLOC_IDR
- 1000000003
- DEPT
- 1003
- CLASS
- 1103
- TO_LOC
- 3
- WEIGHT
- 12.5000
- EOW_DATE
- 2026-01-03
- PACK_QTY
- 12.5000
- SUBCLASS
- 1113
- PLAN_NEED
- 12.5000
- TRAN_ITEM
- Alc Calc Need Temp-002-AL
- IWOS_WEEKS
- 12.5000
- RULE_LEVEL
- 3
- REPLAN_NEED
- 12.5000
- SOURCE_ITEM
- Alc Calc Need Temp-002-AL
- SISTER_STORE
- 1003
- FORECAST_NEED
- 12.5000
- TRAN_DIFF1_ID
- ALT-ALC_CA
- TRAN_DIFF2_ID
- ALT-ALC_CA
- TRAN_DIFF3_ID
- ALT-ALC_CA
- TRAN_DIFF4_ID
- ALT-ALC_CA
- TRAN_PACK_IND
- A
- CORP_RULE_NEED
- 12.5000
- SALES_HIST_NEED
- 12.5000
- SOURCE_DIFF1_ID
- ALT-ALC_CA
- SOURCE_DIFF2_ID
- ALT-ALC_CA
- SOURCE_DIFF3_ID
- ALT-ALC_CA
- SOURCE_DIFF4_ID
- ALT-ALC_CA
- SOURCE_PACK_IND
- A
- TRAN_ITEM_LEVEL
- 3
- TRAN_TRAN_LEVEL
- 3
- SIZE_PROFILE_QTY
- 12.5000
- RECEIPT_PLAN_NEED
- 12.5000
- SOURCE_ITEM_LEVEL
- 3
- SOURCE_TRAN_LEVEL
- 3
- TOTAL_PROFILE_QTY
- 12.5000
- PLAN_REPROJECT_NEED
- 12.5000
- RULE_MANY_TO_ONE_ID
- 1000000003
default
- ALLOC_IDR
- 1000000005
- DEPT
- 1005
- CLASS
- 1105
- TO_LOC
- 5
- WEIGHT
- 14.0000
- EOW_DATE
- 2026-01-05
- PACK_QTY
- 14.0000
- SUBCLASS
- 1115
- PLAN_NEED
- 14.0000
- TRAN_ITEM
- Alc Calc Need Temp-003-ED
- IWOS_WEEKS
- 14.0000
- RULE_LEVEL
- 5
- REPLAN_NEED
- 14.0000
- SOURCE_ITEM
- Alc Calc Need Temp-003-ED
- SISTER_STORE
- 1005
- FORECAST_NEED
- 14.0000
- TRAN_DIFF1_ID
- EDGE-ALC_C
- TRAN_DIFF2_ID
- EDGE-ALC_C
- TRAN_DIFF3_ID
- EDGE-ALC_C
- TRAN_DIFF4_ID
- EDGE-ALC_C
- TRAN_PACK_IND
- A
- CORP_RULE_NEED
- 14.0000
- SALES_HIST_NEED
- 14.0000
- SOURCE_DIFF1_ID
- EDGE-ALC_C
- SOURCE_DIFF2_ID
- EDGE-ALC_C
- SOURCE_DIFF3_ID
- EDGE-ALC_C
- SOURCE_DIFF4_ID
- EDGE-ALC_C
- SOURCE_PACK_IND
- A
- TRAN_ITEM_LEVEL
- 5
- TRAN_TRAN_LEVEL
- 5
- SIZE_PROFILE_QTY
- 14.0000
- RECEIPT_PLAN_NEED
- 14.0000
- SOURCE_ITEM_LEVEL
- 5
- SOURCE_TRAN_LEVEL
- 5
- TOTAL_PROFILE_QTY
- 14.0000
- PLAN_REPROJECT_NEED
- 14.0000
- RULE_MANY_TO_ONE_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 43
- Governed Rule Count
- 37