topic Removing synthetic key in SAP data model in QlikView https://community.qlik.com/t5/QlikView/Removing-synthetic-key-in-SAP-data-model/m-p/1420322#M1230423 <HTML><HEAD></HEAD><BODY><P>Hi Guru's,</P><P></P><P>A nice interesting one for you all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I need to remove this synthetic key for obvious reasons, the key is currently made up of a concatenated key of Sales Order &amp; Item. And also DIVISION. Both of these fields are needed to be key fields however I can't seem to be able to imagine a better data model at this moment. </P><P><IMG alt="Syn1$.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182271_Syn1$.png" style="width: 620px; height: 534px;" /></P><P></P><P>Any input or comments would be helpful!</P><P></P><P>Thanks All! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Mon, 26 Jan 2026 21:26:37 GMT Anonymous 2026-01-26T21:26:37Z Removing synthetic key in SAP data model https://community.qlik.com/t5/QlikView/Removing-synthetic-key-in-SAP-data-model/m-p/1420322#M1230423 <HTML><HEAD></HEAD><BODY><P>Hi Guru's,</P><P></P><P>A nice interesting one for you all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I need to remove this synthetic key for obvious reasons, the key is currently made up of a concatenated key of Sales Order &amp; Item. And also DIVISION. Both of these fields are needed to be key fields however I can't seem to be able to imagine a better data model at this moment. </P><P><IMG alt="Syn1$.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182271_Syn1$.png" style="width: 620px; height: 534px;" /></P><P></P><P>Any input or comments would be helpful!</P><P></P><P>Thanks All! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Mon, 26 Jan 2026 21:26:37 GMT https://community.qlik.com/t5/QlikView/Removing-synthetic-key-in-SAP-data-model/m-p/1420322#M1230423 Anonymous 2026-01-26T21:26:37Z