Thursday, September 23, 2010

Table Names for Creating Basic Pay Infotype

How can one find which table we are updating when adding/updating an entry in IMG?
The first step of creating a basic pay infotype is 
Payroll India - Basic Settings - Environment of Wage type Maintainence - Create Wage type Catalogue . 
Here when you copy from MB10 and make a new wage type for your client you will find a list of tables displayed. 
Attached is a screen shot for the same.
Module Variant for India is Inval and for rest of the world is PERZT. The table which in which module variants A,B,C,D are maintained is T511.

Finding the list of HR module Tables

Is anybody is having a complete list of HR module tables?
 
All personnel administration tables start with PA and the infotype number behind it. 
All personnel development/OM tables start with HRP and infotype (e.g. 1000) behind it. 
All recruitment tables start with PB and infotype number behind it. 
There also are HR tables that start with HRA, HPD, HRT, etc. The easy way to get a list is to use SAP's 'Application Hierarchy', transaction SE81 (select all HR modes in the tree that you are want a list of tables for, click on the 'Information System' button, under Abap Dictionary --> Basic Objs, double click on 'database tables', increase your 'maximun no. of hits' and execute).
Use transaction se11...type in PA* do dropdown and enter, do the same for HRP* and you will have most of the HR transaparent Tables. To access them look for RP_read_* and RP_provide* in Table TRMAC to read a infotype or use the 'select' statement to access the Transparent table. 
Transaction SE16 (data browser) is also useful.  As mentioned above, the PA infotype tables all begin with PA and are followed by the infotype number e.g. PA0001 for the Org Man infotype. 
PA* - PA infotype tables 
PCL* - HR clusters 
PB* - recruitment tables 
PCERT - payroll posting runs 

Transparent tables for WCM

Need to generate a report for WCM. I need the trasparent tables (Not structures).  Where these fields are located. These are the fields required.
I have checked but these fields are mentioned with reference to structures and not transparent tables.
 
1) WCA= Field Name: WAPINR
2) WCD =Field Name: WCNR
3) Short description = Field Name: STXT
4) User Status =Field Name: USRST
5) System Status =Field Name: SYSST
6) Created on = Field Name = GENDATUM
7) Created by = Field Name =GENNAME
8) Approved by = Field Name= GENVNAME

Have you tried the multi level list reports – WCLE & WCLB. 




Sometimes it also pays the SE16n the tables because those fields could exist there. We have a lot of custom tables so these are the SAP standard I think.



















 
















Transparent Table Relate With PM Module

Like to know all transparent Table relate with PM module. 
Try SE80 than fill the program related to PM transaction.
View Dictionary structures you'll get all table that related with PM
Trasaction code that used in PM eq. IW31, IW21, IW41
Try tcode DB15 
Fill the object that related to PM Module 
PM_EQUI              Equipment
PM_IBASE            IBase
PM_IFLOT            Functional locations
PM_IMRG             Measurement documents
PM_MPLAN         Maintenance plans
PM_NET               Object links, master data
PM_OBJLIST        Serial Number History
PM_ORDER          Service and maintenance orders
PM_PLAN             Routings
PM_QMEL            Maintenance Notifications
You can get all table that related to PM Object.

Important QM Tables

Area Table Description 
Master Data QMAT Inspection type - material parameters 
Master Data QMHU QM Link Between Inspection Lot and Handling Unit Item 
Master Data QMTB Inspection method master record 
Master Data QMTT Inspection Method Texts 
Master Data QPAC Inspection catalog codes for selected sets 
Master Data QPAM Inspection catalog selected sets 
Master Data QPMK Inspection characteristic master 
Master Data QPMT Master Inspection Characteristics Texts 
Master Data QPMZ Assignment table - insp. methods/master insp. characteristic 

Master Data TQ01D Authorization groups for QM master data 
Master Data TQ01E Text authorization groups for QM master data 
Master Data TQ21 Assignment of screens to screen groups 
Master Data TQ25 QM:screen sequence for master and inspection characteristics 
QM Master Data 
Catalog QPCD Inspection catalog codes 
Catalog QPCT Code texts 
Catalog QPGR Inspection catalog code groups 
Catalog QPGT Code group texts 
Catalog TQ07 Follow-Up Action for Usage Decision of Inspection Lot 
Catalog TQ07A QM: Function Modules for Follow-Up Action 
Catalog TQ07T Language-dependent texts for Table TQ07 
Catalog TQ15 Inspection catalog type index 
Catalog TQ15T Language-dependent texts for table TQ15 
Catalog TQ17 Defect classes 
Catalog TQ17T Language-dependent texts for table TQ17 
Catalog 
Sample Determination QDEB Allwd. Relationships: Sampling Procedures/Dynamic Mod. Rules 
Sample Determination QDEBT Allowed combinations of procedures/dynamic mod. rules: texts 
Sample Determination QDPA Sampling scheme-instructions 
Sample Determination QDPK Sampling scheme header 
Sample Determination QDPKT Sampling scheme: texts 
Sample Determination QDPP Sampling scheme item 
Sample Determination QDQL Quality level 
Sample Determination 

Table of the Order Production Operation

Which is the table of the order production operation details?  I need to get the activities for production order : 

Setup, Labor, Machine, Confirmed and to confirm.

I can see look at this in CO02 / Operation Overview (f5) / Operation Detalis / Qty-Activities
 
That is probably the hardest information to piece together, I used 5 tables with multiple joins to get User Fields for operations in a production order. Maybe you can use something simular.

AFKO - this is for your basic production header info - order number, basic finish date etc

S022 - this is for your operation header details - operation number, Work centre etc if you are only after the header details such as setup time and execution time, you can probably stop here without going to AFVC or AUFV (you definitely need AUFK if you want order status)

AUFK - this is for your order master data - Order released flag, order complete flag, technically complete date, you'll need this to filter out closed orders

SAP PP Master Data Tables

MASTER DATA
 
Engineering Change Management

AENR        Customer and priority
AEOI          Revision Numbers

Work Center

CRHD         Workcenter Header Data
CRCA         Workcenter Capacity Allocation
CRCO         Workcenter Cost Center Assignment
CRHH          Hierarchy Header
CRHS           Hierarchy Structure
CRTX          Workcenter Text
KAKO         Capacity Header
KAZY          Intervals of Capacity

SAP Production Planning Table

Demand Management

PBED          Independent Requirements Data
PBIM          Independent Requirements by Material

Repetitive Manufacturing

SAFK         RS Header Master Data
S025           LIS -- Run Schedule Quantities
S026           LIS -- Material Usage
S028           LIS -- Reporting Point Statistics
CEZP          Reporting Point Document Logs
CPZP          Reporting Points - Periodic Totals

MRP Records

MDKP        MRP Document Header Data
MDTB         MRP Table Structure (no data)
PLSC          Planning Scenario (Long-term Planning)
MDFD        MRP Firming Dates
MDVM       Planning File Entries
S094           LIS -- Stock/Requirements Analysis

Reservations

RESB          Reservations/Dependent Requirements

Planned Orders

PLAF          Planned Orders

Discrete Production

AFKO         Order Header
AFPO          Order Item Detail
AFVC          Order Operations Detail
AFFL           Order Sequence Details
AFFH          Order PRT Assignment
AFBP          Order Batch Print Requests
AFRU          Order Completion Confirmations
AFFW         Confirmations -- Goods Movements with Errors
AFRC          Confirmations -- Incorrect Cost Calculations
AFRD          Confirmations -- Defaults for Collective Confirmation
AFRH          Confirmations -- Header Info for Confirmation Pool
AFRV          Confirmation Pool
AFWI          Confirmations -- Subsequently Posted Goods Movements

Classification

KLAH          Class Detail
CABN          Characteristic Detail
AUSP          Characteristic Values
CAWN          Characteristic Values
CAWNT         Characteristic Value Texts
KSML          Characteristic Allocation to Class
KSSK          Material Allocation to Class

SAP WM Tables Process Flow

Warehouse Management in SAP (WM) :
Transfer requirement
LTBK Transfer requirement - header
LTBP Transfer requirement - item
Transfer order
LTAK Transfer order - header
LTAP Transfer order - item
Master data - stock positions
LQUA Quants
Inventory documents in WM
LINK Inventory document header
LINP Inventory document item
LINV Inventory data per quant
The easiest way to determine all WM tables is via the data dictionary. 
Transaction SE11 
Press F4 in field tables. 
On the popup for the table search, enter LVS in field development class and execute

What Are The Standard Tables Used For Material Ledger

The following tables contain data that can appear in the material ledger documents:
· MLHD Material Ledger Document: Header
· MLIT Material Ledger Document: Items
· MLPP Material Ledger Document: Posting Periods and Quantities
· MLPPF Material Ledger Document: Field Groups (Posting Periods and Quantities)
· MLCR Material Ledger Document: Currencies and Values
· MLCRF Material Ledger Document: Field Groups (Currencies and Values)
· MLCRP Material Ledger Document: Price Change (Currencies, Prices)
· MLMST Material Ledger Document: Costing Run Header Data
 

All The Tables In SAP MM Purchasing

Please find all tables in MM-PUR (Purchasing) :
 
EBAN  - Purchase Requisition 
EBKN  - Purchase Requisition Account Assignment 
EBUB   - Index for Stock Transport Requisitions for Materi
EINA    - Purchasing Info Record: General Data 
EINE     - Purchasing Info Record: Purchasing Organization D
EIPA     - Order Price History: Info Record 
EKAB   - Release Documentation 
EKAN   - Vendor Address: Purchasing Document 
EKBE    - History per Purchasing Document 
EKBEH - Removed PO History Records 
EKBZ    - History per Purchasing Document: Delivery Costs 
EKBZH  - History per Purchasing Document: Delivery Costs 
EKEH    - Scheduling Agreement Release Documentation 
EKEK    - Header Data for Scheduling Agreement Releases 
EKES     - Vendor Confirmations 
EKET     - Scheduling Agreement Schedule Lines 
EKETH   - Scheduling Agreement Schedules: History Tables 
EKKI      - Purchasing Condition Index 
EKKN    - Account Assignment in Purchasing Document 
EKKO    - Purchasing Document Header 
EKPA     - Partner Roles in Purchasing 
EKPB     - "Material Provided" Item in Purchasing Document 
EKPO    - Purchasing Document Item 
EKPV    - Shipping-Specific Data on Stock Tfr. for Purch. D 
EKRS    - ERS Procedure: Goods (Merchandise) Movements to b 
EKUB    - Index for Stock Transport Orders for Material 
EORD    - Purchasing Source List 
EQUK    - Quota File: Header 
EQUP     - Quota File: Item 
T024      - Purchasing Groups 
T024E    - Purchasing Organizations 

Common Tables used by SAP MM

Below are few important Common Tables used in Materials Management Modules: 

EINA Purchasing Info Record- General Data 
EINE Purchasing Info Record- Purchasing Organization Data 
MAKT Material Descriptions 
MARA General Material Data 
MARC Plant Data for Material 
MARD Storage Location Data for Material 
MAST Material to BOM Link 
MBEW Material Valuation 
MKPF Header- Material Document 
MSEG Document Segment- Material 
MVER Material Consumption 
MVKE Sales Data for materials 
RKPF Document Header- Reservation 
T023 Mat. groups 
T024 Purchasing Groups 
T156 Movement Type 
T157H Help Texts for Movement Types 
MOFF Lists what views have not been created 
A501 Plant/Material 
EBAN Purchase Requisition 
EBKN Purchase Requisition Account Assignment 
EKAB Release Documentation 
EKBE History per Purchasing Document 
EKET Scheduling Agreement Schedule Lines 
EKKN Account Assignment in Purchasing Document 
EKKO Purchasing Document Header 
EKPO Purchasing Document Item 
IKPF Header- Physical Inventory Document 
ISEG Physical Inventory Document Items 
LFA1 Vendor Master (General section) 
LFB1 Vendor Master (Company Code) 
NRIV Number range intervals 
RESB Reservation/dependent requirements 
T161T Texts for Purchasing Document Types 

Create Own Transaction Using SE93

What is SE93 and why we use this transaction?

SE93 is to Maintain Transaction Codes.

If we develop some Module pool programs or Report Programs, to make these programs available to the end users, we create transaction codes for these programes.

For performing any kind of task in the SAP R/3 ERP system, a transaction is used. SAP provides a standard set of transactions to manipulate i.e insert, update, delete and display data in the system. But sometimes, the need to create a customer specific transaction may arise due to the following reasons

--> Standard SAP may not support that task.

--> A particular transaction needs to be customized to suit the customer requirements.

A transaction is defined as a sequence of dynpros (sap term for screens) having input and output fields and corresponding processing logic behind them to perform a particular task.

So we create a transaction in SE93.

We call an execution of an ABAP program using a transaction code a transaction . There are dialog , report, parameter, variant, and - as of Release 6.10 - OO transactions. A transaction is started by entering the transaction code in the input field on the standard toolbar or by means of the ABAP statements CALL TRANSACTION or LEAVE TO TRANSACTION. Transaction codes can also be linked to screen elements or menu entries. Selecting such an element will start the transaction.

Wednesday, September 22, 2010

Transaction Code To View All SAP Tables

What is the transaction code to view all SAP (PP) table,or there is some other way to view?

To browse tables which specified for PP module only, you can use SE16 with a specified application component & sub-component. First, go to SE16, browse the application component (ex : PP), then select the sub-component (ex : PP-SFC, for Production Orders related tables); and all tables within the specified area will be displayed.

In tcode SE16, click the Down Arrow next to the Table Name field:

Then it will pop-up a screen, look at the bottom of the screen: 




Then select components by clicking the + sign to open up the sub-compenent you want.  For e.g.:


Transactions That Are Changed From Release 4.6 C

What are the new transaction code, through from R/3 4.6c to ECC6?

New transactions -
FB50L - Enter GL Account Document for Ledger Group
FB01L - Enter General Posting for Ledger Group
FAGLB03 - Display General ledger Account Balances
FAGLL03 - Display /Change Items (New) (FBL3N)
FAGL_FC_VAL - Foreign currency valuation of open items
FAGLGVTR - Balance Carry Forward (New)
S_PL0_86000028 - Financial statement.

Apart from the tocdes listed above,
Transactions that changed from Release 4.6 C

How to access transactions for which you do not have access to execute and View ABAP Codes?

Tip for use with CALCULATED caution BY EXPERTS ONLY.
You do not have access to run most of the transactions in PRD, even to Z reports which do not update any data.
Pre-req: You should have access to SE93

- Execute SE93
- Enter your t.Code you want to execute
- Hit Display
- Then double click on the program field that will take you to the program code for view.
- If you click on 6th Icon from you left, which is execute, you will be able to execute this program

CAUTION USE THIS TIP WITH CAUTION

Easy to Remember (SAP Transaction Codes)

 SPRO    DEFINE ITEM CATEGORY  
MM01    CREATE MATERIAL
MM02    MODIFY MATERIAL
MM03    DISPLAY MATERIAL      
MMS1    CREATE MATERIAL MASTER
MMS2    CHANGE MATERIAL MASTER
MMS3    DISPLAY MATERIAL MASTER
MB1C    MAINTAIN STOCK
MMPI    INITIALISE PERIOD FOR MASTER MATERIAL RECORDFROM CO CODE      
MMBE    CREATE STOCK  
MM60    MATERIAL LIST 
XD01    CREATE CUSTOMER
XD02    MODIFY CUSTOMER
XD03    DISPLAY CUSTOMER      
VA01    CREATE ORDER  
VA02    CHANGE ORDER  
VA03    DISPLAY ORDER 
VA11    CREATE INQUIRY
VA12    CHANGE INQUIRY
VA13    DISPLAY INQUIRY
VA21    CREATE QUOTATION      
VA22    CHANGE QUOTATION      
VA23    DISPLAY QUOTATION     
VD02    CHANGE  SALES PROSPECT
VD03    DISPLAY SALES PROSPECT
VD04    DISPLAY CHANGES
VD06    FLAG FOR DELETION     
VK11    MAINTAINING PRICING   
VK0A    ASSIGN G/L ACCOUNT GENERAL    
VOK0    PRICING
VOR1    DEF COMMON DIST CHANEL
VOR2    DEF COMMON DIV
VOV6    DEFINE SCHEDULE LINES 
VOV8    DEFINE SALES DOC TYPE 
VOFA    CREATE/OR CHANGE BILLING TYPES CONFIGURATION  
V129    DEFINE INCOMPLETENESS SCHEMAS FOR FOREIGN TRADE
V149    ASSIGN INCOMPLETENESS SCHEMAS FOR COUNTRY CODE
CA01    CREATE ROUTING
CA02    EDIT  ROUTING 
CA03    DISPLAY ROUTING
CS01    CREATE BOM    
CS02    CHANGE BOM    
CS03    DISPLAY BOM   
OVK1    DEFINE TAX DET RULES  
OVK3    DEF TAX REL OF MASTER RECORDS CUSTOMER TAXES  
OVK4    DEF TAX REL OF MASTER RECORDS MATERIAL TAXES  
OVR6    DEF LEGAL STATUSES    
OVS9    DEF CUSTOMER GRP      
OVRA    MAINT STATISTICS GRPS FOR CUSTOMERS   
OVRF    MAINT STATISTICS GRPS FOR MATERIAL    
OVXC    ASSIGN SHIIPING POINT TO PLANT
OVX6    ASSIGN PLANT TO S.O AND DIST CHANEL   
OVLK    DEFINE DELIVERY TYPE  
OVSG    DEFINE INCOTERMS      
OVLH    DEFINE ROUTES 
OVXM    ASSIGN SALES OFF TO SALES AREA
OVXJ    ASSIGN SALES GRP TO SALES OFFICE      
OMS2    MATERAIL UPDATE
OVLP    DEFINE ITEM CATEGORY FOR DELIVERY     
OX10    ASSIGN DEL PLANTS FOR TAX DET 
O/S2    DEFINE SERIAL NO PROFILE      
O/S1    DEFINE CENTRAL CONTROL PARAMETERS FOR SR NO   
OBB8    DEFINE TERMS OF PAYMENT
OKKP    ACTIVATION OF COMPONENETS     
VB01    CREATE REBATE AGGREMENTS      
VB02    CHANGE REBATE AGREMENT
VB03    DISPLAY REBATE AGGREMENT      
VB31    CREATE PROMOTION      
VB32    CHANGE PROMOTION      
VB33    DISPLAY PROMOTION     
VB21    CREATE SALES DEAL     
VB22    CHANGE SALES DEAL     
VB23    DISPLAY SALES DEAL    
VB25    LIST OF SALES DEAL    
VB35    PROMOTION LIST
VKA4    CREATE ARCHIVE ADMINISTRATION 
VKA5    DEL ARCHIVE ADMINISTRATION    
VKA6    RELOAD ARCHIVE ADMINISTRATION 
VC/1    CUSTOMER LIST 
VC/2    CREATE SALES SUMMARY  
VDH2    DISPLAY CUSTOMER HIERARCHY    
VF01    CREATE PROFORMA INVOICE
VF02    CHANGE PROFORMAINVOICE
VF03    DISPLAYPROFORMA  INVOICE      
VF07    DISPLAY FROM ARCHIVE  
VF11    CANCEL BILL   
VFX3    BLOCKED BILLING DOC   
VFRB    RETRO BILLING 
VF04    MAINTAIN BILL DUE LIST
VF06    BACKGROUND PROCESSING 
VF21    CREATE INVOICE LIST   
VF22    CHANGE INVOICE LIST   
VF23    DISPLAY INVOICE LIST  
VF44    MAINT  REVENUE LIST   
VF45    REVENUE REPORTS
VF46    MAINT CANCELLATION LIST
VF31    ISSUE BILLING DOC     
VFP1    SET BILLING DATE      
VARR    ARCHIVE DOCUMENTS     
VL01N   CREATE DELIVERY       
VL02N   TO CHANGE DELIVERY WHICH IS ALREADY CREATED   
VL03N   DISPLAY DELIVERY                
V/08    TO CHANGE CONDITION (PR PROCEDURE)    
V/30    DEFINE PRINT PARAMETERS
FD32    SETTING CREDIT LIMIT FOR CUSTOMER     
/NSM12  TO REMOVE LOCK ENTRY  
SM30          
ND59    LIST CUSTOMER MATERIAL INFO   
VB0F    UPDATE BILL DOC

These are alternate Tcodes which are not
listed in SAP front end 4.7 enterprise edition either. Some examples are:

OY05 is also SCAL.
S_AHR_61016362 - PAR1- SAP Standard flexible report is also PAR1
S_AHR_61016369 - Employee List - PAR2.

Find the list of SAP Transaction codes

Where I can find the list of transaction codes and their usage, I heard that there is some table which contains all the transaction codes with their descriptions.
 
Does anyone know about the Table that consist all the T-Code?
 
Listed here are the various ways you can find the list of transaction codes and their usage:

Use transaction SE11 - ABAP Dictionary:

Fill in the Database table name and click the Display button.

- TSTC   table will contain all the Tcodes and

- TSTCT table will contain all the Tcodes with Texts.

Once you entered the screen, click in Top Menu - Utilities - Table contents - Display
 
If you want to display all the transaction code (total - 57,048) you have to change the Fields: Maximum number of hits to 99999 (default 500).

or

Simply goto transaction SM01, although this tcode is to Lock/Unlock any transaction code, you can also view all the tcode available in the R/3 system from here.

or

Goto transaction SE93
 
There are two ways where you can find the list of transaction codes in SE93.

Basic Knowledge and System Navigation Question

What SPRO stands for?
SPRO stands for SAP Project Reference Object
.
It is used to configure the setting as per your client requirement by using the standard setting present in the system.  This where you can do all the SAP configuration work.  It is also known as the Configuration Menu.

What is full form IMG and SPRO? How are they different from each other?
 
IMG    :-  Implementation Guide.

SPRO :-  SAP Project Reference Object.

SPRO------>IMG.

Type in the T-Code SPRO under That got to Main Menu which is IMG.

SPRO is basically used to organize the consultant customizing during the SAP Project Phrase.

How to close a window?
 
If we want to stop a transaction in the middle, Right click on the end button (X) on the top right corner of the window. Then select "stop transaction".

As we dont have STOP icon as we have in WINDOWS, this will help in the same way.


Its a very small tip, but will help a lot.

Interview questions in SAP BW/BI

  1. What is table partition?

2. What are the options available in transfer rule and when ABAP code is recquired during the transfer rule what important variables you can use?

3. How would you optimize the dimensions?

4. What are the conversion routines for units and currencies in the update rule?

5. Can you make an infoobject as info provider and why?

6. What are the steps to unload non cumulative cubes?

7. Give step to step approach to archiving cubex.

8. What are the load process and post processing.

9. What are the data target administration task

10. What are the parallel process that could have locking problems

System-Wide Features

System-Wide Features

SAP uses certain system wide features that should be understood at the outset. These are used to logically, safely and flexibly organize the data in a business enterprise.
  • Customizing--
    is the configuring of the system
    to represent your organization's legal structure, reporting requirements and business processes. Internal reporting is a managerial tool in the daily operations. External reporting is required by governmental units controlling the legal structure of the corporation, such as, the IRS state taxing authorities, SEC etc.
  • Organizational Elements
    • Financial--
      • client is a legal and organizationally independent unit at the highest level in SAP
      • company is an independent legal entity within a client
      • business areas are used to produce profit and loss statements and balanced sheets across marketing lines
    • Materials Management
      • Purchasing units
      • Plants
    • Sales and Distribution
      • Sales Organization
      • Distribution channel
      • Division
  • Master Data is records that remain in the database
    over an extended period of time. Examples:
    • Customer Master
    • Vendor Master
    • Material master
    • Account Master
    This structure eliminates redundant data and is shared by all SAP Modules. It is a critical aspect of the robustness of the system.

  • Employee Self Service--your employees have access to the own HR records over the Internet.
  • Classification is the assignment of objects to a class. Each class has standard characteristics.
  • Matchcodes are query tools used to find specific information using search methods.

  • Security
    is administered for objects, profiles and authorizations. Users are only authorized to see or change the parts of the system required by their job responsibilities.

SAP Application Modules

SAP Application Modules

SAP has several layers. The Basis System is the heart of the data operations and should be not evident to higher level or managerial users. Other customizing and implementation tools exist also. The heart of the system from a manager's viewpoint are the application modules. These modules may not all be implemented in a typical company but they are all related and are listed below:

    *FI Financial Accounting--designed for automated management and external reporting of general ledger, accounts receivable, accounts payable and other sub-ledger accounts with a user defined chart of accounts. As entries are made relating to sales production and payments journal entries are automatically posted. This connection means that the "books" are designed to reflect the real situation.

    *CO Controlling--represents the company's flow of cost and revenue. It is a management instrument for organizational decisions. It too is automatically updated as events occur.

    *AM Asset Management--designed to manage and supervise individual aspects of fixed assets including purchase and sale of assets, depreciation and investment management.

    *PS Project System--is designed to support the planning, control and monitoring of long-term, highly complex projects with defined goals.

SAP Introduction

SAP is the leading Enterprise Information and Management Package worldwide. Use of this package makes it possible to track and manage, in real-time, sales, production, finance accounting and human resources in an enterprise.

SAP the company was founded in Germany in 1972 by five ex-IBM engineers. In case you’re ever asked, SAP stands for Systeme, Andwendungen, Produkte in der Datenverarbeitung which - translated to English - means Systems, Applications, Products in Data Processing. So now you know! Being incorporated in Germany, the full name of the parent company is SAP AG. It is located in Walldorf, Germany which is close to the beautiful town of Heidelberg. SAP has subsidiaries in over 50 countries around the world from Argentina to Venezuela (and pretty much everything in between). SAP America (with responsibility for North America, South America and Australia - go figure!) is located just outside Philadelphia, PA.

The original five founders have been so successful that they have multiplied many times over such that SAP AG is now the third largest software maker in the world, with over 17,500 customers (including more than half of the world's 500 top companies). SAP employs over 27,000 people worldwide today, and had revenues of $7.34 billion and Net Income of $581 million in FY01. SAP is listed in Germany (where it is one of the 30 stocks which make up the DAX) and on the NYSE (ticker:SAP).

There are now 44,500 installations of SAP, in 120 countries, with more then 10 million users!

So what made this company so successful? Back in 1979 SAP released SAP R/2 (which runs on mainframes) into the German market. SAP R/2 was the first integrated, enterprise wide package and was an immediate success. For years SAP stayed within the German borders until it had penetrated practically every large German company. Looking for more growth, SAP expanded into the remainder of Europe during the 80's. Towards the end of the 80's, client-server architecture became popular and SAP responded with the release of SAP R/3 (in 1992). This turned out to be a killer app for SAP, especially in the North American region into which SAP expanded in 1988.