topic Re: How to make composite key in SAP Sql query in QlikView

How to make composite key in SAP Sql query

asmitagg — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I m trying following subquery in SAP but its not working plz suggest.

SQL SELECT MBLNR,MJAHR,MATNR,CHARG,WERKS,MEINS,BUDAT_MKPF,BWART,MENGE FROM MSEG

WHERE MBLNR&MJHAR IN (SELECT MBLNR&MJHAR FROM MKPF WHERE CPUDT > '$(vDate)' AND CPUDT < '$(vToday)');

"MBLNR&MJHAR" how to make composite key or concat these two fields to make key.

I m trying with '&' its not working.

Ricardo_Gerhard — Tue, 06 Feb 2018 18:14:06 GMT

Dear Asmita,

You can use this syntax below because I SAP database doesn´t allow subqueries as you tried:

- Load the query:

SELECT MBLNR&MJHAR FROM MKPF WHERE CPUDT > '$(vDate)' AND CPUDT < '$(vToday);

- Then run the first query

SQL SELECT MBLNR,MJAHR,MATNR,CHARG,WERKS,MEINS,BUDAT_MKPF,BWART,MENGE FROM MSEG

WHERE MBLNR&MJHAR

with where exists statement

Ricardo_Gerhard — Tue, 06 Feb 2018 18:15:17 GMT

Anyway, SAP allows the composite key like you had tried FIELD1&FIELD2

rupamjyotidas — Tue, 06 Feb 2018 18:23:53 GMT

Suggestion would be to load the Data as it is and Use Preceding load to built your composite key

Load MBLNR&MJHAR as Key;

SELECT MBLNR,MJHAR FROM MKPF WHERE CPUDT > '$(vDate)' AND CPUDT < '$(vToday);

Load * Where Exists(Key);

Load

SQL SELECT MBLNR,MJAHR,MATNR,CHARG,WERKS,MEINS,BUDAT_MKPF,BWART,MENGE FROM MSEG

MarcoWedel — Tue, 06 Feb 2018 19:07:04 GMT

MJHAR -> MJAHR Typo?