cancel
Showing results for 
Search instead for 
Did you mean: 

Upload / import variant tables containing multiple value characteristics

former_member214775
Contributor
0 Kudos

Hi All,

do you have any experience about to upload / import such variant tables which are containing multiple value characteristics?

In the example below Char1 and Char2 charcteristics would be multiple value enabled characteristics. Between the values of Char1 (and Char2) there is an OR relationship. That is why it has to be represented by a multi-value characteristic.

Char3 is a single value characteristic.

In excel:

Char1Char2Char3
C1V1C2V1C3V1
C1V2C2V1C3V2
C2V2C3V2
C1V1C2V2C3V3
C1V3C2V3C3V4

In SAP it should look like this in CU60 e.g.:

Line number in CU60Char1Char2Char3
0001C1V1C2V1C3V1
C1V2C2V1C3V2
C2V2C3V2
0002C1V1C2V2C3V3
0003C1V3C2V3C3V4

Thank you in advance!

Best regards

Tamas

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Dear Tamas,

I think the Excel file must be completely filled. So the third line in your example should be

Char1Char2Char3
C1V2C2V2C3V2

This way you get the normalized form of a variant table that contains multivalued characteristics.

Best regards,

Eric

former_member214775
Contributor
0 Kudos

Hi Eric,

let's say it is ok. My issue is that the CU60E can not upload such files and upload multiple values in one line. In CU60 it is possible to choose multiple values in one line.

Best regards

Tamas

Former Member
0 Kudos

Dear Tamas,

is the Excel file formatted exactly the way it is described as in the attachment of note 516885?

Best regards,

Eric

former_member214775
Contributor
0 Kudos

Hi Eric,

it is not an issue. The CU60E can not upload multiple values in one line (I understand here line number).

See an example screenshot which I created manually in CU60:

So in line 00001 the CHAR1 and CHAR2 are multi-valued chars. CHAR3 is single.

Line 00001 cannot be uploaded with the standard.

Best regards

Tamas