Sap Accounting

 

FI Module Reporting Tools:

OKSA : Genegate reports

FSI0 : Balance Sheet Report
FSI1 - Create report FI - Information System
FSI4 - Create Form FI - Information System
FXI4 - Create Form FI - Information System
FXI0 - Execute report FI - Information System
FXI2 - Change report FI - Information System
FDI0 - Execute report FI - Information System

FDI5 : Change FI Forms
FI-AP Module Reporting Tools:

VENDOR
FKI5 - Formular FI - Information System
FKI1 - Create report FI - Information System
FKI2 - Change report FI - Information System
FGI4 - Create Form FI - Information System
FGI1 - Create report FI - Information System

 

FICO :

KE34 - Create form CO - Profitability Analysis
KKRV - Data Collection Product drilldown CO - Product Cost Controlling Information System
KE35 - Change form CO - Profitability Analysis
KE3E - Maintain Global Variables CO - Profitability Analysis
KKO0 - Run drilldown report CO - Product Cost Controlling Information System
OKN0 - Control of CO-PC Information System CO - Product Cost Controlling Information System
MCBG - INVCO: MRP Cntrlr Analysis Selection MM - Inventory Controlling

Others:

GCRE1 - Activate drilldown rep. for SL table FI - Basic Functions
KE81 - EC-PCA: Create Drill-Down report Enterprice Controlling - Profit Center Accounting
OKQ3 - Define Reference Character. (Orders) CO - Product Cost Controlling Information System
KKO3 - Display drilldown report CO - Product Cost Controlling Information System

 

Reference:
http://scn.sap.com/community/erp/financials/blog/2013/02/22/vendor-aging-analysis-through-sap-report-painter
https://scn.sap.com/thread/1371715
https://wiki.scn.sap.com/wiki/display/ABAP/Create+t.codes+for+Drilldown+reports+in+FGI0+transaction

https://sites.google.com/a/sapland.com/main/sap-business-processes/fi-modules/internal-order-tcode

0 Comments

1. Recurring Documents.
• Create Recurring documents
• Create Batch Input for Posting Recurring Documents
• Run the Batch Input Session
2. Posting Accruals or Provisions entries at month end
3. Managing the GR/IR Account-Run the GR/IV Automatic Clearing
4. Foreign Currency Open Item Revaluation-Revalue Open Items in AR.AP
5. Maintain Exchange Rate
6. Run Balance Sheets –Run Financial Statement Version
7. Reclassify Payables and Receivables if necessary
8. Run the Depreciation Calculation
9. Fiscal Year Change of Asset Accounting if it is year end
10. Run the Bank Reconciliation
11. Open Next Accounting Period

0 Comments

You want to delete or repost CO documents created during postings for external accounting (FI, MM, SD).

During repeated re postings to CO, CO documents are created more than once if you do not use the "Check for existing records" option.

First, use program RKACOR20 to delete the incorrect CO documents. For this, enter the company code, the fiscal year and the document number of the FI documents. With parameters PPROT and PTEST you can control by entering "X" whether a detailed log is created or whether the program is executed in test mode, that is, without posting.

Afterwards, you can use Transaction OKBA to subsequently post the deleted CO documents for source document from FI, OKBB for source document from MM and OKBC for source document from SD. Enter the company code, fiscal year and document numbers, select the "Test run" and "Log" options, always select the "Check for existing records" option (if the option is displayed on the screen) and delete the defaults for the "Transaction" and "Document origin" fields.
Notes:
When you delete and repost CO documents, the system also updates the data in the reconciliation ledger.
If it is not possible to repost the CO document for the reversal of a billing document, then this may be due to the fact that the CO document for the reversed billing document has also been deleted and not yet reposted.

Please note:

1. Transaction OKBB (Subsequent posting from MM document) is based on database table ACCTIT (see also Note 48009). If the update of that table has been deactivated, you can no longer use Transaction OKBB . The CO document can then only be posted from the FI document (OKBA), but not completely posted subsequently.
2. Before starting to delete documents, please check whether the correction from Note 356608 has been applied to your system.
3. Deleting and subsequently posting CO documents may be problematic, if one of the following actions already exists for the document:

• Line item settlement to internal orders or projects
• Line items are intended for expense-related invoice or invoiced
• Assessments for the period
• Line items were transfer posted
• Document was reversed

The last two items can be checked under 'Follow-up CO documents' using Transaction RKABSHOW. If the document is a reversal document that was posted from external accounting into CO, the document header fields COBK-STOKZ and COBK-STFLG show whether a document was reversed or is a reversal document. In such cases, reverse the transaction before deleting and subsequently posting a CO document (i.e. reverse line item settlement or transfer posting) and repeat it after repairing the document. If this is not done, document references may no longer be correct, and documents may be settled twice (separately), transfer posted, etc. Normal settlement do not cause any problems since possible differences are not taken into account in the next settlement run.

If you delete a reversed document or a reversal document, also delete (and subsequently post) the associated reversal document/reversed document. Please make sure that the reversed document is posted prior to the reversal document.

Q&A Database

• Cancel check by mistake in FCH8

• How to create a recurring document or a sample document.

• How to move SAP servers to a virtual machine ?

• How to set up commission for saleman?

• What is difference between Upgradation and Rollout Project?

1 Comment