cancel
Showing results for 
Search instead for 
Did you mean: 

Expert Routine to concatenate Fiscal year and posting period into fiscal period

former_member246680
Participant
0 Kudos

Hi all,

I am on BW/4HANA and using Expert routine in my transformation. Trying to concatenate 0FISCYEAR and 0FISCPER3 into 0FISCPER but the expert routine does not take "CONCATENATE" and giving error.

I wanted to use syntax CONCATENATE SOURCE_FIELDS-FISCYEAR SOURCE_FIELDS-FISCPER3 INTO RESULT.

I also want to concatenate where there a value in 0FISCPER3, else if 0FISCPER3 is 000, 0FISCPER should be 0000000.

What do I use instead?

Regards

Jordan

Jan_van_Ansem
Contributor
0 Kudos

You say "Expert Routine" but are referring to target RESULT. RESULT is used in rules, not in expert routines.

In the expert routine you have the RESULT_PACKAGE.

Maybe you have mixed up the fields used in rule mapping with the structures available in Expert Routine?

Concatenate works both in expert routine and in rules routines - but make sure you use the appropriate structures in any given context.

As Mario said, post some of your code to show the context. Your syntax looks sound, but without the context it is not possible to say why this goes wrong.

Accepted Solutions (1)

Accepted Solutions (1)

former_member186445
Active Contributor
0 Kudos

concatenate works fine in my expert routines. think the issue is somewhere else. can you paste your entire code?

Answers (2)

Answers (2)

former_member246680
Participant
0 Kudos

Thank you guys it was a a typo error on code

sulgup
Explorer
0 Kudos

please check the data type and length of Target field, otherwise you can declare a char type variable and concatenate into that and finally assign that variable to RESULT.

also RESULT is in field routine not in expert routine.

sulgup
Explorer
0 Kudos

also check the Format which is accepted by 0FISCPER.