FB60 batch input from MS Excel file

[Former Member]

Dear experts,

We want to post regular acquisitions from appr. 200 vendors each month (amounts each month are different). We need to post different vendors to different cost centers, segments and other assignment elements/objects. I suppose that we need to use a batch input by importing a MS Excel spreadsheet, because software where we are tracking those payables makes export just into Excel. In SAP we have separate Vendors Master Data for all 200 vendors. Please help me to create batch input program for this monthly batch postings. How to define SAP field correspondence with Excel cells, and etc.?

(P.S. I’m quite new in batch input functionalities…)

[Former Member]

Hi,

You can use SCAT for recording of transaction for uploading purpose., which is very easy and it will not include much technicality.

Assign points for wonderful idea.

Regards.

[Former Member]

Thank you both for response, but could you provide more details about this, i.e. main and most important steps where and how to create excel file structure, and how to link data import process to particular SAP program or transaction?

I tried to use LSMW, but it was unclear for me where to define excel file structure and link to transaction FB60 or FB01?

Also how to use BAPIs or IDOCs as alternative methods?

Thanks

[Former Member]

Hi Marius,

I am facing the same challenges with you as I needed to upload legacy data into SAP using the transaction FB60 - Invoice verification system . I have tried SCAT and SM35 without any success and presently created a ticket with SAP market place to resolve this problem hoping they will respond on time.

FB01 was suggested from SAP notes but Vendor ID field is not on the FB01 screen and the PST key field is not accepting 31 as 'credit'.

Have you receive any detail responds for using LSMW with BAPI or IDOCs. Please if you do, I will like you to share it with me. Incase there is solution from the SAP I can also mail you there comments and solution.

You can mail me on this e-mail address: stephenomo@gmail.com

Thanks

[Former Member]

Hi Stephen,

I still not have any responds using LSMW. I tried to use for this <i>Standard Batch/Direct Input Object</i> - <b><i>0100 Financial Documents</i></b> but this object allows to use just t.code FB01, and as you mentioned in your previous message, there no choices to assign Vendor ID field, or Posting Key field. So this option did not pass to me too. Then I found t.code SHDB, maybe it is quite complicated process, but for me it works and I have posted invoices from my 200 vendors. I just convert my data within excel spreadsheet in appropriate manner (rows must be transposed to columns), save it in .txt file and import to SAP within SHDB, and push the button <i>Process</i>. First few times system gave me errors, but there were inaccuracies in .txt file, after little corrections everything started to work.

I am not sure if t.code SHDB will work for you, because you need to upload your legacy and not current data, but you could try.

[Former Member]

You could also use transaction LSMW. By using this transaction you could use excel files, plain text, etc..

Hope it help

Regards

[Former Member]

Hi,

It is better to use FB01 for this. You have only to use posting keys.

For creating the transaction you can use IDOC's or an ABAP with BAPI's (or transfer direct to the screens).

The best is that the external system create a file and that you read in this file directly in SAP.

Paul