Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
shawnklar
New Contributor II

Shorten SAP BELNR from behind

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

1 Solution

Accepted Solutions
Sokkorn
Honored Contributor

Re: Shorten SAP BELNR from behind

Hi Peter,

In your load script, you can use

SubField(AWKEY,'-',1) AS AWKEY

Regards,

Sokkorn

4 Replies
datanibbler
Esteemed Contributor

Re: Shorten SAP BELNR from behind

Hi Peter,

LEFT(AWKEY, (Length(AWKEY)-8)) - this will take, from the left, all the letters from AWKEY minus the 8 you want to cut off.

HTH

Best regards,

DataNibbler

Sokkorn
Honored Contributor

Re: Shorten SAP BELNR from behind

Hi Peter,

In your load script, you can use

SubField(AWKEY,'-',1) AS AWKEY

Regards,

Sokkorn

shawnklar
New Contributor II

Re: Shorten SAP BELNR from behind

Thank you very much Sokkorn,

it works perfectly.

Peter

Sokkorn
Honored Contributor

Re: Shorten SAP BELNR from behind

You are welcome Peter.

Regards,

Sokkorn

Community Browser