Transfer the Purchasing category to requisition distribution DFF

Summary

Transfer the Purchasing category to requisition distribution DFF

Content

Hi,

We have a requirement where purchasing category needs to transfered to the invoice.

One way to do that is, to copy the purchasing category available at the line level to requisition distribution DFF and then transfer it to PO distribution DFF and then to Invoice distribution DFF.

Can some one help me on, how can i dynamically copy the Purchasing category available at requisition line to requisition distribution DFF

I think, i need to write a SQL for the default value in the DFF value set. I am looking for the SQL.