Skip to main content

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!

 

 

Perhaps it can be done by accessing the LOV? 

Name: CommodityGroup2, Mandatory: false, Translation Path: PurchaseRequisitionLines.list.RequisitionDetailList.listcontent.field.CommodityGroup2Ref, LOV: ReferenceCommodityGroupSelector (Reference_CommodityGroup)

Any advice on getting the field values for use in my query would be much appreciated!

Hi ​@awelsh,

Please add a custom column with below getter function in your Data Source Designer having view PURCHASE_REQ_LINE_ALL 

INVENTORY_PART_API.GET_SECOND_COMMODITY(CONTRACT,PART_NO)

 

Regards

Abdul Rehman

Thank you for your quick reply ​@Abdul, this worked. Do you know if there is any IFS Cloud Technical Documentation or otherwise which has more information onhow to use getter functions like these in queries? 

Regarding my second question, I have managed to find how to access specific API documentation via API Explorer on IFS Cloud, thanks.

Reply


Terms & ConditionsCookie settings