Skip to Content
author's profile photo Former Member
Former Member

Data Transfer Workbench - importing invoice text lines

my experience with DTW is limited, we are using SAP2004A with the latest patch.

I need to import Invoices to SAP using DTW and some of the source invoice lines contain line comments, They are long text and my client wishes to have them incorporated in to SAP as text type lines. I however could not see a way of doing this using DTW.

have I missed it somewhere? is this a shortcomming of DTW?

if so has anybody being able to perform this task in any other way?

any help is appreciated.

Thanks,

Indika.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 26, 2005 at 04:40 AM

    Hi there,

    Is it possible to store the invoices' comments in a user-defined field?

    If can, create a UDF for the marketing document - Row. In your excel spreadsheet which contain the Invoices, move invoices' comments column to User-Defined Field1, this is such a column in your excel spreadsheet if you use the DTW template.

    Then in DTW doing import, on step 4, under the row User-Defined Field1 in Source Field Column, select your Target Field to the UDF you had created in SBO. Finish the process. This way you will be able to import your comment into the UDF.

    If your client doesn't want to put into a UDF, you can always put it in the Free Text Column in your excel spreadsheet to import. By default, Free Text column won't appear. So, you have to go to DTW to maintain interface for Sales Invoices - Item Line 1 to add field.

    Or you want it to put under the Type:Text in Invoices for your Invoice Comment? This I only know using SDK or SQL query, DTW not very sure...

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.