Data Transfer Workbench

[Former Member]

I have a problem. I donu2019t know how to get data in Sap business one after import by data transfer workbench, anyone show to me the way ,pls.

Thank !

Edited by: binhtt1988 on Jul 19, 2011 10:48 AM

[Former Member]

Hi............

Bit confusing.....

What is

How to get the data in SAP Business One after Data Transfer

?

When you import data through DTW and when you check in SAP which data you have imported just go to that module and check....

Say if you imported Item Master Data then if you want to know the table name where you get the data then it is OITM,

For Business Partner Master Data it is OCRD.

Like wise you can query and find teh data in SQL.

The best way to know the table name is Login to SAP and go to View in Menu Bar and enable System Information.

Now just open any of the form and move and hold cursor to any of the field you get the Table name, Field Name at teh left bottom of SAP Screen......

Hope this is helpful for you...........

Regards,

rahul

[Former Member]

Thank Ruhul so much.

I imported list(code, name ,Production order, quanlity) production order to issue by DTW, and go to modul -> production -> issue for production, I want press shift+F2 to load data to issue production order.

Issue production include (Production order, Row no,Item code, Item description,Quantity,where house)

show me the way. pls

Thanks so much.

Edited by: binhtt1988 on Jul 19, 2011 12:19 PM

[Former Member]

Hi,

Shift+F2 is for Formatted Search. Please clarify if you need FMS. If not, your DTW may not be successful because the Production Order should be available to issue without keying anything.

Sounds like you are DTW UDT only. In that case, FMS is needed from Issue production order screen to add UDT data.

Thanks,

Gordon

[Former Member]

Thanks Gordon !

Difficult show to you . but I have seen my friends did it, but he don't say to me how to do it.

after import data by DTW to issue production go to issue for Production in B1 , and press shift + F2 , list Production will be show. It include all material in Production order.

Transfer material same .

Thanks and best regards

Binh Tran

[Former Member]

Hi............

Bit confusing.....

What is

How to get the data in SAP Business One after Data Transfer

?

When you import data through DTW and when you check in SAP which data you have imported just go to that module and check....

Say if you imported Item Master Data then if you want to know the table name where you get the data then it is OITM,

For Business Partner Master Data it is OCRD.

Like wise you can query and find teh data in SQL.

The best way to know the table name is Login to SAP and go to View in Menu Bar and enable System Information.

Now just open any of the form and move and hold cursor to any of the field you get the Table name, Field Name at teh left bottom of SAP Screen......

Hope this is helpful for you...........

Regards,

rahul

[Former Member]

Hi............

Bit confusing.....

What is

How to get the data in SAP Business One after Data Transfer

?

When you import data through DTW and when you check in SAP which data you have imported just go to that module and check....

Say if you imported Item Master Data then if you want to know the table name where you get the data then it is OITM,

For Business Partner Master Data it is OCRD.

Like wise you can query and find teh data in SQL.

The best way to know the table name is Login to SAP and go to View in Menu Bar and enable System Information.

Now just open any of the form and move and hold cursor to any of the field you get the Table name, Field Name at teh left bottom of SAP Screen......

Hope this is helpful for you...........

Regards,

rahul