如何将数据导入SAP [英] How to import data to SAP

问题描述

作为SAP的一个陌生人，我想将自己的应用程序(移动销售人员自动化)数据传输到SAP.我的应用程序具有客户，库存，库存，发票(和运单)，支票，付款，收款，库存转移数据等的记录.我还有一个附加数据库，用于保存记录的匹配项. IE.我的应用程序中具有ID 345的客户在SAP中具有密钥120-035-0223.当然，每条记录都必须知道对应的记录，包括参数.

As a complete stranger in town of SAP, I want to transfer my own application's (mobile salesforce automation) data to SAP. My application has records of customers, stocks, inventory, invoices (and waybills), cheques, payments, collections, stock transfer data etc. I have an additional database which holds matchings of records. ie. A customer with ID 345 in my application has key 120-035-0223 in SAP. Every record, for sure, has to know it's counterpart, including parameters.

在Google和SAP帮助网站上搜索了一天之后，我发现这比我想象的要痛苦得多.特别是SAP网站甚至没有提供任何线索.说我找不到.

After searching Google and SAP help site for a day, I covered that it's going to be a bit more pain than I expected. Especially SAP site does not give even a clue on it. Say I couldn't find.

我们将数据传输到其他一些ERP系统，其中一些需要XML文件，另一些则公开了它们的API.

We transferred our data to some other ERP systems, some of which wanted XML files, some other exposed their APIs.

我的意思是，我是否可以选择Sql Server的SSIS?我希望是这样，所以我可以在自己的领土上战斗.由于客户的要求差异很大，因此我将灵活性视为最重要的标准.另外，我想传输尽可能多的数据.

My point is, is Sql Server's SSIS an option for me? I hope it is, so I can fight on my own territory. Since client requests would vary a lot, I count flexibility as most important criteria. Also, I want to transfer as much data as I could.

感谢您的帮助.

推荐答案

过去十几次迁移中的一些建议使我参与其中:

Some advice from the past dozen migrations or so I was involved in:

• 请勿尝试绕过SAP系统并直接导入到SAP数据库中.甚至不用考虑它.如果出现任何问题，则说明您已经粉碎了一个生产系统，而您正是受到指责的人.

• Do NOT try to bypass the SAP system and import into the SAP database directly. Don't even think of it. If anything goes wrong, you have shredded a production system - and you're the one who's getting the blame.

确定您是要迁移类型的方案(单次传输)还是永久接口(每n分钟/小时/天传输一次).这产生了巨大的差异(例如:在迁移方案中，您通常不必担心一遍又一遍地更新相同的记录-在永久性界面中，您将不得不照顾这一点).如果以后需要更改决定，通常必须从头开始.

Decide whether you want a migration-type scenario (a single transfer) or a permanent interface (transfer every n minutes/hours/days). This makes a huge difference (for example: in migration scenarios you'll usually won't have to worry about updating the same record over and over again - in a permanent interface, you'll have to take care of this). If you have to change your decision later on, you'll usually have to start from scratch.

让某人知道所涉及的SAP模块以及该模块在系统中的自定义和使用方式.您可能需要各种专家-对模块有深入了解的顾问，以及对实际数据的输入和使用方式有详细了解的关键用户.

Get someone who knows both the SAP module involved and the way the module is customized and used in your system. You might need various experts - a consultant with in-depth knowledge of the module and a key user with detailed knowledge about the way the actual data is entered and used.

使自己熟悉所涉及的数据字典结构.您将需要这些知识来将输入数据正确映射到SAP结构.

Make yourself familiar with the data dictionary structures involved. You'll need this knowledge to correctly map your input data to the SAP structures.

是否有任何可用的接口，请教专家.如果有的话，专家应该能够告诉您更多有关它，包括文档.如果没有，则必须自己创建一些东西.

Ask the expert if there are any interfaces available. If there are, then the expert should be able to tell you more about it, including documentation. If there aren't any, you'll have to create something yourself.

对于迁移方案，n:与关键用户手动输入代表记录，以确保您覆盖了所有详细信息(哪些字段内容在SAP系统中位于何处?我们是否拥有全部的所有数据必填字段?).在许多情况下，您可以使用事务记录器(SHDB)来跟踪您输入的内容，尤其是技术领域的名称.

For a migration scenarion: Perform a manual entry of representative records with a key user to make sure you have all of the details covered (Which field contents go where in the SAP system? Do we have all data for all of the required fields?). In many cases, you can use the transaction recorder (SHDB) to keep track of what you entered and especially of the technical field names.

看看旧版系统迁移工作台(LSMW).首先，它可能看起来有些复杂，但是它是用于许多目的的出色工具.

Take a look at the Legacy Systems Migration Workbench (LSMW). It might seem a bit complicated first, but it's a great tool for many purposes.

一如既往，YMMV.哦-准备学习ABAP.您至少应该能够阅读它，了解正在发生的事情并逐步调试程序中的程序，否则事情将变得非常令人沮丧.

As always, YMMV. Oh, and - be prepared to learn ABAP. You should at least be able to read it, understand what's going on and step through programs in the debugger, otherwise things will get very frustrating.

这篇关于如何将数据导入SAP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！