QUERY CALIDAD CON PARAMETROS
Buenas tardes, espero se encuentren bie, quisiera conocer porque no funciona esto si en sap solo se lo hace con este parametro '[%]'
/* SELECT FROM [dbo]. [OITM] T1 */
DECLARE @ItemCode NVARCHAR(100)
/* WHERE*/
SET @ItemCode = /* T1. ItemCode */ '[%0]'
SELECT
DISTINCT
T3."BELDAT",
T3."LFGDAT",
T0."PRUEFAUFTRAG" AS "Plan de calidad",
T0."ItemCode",
T1."CHARGE_ID" AS "ORIGEN",
T1."FERT_BELNR_ID" AS "Lote/OT",
T1."DocEntry" AS "Orden de Calidad",
T1."KND_ID" AS "Muestra",
T1."QS_ID" AS "Medición",
CAST(T1."BEZ" AS VARCHAR(255)) AS "Metodología",
T1."MINIMAL" AS "Mínimo",
T1."MAXIMAL" AS "Máximo",
T1."MESSWERT" AS "Valor Numérico",
T1."MESSWERTC" AS "Valor Texto",
T1."ME_ID" AS "Unidad de Medida"
FROM "BEAS_QSFTHAUPT" T0
INNER JOIN "BEAS_QSFTPOS" T1 ON
T1."FERT_BELNR_ID" = T0."FERT_BELNR_ID"
AND T0."DocEntry" = T1."DocEntry"
INNER JOIN "BEAS_FTSTL" T2 ON
T1."FERT_BELNR_ID" = T2."BELNR_ID"
AND T1."FERT_BELPOS_ID" = T2."BELPOS_ID"
INNER JOIN "BEAS_FTHAUPT" T3 ON
T2."BELNR_ID" = T3."BELNR_ID"
WHERE T0."ItemCode" = @ItemCode
ORDER BY T3."BELDAT", T3."LFGDAT" ASC
0
-
--SELECT "ItemName" FROM "OITM" WHERE "ItemCode" = [%0]SELECT DISTINCTT3."BELDAT",T3."LFGDAT",T0."PRUEFAUFTRAG" AS "Plan de calidad",T0."ItemCode",T1."CHARGE_ID" AS "ORIGEN",T1."FERT_BELNR_ID" AS "Lote/OT",T1."DocEntry" AS "Orden de Calidad",T1."KND_ID" AS "Muestra",T1."QS_ID" AS "Medición",CAST(T1."BEZ" AS VARCHAR(255)) AS "Metodología",T1."MINIMAL" AS "Mínimo",T1."MAXIMAL" AS "Máximo",T1."MESSWERT" AS "Valor Numérico",T1."MESSWERTC" AS "Valor Texto",T1."ME_ID" AS "Unidad de Medida"FROM"BEAS_QSFTHAUPT" T0INNER JOIN"BEAS_QSFTPOS" T1 ON T1."FERT_BELNR_ID" = T0."FERT_BELNR_ID"AND T0."DocEntry" = T1."DocEntry"INNER JOIN"BEAS_FTSTL" T2 ON T1."FERT_BELNR_ID" = T2."BELNR_ID"AND T1."FERT_BELPOS_ID" = T2."BELPOS_ID"INNER JOIN"BEAS_FTHAUPT" T3 ON T2."BELNR_ID" = T3."BELNR_ID"WHERET0."ItemCode" = [%0]ORDER BYT3."BELDAT",T3."LFGDAT" ASC;
Iniciar sesión para dejar un comentario.
Comentarios
1 comentario