on 09-15-2014 10:49 AM
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:
Char1 | Char2 | Char3 |
---|---|---|
C1V1 | C2V1 | C3V1 |
C1V2 | C2V1 | C3V2 |
C2V2 | C3V2 | |
C1V1 | C2V2 | C3V3 |
C1V3 | C2V3 | C3V4 |
In SAP it should look like this in CU60 e.g.:
Line number in CU60 | Char1 | Char2 | Char3 |
---|---|---|---|
0001 | C1V1 | C2V1 | C3V1 |
C1V2 | C2V1 | C3V2 | |
C2V2 | C3V2 | ||
0002 | C1V1 | C2V2 | C3V3 |
0003 | C1V3 | C2V3 | C3V4 |
Thank you in advance!
Best regards
Tamas
Dear Tamas,
I think the Excel file must be completely filled. So the third line in your example should be
Char1 | Char2 | Char3 |
---|---|---|
C1V2 | C2V2 | C3V2 |
This way you get the normalized form of a variant table that contains multivalued characteristics.
Best regards,
Eric
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Tamas,
is the Excel file formatted exactly the way it is described as in the attachment of note 516885?
Best regards,
Eric
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
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.