Please review this article for understand how DataRepeater manipulation is working
How to manipulate DataRepeater (List)
When customer changes the item description on Purchase Order by CTRL-Tab keys, these custom, one time descriptions are not displayed in Produmex Scan GRPO screen, but rather the item name from item master data.
In this example I changed the Item Description on the Purchase Order
This is how it looks on the scanner
Check customization screen on scanner, we need the $[SelectedPurchaseOrderLine.DocEntry] variable to find the Purchase Order to get the item description
We need the name of the DataRepeater line to overwrite. In this case this is $[DataRepeater.UIItemCode]. This variable contains the item code and name
Create a user query in SAP.
Query name: BXMobileWH9_GoodsReceiptPOLinesScreen_DataRepeater_InternalDataLoad
Query:
MSSQL
SELECT
CONCAT(T0."ItemCode", ' * ', T0."Dscription") AS "DataRepeater.UIItemCode"
FROM
POR1 AS T0
WHERE
T0."DocEntry" = $[SelectedPurchaseOrderLine.DocEntry]
ORDER BY
T0."LineNum"HANA
SELECT
T0."ItemCode" || ' * ' || T0."Dscription" AS "DataRepeater.UIItemCode"
FROM
POR1 AS T0
WHERE
T0."DocEntry" = $[SelectedPurchaseOrderLine.DocEntry]
ORDER BY
T0."LineNum"
Result on scanner
Comments
0 comments
Please sign in to leave a comment.