Skip to Content
avatar image
Former Member

DTW Purchase Orders shows imported but nothing is there

This I have never seen.

When I import Purchase Orders through the DTW, I am told that everything imported correctly. When I go into SAP to check, nothing is there. It seems that nothing was imported.

I was able to import AP Invoices just fine (they were all service type invoices). The Purchase Orders I'm trying to import are Item type POs. I have to be missing something but I can't figure it out. I have included the item and the item description, the warehouse, set the type to "I". What am I missing?

Please help. Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 13, 2009 at 10:06 PM

    The Documenttype should be dDocument_Items for item type document.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Here is some sample data. The document contains the following:

      RecordKey CardCode DocDate DocDueDate DocTotal DocType NumAtCard TaxDate

      1 SFSI001 20070425 20070425 383662.2 dDocument_Items 01766 20070425

      2 CMR001 20070608 20070608 31057.4 dDocument_Items 01788 20070608

      3 RIGI001 20071130 20071130 550926.25 dDocument_Items 01871 20071130

      The Document Lines contains the following:

      RecordKey LineNum AccountCode ItemCode ItemDescription LineTotal Price ProjectCode Quantity WarehouseCode

      1 0 50200 EA Each 383662.2 1.03135 1001 372000 JC

      2 0 50200 LB LBS 21681.4 5.38 1004 4030 JC

      2 1 50200 LB LBS 9376 5.86 1004 1600 JC

      3 0 50200 SM Square Meter 503926.2466 24.61 1004 20476.483 JC

      3 1 50200 SM Square Meter 29000 2.9 1004 10000 JC

      3 2 50200 SM Square Meter 18000 3.6 1004 5000 JC

      There is a mixture of inventory and non-inventory items in my import.

  • avatar image
    Former Member
    Jul 13, 2009 at 11:11 PM

    Omit DocTotal, LineNum, LineTotal and AcctCode. Then try again.

    Your Item Codes and Descriptions look wrong to me. Double check them too.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I tried it every way possible. With LineNum, without. Test Run wasn't checked. I ran out of time. The client is now having to enter them manually. At least it's only about 40 purchase orders and 150 lines of data.

      This was really frustrating.

  • avatar image
    Former Member
    Jul 14, 2009 at 04:50 AM

    Hi Phil,

    Check at the time of import through DTW you checked the TEST RUN option in STEP 4 (Choose a Task).

    *Close the thread if issue solved.

    Regards

    Jambulingam.P

    Edited by: Jambulingam P on Jul 14, 2009 6:53 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 15, 2009 at 06:24 AM

    Hi Phil,

    Better Post a Message to SAP Support Center.

    Regards

    Jambulingam.P

    Add comment
    10|10000 characters needed characters exceeded