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

[former_member401938]

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

[former_member401938]

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

Any other suggestions?

Joran

[former_member186338]

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

As text!"

[former_member401938]

Sorry, didn't see your respons...

OTHER_Dummy CL_tax_social_sec.Value_added 1094956,71

[former_member186338]

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

[former_member401938]

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

[former_member186338]

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

[former_member401938]

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 🙂

[former_member186338]

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

[former_member186338]

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

"CL_tax_social_sec.Value_added "

in the conversion file!

[former_member401938]

Hereby the screenshots...

[former_member186338]

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

As text!

[former_member186338]

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