Unable to Find “Commodity Group 2” in PURCHASE_REQ_LINE_ALL View using Datasource Designer – Alternative Ways to Access It?

Hi all,

I’m working with IFS Cloud and trying to retrieve the Commodity Group 2 field from the Purchase Requisition Lines page. However, I can’t find it in Data Source Designer within the PURCHASE_REQ_LINE_ALL view.

From the Debug Console, I see the following details:

• LU Name: PurchaseReqLine

• Projection: PurchaseRequisitionLinesHandling

• Entity Set: PurchaseReqLineSet

• Entity: PurchaseReqLine

• View: PURCHASE_REQ_LINE_ALL

• Component: PURCH

I’ve checked the columns in the PURCHASE_REQ_LINE_ALL view, but I don’t see Commodity Group 2 listed. Is it possible that this field is stored in another table or fetched dynamically through another projection?

If it’s in a different table, would anyone know the correct join conditions or an alternative where query to access it?

Or is this field perhaps derived from a different entity that I should be using?

Any advice on where to find this field or how to retrieve the relevant commodity group or codes would be greatly appreciated!

Thanks in advance!