Recent Questions

Caio Jordão Calisto
[Email redacted]
Hi Jimbo.

First of all, thanks for all your efforts on maintain and share your knowledge regarding the LSWM and SAP Data connections. I'm writing you, and I don't know if it's too late for that, because recently I use your code to integrate ms access and SAP. This code was found in answer to an anonymous question, where you told that you didn't know if the RFC_READ_TABLE accepts more than one Option (Where condition). In fact, it accepts as part of the same string with the END Clause. So, I've updated your code and that's why i'm here, to share with you this update. Feel free to share in your website, if you want to.

I See two ways to improve this code: First, the login box should appear once allowing the programmer to process different tables without having to login again. And the second One, with the update of SAP GUI, the file SAPLogon.INI (Which is the file from where the login window of VBA pulls the information regarding the systems) is no longer used, and it was replaced by an XML file. I'll try to figure out a way to generate a login box with the updated file, and if I achieve it, i'll share with you.

Best Regards:
Caio

it is not possible to download the Jimbo's VBA Automation Toolbox.
Could you please advise. Kind Regard from swizerland Guido

I have got an urgent requirement in LSMW and it goes like this :
I have created an object for migrating Open Accounts payable items with which after this LSMW execution, LSMW will generate a Document Number(BELNR) internally.
1. I need to capture these document numbers created by SAP and display in a report [like so many documents got created (success records)].
2. This report has to be displayed after all the steps of LSMW are executed.

Hello,
Do you have any advice or best practice for uploading chinese character data? There seems to be a myriad of options for codesets and codepages in various places, but which combination works and is considered best practice?
Many Thanks in advance.
Nikki

Our company is doing a cutover to a new SAP. The system has the potential of being down for 3 to 16 days. I will be recording all of our packaged products. I plan on using Userforms that log all the information in excel sheets for my tech's to use while SAP is down. I know that i have to save the spreadsheets to TXT delimited before trying to use LSMW. My question is there any certain way i need to have the spreadsheet set up as far as format? I have never used LSMW before so it will be a learning experience to say the least. Any other information or direction would be appreciated.

Hi,
I am trying to use LSMW to transfer the balance of old cost centers to the new cost centers.
Can this be done with LSMW without any programming?
Our SAP System is ECC 6.0

Thanks in advance,
LITAU

I have a project that uses RMDATIND for direct input of material master records. My main source structure maps to BGR00, BMM00 and BMMH1. Other structures map to BMMH2, BMMH5 and BMMH6.

I make changes to the project in the development system (DEV) and transport the entire project to the Quality system (QA) for loading the data.

1. Using LSMW , XD01
want to test data, before loading with a RADIO button option to user.
a) 'Radio button' TEST -- To test for errors in data file
b) Display Error records in excel file

c) 'Radio button' Create customer
d) Display created records in excel file

2. How to avoid duplicate customers creation -- Internal number range.
e)Say if customer with "ex: check if KNA1-legacy number is existing, then don't commit the data, go to next record.

How to code these requirements in LSMW

I have some people in management telling us that we should push out the usage of this transaction to the business users. I disagree as this transaction is very powerful. Can you provide some guidance?

Mark