how to remove some characters from a source value in SAP BODS

[Former Member]

Hi

I'm extracting the data fro EQUI table from SAP ECC into Oracle By using Data Service . I would like to remove two characters from the source value while data is extracting from ECC to Oracle (Template Table)

The source data is like below

EQUNR                OBJNR

123                       IE00000123

I want to remove IE from the OBJNR field source value and like the target data like below

EQUNR                OBJNR

123                       00000123

How can i achieve this in SAP BODS

Please let me know

Thanks

Mubeen

[Former Member]

HI Muhammed,

Please try Substr('IE00000123',3,LENGTH('IE00000123')-2) function.

Regards

Asgar

[bhanu_prakash37]

Hi Mohammed,

Click on the column on which you want to populate OBJNR column value in SCHEMA OUT

bottom you can see MAPPING,SELECT,FROM,GROUPBY... etc tabs

IN mapping you need to apply below

ltrim(TABLE.OBJNR,'IE')

Bhanu

[Former Member]

Hi Bhanu

Thanks alot for reply

Im getting the below error after writing above code

Cant parse expression function <ltrim> was not found in the repository. Before use a script function

Please suggest what to do now

Thanks

Mubeen

[bhanu_prakash37]

Have you used any other functions in your jobs and those are running fine?

I'm thinking that DS cannot able to locate functions or try to run the job as administrator.

[Former Member]

Hi Bhanu

I'm not using any other functions in SAP BODS.

yes DS is not able to recognize the functions

Regards

Mubeen

[bhanu_prakash37]

Please try to run the job as administrator. if not  try to disable UAC in server,

[bhanu_prakash37]

Hi

All repo function are available in Al_FUNCINFO table.if this table is empty then you need to populate the functions in that table by re-create repo

Bhanu

[Former Member]

Hi Bhanu

Actually I'm very new to SAP BODS project as basically I'm a SAP BW Consultant.

Can you please tell me how can i create the Al_FUNCINFO repository and how can i populate that table

Thanks

Regards

Mubeen

[Former Member]

Can show the screenshot of your design and query transform details?

[bhanu_prakash37]

Hi Mohammed,

If In case built functions are not recognizing , then my understanding is there is something wrong in your repository. when we create repository by default some tables are created in repository DB, those will be prefix with "AL_".

So all the inbuilt function are stores in Al_FUNCINFO table.if in case there are no values in that table then we can confirm that repository is not created properly.

so you need to  create repository again and automatically  you will get values in Al_FUNCINFO table.

Regards

Bhanu

[Former Member]

Hi Bhanu

Can you please tell me STEPS for how to create the Al_FUNCINFO table.

I'm new SAP DS system

Please help me here

Regards

Mubeen

[former_member198401]

It seems that the repository is corrupted. Can you recreate the Local repository using the Data Services Repository Manager.

Regards

Arun Sasi

[Former Member]

Hi Arun

Thanks alot for your reply

Can you please tell me HOW TO create the Local repository and use in my Data Flow for LTRIM functionality

Regards

Mubeen

[bhanu_prakash37]

Hi

Please refer below link for repository creation.

http://scn.sap.com/thread/3317583

Bhanu

[Former Member]

Hi Mohammed,

Try to apply ltrim( )function

ltrim('IE00000123','IE')

Thanks,

praveen

[Former Member]

Hi Pravin

Thanks for your reply

I have some many source data like IE000123 in the OBJNR column , so how can i apply the ITRM functionality to all source values

where can i apply the ITRIM functionality in Query Transformation

Please help me this is urgent

Mubeen

[Former Member]

In query transform,under mapping you just write the code.

ltrim(TABLE.OBJNR,'IE')