您好,欢迎来到我们的官网!国内最权威、最专业的SAP Business One平台!

在线咨询 | 联系我们 | 关于我们

更多 选择理由
选择SAP Business One的十大理由: 1、领导地位:SAP是全世界ERP领域的领导者,值得信赖。 2、完备性:SAP为中小企业提供全面的信息化解决方案。 3、多样性选择:您可购买、或在云端租用SAP Business One。 4、行业知识:SAP顾问具备丰富的行业经验和管理经验。 5、快速实施:快速上线,数周之内看到成效。 6、洞察力:SAP Business One具备强大的报表分析能力。 7、创新:SAP Business One具有强……

最新资讯

    SAP Business One:DTW示例
    浏览次数:168  发布时间:2018-8-22 16:47:41 




    一.登录
    DTW



    1.登录SBO_DTW


    使用DTW前必须安装DTW模块(客户端也可单独安装DTW进行数据导入),程序文件安装包在.. \Packages\Data Transfer Workbench中。


    如下图所示登录。




                  




    2.       配置登录服务器




                                  



    第一次登录时需要配置数据导入的服务器。



    点击右上角   (更改登录服务器)




                           




    服务器验证成功后列表中会列示出服务器中的SBO数据库

    选择某一公司库,输入SBO用户名及密码登录


    3.       登录成功后在操作界面状态栏会显示出当前连接服务器及SBO数据库版本信息。

     



                 




    二.     整理数据导入格式



    1.      以下以导入物料主数据为例,详细介绍DTW的使用。


    2.      在登录DTW窗口中有三个选项,   分别是:DTW,说明文档,模板。



    3. 点击打开 Templates,此文件夹包括两个文件夹,分别为:Data preparation examples(示例)及Templates(模板),其中示例文档是整理好的导入示例文件。


    4. 依次打开Templates\Templates\Inventory\Item Master Data \OITM - Items.xlt


    5. OITM - Items.xlt中包含了对应版本的OITM表中所有字段(除自定义字段外),在整理时可以把不导入数据的列给删除或者留空。

    注:

          1) OITM导入格式里部分字段的值只能是固定的格式,如 SaleItem值在导入时只能是注释中的 tYES或者tNO ,而不是系统表里记录的Y或者N。



              



    2)       物料组里的值只能是后台数据库的实际值(100101…),而不能是前端看到的 物料组名称。

    3)       文档中第一行是此字段的数据库的详细描述,第二行是此字段在系统表里的列名。

     


    6.      整理后的OITM 导入结果如下。







    7.      对此文档另存为.CSV格式,也可以保存为TXT格式。



    三.     导入整理后的数据



    1.      登录DTW

    2.      点击 Import



         

                    




    3.      导入物料主数据时此处选择 第二项(附录中会列示出各凭证及数据导入时所选择项)



                 

                    



    4.   

                   



                    




    5.     


     


                    



    6.     




                    



    7.     




                    



    8.  

                   



                    

       

      


    9.      预览要导入的数据



                   

                    



    10.  

                  



                    



    11.  

                  



                    




    12.   此处可以详细查看出错原因。



                   

                    




    附录一:Data Type





                                            

    bject Name Object Type
    A/P Credit Memo Transactional Data
    A/P Down Payment Transactional Data
    A/P Invoice Transactional Data
    A/R Credit Memo Transactional Data
    A/R Down Payment Transactional Data
    A/R Invoice Transactional Data
    Account Segmentation Setup Data
    Account Segmentation Categories Setup Data
    Activity Transactional Data
    Activity Locations Setup Data
    Activity Status Setup Data
    Activity Types Setup Data
    Additional Expenses Setup Data
    Attachments2 Setup Data
    Bank Pages Transactional Data
    Banks Setup Data
    Bill of Exchange Transactions Transactional Data
    Bill of Materials Transactional Data
    BPFiscalRegistryID Setup Data
    Branches Setup Data
    Budget Transactional Data
    Budget Distribution Transactional Data
    Budget Scenarios Transactional Data
    Business Partner Catalog Numbers Transactional Data
    Business Partner Groups Setup Data
    Business Partner Master Data Master Data
    Business Partner Priorities Setup Data
    Business Partner Properties Setup Data
    BusinessPlaces Setup Data
    Cash Discount Setup Data
    Chart of Accounts Master Data
    Checks for Payment Transactional Data
    Choose From List Setup Data
    ClosingDateProcedure Setup Data
    Commission Groups Setup Data
    Contract Templates Setup Data
    Correction Invoice Transactional Data
    Correction Invoice Reversal Transactional Data
    Correction Purchase Invoice Transactional Data
    Correction Purchase Invoice Reversal Transactional Data
    Credit Card Payment Setup Data
    Credit Card Payment Methods Setup Data
    Credit Cards Setup Data
    Currencies Setup Data
    Customer Equipment Card Master Data
    Customs Groups Setup Data
    Deduction Tax Groups Setup Data
    Deduction Tax Hierarchies Setup Data
    Delivery Transactional Data
    Departments Setup Data
    Dimensions Setup Data
    Discount Groups Setup Data
    Distribution Rules Setup Data
    Draft Transactional Data
    Dunning Letters Setup Data
    Dunning Terms Setup Data
    Dynamic System Strings Setup Data
    Employee Master Data Master Data
    Employee Roles Setup Data
    Exchange Rates and Indexes Setup Data
    Factoring Indicators Setup Data
    Formatted Searches Setup Data
    Forms 1099 Setup Data
    Goods Issue Transactional Data
    Goods Receipt Transactional Data
    Goods Receipt PO Transactional Data
    Goods Return Transactional Data
    House Bank Accounts Setup Data
    Incoming Payments Transactional Data
    Industries Setup Data
    Inventory Cycles Setup Data
    Inventory Posting Transactional Data
    Inventory Revaluation Setup Data
    Inventory Transfer Transactional Data
    Item Groups Setup Data
    Item Master Data Master Data
    Item Properties Setup Data
    Journal Entry Transactional Data
    Journal Vouchers Transactional Data
    Knowledgebase Solutions Master Data
    Landed Costs Setup Data
    Length and Width UoM Setup Data
    Manufacturers Setup Data
    Message Transactional Data
    MultiLanguageTranslations Setup Data
    Outgoing Payments Transactional Data
    Packages Types Setup Data
    Payment Methods Setup Data
    Payment Terms Types Setup Data
    PaymentRunExport Setup Data
    Payments Drafts Transactional Data
    Pick List Setup Data
    Predefined Text Setup Data
    Price Lists Setup Data
    Production Orders Transactional Data
    Profit Centers Setup Data
    Projects Setup Data
    Purchase Order Transactional Data
    Purchase Tax Invoice Transactional Data
    Query Categories Transactional Data
    Queues Setup Data
    Relationships Setup Data
    Return Transactional Data
    Sales Employees Setup Data
    Sales Forecast Transactional Data
    Sales Opportunities Transactional Data
    Sales Opportunity Competitors Setup Data
    Sales Opportunity Interests Setup Data
    Sales Opportunity Reasons Setup Data
    Sales Opportunity Sources Setup Data
    Sales Order Transactional Data
    Sales Quotation Transactional Data
    Sales Stages Setup Data
    Sales Tax Authorities Setup Data
    Sales Tax Authorities Types Setup Data
    Sales Tax Codes Setup Data
    Service Call Transactional Data
    Service Call Origins Setup Data
    Service Call Problem Types Setup Data
    Service Call Solution Status Setup Data
    Service Call Status Setup Data
    Service Call Types Setup Data
    Service Contract Master Data
    Shipping Types Setup Data
    Special Prices for Business Partners Setup Data
    States Setup Data
    StockTransferDraft Setup Data
    Tax Groups Setup Data
    Tax Invoice Setup Data
    Teams Master Data
    Territories Setup Data
    User Default Groups Setup Data
    User Languages Setup Data
    User Permission Tree Setup Data
    User Queries Setup Data
    UserFieldsMD Setup Data
    UserKeysMD Setup Data
    UserObjectsMD Setup Data
    Users Setup Data
    UserTablesMD Setup Data
    Warehouse Locations Setup Data
    Warehouses Setup Data
    Weight UoM Setup Data
    Withholding Tax Setup Data
    Work Order Transactional Data



                                           


     

    标签:SAP Business One ;DTW模块;服务器;配置数据;SBO数据库;物料主数据;

联系我们

客户服务(工作日9:00-22:00) 商务合作(工作日9:00-18:00)

客服电话:021-58355495
更多联系方式

商务QQ:94508526 59949799
商务电话:021-58355496 021-58353850