Boa tarde.
Declare uma variavel antes, e utilize ela na sua consulta, lembrando que serial é int
O primeiro /* T0.Serial */ é pra enganar o SAP, assim ele sabe que é esse campo que deve ser solicitado.
DECLARE @SERIAL INT SET @SERIAL = /* T0.SERIAL */ [%0] SELECT 'NF Entrada', T0.DocEntry, T0.DocDate, T0.Serial FROM OPCH T0 WHERE T0.Serial=@SERIAL union all SELECT 'Devoluções', T0.DocEntry, T0.DocDate, T0.Serial FROM ORDN T0 WHERE T0.Serial=@SERIAL union all SELECT 'Dev. NF Saida', T0.DocEntry, T0.DocDate, T0.Serial FROM ORIN T0 WHERE T0.Serial=@SERIAL union all SELECT 'Recebimento', T0.DocEntry, T0.DocDate, T0.Serial FROM OPDN T0 WHERE T0.Serial=@SERIAL union all SELECT 'NF Saida', T0.DocEntry, T0.DocDate, T0.Serial FROM OINV T0 WHERE T0.Serial=@SERIAL union all SELECT 'Entrega', T0.DocEntry, T0.DocDate, T0.Serial FROM ODLN T0 WHERE T0.Serial=@SERIAL union all SELECT 'Dev. NF Entrada', T0.DocEntry, T0.DocDate, T0.Serial FROM ORPC T0 WHERE T0.Serial=@SERIAL union all SELECT 'Devoluções de mercadoria', T0.DocEntry, T0.DocDate, T0.Serial FROM ORPD T0 WHERE T0.Serial=@SERIAL
[]'s
Fabio
SAP 9.1 PL11 / SAP 9.2 PL5 (test)
Add comment