1 / 19

19 Data import

19 Data import.

gregorygarrett
Download Presentation

19 Data import

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 19 Data import

  2. This documentation and training is provided to you by beas group AG. The documents are neither approved nor in any way acknowledged or endorsed by SAP. For SAP Business One, only the documentation and training officially released by SAP shall be binding upon SAP. SAP shall not be responsible for any content of this documentation and training and this documentation and training shall not be binding upon SAP in any way. The official current SAP Business One documentation and training for SAP Business One is available at http://service.sap.com/sbocustomer/documentation and http://service.sap.com/sbocustomer/training.

  3. Requirements for this Tutorial What you should successfully master • The basics of SAP • The basics of be.as, knowledge of data structure • Basics of SQL

  4. Learning Targets After working through the lesson, you will be able to: • Import and convert databases • Adjust databases

  5. Agenda Data import 1: General 2: Working with the import program 3: Step by step

  6. Data importWhich program? DTW (by SAP) Standard-SAP-Tables + UDF + UDT Be.as – Import - Program Be.as- andowntables Be.as – Script, suitableforiterationsandcompleximporttasks

  7. Data import The be.as import - program • Advantages: • Full integration in be.as • Many functions for import and conversion • Data source can be converted and processed after import,useful for multiple imports • Disadvantages: • No accuracy check of the imported data

  8. Data importGeneral structure of the process Data source Data target Filter + Conversion Assignment

  9. Data importData source Every ODBC- capabledatabase Anytextfile NO Excel-files! Current database Tablesfrom be.as and SAP

  10. Data importData target Complexandhazardous Interface: Manuallydefined sourcefile Completeand simple Interfaces for Resource Operation Item Routing Bill of Materials Customers Addresses ContactPersons Prices Warehouse Attendance

  11. Agenda Data import 1: General 2: Working with the import program 3: Step by step

  12. Data importImport definition target source Additional source defition Assigment of source fields to target fields

  13. Data importImport from text file

  14. Data import Import from data base

  15. Data import Field assignment ag_id 123-<ag_id> Select ‘123‘-‘<ag_id>‘ select case when x=y then ‘<Ag_id>‘ else ‘ <ag2_id>‘ end

  16. Data importManually define target

  17. Data importPerforming the import

  18. Summary You can now: • Import and convert databases • Adjust databases

  19. Thank you for your cooperation!

More Related