ltrim function in SAP BODS

[#1]

Hi Guru's

I have a issue in SAP BODS , please help me to resolve the issue..

Attached my input and output file format for your reference..

As I have column i.e. Material - we wanted to prefix "M" in front of all the Materials, If the Material is blank ...we have to make it as blank column (' ') as shown below output file results.

capture.png

I have applied 'M' || Ltrim(Query.Material,'M_') but this is giving wrong results. Please do the needful.

Regards,

Rag

.

[rajiv_deshpande · Accepted solution]

Hi

Use this code in the Mapping of the Output Field.

decode(MaterialNo IS NULL, '', 'M' || to_char(MaterialNo))

The output field for Material should be varchar and it should be big enough to hold "'M'+Mat#"

Thank you

Rjaiv Deshpande

[Former Member]

Hi Rajiv,

Thanks for your help...its working fine.....