QUERY CALIDAD CON PARAMETROS

Jefferson Daniel Vásconez Vargas

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

Comments

1 comment

Date Votes
  • Comment author
    Thierry Rodrigues da Silva
    --SELECT "ItemName" FROM "OITM" WHERE "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" = [%0]
    ORDER BY
    T3."BELDAT"
    ,T3."LFGDAT" ASC;
    0

Please sign in to leave a comment.