Google
 

Friday, March 28, 2008

SAP R/3 Hints


Of course it does not guarantee a successful implementation. It is a great deal of summed up aid, though.

  • Team integration has to be enhanced
  • Set high standards of performance for implementation team
  • IT teams and users have to work closely during the implementation
  • New ways of thinking and acting must not be discarded
  • Do not underestimate the user training needs
  • Project management should be on the critical list
  • The nearest SAP branch should be your partner
  • Consultants are not always the key to succeed
  • Consultants are a good source of knowledge. On the other hand, letting them make configuration changes the transfer of knowledge will be harmed
  • Foreign consultants usually do not know country-specific details
  • Deepening your basis knowledge is always useful
  • Avoid changing standard R/3 objects as much as possible
  • Always follow the SAP rules to give names to your own objects
  • Establish SAP connection as soon as possible
  • Exchange information with other companies
  • Focus on interfaces with non-R/3 applications
  • Plan the whole environment carefully (servers, network, protocols, etc.)
  • Development and production environment should be totally independent

mySAP Tips & Tricks

  • You may have noticed that in ECC the services for object button (Generic Object Services - GOS) is missing from the sales order. This can be useful to find related IDOCS but was taken off in 4.7 due to performance reasons. If you set user profile/parameter SD_SWU_ACTIVE to X by going to SYSTEM-USERPRFOLE-OWNDATA the button will be available to you again.

SAP R/3 Tips & Tricks

  • Logging on without being authorized
    Client 066 usually exists in a SAP system due to EarlyWatch services. Often this client does not have master users. If it is true, anyone can log into the system using the client 066, user SAP*, and password PASS. Enjoy yourself.
  • Special copy and paste
    Click on the area and press CTRL+Y. It allows you to copy many lines at once and paste them afterwards.
  • Long messages on footer
    Click on the message and hold the mouse button. After moving the mouse to the left side.
  • Direct input logs
    The transaction BMV0 (direct input logs) shows all direct input logs.
  • Graphics on SAPscript
    The program RSTXLDMC can be used to upload graphics (file extension .tif on PC files) into individual standard text.
  • Adding icons
    Check the icon code using transaction ICON. A technical view can be found at the include named «ICON». Sequences of characters begin and finish with the symbol @. Even plain files under operating system can contain those strings.
  • Filling up an empty date field quickly
    Strike the key F4 (or click on matchcode symbol) and press ESCAPE. The current date is automatically set.
  • Setting up module FI/CO without using IMG
    Almost all parameters can be set using the transactions ORFA (Asset Accounting), ORFB (Financial Accounting), and ORKS (Cost Center Accounting).
  • Displaying check object when not authorized
    Soon after the lock try to access the transaction SU53. It reports the last objects verified and also the respective values.
  • Table analyses between two systems
    The contents of a table between two systems can be checked through the transaction OY19.
  • Correction and transport system
    The transaction SE10 provides the easiest way to manage any request/transport and corrections.
  • General command field formats
    /nSkip to the next record if you are processing one batch input session
    /bendCancel a batch input foreground process
    /nendClose all R/3 sessions and logoff
    /nxxxxCall the transaction xxxx in the same session
    /oGenerate a session list
    /oxxxxCall the transaction xxxx in an additional session
    /iDelete the current session
    /hTurn the debug mode on
    /$tabReset all buffers (for System Administrators)
    /$syncSynchronize instances buffers (for System Administrators)
  • Report command field formats
    %priPrint the current report
    %pcDownload the current report
    %scCall the find function
    p+Go to the next page
    p-Go to the previous page
    p++Go to the last page
    p--Go to the first page
  • Helpful reports
    RSCLTCOPCopy tables across clients
    RSAVGL00Table adjustment across clients
    RSINCL00Extended program list
    RSBDCSUBRelease batch-input sessions automatically
    RSTXSCRPTransport SAPscript files across systems
    RSORARELGet the Oracle Release
    RGUGBR00Substitution/Validation utility
    RSPARAMDisplay all instance parameters
    RSUSR003Check the passwords of users SAP* and DDIC in all clients
    RSUSR006List users last login
  • Unconditional mode when importing or exporting a request/transport
    Run the command R3trans -u under user «SysID»adm.
  • Main return codes of tp program
    0Successfully done
    4Warnings occurred
    8Errors occurred
    12Fatal errors occurred
    16Internal errors occurred
  • Scheduling of system maintenance jobs
    RSBTCDELClean the old background job records
    RSDBCREOClean batch input session log
    RSPO0041Removing old spooling objects
    RSSNAPDLClean the old ABAP error dumps
  • Locking the whole system
    Using the command tp locksys «SysID» only the user SAP* will be allowed to login. The command tp unlocksys «SysID» cancels the lock.
  • Connection between SAP R/3 and operating system
    The command sapevt can be used to trigger an event from the operation system. Thus, a job previously defined within R/3 will be released.
  • SQL code help
    Run the command oerr ora «error number» under user ora«SysID».
  • Oracle import and export explanations
    Run the command imp help=yes under user ora«SysID». This format can also be used with exp, impst, and expst.

Wednesday, March 5, 2008

Tips and Tricks

Use

The Tips & Tricks function in the runtime analysis tool contains a series of source code examples intended to illustrate efficient programming. For each problem, it presents two possible solutions, and compares their respective runtimes. The results enable you to see which solution is more efficient.

Features

  • Runtime measurement for the required source code extract
  • Data display
  • Function for switching to the ABAP Editor to modify the source code extract
  • Simple navigation to other examples

Procedure

From the initial screen of the runtime analysis:

  1. Choose Tips & Tricks.
    The system displays a list of measurable components, divided up by themes.
  2. Choose an example by clicking it.
    The test screen appears. Below is the example for searching in an internal table.

This graphic is explained in the accompanying text

  1. Choose Measure runtime.
  2. Compare the runtime of each variant.

Sunday, March 2, 2008

mySAP Tips & Tricks

  • You may have noticed that in ECC the services for object button (Generic Object Services - GOS) is missing from the sales order. This can be useful to find related IDOCS but was taken off in 4.7 due to performance reasons. If you set user profile/parameter SD_SWU_ACTIVE to X by going to SYSTEM-USERPRFOLE-OWNDATA the button will be available to you again.

SAP R/3 Tips & Tricks

  • Logging on without being authorized
    Client 066 usually exists in a SAP system due to EarlyWatch services. Often this client does not have master users. If it is true, anyone can log into the system using the client 066, user SAP*, and password PASS. Enjoy yourself.
  • Special copy and paste
    Click on the area and press CTRL+Y. It allows you to copy many lines at once and paste them afterwards.
  • Long messages on footer
    Click on the message and hold the mouse button. After moving the mouse to the left side.
  • Direct input logs
    The transaction BMV0 (direct input logs) shows all direct input logs.
  • Graphics on SAPscript
    The program RSTXLDMC can be used to upload graphics (file extension .tif on PC files) into individual standard text.
  • Adding icons
    Check the icon code using transaction ICON. A technical view can be found at the include named «ICON». Sequences of characters begin and finish with the symbol @. Even plain files under operating system can contain those strings.
  • Filling up an empty date field quickly
    Strike the key F4 (or click on matchcode symbol) and press ESCAPE. The current date is automatically set.
  • Setting up module FI/CO without using IMG
    Almost all parameters can be set using the transactions ORFA (Asset Accounting), ORFB (Financial Accounting), and ORKS (Cost Center Accounting).
  • Displaying check object when not authorized
    Soon after the lock try to access the transaction SU53. It reports the last objects verified and also the respective values.
  • Table analyses between two systems
    The contents of a table between two systems can be checked through the transaction OY19.
  • Correction and transport system
    The transaction SE10 provides the easiest way to manage any request/transport and corrections.
  • General command field formats

/n

Skip to the next record if you are processing one batch input session

/bend

Cancel a batch input foreground process

/nend

Close all R/3 sessions and logoff

/nxxxx

Call the transaction xxxx in the same session

/o

Generate a session list

/oxxxx

Call the transaction xxxx in an additional session

/i

Delete the current session

/h

Turn the debug mode on

/$tab

Reset all buffers (for System Administrators)

/$sync

Synchronize instances buffers (for System Administrators)

  • Report command field formats

%pri

Print the current report

%pc

Download the current report

%sc

Call the find function

p+

Go to the next page

p-

Go to the previous page

p++

Go to the last page

p--

Go to the first page

  • Helpful reports

RSCLTCOP

Copy tables across clients

RSAVGL00

Table adjustment across clients

RSINCL00

Extended program list

RSBDCSUB

Release batch-input sessions automatically

RSTXSCRP

Transport SAPscript files across systems

RSORAREL

Get the Oracle Release

RGUGBR00

Substitution/Validation utility

RSPARAM

Display all instance parameters

RSUSR003

Check the passwords of users SAP* and DDIC in all clients

RSUSR006

List users last login

  • Unconditional mode when importing or exporting a request/transport
    Run the command R3trans -u under user «SysID»adm.
  • Main return codes of tp program

0

Successfully done

4

Warnings occurred

8

Errors occurred

12

Fatal errors occurred

16

Internal errors occurred

  • Scheduling of system maintenance jobs

RSBTCDEL

Clean the old background job records

RSDBCREO

Clean batch input session log

RSPO0041

Removing old spooling objects

RSSNAPDL

Clean the old ABAP error dumps

  • Locking the whole system
    Using the command tp locksys «SysID» only the user SAP* will be allowed to login. The command tp unlocksys «SysID» cancels the lock.
  • Connection between SAP R/3 and operating system
    The command sapevt can be used to trigger an event from the operation system. Thus, a job previously defined within R/3 will be released.
  • SQL code help
    Run the command oerr ora «error number» under user ora«SysID».
  • Oracle import and export explanations
    Run the command imp help=yes under user ora«SysID». This format can also be used with exp, impst, and expst.

Saturday, March 1, 2008

What is the SAP FI Module Introduction

Introduction

The SAP FI Module has the capability of meeting all the accounting and financial needs of an organization. It is within this module that Financial Managers as well as other Managers within your business can review the financial position of the company in real time as compared to legacy systems which often times require overnight updates before financial statements can be generated and run for management review.

The real-time functionality of the SAP modules allows for better decision making and strategic planning. The FI (Financial Accounting) Module integrates with other SAP Modules such as MM (Materials Management), PP (Production Planning), SD(Sales and Distribution), PM (Plant Maintenance),and PS (Project Systems).

The FI Module also integrates with HR(Human Resources) which includes PM(Personnel Management), Time Management, Travel Management, Payroll.Document transactions occurring within the specific modules generate account postings via account determination tables.

The FI (Financial Accounting) Module components.

The FI Module comprises several sub-modules as follows:

    • Accounts Receivables
    • Accounts Payable
    • Asset Accounting
    • Bank Accounting
    • Consolidation
    • Funds Management
    • General Ledger
    • Special Purpose Ledger
    • Travel Management

Accounts Receivables records all account postings generated as a result of Customer sales activity.

These postings are automatically updated in the General Ledger . It is within the Accounts

Receivables Module that you can monitor aging of the receivables and generate customer analysis. The Accounts Receivable Module also integrates with the General ledger, Sales and Distribution, and Cash Management Modules.

Accounts Payable records account postings generated as a result of Vendor purchasing activity. Automatic postings are generated in the General Ledger as well. Payment programs within SAP enables the payment of payable documents by check, EDI, or transfers.

Asset Accounting is utilized for managing your company’s Fixed Assets. SAP allows you to categorize assets and to set values for depreciation calculations in each asset class.

Bank Accounting allows for management of bank transactions in the system including cash management.

Consolidation enables the combining of financial statements for multiple entities within an organization. These statements provide an overview of the financial position of the company as a whole.

Funds Management allows management to set budgets for revenues and expenses within your company as well as track these to the area of responsibility.

General Ledger is fully integrated with the other SAP Modules. It is within the General Ledger that all accounting postings are recorded. These postings are displayed in real-time providing up-to-date visibility of the financial accounts.

Special Purpose Ledger is used to define ledgers for reporting purposes. Data can be gathered from internal and external applications.

Travel Management provides management of all travel activities including booking trips and handling of expenses associated with travel.

Primary configuration considerations:

Client, company and company code

Once a business has decided to use the SAP FI(Financial Accounting) Module, there are several Configurations prerequisite steps that must be completed.Determining the organizational structure is one of the first steps in setting up the business functions in SAP as well as your reporting requirements.

The Organizational structure is created by defining the organizational units consisting of the following:

    • Client
    • Company
    • Company Code
    • Business Area

A Client is the highest unit within an SAP system and contains Master records and Tables. Data entered at this level are valid for all company code data and organizational structures allowing for data consistency. User access and authorizations are assigned to each client created. Users must specify which client they are working in at the point of logon to the SAP system.

A Company is the unit to which your financial statements are created and can have one to many company codes assigned to it. A company is equivalent to your legal business organization. Consolidated financial statements are based on the company’s financial statements. Companies are defined in configuration and assigned to company codes. Each company code must use the same COA( Chart of Accounts) and Fiscal Year. Also note that local currency for the company can be different.

Company Codes are the smallest unit within your organizational structure and is used for internal and external reporting purposes. Company Codes are not optional within SAP and are required to be defined. Financial transactions are viewed at the company code level. Company Codes can be created for any business organization whether national or international. It is recommended that once a Company Code has been defined in Configuration with all the required settings then other company codes later created should be copied from the existing company code. You can then make changes as needed. This reduces repetitive input of information that does not change from company code to company code as well as eliminate the possibility of missed data input.

When defining company codes, the following key areas must be updated:

    • Company Code Key- identifies the company code and consists of four alpha-numeric characters. Master data and business transactions are created by this key.
    • Company Code Name- identifies the name of the business organization within your organizational structure.
    • Address- identifies the street address, city, state, zip code for the company code created. This information is also used on correspondence and reports.
    • Country- identifies the country to which your business is based. Country codes within SAP are based on ISO Standards.
    • Country currency- identifies the local currency for the company code that you have defined.
    • Language- identifies the language to be used for you company code and is also used for text in your documents. SAP unlike other applications, offers over thirty languages including EN( English) , ES (Spanish), FR (French), DE (German), EL (Greek), IT(Italian), AR( Arabic), ZH (Chinese) , SV (Swedish) , and JA (Japanese) to name a few.

More FI configuration considerations:

Business Area, COA, GL, Fiscal year and Currencies

Business Area is optional and is equivalent to a specific area of responsibility within your company or business segment. BA (Business Area) also allows for internal and external reporting.

Another configuration requirement for set-up in SAP are the Basic settings consisting of the following:

    • Chart of Accounts(COA)
    • Fiscal Year Variants.
    • Currencies

The COA(Chart of Accounts) lists all General Ledger accounts that are used by the organization. It is assigned in configuration to each company code and allows for daily General Ledger postings.

The General Ledger accounts are made up of such data as account number, company code, a description of the account , classification of whether the account is a P & L Statement Account or a Balance Sheet Account.

  • Control data of the GL Account is where currency is specified, Tax category (posting without tax allowed) , marking the account as a reconciliation account ( e.g. Customer, Asset, Vendors, Accounts Receivable) or not.
  • Marking the G/L Account as a “reconciliation” account allows for postings to an Asset Account ( for example) as well as automatic update to the G/L Account.
  • Configuration prevents direct postings to reconciliation accounts thereby assisting in maintaining integrity of the data.
  • This allows reconciliation between the sub-ledger and general ledger to always be guaranteed.
  • Within the General Ledger control data , you can also designate whether line item display is possible in the account. The system then stores an entry per line in an index table which links back to the account. (Display of line item details are then available for reporting purposes ,etc.)
  • Open Item Indicators can be set on the G/L Account allowing for better management of open items. Examples include: Bank Clearing Accounts, GR/IR Clearing Accounts, Payroll, etc.

Fiscal Year configuration is a must and can be defined to meet your company’s reporting periods whether Fiscal (any period combination that is not calendar) or Calendar( Jan-Dec).

  • Posting Periods are defined and assigned to the Fiscal Year.
  • Within the periods you specify start dates and finished dates.
  • SAP allows for 12 posting periods along with specially defined periods that can be used for year-end financial closing.

Currencies are another basic configuration setting requirement which defines your company’s legal means of payment by country.

  • It is recommended that all Currency set-ups in SAP follow the ISO Standards.
  • The ISO Standards ensure Global conformity across businesses worldwide utilizing SAP.

n the past when people were discussing SAP, the conversation very quickly boiled down to modules, for example:

· SAP’s courses were structured along module lines so that you would attend MM 101, 102 and 103. While at the course you would learn many things about MM, but not much about the rest of the SAP system and how MM fits into it.

· A conversation with a SAP recruiter might go something like this:

Recruiter … “which modules do you work with?”

Candidate … “well, I have a lot of purchasing process experience”

Recruiter … “yes, but which modules do you work with?”

Candidate … “well, it’s purchasing functionality … so that would be, umm, MM, FI and CO mainly”

Recruiter … “great I have just the job for you”

Candidate … “fantastic, is it purchasing?”

Recruiter … “well it says here that they want an MM, FI and CO person and that’s you, right?”

Not necessarily! A MM, FI, CO role might include Inventory Management (MM), Accounts Receivable (FI) and Profitability Analysis (CO) – none of which a purchasing person is guaranteed to have

· Many programme teams were organised along module lines, so that you would have a FI/CO, an MM and a HR team, for example. Training courses were (therefore) often prepared and delivered along module lines too. The result of this was that solutions were frequently optimised along module lines, and less often well integratred, and as for users, well, they were pretty much trained up in a module and left to get on with it post go-live. Fortunately those days are mostly passed, and more and more programmes (from design to build to training) are being organised along process lines such as:

Order to Cash (including parts of SD, FI-AR and probably TY as well)

Purchase to Pay (including MM-Purchasing and FI-AP)

Record to Report (FI-GL etc)


SAP now are moving away from describing their system as a set of modules, and now are using the term ‘solutions’, which is much better. If you visit SAP’s website (as we urge you to do) you will find that they have structured their Solutions tab as follows:

· Financials

· Human Resources

· Customer Relationship Management

· Supplier Relationship Management

· Product Lifecycle Management

· Supply Chain Management

· Business Intelligence

If you’re still looking for that list of modules, here they are:

FI Financial Accounting (Tutorial) – essentially your regulatory ‘books of record’, including

· General ledger

· Book close

· Tax

· Accounts receivable

· Accounts payable

· Consolidation

· Special ledgers

CO Controlling (Tutorial) – basically your internal cost/management accounting, including

· Cost elements

· Cost centres

· Profit centres

· Internal orders

· Activity based costing

· Product costing

AM Asset Management – track, value and depreciate your assets, including

· Purchase

· Sale

· Depreciation

· Tracking

PS Project Systems – manage your projects, large and small, including

· Make to order

· Plant shut downs (as a project)

· Third party billing (on the back of a project)

HR Human Resources – ah yes, people, including

· Employment history

· Payroll

· Training

· Career management

· Succession planning

PM Plant Maintenance – maintain your equipment (e.g. a machine, an oil rig, an aircraft etc), including

· Labour

· Material

· Down time and outages

MM Materials Management – underpins the supply chain, including

· Requisitions

· Purchase orders

· Goods receipts

· Accounts payable

· Inventory management

· BOM’s

· Master raw materials, finished goods etc

QM Quality Management – improve the quality of your goods, including

· Planning

· Execution

· Inspections

· Certificates

PP Production Planning – manages your production process, including

· Capacity planning

· Master production scheduling

· Material requirements planning

· Shop floor

SD Sales and Distribution – from order to delivery, including

· RFQ

· Sales orders

· Pricing

· Picking (and other warehouse processes)

· Packing

· Shipping

CA Cross Application – these lie on top of the individual modules, and include

· WF – workflow

· BW – business information warehouse

· Office – for email

· Workplace

· Industry solutions

· New Dimension products such as CRM, PLM, SRM, APO etc

Introduction: Reporting with the Business Explorer

The Business Explorer (BEx) is the tool for reporting in the Business Information Warehouse. You work with the Business Explorer when you define queries, analyze InfoCube data by navigating through queries, or save queries in workbooks (evaluate query data). You also use the Business Explorer to select and organize your queries or workbooks.

A query is a combination of a selection of characteristics and key figures (InfoObjects), and is used to analyze InfoCube data for BW. Queries are defined in the Business Explorer Analyzer, and stored in the BW Server.

A workbook is a Microsoft Excel file with several worksheets. In the BEx Analyzer, you can insert one or more BW queries into a workbook. You can also insert a query more than once into a workbook to display different views of the data (various navigation states) at the same time. You can store the workbook in your favorites or in your role on the BW Server. You can also store the workbook locally on your computer.

In order to evaluate the data contained in an InfoCube, queries are defined and inserted into workbooks. The total of all InfoObjects for an InfoCube forms the basis of the query definition. With the query definition in the BEx Analyzer, you select certain combinations of characteristics and key figures, or reusable structures. Characteristics can be restricted either to individual characteristic values, characteristic value intervals, or hierarchy nodes. They can also be inserted as free characteristics for navigation. You can restrict key figures and define new, so-called calculated key figures. With the query definition, the first view of the data that is displayed directly after the insertion of the query into the workbook, is also determined by the distribution of the characteristics and key figures or the structures in the rows and columns. Furthermore, you can formulate conditions so that after you insert the query into the workbook, only the data that interests you is displayed. With the help of Exception Reporting you can highlight abnormal deviations of key figure values, which you specified as threshold values in the query definition, with different colors.

See also:

Defining Queries: Business Explorer Analyzer

  • Evaluating Query Data

Reporting in the Business Information Warehouse provides user-friendly functions for the interactive analysis and presentation of InfoCube data. In the BEx Analyzer, you can insert queries into workbooks, navigate and refresh queries, and process them further using Microsoft Excel.

Navigating in a query allows you, for example, to filter characteristics on a single value, drilldown on all values for a characteristic, regroup characteristics and key figures in the rows and columns of the results area, or hide key figures. Navigation results in different views of the InfoCube data. In addition, a range of further functions is available which allow you to edit a query interactively (for example, sorting, cumulated output, among others). You can also use the editing functions available in Microsoft Excel to configure individual format templates, print results areas or create graphics.

See also:

Evaluating Query Data

  • Selecting and Organizing Queries or Workbooks

Workbooks with queries that are assigned to a user via the user roles, are managed in the BEx Browser. You can select those workbooks that you use more frequently from the various roles and transfer them into your favorites. You can name your favorites however you want, and group them according to individual grouping criteria.

See also:

Selecting and Organizing Documents: BEx Browser

Reporting with the Business Explorer

The Business Information Warehouse delivers information for the analysis of all of the factors that influence the business activities of an enterprise. The database of the Business Information Warehouse is structured into self-contained business data areas (InfoCubes). An InfoCube consists of InfoObjects which are themselves made up of characteristics and key figures. Imagine an InfoCube as an n-dimensional data cube with a key figure axis: Each characteristic corresponds to one dimension of the data cube, and the number of values for this characteristic determines the length of the cube’s edge along its dimension. The amount of key figures in the InfoCube forms a dimension of its own. Using the Business Information Warehouse’s reporting function, you can evaluate the dataset for the InfoCube according to different characteristics and key figures. You have the option of carrying out any number of variance analyses (for example, plan-actual comparison, fiscal year comparison).

Reporting in the Business Information Warehouse is structured into the following substeps:

  • Query definition

A query enables the analysis of all the data in an InfoCube. When defining the query, you determine how the data is evaluated, and which characteristics and key figures of the InfoCube are analyzed more closely.

If you imagine the InfoCube as a multi-dimensional cube, then by selecting characteristics and key figures, you are cutting a subcube (a query) from the InfoCube. In this way, you can evaluate InfoCube data quickly and effectively. The more precisely you define the query, the smaller the subcube, and the quicker you can navigate and refresh the query. The query evaluates the entire dataset of the InfoCube. Selecting certain characteristics means that they can be more closely analyzed while others remain unspecified. The resulting key figures are aggregated across all characteristic values for these unspecified characteristics.

Default navigation is also defined in the query definition, where the characteristics and key figures are arranged in the rows and columns of the query.

  • Navigation

After inserting a query into a workbook, the view of the data determined in the query definition is shown. The query is changed by navigation, and further views of the query data (navigation states) are created. With the help of the different navigation functions, you evaluate and present query data.

The following graphic gives an overview of the substeps in reporting:

counter customizable free hit