Skip to Content
-1

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

Oct 26, 2016 at 03:56 PM

54

avatar image
Former Member

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?

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

3 Answers

Vadim Kalinin Oct 26, 2016 at 04:36 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Oct 26, 2016 at 04:17 PM
0

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...

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 26, 2016 at 04:23 PM
0

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

see the file attached : excel-file.txt


Share
10 |10000 characters needed characters left characters exceeded