Yes SetRecFieldEditTable updates the metdata but you can use event mapping to temporarily change this to desired prompt and put it back to its original state.

For example change the prompt in Field Default

&ret = SetRecFieldEditTable(Record.PSUSERATTR, Field.MPDEFAULMP, Record.PSCLASSDEFN, %EditTableType_Prompt);

Rollback in Save postchange.

&ret = SetRecFieldEditTable(Record.PSUSERATTR, Field.MPDEFAULMP, Record.PSMPDEFN, %EditTableType_Prompt);

Agreed with Peter if you have plain simple override you can choose the tools prompt override but if you want to systematically show the prompt based on user then you can use above peoplcode and conditionally show the prompts..you can literally write as many logic as you need.

-Velu

The built-in function SetRecFieldEditTable() will change the metadata (record definition). It is not doing a runtime override.

The prompt edit for record-field PR_REQUEST.TXN_CURRENCY_CD is view CURR_TXN_VW. Use the Prompt Table Override feature to override this at runtime with your own view. Read the documentation for this feature.

Hi - you can create a dynamic view and use setrecfieldedit peoplecode to override using appclass in event mapping.

Though i have not tested but i feel it may works..let me know how it goes

-Velu