1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
SELECT DBSTAL_REKP_D.RETOURNR, DBSTAL_REKP_D.RET_POS_NR_GES, DBSTAL_REKP_D.POS_NR_GES, DBSTAL_REKP_D.PACK_POS_NR, DBSTAL_REKP_D.RG_NR, DBSTAL_REKP_D.AU_NR, DBSTAL_REKP_D.AU_POS, DBSTAL_REKP_D.SACHNR, DBSTAL_REKP_D.SACH_GERAET, DBSTAL_REKP_D.MENGE, DBSTAL_REKP_D.VK_PREIS, DBSTAL_REKP_D.BEZ_PREIS, DBSTAL_REKP_D.IST_PREIS, DBSTAL_REKP_D.PREISEINH, DBSTAL_REKP_D.DATUMS_TAB_1, DBSTAL_REKP_D.DATUMS_TAB_3, DBSTAL_REKP_D.DATUMS_TAB_7, DBSTAL_REKP_D.DATUMS_TAB_8, DBSTAL_REKP_D.STATUS,
IIF(LEFT(DBSTAL_REKP_D.RET_POS_NR_GES,17) & "G" = DBSTAL_REKS_D.RET_POS_NR_GES , MID(DBSTAL_REKS_D.RET_POS_CODE,18, 3), "") AS [Code Type de Probléme],
IIF([Code type de Probléme] = DBSTAL_BEAG_D.[BEASCHL], DBSTAL_BEAG_D.BEAMSG_1, "") AS [Libellé Type de Probléme],
IIF(LEFT(DBSTAL_REKP_D.RET_POS_NR_GES,17) & "F" = DBSTAL_REKS_D.RET_POS_NR_GES , MID(DBSTAL_REKS_D.RET_POS_CODE,18, 3),"" ) AS [Code Défaut Constaté],
IIF([Code Défaut Constaté] = DBSTAL_BEAG_D.[BEASCHL], DBSTAL_BEAG_D.BEAMSG_1,"" ) AS [Libellé Défaut Constaté],
IIF(LEFT(DBSTAL_REKP_D.RET_POS_NR_GES,17) & "W" = DBSTAL_REKS_D.RET_POS_NR_GES , MID(DBSTAL_REKS_D.RET_POS_CODE,18, 3), "") AS [Code Décision Commerciale],
IIF([Code Décision Commerciale] = DBSTAL_BEAG_D.[BEASCHL], DBSTAL_BEAG_D.BEAMSG_1, "") AS [Libellé Décision Commerciale],
IIF(LEFT(DBSTAL_REKP_D.RET_POS_NR_GES,17) & "A" = DBSTAL_REKS_D.RET_POS_NR_GES , MID(DBSTAL_REKS_D.RET_POS_CODE,18, 3), "") AS [Code Résultat Contrôle],
IIF([Code Résultat Contrôle] = DBSTAL_BEAG_D.[BEASCHL], DBSTAL_BEAG_D.BEAMSG_1, "") AS [Libellé Résultat Contrôle]
FROM (DBSTAL_REKS_D INNER JOIN DBSTAL_REKP_D ON DBSTAL_REKP_D.RETOURNR = DBSTAL_REKS_D.RETOURNR) INNER JOIN DBSTAL_BEAG_D ON MID(DBSTAL_REKS_D.RET_POS_CODE,18, 3) & " " = DBSTAL_BEAG_D.BEASCHL; |
Partager