Shorten SAP BELNR from behind

[shawnklar]

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

[datanibbler]

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 · Accepted solution]

Hi Peter,

In your load script, you can use

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

Regards,

Sokkorn

[shawnklar]

Thank you very much Sokkorn,

it works perfectly.

Peter

[Sokkorn]

You are welcome Peter.

Regards,

Sokkorn