PIPE issue_Unknown Material Error

[Former Member]

Hi,

We have a situation, where there are multiple transactions failure for a store with mu7ltiple dates. This happened as the TLOG was prepared manually, with the EAN numbers instead of the material number. Hence we are getting the error of Unknown Material.

Is there a way to rectify all such erroneous transactions in mass by replacing the EAN numbner by the exact material number.

*** Sending another TLOG with proper data is not possible

[Former Member · Accepted solution]

Hi Nimo,

Hey you are having various options to rectify your error. You know
that the Material/EAN error comes when that Material/EAN is not updated in BW Master
Data DSO(Data Source Object).

There are couples of things you can do for your query.

1. You can manually maintain/update EAN/Material number by going
   into

TCODE -> RSA1 then find 0RPA_MEAN and Right Click & select Maintain Master Data and
update the correct EAN/Material Number against the required Materials then you
have Click on Activate Mater Data.

After this you master data will
be updated then go to workbench and select all transaction for the store for
the day and re-process. All your Errors will be resolve.

1. You can replace/correct/edit EAN numbers by going into
   transaction one by one if the EAN/Material Numbers are different in each
   transaction by going into transaction one by one and click on Edit button and
   then change the required EAN then Save and Reprocess the transaction.
2. If the EAN/Material Number is same in all transactions then you
   can replace in mass day by day. For this you have to go to workbench into store
   for the day then select all transactions then go to option Mass Change (POS Data) then you have to select Sales Item Data
   & Article Identifier/Material Number then you can give required Material
   Number and replace.
3. If
   you want to replay the same TLOG File by correcting all required Materials/EAN,
   this also you can do, but for this you have follow the method mentioned below, but this is Not the correct Process just
   and alternate way.

You can simply edit all Transaction Numbers (Like original
Transaction Number was 1234001 then you can change it to 1234001_1) into TLOG File
and correct all Material/EAN then Replay the same TLOG.

Again if there is a TLOG file name Validation is there then you
have to change the TLOG file Name As well by adding any character.

Hope this can solve your issue.

BR

Anup Mishra

[Former Member]

Hi Anup,

Is there a way for mass change.

TLOG file rectification will not work as the sales were made before POS initialization, by manual EAN number and price processing.

[Former Member]

Hi Sudip,

As already Mentioned the mass change is possible in wokbench if all transaction are having the same Article/EAN that need to be changed. But if transactons are having different-2 EAN/Materials then you have to do one by one.

see the below mentioned steps for both case

• 1 -You can replace/correct/edit EAN numbers by going into
  transaction one by one if the EAN/Material Numbers are different in each
  transaction by going into transaction one by one and click on Edit button and
  then change the required EAN then Save and Reprocess the transaction.
• 2- If the EAN/Material Number is same in all transactions then you
  can replace in mass day by day. For this you have to go to workbench into store
  for the day then select all transactions then go to option Mass Change (POS Data) then you have to select Sales Item Data
  & Article Identifier/Material Number then you can give required Material
  Number and replace.

BR

Anup

[Former Member]

Thanks Anup for your inputs. But we have multiple EAN numbers.

[Former Member]

Hi Nimo,

You have to bulid a customize program if we want to change mutiple EAN's  at one go.

POSDM workbench  mass change functionality supports  only one EAN change at a time.

Regards,

Ramki