Archive for the ‘SAP’ Category

Download SAP R/3 Ruby Cheat Sheet

Saturday, November 15th, 2008


Ruby is a reflective, object-oriented programming language. It combines syntax inspired by Perl with Smalltalk-like object-oriented features, and also shares some features with Python, Lisp, Dylan and CLU. Ruby is a single-pass interpreted language. Its main implementation is free software distributed under an open-source license.

The language was created by Yukihiro “Matz” Matsumoto, who started working on Ruby on February 24, 1993, and released it to the public in 1995. “Ruby” was named after a colleague’s birthstone. As of June 2006, the latest stable version is 1.8.4. Ruby 1.9 (with some major changes) is also in development.

Ruby on Rails is a full-stack framework for developing database-backed web applications according to the Model-View-Control pattern. From the Ajax in the view, to the request and response in the controller, to the domain model wrapping the database, Rails gives you a pure-Ruby development environment. To go live, all you need to add is a database and a web server. Ruby on Rails was created by David Heinemeier Hansson. “Rails”, “Ruby on Rails”, and the Rails logo are trademarks of David Heinemeier Hansson. All rights reserved.

Download

Popularity: 20% [?]

Download SAP Security Checklist

Saturday, November 15th, 2008

2 Security and access protection
2.1 Objective
An access protection system and the ability to grant individual authorizations basically serves four purposes:
- To protect confidential data against unauthorized disclosure
- To protect the data against unauthorized, but also against unintentional, changes or deletion
- To facilitate the transparency of the procedures by tracing exactly who did what in the system, and when.
- To guarantee that applications can be audited.

According to commercial law, these measures (i.e. preemptive controls in the internal control system) should prevent violations of any legal restrictions on the erasure of electronically stored data. They should also guarantee legally required audit trail traceability and ensure that no violations against complete and orderly accounting occur. These measures ensure, then, that no data which is unauthorized, incomplete, incorrect, or posted to the wrong period or account is entered into the system.

2.2 Requirements
The access protection system must ensure that only authorized individuals have access to the system and to particular data. It must be possible to key in the corresponding codes (passwords) without others being able to see them. The system should ensure that:
- only passwords of a defined minimum length are accepted,
- certain sequences of characters that could be easily guessed are not accepted,
- the password may be defined and altered by the user only,
- the system automatically demands the password to be changed at defined intervals,
- passwords are protected against being divulged to anyone other than the user him/herself. (more…)

Popularity: 28% [?]

Five tips for SAP R/3 ECC6 Upgrade

Tuesday, July 8th, 2008

1. The Cost of Logging
Some of you may already know that you can’t turn off [transaction] logging in db2 for z/os. Turning off transaction logging is an important part of the ECC upgrade process, and for good reason, since the upgrade process eats up a huge number of logs, and you seldom need to perform any kind of point in time recovery since the upgrade program can rerun each step.

In the SAP SERVICE MARKETPLACE you can find some information on the upgrade procedure’s requirements from the various servers and databases. Note 815203 will even tell you how much free space you require. But I haven’t found an official document that addresses the logins issue, so I guess there isn’t one. Anyway, what I’m trying to say is that my recent experience shows that upgrade from ECC5 to ECC6 generates around 500MB of transaction log data, and if you use dual logging it will add up to 1TB of data, so be prepared.

2. Profile Parameter Issues
a. Save your [old] instance and default profiles before the upgrade.
b. Save your [old] instance and default profiles before the upgrade.
c. Save your [old] instance and default profiles before the upgrade.
d. Save your [old] instance and default profiles before the upgrade.
e. Review the new profiles, make sure you haven’t lost important non-standard parameters, also note that some of the memory related parameters have changed, they are given default values , and this is probably not optimal for your system.
f. Review the shadow instance profile before the upgrade. At the very least consider adding the following parameters to it :
dbs/db2/use_wlm=1
dbs/db2/use_accounting = 1
(more…)

Popularity: 26% [?]

Quick References for SAP R/3 and Microsoft Office Integration

Sunday, July 6th, 2008

The following sections provide simple step-by-step instructions for executing many of the reporting processes just discussed. Use the following sections as a quick reference to speed you through each respective reporting process. And remember, if you need more information, refer to each process’s respective detailed sections provided earlier in this hour.

Quick Reference for Exporting Lists to Microsoft Excel
Quick Reference for Exporting SAP Query Reports to Excel
Quick Reference for Creating Form Letters with Microsoft Word
Quick Reference for Exporting Lists to Microsoft Access
Quick Reference for Exporting SAP Query Reports to Access


Quick Reference for Exporting Lists to Microsoft Excel


The following is a recap of the steps required to use the System List function to export SAP lists to Microsoft Excel.

  1. Navigate to the SAP screen containing the list you want to output.
  2. Follow the menu path System, List, Save, Local File.
  3. (more…)

Popularity: 20% [?]

How to use Microsoft Access Report Wizard to download SAP R/3 Data

Sunday, July 6th, 2008

Creating reports in Microsoft Access is easy using a tool called the Microsoft Access Report Wizard. The use of reports wizards simplifies the layout process of your fields by visually stepping you through a series of questions about the type of report that you want to create. The wizard walks you through the step-bystep creation of a report, while behind the scenes Access is formatting, grouping, and sorting your report based on selections you make.

Instead of having to create a report from scratch, Microsoft Access provides a number of standard report formats. Some of these, like tabular and columnar reports, mail-merge reports, and mailing label formats, lend themselves to meeting basic reporting requirements. Reports created using the Microsoft Access Report Wizard can also be customized to fit your needs. To use the Report Wizard, perform the following steps: (more…)

Popularity: 16% [?]