How to use Line level remark customoization option for Reception flow in Produmex WMS

You have the following customization option for the Reception flow:

http://wiki.produmex.name/doku.php?id=implementation:wms:purchasedeliverygen

With this customization you can provide additional information on the Mobile client on a separate screen. In our example we are adding the Shipdate, and Open Quantity information from PO lines. It is important that you use cast on these fields in your view.

Custom view in MS SQL:

CREATE VIEW [dbo].[PMX_PO_LINE_REMARKS] AS

SELECT
T1.[ObjType]
, T1.[DocEntry]
, T1.[LineNum]
, T1.[ItemCode]
, cast(T1.[ShipDate] as varchar(20)) as "ShipDate"
,cast(T1.[OpenQty] as varchar(20)) as "OpenQty"
FROM POR1 T1
WHERE T1.LineStatus = 'O'

Custom view in HANA:

CREATE VIEW "PMX_PO_LINE_REMARKS"
(
"ObjType"
,"DocEntry"
,"LineNum"
,"ItemCode"
,"ShipDate"
,""OpenQty"
) AS
SELECT
"T1"."ObjType"
, "T1"."DocEntry"
, "T1"."LineNum"
, "T1"."ItemCode"
, cast("T1"."ShipDate" as varchar(20))
,cast("T1"."OpenQty" as varchar(20))
FROM "POR1" "T1"
WHERE "T1"."LineStatus" = 'O'

Result on the mobile client: