?
Solved

SAP Import

Posted on 2011-03-16
10
Medium Priority
?
948 Views
Last Modified: 2013-12-08
We're currently in the onset of SAP implementation and we're preparing for the Data import into the SAP system.  We currently have MAS200.  Here's the question and hopefully anybody knows MAS200 and SAP, do I need to have technical expertise in MAS200's backend just to generate inputs to SAP?  What we don't know is what SAP implementation vendors will ask us during data migration.  Is it possible that we will just rely on the MAS200's report capabilities and just generate reports and export to a format acceptable to SAP or do we need to do a lot of ODBC connection to MAS (since it's a file based system not SQL)?

We want to predict and foresee right now what level of knowledge do we need from MAS200 just to provide the right output that will serve as input to the SAP system.  Anyone out there who has experienced exporting from MAS200 / 90 to SAP?
0
Comment
Question by:Vachik
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 5

Expert Comment

by:SageMas90_200guy
ID: 35160061
Unless your SAP Provider has a routine specific to pulling your data out of Mas90/200, I'm thinking that the odbc connection thru Access or Excel will be your best bet.  Your SAP Vendor should be able to provide you with the mapping to thier System for these data items.    Usually, Static Data first, Customers, Vendors, Chart of Accounts, Inventory Items, Users and Security. These can all be done with plenty of lead time to going live on your new system.  Then, just before go live, Unpaid AR and AP invoices, Open Orders and Quotes.   You will probably have a discussion with your Vendors implementation team about History.. etc.  
0
 

Author Comment

by:Vachik
ID: 35160171
Mapping of MAS200 vs SAP is out of the picture in our contract.  What's going to happen is they will provide templates of what they want for SAP import and it'll be our (IT and Business) side to provide the equivalent.

Ok, so when you meant static data, can we safely say that these can easily be generated in the Front End of MAS rather than connecting to the back-end?  Can we generate thru reports or report exports (like excel) most of the aspects of an accounting system?  Does it have like a report creator where we choose the fields and click a button and just generate the report?

Thanks.

0
 

Author Comment

by:Vachik
ID: 35160210
By the way, the difficulty in accessing the backend is that most of the fields are archaic and difficult to know which is which.  Definitely, the field names in the backend does not directly correlate with the front-end's definitions (example: invoice might not be invoice in the field name at the back-end).  We were actually able to get from Sage Data Dictionary but it's just overwhelming since there's a lot of "tables" (actually files) that you need to logically define & connect just to derive data from possible import needs of SAP.
0
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 
LVL 5

Expert Comment

by:SageMas90_200guy
ID: 35160286
Although possible, with reports, most of the canned reports do not translate well when it comes to status flags.  So, in the long run, it would be a more efficient process to utilize the odbc connectivity to download every data item in the file, and change the file to match the SAP import template.  To possibly ease the temptation to stress over this, you may want to aquire, say, a customer import template from the SAP Vendor, and then walk yourself through it.  You may even consider hiring someone familiar with the MAS90 Data File Structure to assist you in this process.  
0
 
LVL 5

Expert Comment

by:SageMas90_200guy
ID: 35160324
What version of MAS90/200 are we chatting about  please.
0
 

Author Comment

by:Vachik
ID: 35160329
I think everything you said make sense.  Just one more set of questions before I award the points.  Can you provide examples of status flags that might not get exported or generated using reports?  Or can I generate a report where the status flag is the main criteria?  For Example : Report of all invoices that are "unpaid" where "unpaid" is the flag (just assuming).  Do you think this is possible?
0
 

Author Comment

by:Vachik
ID: 35160385
MAS 200 Version 4.3  (non-SQL)
0
 
LVL 5

Accepted Solution

by:
SageMas90_200guy earned 2000 total points
ID: 35160568
In the case of open invoices, they are all retained in an AR_OpenInvoice.m4t File until paid, so thats pretty simple.  Static data contains relationship flags.  Customers for Example, have terms codes attached to them.  Suppose the code on the customer is Actually 01, when the system looks at the AR_TermsCode.m4t File, it sees 01, and then prints NET 10 Days.  Customer Number,  If you use divisions, the division number is available for you to see.  If you do not, it still exsists, ie  every customer number starts with a 00, but the user just can not see it, nor does it print.  It will however export throug odbc.
0
 

Author Comment

by:Vachik
ID: 35160579
Thank you.
0
 
LVL 5

Expert Comment

by:SageMas90_200guy
ID: 35161595
You are very welcome,

kevin@reedcg.com
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
Note: You must have administrative privileges in order to create/edit Roles. Salesforce.com (http://www.salesforce.com/) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales and marke…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month9 days, 13 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question