Golden arrow to work order position
Answered
Hello, I would like to open a work order position through a golden arrow in a sql report. That's my scenario:
1. Sql report that selects BELPOS_ID
2. Push golden arrow and the work order position doesn't show
3. Work order position that I want to show
I think that problem is that I don't know what is DocEntry (or the combination that I have to show to link the golden arrow) of work order position.
Can you help me, please?
-
Official comment
Hello Ignacio,
Work Order is special as it's a combination of two fields in the database. Below you can see some example SQL there works with 'Work order position' by combining the DocEntry and LineNumber fields into one I call ObjectKey and adding the golden arrow to this:
select "BEASV_WORKORDER"."DocEntry","BEASV_WORKORDER"."DocNum",
'000192010' as 'barcode',CAST("BEASV_WORKORDER"."DocEntry" AS NVARCHAR(254)) + '|' + '10' AS 'ObjectKey',
"BEASV_WORKORDER"."DocDate","BEASV_WORKORDER"."CardCode",
"BEASV_WORKORDER"."CardName" ,"BEASV_WORKORDER"."ItemCode"
from "BEASV_WORKORDER"
where "BEASV_WORKORDER"."ItemCode" = '$[BEAS:dw_1.item.itemcode.value]'
-
I think you need to use the 'Multi' option to link the drill down (golden arrow) column with both the entry number and the object type. That's how it works for other marketing documents, I haven't tried it with SAP Production Orders.
Please sign in to leave a comment.
Comments
2 comments