BRF+ data Validation

[sarvesh_ranjan]

Hi Experts,

I have BRF+ table where i created decision table with three columns plant, profit center and indicator.

I have a condition for a PLANT and ACTIVE X indicator combination if the value already exists in decision table it should throw an error when user tries to create the same entry.

Input Fields = PLANT, INDICATOR

Output Fields = PROFIT CENTER

1)	Plant	profit centre	Indicator
	Plant 1	1	X
	Plant 1	2	X	Error - profit centre already active for this plant
2)	Plant	profit centre	Indicator
	Plant 1	1	X
	Plant 2	1	X	Possible

I tried using Rule Set and Custom Exit but unable to validate existing entries using loop.

I am new to BRF+ Concept so any help would be appreciated.

Thanks.

[snedden_almeida]

Hi,

Have you tried maintaining the primary key fields as mandatory? Also in the table settings under the decision table, you need to select the option of unique fields only for the particular column. Hope this should work.

Snedden