SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Regional Structure Update from Canada Post file

Former Member
0 Kudos
172

Hi Experts,

Is anyone aware of the regional structure update process using the Canada Post files. I would require the LSMW and process details to convert the Canada Post files into the RSADRLSM02 file format so that the most updated regional structure elements from Canada Post are loaded into SAP.

Thanks and much appreciated

Raj

2 REPLIES 2

AmlanBanerjee
Active Contributor
0 Kudos
116

Hi Raj,

As far my knowledge goes, Canada Post doesn't issue delta files and SAP Database tables do not allow the re-loading of the entire file due to primary key issues leading to a duplicate entry error.

Is this what you are currently facing?

Moreover, if you are looking for the LSM Workbench mapping for the report RSADRLSM02 against the Canda Post file, then you have a look at the SAP Note 785749. Its an old note but contains different tips that could be helpful for mapping the external file with LSMW.

Hope it helps.

Thanks,

Amlan 

0 Kudos
116

Thanks Amlan for the response.

I am at the initial stage of filling the RSG elements city,street,post codes for the first time based on Canada Post file. How did you deal with the Canada Post initial upload and Canada Post Delta upload.

Regards,

Raj