RPM Price Change Helper (GTT)

Out of Scope

Technical: RPM_PRICE_CHANGE_HELPER_GTT | ID: OR-PRC-RPM_PRICE_CHANGE_HELPER_GTT-RPM_PRICE_CHANGE_HELPER_GTT

Helper table for the price change maintence. A copy of RPM_PRICE_CHANGE with some additional helper columns.

See how this object fits into Pricing & Promotions

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: RPM_PRICE_CHANGE_HELPER_GTT

Field Definitions(5)

Rules & Considerations(58)

constraint

validation

Sample Load Data(4)

_scenario	PRICE_CHANGE_IDR	PRICE_CHANGE_DISPLAY_IDR	ITEM	STATE	DIFF_ID	NEW_IND	ZONE_ID	LOCATION	CREATE_ID	APPROVAL_ID	CHANGE_TYPE	MULTI_UNITS	REASON_CODE	CONFLICT_IND	GENERATED_BY	APPROVAL_DATE	CHANGE_AMOUNT	ORIGINAL_ITEM	PURCHASE_TYPE	CHANGE_PERCENT	EFFECTIVE_DATE	MASTER_BGE_IND	MASTER_SGE_IND	ZONE_NODE_TYPE	CHANGE_CURRENCY	CREATE_DATETIME	LAST_UPDATED_ID	ORIGINAL_DIFF_ID	ORIGINAL_ZONE_ID	PRIMARY_SUPPLIER	ROUNDING_RULE_ID	MULTI_UNIT_IMPACT	MULTI_UNIT_RETAIL	OBJECT_VERSION_ID	CHANGE_SELLING_UOM	IGNORE_CONSTRAINTS	EXCEPTION_PARENT_ID	LAST_UPDATE_DATETIME	PRICE_CHANGE_GROUP_ID	EXCEPTION_FROM_LOC_IND	LOC_EXC_CHILDREN_EXIST	MULTI_UNIT_SELLING_UOM	EXCEPTION_FROM_ITEM_IND	ITEM_EXC_CHILDREN_EXIST	SYS_GENERATED_EXCLUSION	BATCH_GENERATED_EXCLUSION	MULTI_UNIT_RETAIL_CURRENCY
Example values from field definitions	1	SAMPLE	SAMPLE	1	SAMPLE	1	1	1	SAMPLE	SAMPLE	1	1.0000	SAMPLE	1	S	2026-01-01	1.0000	SAMPLE	1	1.0000	2026-01-01	1	1	1	SAM	2026-01-01	SAMPLE	SAMPLE	1	1	1	SA	1.0000	1	SAMP	1	1	2026-01-01	1	1	1	SAMP	1	1	1	1	SAM
default	1000000003	ALT-RPM_PRICE-0	RPM Price Change Helper G	3	ALT-RPM_PR	3	1000000003	3	MDM_USER	ALT-RPM_PRICE-002	3	12.5000	ALT-RP	3	S	2026-01-03	12.5000	RPM Price Change Helper G	1	12.5000	2026-01-03	3	3	3	RPM	2026-01-03	ALT-RPM_PRICE-002	ALT-RPM_PR	1000000003	3	1000000003	R	12.5000	1000000003	RPM	3	1000000003	2026-01-03	1000000003	3	3	RPM	3	3	3	3	RPM
default	1000000005	EDGE-RPM_PRICE-	RPM Price Change Helper G	5	EDGE-RPM_P	5	1000000005	5	BATCH_USER	EDGE-RPM_PRICE-003	5	14.0000	EDGE-R	5	S	2026-01-05	14.0000	RPM Price Change Helper G	0	14.0000	2026-01-05	5	5	5	RPM	2026-01-05	EDGE-RPM_PRICE-003	EDGE-RPM_P	1000000005	5	1000000005	AU	14.0000	1000000005	RPM	5	1000000005	2026-01-05	1000000005	5	5	RPM	5	5	5	5	RPM

Example values from field definitions

PRICE_CHANGE_IDR: 1
PRICE_CHANGE_DISPLAY_IDR: SAMPLE
ITEM: SAMPLE
STATE: 1
DIFF_ID: SAMPLE
NEW_IND: 1
ZONE_ID: 1
LOCATION: 1
CREATE_ID: SAMPLE
APPROVAL_ID: SAMPLE
CHANGE_TYPE: 1
MULTI_UNITS: 1.0000
REASON_CODE: SAMPLE
CONFLICT_IND: 1
GENERATED_BY: S
APPROVAL_DATE: 2026-01-01
CHANGE_AMOUNT: 1.0000
ORIGINAL_ITEM: SAMPLE
PURCHASE_TYPE: 1
CHANGE_PERCENT: 1.0000
EFFECTIVE_DATE: 2026-01-01
MASTER_BGE_IND: 1
MASTER_SGE_IND: 1
ZONE_NODE_TYPE: 1
CHANGE_CURRENCY: SAM
CREATE_DATETIME: 2026-01-01
LAST_UPDATED_ID: SAMPLE
ORIGINAL_DIFF_ID: SAMPLE
ORIGINAL_ZONE_ID: 1
PRIMARY_SUPPLIER: 1
ROUNDING_RULE_ID: 1
MULTI_UNIT_IMPACT: SA
MULTI_UNIT_RETAIL: 1.0000
OBJECT_VERSION_ID: 1
CHANGE_SELLING_UOM: SAMP
IGNORE_CONSTRAINTS: 1
EXCEPTION_PARENT_ID: 1
LAST_UPDATE_DATETIME: 2026-01-01
PRICE_CHANGE_GROUP_ID: 1
EXCEPTION_FROM_LOC_IND: 1
LOC_EXC_CHILDREN_EXIST: 1
MULTI_UNIT_SELLING_UOM: SAMP
EXCEPTION_FROM_ITEM_IND: 1
ITEM_EXC_CHILDREN_EXIST: 1
SYS_GENERATED_EXCLUSION: 1
BATCH_GENERATED_EXCLUSION: 1
MULTI_UNIT_RETAIL_CURRENCY: SAM

default

PRICE_CHANGE_IDR: 1000000003
PRICE_CHANGE_DISPLAY_IDR: ALT-RPM_PRICE-0
ITEM: RPM Price Change Helper G
STATE: 3
DIFF_ID: ALT-RPM_PR
NEW_IND: 3
ZONE_ID: 1000000003
LOCATION: 3
CREATE_ID: MDM_USER
APPROVAL_ID: ALT-RPM_PRICE-002
CHANGE_TYPE: 3
MULTI_UNITS: 12.5000
REASON_CODE: ALT-RP
CONFLICT_IND: 3
GENERATED_BY: S
APPROVAL_DATE: 2026-01-03
CHANGE_AMOUNT: 12.5000
ORIGINAL_ITEM: RPM Price Change Helper G
PURCHASE_TYPE: 1
CHANGE_PERCENT: 12.5000
EFFECTIVE_DATE: 2026-01-03
MASTER_BGE_IND: 3
MASTER_SGE_IND: 3
ZONE_NODE_TYPE: 3
CHANGE_CURRENCY: RPM
CREATE_DATETIME: 2026-01-03
LAST_UPDATED_ID: ALT-RPM_PRICE-002
ORIGINAL_DIFF_ID: ALT-RPM_PR
ORIGINAL_ZONE_ID: 1000000003
PRIMARY_SUPPLIER: 3
ROUNDING_RULE_ID: 1000000003
MULTI_UNIT_IMPACT: R
MULTI_UNIT_RETAIL: 12.5000
OBJECT_VERSION_ID: 1000000003
CHANGE_SELLING_UOM: RPM
IGNORE_CONSTRAINTS: 3
EXCEPTION_PARENT_ID: 1000000003
LAST_UPDATE_DATETIME: 2026-01-03
PRICE_CHANGE_GROUP_ID: 1000000003
EXCEPTION_FROM_LOC_IND: 3
LOC_EXC_CHILDREN_EXIST: 3
MULTI_UNIT_SELLING_UOM: RPM
EXCEPTION_FROM_ITEM_IND: 3
ITEM_EXC_CHILDREN_EXIST: 3
SYS_GENERATED_EXCLUSION: 3
BATCH_GENERATED_EXCLUSION: 3
MULTI_UNIT_RETAIL_CURRENCY: RPM