Closing Sales Order through DTW

[Former Member]

I want to close Sales Order using DTW, because the are a lot of open sales orders and is to much work to do it manually. I would do a query to the SBO DB to get the fields into the template. What fields would be needed to do it???

[former_member187989 · Accepted solution]

hector,

good question.

You can raise a ticket to

SAP in service market

place before procedding

further with closing of

sales order.

Hope it will solve the

problem.

Jeyakanthan

[Former Member]

I have a query that selects the SO that need to be closed. i want to be able to close these SO. Any idea how to do it in batch??

[former_member583013]

Hector,

DTW is primarily for importing data into SAP. It cannot be used for Cancelling / Closing documents.

Suda

[Former Member]

Hi,

Since you want to use DTW, I understand that you know which SO to close.

If yes, you can use scripting... Or B1TCH (from the SDN). This will give you access to all (nearly) the DI-API and you can do what you want.

Regards,

Eric

[Former Member]

Hi Hector,

That is not possible by current DTW since once you manually close your open SO, there are some transactions based on your action should be triggered. It will be very very difficult to achieve that by just updating your SO table directly.

Thanks,

Gordon