RPM Clr Group Search Res (GTT)

Out of Scope

Technical: RPM_CLR_GROUP_SEARCH_RES_GTT | ID: OR-PRC-RPM_CLR_GROUP_SEARCH_RES_GTT-RPM_CLR_GROUP_SEARCH_RES_GTT

This helper table holds clearances that meet the search criteria in the clearance group search screen. The results are used to populate rpm_clr_group_search_ws.

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_CLR_GROUP_SEARCH_RES_GTT

Field Definitions(5)

Rules & Considerations(14)

validation

constraint

Sample Load Data(4)

_scenario	STATER	CLEARANCE_IDR	CLEARANCE_GROUP_IDR	CLEARANCE_GROUP_DESCR	CLEARANCE_GROUP_DISPLAY_IDR	CONFLICT_IND	GENERATED_BY	EFFECTIVE_DATE
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	1	S	2026-01-01
default	3	1000000003	1000000003	RPM Clr Group Search Res Gtt-002-ALT	ALT-RPM_CLR-002	3	S	2026-01-03
default	5	1000000005	1000000005	RPM Clr Group Search Res Gtt-003-EDGE	EDGE-RPM_CLR-00	5	S	2026-01-05

Example values from field definitions

STATER: 1
CLEARANCE_IDR: 1
CLEARANCE_GROUP_IDR: 1
CLEARANCE_GROUP_DESCR: SAMPLE
CLEARANCE_GROUP_DISPLAY_IDR: SAMPLE
CONFLICT_IND: 1
GENERATED_BY: S
EFFECTIVE_DATE: 2026-01-01

default

STATER: 3
CLEARANCE_IDR: 1000000003
CLEARANCE_GROUP_IDR: 1000000003
CLEARANCE_GROUP_DESCR: RPM Clr Group Search Res Gtt-002-ALT
CLEARANCE_GROUP_DISPLAY_IDR: ALT-RPM_CLR-002
CONFLICT_IND: 3
GENERATED_BY: S
EFFECTIVE_DATE: 2026-01-03