Wednesday, February 23, 2011
Friday, February 4, 2011
How to delete a BRS statement in SAP
How to delete a BRS statement uploaded through FF67
Program: RFEBKA96
Execute
Enter "0001" in Application Field (0001 = Electronic and Manual Bank Statement)
Execute
In the next following screen DESELECT all other bank statements and select the ones which needs to be deleted.
Click on "DELETE STATEMENTS"
*Done*
CAUTION: Do not delete the bank statements that are posted correctly. However, only those bank statements are deleted which are posted in sub-ledger account. Bank statements which are POSTED to G/L Accounts are not deleted.
Step 1:
TCode - SA38Program: RFEBKA96
Execute
Enter "0001" in Application Field (0001 = Electronic and Manual Bank Statement)
Execute
In the next following screen DESELECT all other bank statements and select the ones which needs to be deleted.
Click on "DELETE STATEMENTS"
*Done*
CAUTION: Do not delete the bank statements that are posted correctly. However, only those bank statements are deleted which are posted in sub-ledger account. Bank statements which are POSTED to G/L Accounts are not deleted.
Labels:
Deleting BRS Statement
Friday, December 24, 2010
Important Basis T-Codes & Tables
Serial No. | Transaction Code | Usage |
1 | Making entry for New Client Changing client properties | |
2 | Importing Change request within the same server in a different client | |
3 | Delete a client | |
4 | SCCL | Local Client Copy |
5 | Remote Client Copy | |
6 | 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 | |
13 | ST02 | |
14 | ST05 | Trace Analysis |
15 | ST06 | Operating Systems Analysis |
16 | OSS1 | |
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 |
23 | SM13 | View / Manage |
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 | |
38 | SM01 | Lock / Unlock Transaction |
39 | SM02 | Create / Send Messages |
40 | SU01 | User Maintenance |
41 | PFCG | Role Maintenance |
42 | SLICENSE | Applying |
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 | Import Post-processing | |
52 | SU21 | Maintain Authorization Objects |
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 | 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 | 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.
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.
Subscribe to:
Posts (Atom)


