Skip to Content
author's profile photo
Former Member

FB60 batch input from MS Excel file

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…)

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Jul 30, 2007 at 12:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Jul 30, 2007 at 12:19 PM

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

    Hope it help

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Jul 31, 2007 at 07:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • author's profile photo
    Former Member
    Jul 31, 2007 at 08:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded