cancel
Showing results for 
Search instead for 
Did you mean: 

can i add inventory onhand via DTW or excel import?

former_member392795
Participant
0 Kudos

Dear Gurus

Please guide me is there any way i can upload Inventory quantities onhand via DTW temp or import from excel?

Regards

Ghufran

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Ghufran,

In addition to the above details given by kamba dasan if your items are batch managed you might need OBTN and BTN1 templates as well.

Regards,

Rupesh

KennedyT21
Active Contributor
0 Kudos

Hi GHufron...

check this thread

Rgds

former_member392795
Participant
0 Kudos

I am using 8.82 PL4 and i can not find any such option in dtw or the folder which u mention .

Former Member
0 Kudos

Hi

Search for the templates in the directory where you have installed DTW?

you can find the options in DTW.

Please refer below screen.you can select goods receipt only if you set the data type as 'Transactional Data'

Former Member
0 Kudos

HI Ghufran

There are certain documents which can be uploaded by DTW to increase the onhand quantity

They are:

1.Goods Receipt

2.Inventory Posting

3.Inventory Transfer(moving onhand quantity between one warehouse to another)

you can find these templates in:

C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\Inventory\Inventory Transactions\Goods Receipt

You can also watch out the samples to know how to fill up data in these templates