4 Replies Latest reply: Jan 13, 2014 4:58 AM by Sokkorn Cheav RSS

    Shorten SAP BELNR from behind

    Peter Brettschneider

      Hello,


      I have a question and hope my english is not too bad:


      I want to establish a link between SAP FI and SAP IS-U in QlikView.

      For this I use the AWKEY in FI and the FIKEY (DFKKKO) in IS-U.


      Unfortunately the AWKEY is like this:

      13120403/MÜA-0000001

      and the FIKEY like that:

      13120403/MÜA


      Is it possible to cut the AWKEY by 8 points from behind and how would the code look like for this?


      Thank you very much,


      Peter