DataRepeater - How to change item description on GRPO screen

  • Updated

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

DROG_01.png

 

This is how it looks on the scanner

DROG_02.png

 

Check customization screen on scanner, we need the $[SelectedPurchaseOrderLine.DocEntry] variable to find the Purchase Order to get the item description

DROG_03.png

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

DROG_04.png

 

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"
DROG_05.png

 

Result on scanner

DROG_06.png

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.