Showing posts with label SAP GEN. Show all posts

SAP FICO Reports : Most Used & Most Important

Report Name	Transaction Code	Purpose
General Ledger:
Recurring Entry Documents	S_ALR_87012346	You are able to determine which documents: · are carried out in a particular time period · are not carried out · are carried out during the next run of the recurring entry program
G/L Account Statements	S_ALR_87012332	You use this Report to create Statements for Customers / Vendors / G/L Accounts. The primary difference between this report and other item lists for the entry view (line item lists for customers, vendors, and G/L accounts) is that it can be used to produce item lists for G/L accounts without line item display in the entry view.
Financial Statement	S_ALR_87012284	You use this report to create the balance sheet and profit and loss statements for a user-defined reporting period within a fiscal year with absolute and relative comparisons for a comparison period.
Financial Statement: Actual/Actual Comparison	S_PL0_86000028	You use this report to compare actual data within a certain period to reference data from another period.
Compact Document Journal	S_ALR_87012289	You use this report to display the most important data from document headers and items in table form for the selected documents. The list can be used as a journal and for reconciliation with the lists of account balances (accounting reconciliation).
Line Item Journal	S_ALR_87012291	You use this report to create an overview of the selected posting documents.
Advance Return for Tax on Sales/Purchases	S_ALR_87012357	You use this report to create the advance return for tax on sales/purchases. If required, you can also create a batch input session for automatic transfer posting of tax payable or fill out the tax return.
Chart of Accounts	S_ALR_87012326	You use this report to display G/L account master data that is not specific to the company code and print out G/L account lists.

Fixed Assets:
…by cost center	S_ALR_87011979	You use this report to create a fixed asset report by cost center.
…by asset class	S_ALR_87011981	You use this report to create a fixed asset report by asset class.
Asset Balances	S_ALR_87011994	You use this report to create an Asset Balance and display values of fixed assets.
Asset Transactions	S_ALR_87012048	You use this report to display asset transactions. For each document, the report shows: · the change to the acquisition and production costs · the change to the value adjustments · the ordinary and special depreciation planned for this transaction
Asset Acquisitions	S_ALR_87012050	You use this report to display asset acquisitions.The following is displayed for each document: · Acquired APC · Acquired quantity · Planned ordinary and special depreciation for the acquisition
Asset Retirements	S_ALR_87012052	You use this report to display asset retirements.Each document shows the · Retired acquisition and production costs · Retired quantity · Retired proportional depreciation · Earned revenue · Gain/loss · Possible retirement costs

Cost Element Accounting:
Controlling Documents: Actual Costs	KSB5	You use this report to display actual cost documents. The program creates a Document with all actual Costs as required.
Internal Orders: Master Data Report	KOK5	You use this report to display Internal Order Documents.

Cost Center Accounting:
Cost Centers: Actual/Plan/Variance	S_ALR_87013611	You can use the Report/Report-Interface to access the following reports: · Cost Centers: Actual Line Items · Cost Centers: Planning Overview · Cost Centers: Plan Line Items · CCtrs: Period Breakdown Actual/Plan · Activity Types: Period Breakdown · Stat. Key Figs: Period Breakdown · Cost Centers: Breakdown by Partner · Cost Centers: Breakdown by B.Trans. · Area: Actual/Plan 2 Currencies · Display planning long texts
Range: Cost Centers	S_ALR_87013612	You can use the Report/Report-Interface to access the following reports: · Cost Centers: Planning Overview · Cost Centers: Actual/Plan/Variance · Area: Cost Elements · Cost Centers: Breakdown by Partner · Cost Centers: Breakdown by B.Trans
Range: Cost Elements	S_ALR_87013613	You can use the Report/Report-Interface to access the following reports: · Cost Centers: Actual Line Items · Cost Centers: Plan Line Items · CCtrs: Period Breakdown Actual/Plan · Cost Centers: Planning Overview · Cost Centers: Breakdown by Partner
Cost Centers: Planning Overview	KSBL	You use this report to create a planning overview for all cost centers.
Range: Actual/Budget/Commitments	S_ALR_87013648	You use this report to create an overview for each cost center of the · Actual costs · Commitments · Allotted costs · Budget
Cost Centers: Activity Prices	KSBT	You use this report to create a List of Activity Prices by Cost Centers or Cost Center Groups

Internal Orders:
Orders: Actual Line Items	KOB1	You use this program to create a report for Actual Line Items for Orders.
Orders: Commitment Line Items	KOB2	The program creates a Report for Commitment Cost Line Items for Orders as required.
List: Orders	S_ALR_87012995	You use this program to create a List of all Orders by Controlling Area for a Plan/Actual Comparison.
Orders: Actual/Plan/Variance	S_ALR_87012993	You use this program to create an overview of the actual and plan data on internal orders in the reporting time frame for each Cost element, Cost element group and Statistical key figure.
Order: Planning Overview	KABL	You use this program to create a planning overview by Order.
List_ Budget/Actual/Commitments	S_ALR_87013019	You use this program to create a List concerning Budget/Actual/Commitments for Internal Orders.

Profitability Analysis:
Execute Report	KE30	You use this program to create several profitability reports. · Execute Drilldown Report Plan/Actual Sales Detail List · Execute Drilldown Report Plan/Actual Sales Mat. Costs · Execute Drilldown Report Plan/Actual Sales OH Costs · Execute Drilldown Report Reconciliation

Information System:
Costs/Revenues/Expenditures/Receipts	S_ALR_87013531	You use this program to create a Cost/Revenues/Expenditures/Receipts report for projects.
Actual/Costs/Revenues	CJI3	You use this program to display Project Actual Cost Line Items.

Product Costing
Multilevel BOM: Value / Amount / Status	CK86_99	You use this transaction to create a List concerning costed BOMs.
Cost Component	CK80_99	You use this transaction to create a List concerning Cost Components of the Cost Estimate.
Itemization	CK84_99	You use this transaction to create a List concerning Itemization of the Cost Estimate.
Cost Elements	KKBC_MAT	You use this transaction to create a List concerning Cost Elements of the Cost Estimate.
Analyzing/Comparing Material Cost Estimates	S_P99_41000111	You use this transaction to create a List to compare Material Cost Estimate.
Analyzing Product Cost Collector	KKBC_PKO	You use this transaction to create a List to analyze Product Orders.
Analyzing Product Order	KKBC_HOE	You use this transaction to create a List to analyze Product Orders.

Why do we need to DEBUG : BREAK POINT : WATCH POINT

DEBUG

We write programs to achieve certain functionality and like other actions, we make mistakes while writing the code. If they are not trapped at the right time, problem becomes bigger, and bigger and bigger.

BREAK POINT

The BREAK POINT is a debugging aid. When we run a program normally, it is interrupted at the statement, and the system automatically starts the debugger, allowing you to display the contents of any fields in the program and check how the program continues. If the program is running in the background or in an update task, the system generates a system log message.

SAP Upgrade – Key points to remember

Purpose of this post - to highlight why customers across industry need SAP ERP upgrades & how effectively these upgrade projects can be executed. This document also covers actual upgrade experience of customer XYZ Corp.

Note: Above given points covered in one link only.

SAP GUI Scripting and GuiXT

With SAP GUI 6.20, SAP introduced a "scripting API": an object model that represents a screen with its controls at runtime. In Windows environment the API can be used from any tool that supports the COM object interface, especially from the VBScript and JavaScript languages. The object model allows one to automate all user actions.

Unlike GuiXT, the SAP GUI scripting approach is not intended to change the screen layout. It completes the GuiXT functionality, allowing us to manipulate special controls (like the grid control) that GuiXT cannot handle directly, but is restricted to actions that a user is able to do as well.

With GuiXT 2004 Q2 3 and above, you can combine the two approaches. Use the new keyword "ApplyGuiScript" in a GuiXT script or an InputScript in order to perform further actions on the screen via a VBScript.

The general procedure, clarified with a few examples, is set out below.

1 Requirements

SAP GUI 6.20 and upwards
GuiXT 2004 Q2 2 and upwards
For SAP kernel 3.1I-6.10: kernel patch required, see SAP note 480149
For SAP kernel 6.20 and above: Included in standard delivery
It is necessary to activate scripting support in the SAP system, and in the SAP GUI options
Not possible in ITS environment (SAP GUI for HTML)

2 SAP documentation

Please see the following SAP notes concerning SAP GUI scripting:

480149: Kernel patch requirements
587202: Limitations of SAP GUI scripting
527737: Composite SAP note on SAP GUI scripting
612454: Status and Lifetime
619459: SAP GUI Scripting support of SAP applications

for more .........

Data Migration - Master Data - Transaction Data - Open Item Load

Data Uploading Process:

1. Master data (GL accounts, customers, vendors, assets, cost elements, cost centers, profit centers etc.)

2. Transactional Data (Open Items for customers and vendors, GL line items, Cost Center planning, profit center plan data load etc.)

In the first case mostly you can use LSMW, if you are conversant. The following document is useful to you.

http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc

Note: No template is suitable for you, because, your configuration is different and their configuration is different, field status of various fields must be different. Therefore, follow the above document and start from fresh with recording. Recording is more or less sufficient for master data.

In the second case, you create 5 Offsetting accounts + one main offsetting account.

1. Vendor Offsetting Account
2. Customer Offsetting Account
3. Asset Offsetting Account
4. GL Offsetting Account
5. Stock Offsetting Account

At the end of the day, the total balances within these accounts must be ZERO. Make ZERO these accounts and transfer the balance to MAIN offsetting account. Once you have done this, make sure you have blocked all these accounts.

Technically, in second case, you should take help from ABAPer to write BDC, particularly in case if your entries are having different line items. For example your first document is having 5 line items and second document is having 10 line items, in such case LSMW recording will not work. You can depend on some standard SAP programs to map the LSMW. If you are not conversant with how to map, then you can refer the following document posted by Naimesh.

https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/10646

Still, if you are not able to map, then there is no other way, you need to depend on ABAPer for uploading the transaction data through BDC. He / she will create a program and a customized transaction code for you and provide you the format. You may have to help the ABAPer with your requirement what you are exactly looking to upload.