Is it possible to do any calculation on DFF or KFF or these are informative fields, and How do you search for specific DFF or KFF?

Editorial / Best Answer

rams.regalla  

  • Member Since Jun-2007 | Jun 20th, 2007


Hi,
Its possible to do calculations on KFF or DFF columns.

But calculations on KFF or DFF columns are not effective in WHEN-NEW-ITEM-INSTANCE' or 'WHEN-VALIDATE-ITEM' triggers.

Calculations coding should be done in 'PRE-INSERT' or 'WHEN-VALIDATE-RECORD' triggers.

eg: In PRE-INSERT trigger

:M_RECEIPTS.ATTRIBUTE3=:M_RECEIPTS.ATTRIBUTE1+:M_RECEIPTS.ATTRIBUTE2

hope it helps

Showing Answers 1 - 3 of 3 Answers

Hi,
Its possible to do calculations on KFF or DFF columns.

But calculations on KFF or DFF columns are not effective in WHEN-NEW-ITEM-INSTANCE' or 'WHEN-VALIDATE-ITEM' triggers.

Calculations coding should be done in 'PRE-INSERT' or 'WHEN-VALIDATE-RECORD' triggers.

eg: In PRE-INSERT trigger

:M_RECEIPTS.ATTRIBUTE3=:M_RECEIPTS.ATTRIBUTE1+:M_RECEIPTS.ATTRIBUTE2

hope it helps

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions