Skip to Content
0

:Dimension: ACCOUNT member: CL_tax_social_sec.Value_added is invalid or is a calculated member

Nov 10, 2017 at 02:19 PM

57

avatar image
Former Member

Hi All,

I'm trying to validate a transformation file, however i'm receiving the same error every time i run it...

Line361 :Dimension: ACCOUNT member: CL_tax_social_sec.Value_added is invalid or is a calculated member

In my conversion file i have the folloing mapping:

CL_tax_social_sec.Value_added --> CL_TAX_SOC_SEC.VAL_ADD_FORM

The destination account is an existing base member account (i already loaded data on it in the past)

I also tried to *Skip the account but it keeps giving me the same error.

The problem seems to be the source account, but i don't see what the issue might be.

Any ideas?

Thanks

Joran

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Nov 10, 2017 at 02:48 PM
0

Sorry, but without posting full transformation file text and screenshots of conversion files used it's not possible to help you!

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 10, 2017 at 02:59 PM
0

Hereby the screenshots...


conversion.png (43.2 kB)
data.png (52.2 kB)
status-log.png (22.2 kB)
error.png (11.4 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Please post the line of text import file containing: CL_tax_social_sec.Value_added

As text!

0
Vadim Kalinin Nov 10, 2017 at 03:29 PM
0

May be you have space at the end of the sting:

"CL_tax_social_sec.Value_added "

in the conversion file!

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 13, 2017 at 07:56 AM
0

i've already checked that, but that's not the case... Both account ID's are identical...

Any other suggestions?

Joran

Show 7 Share
10 |10000 characters needed characters left characters exceeded

Have to repeat: "Please post the line of text import file containing: CL_tax_social_sec.Value_added

As text!"

0
Former Member

Sorry, didn't see your respons...

OTHER_Dummy CL_tax_social_sec.Value_added 1094956,71


0

Create a new conversion file with a single line:

CL_tax_social_sec.Value_added CL_TAX_SOC_SEC.VAL_ADD_FORM

Copy transformation file an correct conversion line.

And try to import single line

OTHER_Dummy CL_tax_social_sec.Value_added 1094956,71

0
Former Member

Hi, Apparently you can not have the word "Value" in the columns of your conversion file...

1

Interesting finding! Value can be used in the Formula column of conversion file. Looks like it's replaced in all columns :)

If part of the line is unique:

"CL_tax_social_sec."

Then you can use:

CL_tax_social_sec.* CL_TAX_SOC_SEC.VAL_ADD_FORM

P.S. May be also:

CL_tax_social_sec.*_added

0
Former Member

The input file is the result of a macro, so we added at the end a part replacing 'Value' by 'Val' and had no difficulties loading data :)

0

But in general it's definitely a program bug! I recommend you to contact SAP support, so this bug will be fixed in future.

0