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

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.

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