How to manipulate DataRepeater (List)

Sometimes you need to change the layout and the content of data in the lists. This article will help you to understand and influence the layout of the DataRepeater.

Before you start to manipulate the DataRepeater you need to understand the customization technology that you can reach at this link:

http://wiki.produmex.name/doku.php?id=implementation:scan:customizationtechnology

This article is based on this wiki page:

http://wiki.produmex.name/doku.php?id=implementation:scan:datarepeater

In Produmex Scan we call the lists DataRepaters

You can see the content of the lines split by characters ‘##’ in the customization screen. The names of the lines always start with ‘DataRepeater.UI’

If you would like to manipulate the displayed content then you should convert the concatenated string into an SQL table with our example splitter functions shown below. This table can be used in a query in order to load the data you need.

You will need a splitter function to separate data. If it does not exist, you can create it with these queries:

MSSQL

CREATE FUNCTION [dbo].[SplitStringForDataRepeater2] 
       ( @string NVARCHAR(MAX), @string2 NVARCHAR(MAX) ) 
RETURNS @output TABLE(splitdata NVARCHAR(MAX) , splitdata2 NVARCHAR(MAX)) 
BEGIN 
       DECLARE @start INT, @end INT , @start2 INT, @end2 INT 
       SELECT @start = 1, @end = CHARINDEX('##', @string) , @start2 = 1, @end2 = CHARINDEX('##', @string2) 
       WHILE @start < LEN(@string) + 1 BEGIN 
              IF @end = 0 
              BEGIN 
                      SET @end = LEN(@string) + 2 
                      SET @end2 = LEN(@string2) + 2 
              END 
              INSERT INTO @output (splitdata, splitdata2) 
              VALUES(SUBSTRING(@string, @start, @end - @start),
              SUBSTRING(@string2, @start2, IIF(@end2 - @start2<0,0,@end2 - @start2))) 
              SET @start = @end + 2 
              SET @end = CHARINDEX('##', @string, @start) 
              SET @start2 = @end2 + 2 
              SET @end2 = CHARINDEX('##', @string2, @start2) 
       END
RETURN END

HANA

CREATE FUNCTION SPLITSTRINGFORDATAREPEATER2 (strstring nvarchar(5000), strstring2 nvarchar(5000) )
RETURNS TABLE (splitdata nvarchar(5000) , splitdata2 nvarchar(5000) ) 
LANGUAGE SQLSCRIPT AS
BEGIN
       DECLARE strstart INT;
       DECLARE strend INT; 
       DECLARE strstart2 INT;
       DECLARE strend2 INT;
       DECLARE _items nvarchar(5000) ARRAY;
       DECLARE _index integer;
       _index := 1;
       strstart := 1;
       strend := LOCATE(strstring, '##');
       strstart2 := 1;
       strend2 := LOCATE(strstring2, '##');
       WHILE strstart < LENGTH(strstring) + 1 DO 
              IF strend = 0 THEN
                      BEGIN 
                             strend := LENGTH(strstring) + 2;
                             strend2 := LENGTH(strstring2) + 2;               
                      END;
              END IF;
              _items[:_index] := SUBSTRING(strstring, strstart, strend - strstart) || '|||' || SUBSTRING(strstring2, strstart2, strend2 - strstart2);        
              _index := :_index + 1;
              strstart := strend + 2; 
              strend := LOCATE(strstring, '##', strstart);
              strstart2 := strend2 + 2; 
              strend2 := LOCATE(strstring2, '##', strstart2);
       END WHILE; 
       rst = UNNEST(:_items) AS ("items"); 
       RETURN 

              SELECT SUBSTRING("items", 1, LOCATE("items", '|||') - 1) as "SPLITDATA", SUBSTRING("items", LOCATE("items", '|||') + 3, (LENGTH("items") - LOCATE("items", '|||') ) ) as "SPLITDATA2" FROM :rst;

 END;

Hide the displayed data from the DataRepeater

In this example we want to get rid of the stock data  from the ‘Guided Counting’ list, because we want to force the user to do blind counting.

Find the name of the screen and the field in the customization assist window, in this case this is the ‘QuickInventoryCountingQuantitiesScreen’ and ‘DataRepeater.UIQuantity’.

Open the BXPCUSTFD user defined table in SAP and add the following line. Be sure the ‘Visible’ value is ‘No’. You can define any code or name at will.

The result

Overwrite the displayed data in the DataRepeater

In this example we only want to get rid of the stock data from the ‘Guided Counting’ list, because we want to force the user to do blind counting. The counted quantity will remain. (Don’t forget to delete the line from the BXPCUSTFD user defined table that we created in the previous section, because we won’t need it in this case)

Find the name of the screen and the field in the customization assist window, in this case this is the ‘QuickInventoryCountingQuantitiesScreen’ and ‘DataRepeater.UIQuantity’.

Also find the name of the ‘DataRepeater_InternalDataLoad’ event, in this case this is ‘BXMobileWH9_QuickInventoryCountingQuantitiesScreen_DataRepeater_InternalDataLoad’.

Now we will use the ‘SplitStringForDataRepeater2’ function that we created earlier.

Create a user query in the query Manager. The name of the query must be the same as the name of the ‘InternalDataLoad’ event.

Query name: BXMobileWH9_QuickInventoryCountingQuantitiesScreen_DataRepeater_InternalDataLoad

Query:

SELECT
       LEFT(S.splitdata, CHARINDEX(' / ',S.splitdata)) as "DataRepeater.UIQuantity"
FROM
                  dbo.SplitStringForDataRepeater2( $[DataRepeater.UIQuantity], '') as S

Take note:

• The input parameter of the ‘SplitStringForDataRepeater2’ is the field name of the DataRepeater
• The alias in the SELECT statement is also the name of the field that we want to overwrite

Result

Add extra lines and data to the DataRepeater

In this example we want to show the bin locations where the stock is currently located on the GRPO screen.

Review the possible ‘Position Data’ values. There are some differences between possible values on Android and on Windows scanner.

We need to add a line to the CUSTFD table, to make place for the new data. You can define any code or name at will.

Take note of the ‘Position data’. You can add multiple parameters with semicolon separators. In this example we define the new list element with two lines (‘lines’ parameter) and its position in the DataRepeater row is 50 (‘y’ parameter). Feel free to modify these values according to your scanner device.

Then we need to fill this new line with data.

Create a user query in SAP. The name of the query is the same as the name of the screen and the end of its name is ‘_DataRepeater_InternalDataLoad’. In this case this is the ‘BXMobileWH9_GoodsReceiptPOLinesScreen_DataRepeater_InternalDataLoad’.

Query name: BXMobileWH9_GoodsReceiptPOLinesScreen_DataRepeater_InternalDataLoad

Query:

SELECT
       S.splitdata,
       STRING_AGG(T1.BinCode,', ') AS [DataRepeater.CustomLine01]
FROM
   dbo.SplitStringForDataRepeater2($[DataRepeater.UIItemCode],'') AS S
LEFT JOIN
       OIBQ T0 ON T0.ItemCode = LEFT(S.splitdata, CHARINDEX(' * ',S.splitdata))
LEFT JOIN
       OBIN T1 ON T0.BinAbs = T1.AbsEntry
WHERE
       T0.OnHandQty > 0
GROUP BY
       S.splitdata

Take note:

You need to add the S.Splitdata in the SELECT statement, because that’s the way the query can link the new data to the existing data. (see the first line after SELECT)

The new data appeared.

In this case I have set up the parameters in the CUSTFD table to an Android device. If you want to optimize the appearance for another device you need to modify the ‘Position Data’.

Please check this article about a concrete example

• DataRepeater - How to change item description on GRPO screen