Errors while data loading...!!!

[Former Member]

Hi BW Experts,

How is it possible to correct errors in PSA. Even if it is corrected, what happens when in future full update is needed to be done. Does correcting error data at PSA means to correct it in the source system also, say like a flatfile.

Please shed as much light as possible on this topic for me.

Thanks in Advance.

Regards,

Giftedbrain.

[Former Member · Accepted solution]

Hi Gifted Brain,

In that case, as a BW consultant, you cant do much about it. The reason is, you may not be aware from where the data in the oracle or sybase or flat file is created and you wont be aware of the business processes that create records there.

Discussions needs to be done with the team that is responsible for creating the flat files, to check and arrive at a solution.

Hope this helps.

• You may assign points if this or any of my previous postings helped you... ***

Thanks,

Raj

[Former Member · Accepted solution]

Brain,

You should know where the data is lying in the Source System. we shouldn't not change the data in the source system.

Suppose let us take one example, we have one extract in the SAP, which delivering CSV file. If there is any ',' in the output before moving to CSV, automatically next coloumn will be called.

let take while creating Sales Order, user entered PO number as 'FGH123465,0010'. Then in the output file i could see 2 coloumns instead of 1 coloumn for PO number... one with FGH123465 next with '0010'. This is User mistake. they don't know about this ','. We need to ask the user to change the value. We need to instruct them not to give ',' for the above case.

Developer shouldn't change any business data in source system. If every body approves, we can do that. That varies from company to company. depends on authorizations. i don't have authorization to VA01 and VA02 to change the Sales Orders.

All the best.

Regards,

Nagesh Ganisetti.