Friday, December 24, 2010

Important Basis T-Codes & Tables


T-CODES
Serial No.
Transaction Code
Usage
1
SCC4
Making entry for New Client
Changing client properties
2
SCC1
Importing Change request within the same server in a different client
3
SCC5
Delete a client
4
SCCL
Local Client Copy
5
SCC9
Remote Client Copy
6
SCC8
Client Export
7
STMS
Configuring STMS and transporting
8
SPAM
Support Package Application
9
SAINT
Add-on Installation
10
DB02
Database Performance : Tables and Indexes
11
ST04
Database Performance analysis
12
ST03
SAP Workload Analysis
13
ST02
SAP Buffer Analysis
14
ST05
Trace Analysis
15
ST06
Operating Systems Analysis
16
OSS1
SAP OSS access
17
SP01
Spool analysis
18
DB13
DBA Planning Calendar – Scheduling Backup/Database Statistics Generation
19
DB12
View Backup Logs
20
DB16
Database Logs
21
SM21
System Log
22
SM12
View / Delete SAP Lock entries
23
SM13
View / Manage SAP Update mechanism
24
SM69
Define External OS Commands
25
SM36
Scheduling Background Jobs
26
SM37
Background Job Status
27
SM59
RFC setup
28
SMLG
Logon Load balancing
29
RZ10
Maintain Profiles
30
RZ04
Operation Modes Definition
31
SM35
Batch Processing
32
SM30
Table Maintenance
33
SE16
Table browser
34
SE11
ABAP Dictionary
35
SM04
List of Users in current instance
36
AL08
List of Users in all application instances
37
SPRO
IMG Configuration
38
SM01
Lock / Unlock Transaction
39
SM02
Create / Send Messages
40
SU01
User Maintenance
41
PFCG
Role Maintenance
42
SLICENSE
Applying SAP License
43
SM50
Work Process Overview of current Instance
44
SM51
Work Process Overview of all Instances
45
SU10
Mass User Maintenance
46
SUGR
Maintain User Groups
47
SUIM
User Information System
48
SE01
Transport Organiser
49
SPAD
Spool Administration
50
SP12
Temse Administration
51
SCC7
Import Post-processing
52
SU21
Maintain Authorization Objects

TABLES
Serial No.
Table Name
Usage
1
T000
Clients
2
T001
Company Codes
3
T001W
Plant Codes
4
USR02
User Master
5
E070
Change Requests
6
TSTC
Transaction Codes
7
TSP01
Spool Requests
8
PAT01
Support Package Status
9
PATCHHIST
History of Kernel Patch
10
RZLLICLASS
Logon Groups
11
DBSTATC
List of Tables for statistics update
12
SDBAC
Commands and parameters for DB13
13
USR40
Password Exception List
14
TSP01
Spool Requests
15
TST01
TemSe data

Wednesday, December 22, 2010

Useful Reports in SAP Financial Accounting

GENERAL LEDGER

Information Systems

1. Structured Account Balances (Balance Sheet & P&L Account in FS Version Format)

S_ALR_87012279
2. GL Account Balances (Totals & Balances ) S_ALR_87012301
3. GL Line Items S_ALR_87012282
4. Statements for GL Accounts, Customers & Vendors S_ALR_87012332
5. Document Journal S_ALR_87012287
6. Compact Document Journal S_ALR_87012289
7. Line Item Journal S_ALR_87012291
8. Display of Changed Documents S_ALR_87012293
9. Invoice Numbers assigned Twice S_ALR_87012341
10. Gaps in Document Number Assignments S_ALR_87012342
11. Posting Totals Document Type wise S_ALR_87012344
12. Recurring Entry Documents S_ALR_87012346

Master Data

13. Chart of Accounts S_AL:R_87012326
14. GL Account List S_AL:R_87012328
15. Display Changes to GL Accounts S_ALR_87012308
16. Financial Statement Version FSE2

CASH & BANK REPORTS

1. Check Information List FCH6
2. Check Register FCHN
3. Check Number Ranges S_P99_41000102


TAX REPORTS & REGISTERS

1. List of Internally generated Excise Invoices J1I7

2. Capital Goods Transfer of Credit J2I8
3. List of GRs without Excise Invoice J1IGR

4. List of Sub Contract Challans J1IFR

5. CENVAT Register J2I9
(Monthly Return under Rule 57AE of the Central excise Rules from
which Monthly Return under Rule 7 of the CENVAT Credit Rules 2001)

6. Registers : RG 23A/C Part I &II , RG1, PLA J1I5,J2I5,J2I6

ACCOUNTS RECEIVABLE

Information Systems

1. Bill Holdings (Bill of Exchange Receivable List with ALV facility)
S-ALR_87009987
2. Customer Balances in Local Currency S_ALR_87012172
3. Customer Line Items S_ALR_87012197
4. Due Dates Analysis for Open Items S_ALR_87012168
5. List of Customer Open Items S_ALR_87012173
6. Customer Evaluation with Open Item Sorted List S_ALR_87012176
7. Customer Payment History S_ALR_87012177
8. Customer Open Item Analysis (Overdue Items Balance) S_ALR_87012178
9. List of Customer Cleared Line Items S_ALR_87012198
10.List of Down Payments open at key date S_ALR_87012199
11. Debit & Credit Notes Register – Monthly S_ALR_87012287
12. Customer wise Sales S_ALR_87012186

ACCOUNTS PAYABLE

(Note : Similar Reports available for A/R are available for A/P also)

1. Vendor Balances S_ALR_87012082
2. Vendor Debit/Credit Memo Register S_ALR_87012287

Report displaying Master data, that is a list of vendors showing name, address, payment
method, etc., also displays all vendor master data too.

Path:
Financial Accounting -> Accounts Payable -> Information System -> Reports for AP accounting -> Master Data.

Withholding Tax along with Vendor Name (T-Code)
S_P00_07000134 - Generic Withholding Tax Reporting
S_PL0_09000447 - Withholding tax report for the vendor

Reports for receivables to be checked on daily basis:
Go to SAP Easy Access main menu.
Go To Accounting -> FI Acc -> customer(receivables) -> information system -> reports
To get all the standard reports for receivables.

Wednesday, December 8, 2010

Cross Client Concept in SAP

A client is defined as a self-contained commercial, organizational, and technical unit within an SAP System. This means that all business data within a client is protected from other clients. Each client has its own customer data, which can be considered as the exclusive property of this client.

However, the SAP System offers a system solution that is implemented for all clients in a central repository and cross-client tables (central data source).

As far as data administration is concerned, a multiple client option means that the data required for operating the system is well-defined and assigned either to central data or customer data. The following basic guidelines apply:

Only the assigned client can read or write to customer data, and in occasional cases (troubleshooting, background job administration, or change management) the provider. Customers can never read or write to the data of another customer.
All clients can read the centrally stored data, however, only the provider can make changes, not any of the clients (end customers).
Integration

SAP data models map customer data to client-specific tables, and central data to cross-client (or client-independent) tables. The cross-client data includes the Repository itself, but also a set of cross-client control data, which is described in more detail later in the document.

The client is included in the data model as a mapping of the Customer entity, in addition to the business application solution. This means that the client does not contribute to the modeling of the application solution. Instead, it makes sure that all data created during business processes is assigned exclusively to its owners (clients).

Client-specific customer data includes all application tables (master data and transaction data), as well as a large number of Customizing settings.

Application tables
These are tables that hold business data such as master data or transaction data. This data can be created, changed, or deleted at any time by regular business processes. Application tables have the attribute Delivery Class and attribute value A in the ABAP Dictionary.

Customizing tables (business-relevant)
These tables hold data that is influenced by business processes, such as

Data that represents the organizational structures of the enterprise
Parameters that control business processes.
In addition to the client-specific Customizing tables, there is also a range of cross-client Customizing tables. Because Customizing objects are numerous and varied we will categorize and explain them in more detail, including their relationships with clients, in the following section.

There are often strong mutual dependencies between Customizing tables. For this reason, tables are not maintained individually, but as Customizing objects. The formal relationships integrated into a Customizing object makes sure that it remains consistent in its table group when you edit its entries. In the following we speak about Customizing objects when we mean the representation of Customizing tables on the user interface, and about Customizing tables when we mean their concrete form on the database.

A Customizing object can contain both client-specific tables and cross-client tables. We speak of client-specific objects if all tables maintained through this object are client-specific. Likewise, if at least one cross-client table maintained through the object can be changed, then the object itself is cross-client. Remember that an object is client-specific if it contains one or more cross-client tables whose values can only be displayed or read, and not changed

Monday, November 29, 2010

SAP Finance Tables

Table Name | Table Description

AGKO Cleared Accounts
ANAR Asset Types
ANAT Asset type text
ANEK Document Header Asset Posting
ANEP Asset Line Items
ANEV Asset downpymt settlement
ANKT Asset classes- Description
ANLA Asset Master Record Segment
ANLB Depreciation terms
ANLC Asset Value Fields
ANLH Main asset number
AT02T Transaction Activity Category- Description
AT02A Transaction Code for Menu TIMN
AT10 Transaction type
AT10T Name of Transaction Type
BKDF Document Header Supplement for Recurring Entry
BKORM Accounting Correspondence Requests
BKPF Accounting Document Header
BLPK Document log header
BLPP Document log item
BLPR Document Log Index and Planned Order (Backflush)
BNKA Bank master record
BP000 Business Partner Master (General Data)
BPBK Doc.Header Controlling Obj.
BPEG Line Item Total Values Controlling Obj.
BPEJ Line Item Annual Values Controlling Obj.
BPEP Line Item Period Values Controlling Obj.
BPGE Totals Record for Total Value Controlling obj.
BPJA Totals Record for Annual Total Controlling Obj.
BSAD Accounting- Secondary Index for Customers (Cleared Items)
BSAK Accounting- Secondary Index for Vendors (Cleared Items)
BSAS Accounting- Secondary Index for G/L Accounts (Cleared Items)
BSEC One-Time Account Data Document Segment
BSEG Accounting Document Segment
BSID Accounting- Secondary Index for Customers
BSIK Accounting- Secondary Index for Vendors
BSIM Secondary Index, Documents for Material
BSIS Accounting- Secondary Index for G/L Accounts
CEPC Profit Center Master Data Table
CEPCT Texts for Profit Center Master Data
COBRA Settlement Rule for Order Settlement
COBRB Distribution Rules Settlement Rule Order Settlement
COKA CO Object- Control Data for Cost Elements
COSP CO Object- Cost Totals for External Postings
COSS CO Object- Cost Totals for Internal Postings
CRCO Assignment of Work Center to Cost Center
CSKA Cost Elements (Data Dependent on Chart of Accounts)
CSKB Cost Elements (Data Dependent on Controlling Area)
CSLA Activity master
FEBEP Electronic Bank Statement Line Items
FPLA Billing Plan
FPLT Billing Plan- Dates
GLPCT EC-PCA- Totals Table
KNA1 General Data in Customer Master
KOMK Pricing Communication Header
MAHNV Management Records for the Dunning Program
REGUT TemSe – Administration Data
SKA1 G/L Account Master (Chart of Accounts)
SKAT G/L Account Master Record (Chart of Accounts- Description)
SKB1 G/L account master (company code)
T003T Document Type Texts
T007S Tax Code Names
T087J Text
TAPRFT Text tab. for investment profile
TKA01 Controlling Areas
TKA09 Basic Settings for Versions
TKVS CO Versions