BPC 10 NW upload several master data with the same Excel file

[wissler_bastien]

Hello,

I would like the upload the dimensions MATERIAL and COLOR with the same Excel file.

I created two packages (CPMB/IMPORT_MASTER)

• Package in order to upload MATERIAL : ID=*col(1)
• Package in order to upload COLOR: ID=*col(2)

Detail of Excel file

MATERIALCOLOR10000WHITE10001BLACK10002RED10003REDEtc.

I have no problems to upload the dimensions MATERIAL: single member

But I have the problem to upload the dimensions COLOR: BPC can’t duplicated the members like the color RED (error message)

NB : Source is Excel File and not IO of BW.

Target : In transformation file, BPC PCB should concatenate the color before the upload

COLORWHITEBLACKRED

Can you give me a workaround solution?

[former_member186338]

You can't upload master data from the text file with duplicated ID's - no way!

You have to process the original file to get only lines with unique ID's (colors) It can be done in VBA, VB script, etc...

Another option is to write routine badi that will perform processing in abap.

[wissler_bastien]

Yes I know, I transform the Excel file to Txt File

see the file attached : excel-file.txt

[former_member186338]

Sorry, but this is incorrect: "Source is Excel File and not IO of BW" - you can't use Excel file, only text import is allowed!

For the rest - please provide full info including full text of transformation file and data samples! Error screenshots, etc...