String search in HANA

[ravikiran_sap]

Hi All,

I need to identify all 3 rd party billable Internal orders and generate a flat file for our user.

for this i would liek to create a cal.view on Advacned dso which is having all related data. But to identify 3 rd party records , we have to identify 7 th letter of each text description on that order desription.

ex : if the Description contains X , XA , M in the string's 7 th position those records belongs to 3 rd party billable.

please provide your valuable inputs on how to achieve this in view.

Regards,

Raki

[Abhishek_Hazra · Accepted solution]

Hi Ravi,

You can use the function : substring();

Follow : https://help.sap.com/viewer/7c78579ce9b14a669c1f3295b0d8ca16/Cloud/en-US/20e8341275191014a4cfdcd3c83...

But you need to come to a universal check for the description, for your example if you check for the letter 'X' in 7th position I did not understand why do you again want to check 'XA' & then it also include the 8th position. Nevertheless the check is already done for 7th position as 'X'.

Best Regards,
Abhi

[ravikiran_sap]

HI Abhishek

thanks for your valuable reply. yes some values are liek "XE" 'XA"..etc. forthis i have to read XA or XE from the strings 7 th position.

ex: 07001-XE PERSEA (12345Huoik) - here i hav to consider XE to determine it is 3 rd party record.

07001- A C230 k987Khsjko98 - here A i will consider for 3 rd party record.

Regadrs,

Ravi