SAP Programming Finance Cost Center Actual Line Items Report

SAP Finance cost center report lists individual line items that post to the selected cost center or cost center group. At the time the line items list, additional fields can be accessed to assist a cost center manager in monitoring the actual costs being posted to the cost center.

A cost center manager may often use this report to reconcile postings between the General Ledger (G/L) and cost centers, and to monitor the actual postings made to a particular cost center. This report may also assist a manager in searching for particular information, such as a specific material or purchase order posting.

How to run this abap report?

To run this sap fico report, use one of the following access options:

1. Information systems → Accounting → Overhead costs
2.Cost centers → Line items → Actual

In the Command field, enter transaction KSB1 and choose Enter.

Prerequisites:

You must set the Controlling area before running the sap programming report.

Choose Accounting →Controlling → Cost centers → Environment → Set controlling area.

For the examples in this section, the controlling area is set to 2000.

You must enter a value in the selection fields before running the report. You may leave the cost center and cost element selection blank, so that all cost elements are selected. If you enter cost center groups and cost element groups, they must have already been set up. If they contain subtotals, hierarchy nodes should be created within the groups. Each hierarchy node then subtotals in this report.

To display the original document, we can double-click on a line item in the actual line item report. For example, if a material posting was made to the cost center, drill down on a cost center line item to list actual costs contained in the original material document. If a direct financial journal entry was made, drill down on the cost center line item to display the original financial document.

Example cost center report for sap with screen shots

A reconciliation takes place at the end of the month to ensure that the postings in the different modules, such as the G/L and cost center accounting, are balanced. In this example, the postings
are displayed for only one cost center.

To access the first screen for this report, choose

Information systems → Accounting → Overhead costs Cost centers → Line items → Actual.

The sap screen shows the following important points.

Each number indicates the following.

1. Enter 4277 in Cost center. You can also enter a range of cost centers, or a cost center group.
2. Enter OAS-TOTAL in Cost element group.
3. Enter a date range to limit the number of postings to the selected internal orders (for example, 01/01/1997 to 12/31/1997).
This report may also be run for dates that span fiscal years.
4. Enter 1SAP in Display variant. This lists cost element detail for each line item.
5. Choose Further settings.

The Variant fields only checkbox should remain deselected for purposes of this e spa programming example. This increases performance in selecting actual line items and also makes it possible for you to change the line item display after you make the database selection. If the Variant fields only checkbox is selected, only the fields relevant to the first display variant entered are selected from the database and made viewable.

6. Enter 5.000 in Maximum no. of hits. (Additional records—even if they fall within the date range— will not appear.)

7. Choose Enter, then Execute .

This sap screen shows the list of actual line items for the cost center.

8. Choose Subtotal in the abap screen.
9. The current subtotals are based on the cost center field. Deselect the subtotal for the sap fico Cost center, and select the subtotal for the Cost element.

10. Choose Copy.

This screen shows the subtotals based on the cost elements within the cost center. (This allows for easier reconciliation of the General Ledger.)

You may be also interested in the following SAP Finance reports.

Related PostsSAP Finance General Ledger report account balance
Finance general ledger line items SAP ABAP report
General ledger report SAP FINACNE
SAP FICO customer open items report

eRP implementation process and its advantages
What is ASP.NET?

ERP Implementation Process and its Advantages

Justify Full Implementing enterprise resource planning is a big and challenging job and it has to be implemented in different stages in the company or business entity.

There are standard practices in erp implementation and following them is advisable.They are being developed after a through study and company shall consider them.
The first stage of basic erp implementation is done in phases in major areas like sales,materiel procurement,scheduling,finance and accounting departments.

In second state of implementation sales and supply chain integration is done with erp.

In stage three extensions are made for the existing erp strategy.

There is no limit for phase three of erp implementation and it is a continuous process.

Before going for erp implementation the

1. Management team shall learn about erp in detail.
2. Vision document shall be prepared.
3. Cost and benefit analysis shall be made.

If the company is happy about this analysis, it shall commit for implementation in a aggressive way in a stipulated time frame.

ERP implementation shall be scheduled by business function and not by software installation.

Let the general manager who is the project leader of the erp project guide the software company about ES software installation which phase first and taking the business function as a priority is most important thing.

ERP is not computer software installation but a management project which helps them to perform better.

To implement ERP companies prefer using staggered approach and it has several advantages.



The advantages of implementing enterprise resource planning in the staggered approach are

1.ERP can be implemented quickly.
2.Resources avilable can be used effectively.
3.Meterial requirement planning can be done easily as one plant one time.
4.Employes who praticipated previouly in the process can teach to the others.

Sales and operatons is first priority which does not need enterprise software and will start showing results quickly.

Some times to get business function we need a new software or modifications for existing sofrware and it has to be seen in terms of business function.

Documenting the old business process in detail before ERP implementation may waste a lot of time and only important things shall be documented.Even new ERP system need not be documented in detail and identifing proper erp tools required for the business is important.

Request you to share this over the net.



Related Posts

Challenges in implementing ERP

ERP implementation practices
Enterprise resource planning introduction
ERP software selection
ERP project and project leader
General ledger report SAP FINACNE

Here is an a blog that deals with Active Server Pages in Dot net complete Course

ERP Implementation Challenges

Implementing enterprise resource planning is a lot of work for an company as it is a new way of understanding the business process of demand and supply and with erp software information across the branches flows very quickly and decisions shall be taken at the same speed.

ERP shall be implemented with insiders of business and outsourcing it will always creates problems.

Some high level people of the company shall do this job besides their regular job which generally takes the toll of the quality of implementation.

The people who use erp tools shall participate in implementing erp practices.The time of implementation is critical and takes a lot of pain in the process.High level people of the company shall do this double job which makes very difficult to run the process of erp.

With ERP people shall start acting more quickly and they must accustom for this.ERP produces good results when it is implemented correctly.

It shall have aggressive schedule and proven path for implementation.

Taking a time more than a year takes its seriousness and positive feeling of getting changed for for better business away and leads no where.

Temporary Change in the business shall not effect the implementation of erp and its software.

During implementation of erp time,resources and work shall be taken into consideration and plan
shall be laid down for it.

So erp implementation can be divided into parts like different departments and they can be integrated at the later stage .This gives the advantage of seeing the results in one department and hence resources can be effectively utilized by the next departments.

At first the top level executives of company shall know what is enterprise resource planning is

how it gives benefits ?

what is their role during and after implementation?

how data is integrated ?

All this questions shall be answered before starting the erp process.

A executive committed shall be formed with project team, and a full time project leader for implementing erp.

Every one in the company shall be trained about their new way of doing the job and its benefits.

All this steps shall be followed in the name and spirit for better results so that there is word like erp is failed.

As it is said it is not the failure of erp but the people who has not understand it properly and not implemented correctly.

Related Posts

ERP implementation practices
Enterprise resource planning introduction
ERP software selection
Implementing a SAP project
Customer relationship management introduction

ERP System Implementation Practices

Implementing ERP system in any company is a vital part of going to the next level and here are the things that has to be taken care during erp implementation.

ABC Approach of erp and software installation :

-->For erp system implementation the general approach followed is ABC approach where in part A very important things are placed who are vital for any business. In part B a bit less significant and in part C least significant items are placed in the plan.

The funny part is the computer its software and hard ware are in kept in part C .Yes they are need but least significant.

In part B we have data of the business like inventory and bill of materials for analysis .

See here for an introduction of enterprise resource palning system introduction.

In part A the most significant part people are placed. They shall understand the process properly so that they can record the data accurately.

If the information fed to erp system is inaccurate results will be pathetic and blaming it for that is not correct as it is working on the data given to it. It is the set of people who implemented erp who failed but not ERP.

Financial reports shall developed by the people at lever one basing on the data available and it helps at all levels and make the business better. So erp implementation at level one that is people at the high level understanding it correctly is very important for the success of erp.

ERP does not mean implementing a enterprise software like our SAP or people soft or Oracle but blending it into the needs of company and understanding it better for the better performance.

Thus understanding the needs of company and implementing enterprise resource planning system is a time taking process and it is worth of it. Hence People who are operating the business shall play a crucial role in implementation of erp. If the company is not able to spend that much of time on it first it shall implement the enterprise resource software and implement it step by step starting from sales and service strategy for customers ,customer relationship management, who is vital part.

System applications and products pronounces as SAP R/3 is the leading enterprise software which helps in implementing ERP in big companies.

Request you to share this at your favorite social media.


This SAP ABAP Programming blog also consists of series of lessons about the following SAP ABAP topics.

Related posts :

Enterprise Resource Planning System Introduction

Enterprise Resource Planning System is a business process which gives a wonderful advantage to the business over the others. With the help of erp software and system there is a very good business integration and to take decisions data is readily available with the implemented erp software.

What is Enterprise Resource Planning ?

ERP software consists of tools that help an organization in understanding the demand and supply of product and making the right kind of decisions. It can link the suppliers and customers chain. ERP systems help in integrating different units of business like sales,finance,human resources, materiel management effectively which helps in producing better sales and results. This improves the customer satisfaction levels and hence business.

ERP helps in shipping the product on time and makes a customer happy about the company and he may even spread the good will of the company.

A good erp Software can give a you accurte data on real time basis and decisions can be taken quickly and accurately.

When it is effectively used it can improve the coordination between the different departments of company .

Prior to Enterprise Resource Planning, meterial requirement planning is there which helps the company in procuring raw materials.

Enterprise Resource Planning is a set of business rules which is very effective when dealing with multiple departments of a business. It consists of set of tools regarding forecasting of the business, planning and scheduling.

Enterprise resource planning helps in coordinating different units of a business effectively with a seamless integration.All units are going to use same kind of software and tools and understand in a better way.

It is a software tool which helps in forecasting, scheduling and planning besides materiel production.

Having erp tools is the not only important thing and understanding and using them properly is also very much important for any business.

Well I will stop here and this discussion will be continued in the coming posts.
Your opinions and comments about Enterprise Resource Planning System Introduction are most welcome.

Request to spread a word about this article at your choice of social media with the help of below share button and a big thank you for the support.


Related posts about erp are

ERP implementation process
Implementation challenges of erp
Smart Forms
Work Flow

CRM Management Customer Sales Service Stratagy

Customer relationship management has the key job of keeping the customer satisfaction levels high during the process of sales and service and organization shall make a good strategy with the help of crm software.

Any business growth depends on how well they are managing the customer relations.
CRM will help the organizations to improve their customers, relations and business.
Planning a proper strategy for customer relationship management is very important for successful business model.
Getting a customer and making him a regular customer is very important for any one who want to be successful in their business.
Selling some thing is just a beginning of the customer relationship and the relationship shall go ahead for the further business.
Extending the business can be done with the help of CRM software with a good strategy which can improve the customer satisfaction for which customer service is very important.
Sales and service shall work together to make a company a successful and crm software shall help it.
The organizations shall make the comfortable at the sales place and explains the goodness of their product. Actual relationship starts here and giving enough scope for the customer is important .
Identifying a customer who is coming back and giving a better deal as a token of gesture will make the business better.
CRM strategy shall help the employees for this entire process like identifying the repeated customers and giving them a feel like home.
CRM stall identify the customers who feel good about the products and business and spread the good will by the word of mouth.
Depending on the kind of business customer sales and service profiles models are different.
-->
Pyramid profile model:
-->
The level one are regular customers .
Level two are the customers who comes back for business.
Level three are the people who spreads the good will of the business.
Hourglass profile model:
This is a case of model where customer may not be able to come back for the business because of high cost transactions but they do spread the good will which makes the level two smaller but level there better.
Hexagon profile model :

In this model initial transactions are small in base but they used to come repeatedly and spared the good will even better. This model works for a small business and there shall not be a gap in supply and demand. Keeping the existing customers happy and committed is very important in this model.
Asking the customer for feed back and getting answers with proper questions is very important in any customer relationship management .
Business model may use any one of this model or a bit modified one as per their requirement in Customer relationship management process.
Related Posts:
This blog consists of series of lessons about the following SAP ABAP topics.

Smart Forms
Work Flow
Communication Interface

SAP and Customer Relationship Management Introduction

Customer Relationship Management is the way of being good in touch with customer so that he will be coming back and hence a better business.

The base thing is to have a good relation with customer and providing him the best service that is possible so that customer will get the faith in the business.

When customer is king and the most important person of the business entire business plans shall roll as customer centric and keeping him happy is the key.

Every time creating a new customer is a costly affair and hence keeping the existing customer is very important and this can be done with better service.

CRM is a wonderful tool that helps to get and hold customers and hence help the business to grow.

CRM helps us to understand the market dynamics,demands,future requirement better and in a simplified manner.

Hence implementing crm software is very important in today's world to get better business.

Customer Relationship Management is a way of creating,maintaining and expanding customer relations further .

Customer Relationship Management software's generally deals with many departments like sales,IT,Finance and all vital departments.

CRM thinks about customer needs and how best the customer service can be done by and organization/company.

We have to analyze and understand what customer is habituated to buy and the patterns with this software.

For the customer satisfaction the employer of the company being happy and satisfied with his job is important so that he can concentrate on customer needs better.

CRM software shall add value by helping the customer to identify the right product and suggest it for him.

Customer Relationship Management software is about making customer loyal to organization with extra added value so that he will be coming back again and again.

This will improve the company profits and reduce the cost of money that is spent on advertising etc.

With crm software the organization also need a well planned strategy to sustain the business only only software is not going to make miracles.

strategy is not a software technology that comes automatically that shall come from organization and that makes the difference from others.

CRM software is like a dictionary is wonderful database of words, but a dictionary can’t write a letter for you. Strategy plays a important role in keeping the customer satisfaction levels better.

A CRM shall group all departments of organization and a role shall be there for all employees of the company to make it better with CRM.

The software of CRM shall be customer and user friendly.

The software shall give a better shopping experience .

Well this is the basic aim any customer relationship management software and i announce that i am going to cover this topic extensively further regarding this in the broader scene and regarding SAP CRM also in specific.

Your feed back regarding adding the new dimensions and topics like CRM,finance module,to this ABAP Programming blog is most welcome.

Related Posts about CRM:

CRM sales and service strategy
SAP CRM an introduction to customer and business
Customer balance in local currency for SAP FICO

SAP Finance ABAP report for code cost center Overview

SAP Finance and controlling ABAP report which deals with cost center summery is discussed here.

This SAP fico report is default in build report and you need not write any single line of ABAP code provides a summarized view of the costs, activities, and statistical key figures that are posted to cost centers. The report includes both planned and actual postings, and calculates an absolute variance (difference), as well as a percentage of the variance.

A cost center manager would use this report to view planned costs and to monitor the progress of actual activity against the plan. The report allows for a consolidated view of multiple cost centers. The balance of the cost center is calculated from the debits and credits posted to the cost center. Any balance remaining in a cost center before month-end processing, either an over- or under absorption of costs, is usually assessed to other cost centers or to profitability analysis.

To run this ABAP fico report, use one of the following access options:

1.Information systems → Accounting → Overhead costs
Cost centers → Report selection

From the reporting tree, choose the following report:

Plan/Actual Comparison → CCtr: Actual/Plan/Variance → CCtr: Actual/Plan/Variance

2.Choose System → Services → Reporting and enter J1SIPTEX in the Program field.

Then, choose Execute to run the report.
Prerequisite for this SAP FICO report:

You must set the Controlling Area before running the report. Choose Accounting →
Controlling → Cost centers → Environment → Set controlling area. For the examples in this section, the controlling area is set to 2000.

You must enter a value in the selection fields before running the report. You may leave the cost center and cost element selection blank, and get a list that contains values for all cost centers and all cost elements in the selected controlling area.

If you enter cost center groups and cost element groups, they must have already been set up. If they contain subtotals, hierarchy nodes should be created within the groups. Each hierarchy node then subtotals in this report.

You can run multiple context-sensitive reports from this SAP controlling cost center report. For example, when you position the cursor on a cell for planned costs, only the reports that contain planned costs list data. If you select a cell for planned costs and run a report that only contains actual data, no data lists.

The SAP system displays four columns for all sections of the report, including actual postings, planned data, and a calculation of the variance between the two, both as an absolute and as a percentage value (calculated by dividing the actual data by the planned).

By double-clicking on any subtotals in the report, the detail that makes up each subtotal can either be hidden or displayed. For example, double-clicking on the Internal activities line will hide the cost element detail. To display this detail again, double-click on this line.

Example with screen shots :

A cost center manager wants to analyze the detailed postings for a cost center, including all planned and actual costs, planned and actual activities, and planned and actual statistical key figures.

To access the first screen for thisABAP FICO report, choose

Information systems → Accounting → Overhead costs
Cost centers → Report selection.

From the reporting tree, choose the following report:

Plan/Actual Comparison → CCtr: Actual/Plan/Variance → CCtr: Actual/Plan/Variance.

The screen shot is as shown here.

Each number of the screen shot is as explained below.

1. Under Selection values, enter 2000 in Controlling area.

2. Enter the year in Fiscal year (for example, 1997). This report runs for only one fiscal year at a time.

3. Enter 1 in From period and enter 12 in To period. This range includes all periods in the fiscal year.

4. Enter 0 in Plan version.

. Under Selection sets, enter 3200 in Or value(s). You can also enter a range of cost centers or a cost center group.

6. Enter OAS-TOTAL in Cost element group. This is the name of the group which contains all cost elements.

7. Choose Execute.

The output screens are as shown here.

The first screen of the report shows the cost elements, for which actual and planned costs are posted in the cost center.

Debits and credits are separated. If the cost element group contains hierarchy nodes, a subtotal is shown for each of these nodes. Absolute and percentage variances are also calculated.

Cost elements that are included in the cost element group, but for which no postings were made, are not shown.

The next screen of SAP finance report shows the cumulative costs posted to both primary and secondary cost elements, along with the absolute and percentage variances.

These costs are all the costs that posted to the order during the current fiscal year through the selected period.

SAP finance report UPDATE

9. Choose Previous columns to view the previous screen.

The previous screen appears.

10. Choose Page Down to view the remaining cost element data.

This section of the screen shows the remaining cost element data. For this example, all cost elements posted to the cost center did not fit on the previous screen.

11. Choose Page Down to navigate to the next block of data.



You may be also interested in the following SAP Finance reports.

SAP Finance General Ledger report account balance
Finance general ledger line items SAP ABAP report
General ledger report SAP FINACNE

SAP fico Report for Vendor Balances in Local Currency

This SAP finance and control (fico) ABAP report lists the vendor balances by vendor account number and reconciliation account. Vendor balances in local currency provides a high-level review of carry forward balances, current debit and credit balances for each vendor in the chosen period.

To run this sap fico report which is in build with out writing ABAP code, use one of the following access options:

1.Information systems → Accounting → Financial accounting
Accounts payable → Account balances

2.Choose System → Services → Reporting and enter RFKSLD00 in the Program field.

Then, choose Execute to run the report.

In the Command field, enter transaction F.42 and choose Enter.

You must make certain that both the fiscal year and reporting period is selected before running this ABAP report.

The output defaults to account sorting by 1, which means data sorts according to company code, then reconciliation account, and then the account number. Ideally, you should limit the report to criteria-based searches (for example, company code or a range of vendor accounts).

The selection screen of this sap fico report includes:

Variants
Dynamic selection options
User variables
Execution (and print) in background

Sample ABAP report with screen shots:

Create a list of all vendor balances for company 3000 for the year 1996.

To access the first screen for this report, choose

Information systems → Accounting → Financial accounting
Accounts payable → Account balances.

The input screen of SAP FICO report is as shown below for vendor balance in local currency .

Each point of the screen as explained as shown.

1. Enter 3000 in Company code.

2. Enter the year for which customer balances are to be reviewed (for example, 1996).

3. Enter a reporting period (for example, 01 to 16)in Reporting periods. The period determines the reporting debit and credit balances. Any period that is excluded in this selection will be captured in the opening balance or the balance for the entire period.

4. Enter the standard setting of 1 in Account sorting to sort the report by company code, reconciliation account, and customer account.

5. Choose Execute.

This out put screen of SAP ABAP fico program is as shows the list of customer balances for the selected carry forward period .


Each point of out put screen explains the following.

A Company code (3000) and reconciliation account (140000), followed by the customer accounts.

B Balances at the period start are listed for each customer (for example, customer 3000 BUSH has an opening balance of 22,150.00)

C Debit balance (528,906.55) for the period

D Credit balance (551,056.55) for the period

E Totals (provided by reconciliation account).

In this example, the carry-forward balance for the reconciliation account 140000 is 22,704.60. The reporting debit and credit balances are listed as 14,580,582.41 and 14,603,287.01.

F Total (for all reconciliation accounts in company code 3000)

You may be also interested in the following SAP Finance reports.

SAP Finance General Ledger report account balance

SAP ABAP fico report for Vendor open items

This SAP fico report using ABAP code less report that is in build report lists the open items by vendor for a given period. The list of vendor open items offers dynamic sorting options ranging from the A/P reconciliation account to the country of the vendor to the accounting clerk who entered the item.

To run this ABAP report

One method is :Information systems → Accounting → Financial accounting
Accounts payable → Open items

And the second method is

Choose System → Services → Reporting and enter RFKOPO00 in the Program field.
Then, choose Execute to run the report.

In the Command field, enter transaction F.41 and choose Enter.

You must make certain that Open items at key date (system date is the default) is selected before running this report.

The selection screen of SAP ABAP report includes:
  1. Variants
  2. Dynamic selection options
  3. User variables
  4. Execution (and print) in background
The output of this sap finance and control (fico) report includes a listing of vendor open items, sorted by various criteria.

S-sort indicators for master data enable you to sort by:

Reconciliation account (default)
Country
Group key
Consolidated company
Industry key
Accounting clerk
Account abbreviation (sort field)
Account number
P-sort indicators for line item data enable you to sort by:

Special G/L indicators (default)
Allocation number within the account number
Posting period
Posting date
Due date
Document date
Business
According to cash discount 1 due date (With this sorting method, the cash discount 1 due date is issued in the list instead of the due date for net payment.)
Sample SAP FICO report with screen shots

Create a listing of all vendor open items for company 3000.

To access the first screen for this report, choose

Information systems → Accounting → Financial accounting
Accounts payable → Open items.

The input screen looks like this.
Each number of the screen is explained here.

1. Enter 3000 in Company code.

2. Enter 1998.11.12 in Open items at key date. The system selects all items that posted before the specified key date and are open for the given period.

3. Select Standard documents. This excludes sample documents, recurring entries, and statistical
documents.

4. Under Output control, enter 1 in S-Sort indicator to sort by the reconciliation account. Enter 1 in P-Sort indicator to sort by special G/L indicators.

5. Choose Execute.

The output of this ABAP report for sap finance is as shown below.

Each part of the output screen explains the following.

A The list of vendor open items for the selected company code and the sort sequence for this report
B The vendor C.E.B New York and its address information

C The posting date of 08/31/98 and the original document number 5100000001

D The credit amount of 9,750.00 displayed by currency

E The reconciliation account 160000 This screen shows the far right side of the List of Vendor Open Items report.

The second screen shows the far right side of the List of Vendor Open Items report.

You may be also interested in the following SAP Finance reports.

SAP Finance General Ledger report account balance
Finance general ledger line items SAP ABAP report
General ledger report SAP FINACNE
SAP FICO customer open items report
Customer balance in local currency for SAP FICO 
ABAP complete course

SAP Finance Customer Balances in local currency report

SAP Finance and control(sap fico) report lists balances by customer account number and reconciliation account.

It provides a high-level review of carry-forward balances, current debit, and credit balances for each customer in the local currency for the period selected.

The previous sap fico report deals with customer open items of SAP Finance and control.

The following data is issued at the end of the list for each local currency:

Totals per company code
Final total across all company codes

To run this SAP ABAP finance report, we have two options:

1.Information systems → Accounting → Financial accounting
Accounts receivable → Select report
Customers → Information system → Account information → Balances in local currency

2.Choose System → Services → Reporting and enter RFDSLD00 in the Program field.

Then, choose Execute to run the this finance report.

You must select a fiscal year and reporting period before running this report.

The selection screen of this ABAP report includes:
  1. Variants
  2. Dynamic selection options
  3. User variables
  4. Execution (and print) in background
  5. The output of this report includes a listing of the customer open items, sorted by various criteria.
Example with screen shots of this finance report:

Generate a listing of all customer balances for company 3000 in the year 1996.

To access the first screen for this report, choose

Information systems → Accounting → Financial accounting
Accounts receivable → Select report
Customers → Information system → Account information → Balances in local currency.

The selection screen of this sap fico report is as shown below.

Each number of the screen shot gives the following description.

1. Enter 3000 in Company code.

2. Enter the year for which customer balances are to be reviewed (for example, 1996).

3. Enter a reporting period (for example, 01 to 16)in Reporting periods.

The period determines the reporting debit and credit balances. Any period that is excluded in this selection will be captured in the opening balance or the balance for the entire period.

4. Enter the standard setting of 1 in Account sorting to sort the report by company code, reconciliation account, and customer account.

5. Choose Execute.

The output screen is as shown below.


This screen shows the list of customer balances for the selected carry forward period (1-16 1996).

A Company code (3000) and reconciliation account (140000), followed by the customer accounts .

B Balances at the period start are listed for each customer (for example, customer 3000 BUSH has an opening balance of 22,150.00)

C Debit balance (528,906.55) for the period

D Credit balance (551,056.55) for the period

E Totals (provided by reconciliation account)

In this example, the carry-forward balance for the reconciliation account 140000 is 22,704.60. The reporting debit and credit balances are listed as 14,580,582.41 and 14,603,287.01.

F Total (for all reconciliation accounts in company code 3000)

You may be also interested in the following SAP Finance reports.

SAP Finance General Ledger report account balance
Finance general ledger line items SAP ABAP report
General ledger report SAP FINACNE

ABAP TOPIC WISE COMPLETE COURSES

BDC
OOPS ABAPALE
IDOC'S

SAP Finance ABAP Code Customer Open Items

SAP Finance module will have customer open items report which can be extract the data of open items with out writing any ABAP code.

This SAP finance ABAP report lists open customer receivables, sorted by key date. Line items may be suppressed to display only balances. Customer receivables can be analyzed based on a variety of selection parameters.

The list of customer receivables offers dynamic sorting options that range from the A/R reconciliation account to the industry group of the customer to the accounting clerk who entered the item.

We have previously discussed regarding accounts receivable information and the present ABAP report deals with customer open items.
To run this ABAP report, use one of the following access options:

1. Information systems → Accounting → Financial accounting
Accounts receivable → Open Items

2Choose System → Services → Reporting and enter RFDOPO00 in the Program field.

Then, choose Execute to run the report.

In the Command field, enter transaction F.21 and choose Enter.

Output of this SAP report deals with

The selection screen of this report includes:
  1. Variants
  2. Dynamic selection options
  3. User variables
  4. Execution (and print) in background
The output includes a listing of the customer open items, sorted by various criteria.

Normal version sorting sequence: Company code, S-sort indicators (1-8) , Account number, P-sort indicators (1-7), Allocation number, Posting date, Currency key, Sales indicator, Business area.

S-sort indicator for master data:

1. Sort by reconciliation account (default)
2. Sort by country
3. Sort by group key
4. Sort by consolidated company
5. Sort by industry key
6. Sort by accounting clerk
7. Sort by account abbreviation (sort field)
8. Sort by account number

P-sort indicator for line item data:

1. Sorting by special G/L indicators (default)
2. Sorting by allocation number within the account number
3. Sorting by posting period/posting date
4. Sorting by due date
5. Sorting by document date
6. Sorting by business area
7. Sorting according to cash discount 1 due date (Cash discount 1 due date is issued in the list instead of the due date for the net payment).

Example to display SAP Customer open items.

Generate a listing of all customer open items for company 1000.

We have to follow the following steps.

1. Enter 1000 in Company code.
2. Enter 08/10/1998 in Open items at key date. The system selects all items that posted before this date and remain open for this period.
3. Select Standard documents. This excludes sample documents, recurring entries, and statistical
documents.
4. Scroll down the screen to enter the default sort settings under the Output control section.
5. Enter 1 in S-Sort indicator to sort by reconciliation account and enter 1 in P-Sort indicator to sort by special G/L indicators.
6. Choose Execute.

This can be displayed as shown below.


The output of SAP ABAP report screen is as shown below.

This screen shows the list of customer open items for the selected company code.

A Customer and address
B Posting date (063098) and original document number (100008156)
C Debit amount (18391.05)
D Reconciliation account number (140000)
E Total receivables for the company grouped by currency and special G/L.

You may be also interested in the following SAP Finance reports.


SAP Finance General Ledger report account balance
Finance general ledger line items SAP ABAP report
General ledger report SAP FINACNE

ABAP TOPIC WISE COMPLETE COURSES

Work Flow MM
Work Flow SD
Communication Interface

Accounts Recievable Information System Report for SAP

Extraction of data from SAP Finance module can be done with inbuild ABAP reports with out writing and code and programming. The previous report deals with Customer account open item analysis of SAP Finance.

This ABAP inbuild report with out any need of any coding and programming displays standard evaluations conducted in the following areas:
  1. Due date structure
  2. Payment history
  3. Currency risk
  4. Overdue items
You can further refine your choice of evaluation by company code, country, risk category, controlling area, dunning level, and so on. For example, the risk category evaluation node could be further exploded to lower levels to include group, credit control area, company code, or business area.

To run this ABAP report, use one of the following access options:

1.Information systems → Accounting → Financial accounting Accounts receivable → Select report

Information system → Accounts receivable information system (This is via menu path of SAP system)

2.Choose System → Services → Reporting and enter RFDRRANZ in the Program field.

Then, choose Enter. Then, choose the desired evaluation view (for example, Customer standard evaluations → Due date analysis). ( This is via SAP ABAP programme name)

An evaluation must be created in advance of running this report. Do this by choosing Accounting → Financial accounting → Accounts receivable → Periodic processing → Information system → Configure → Create evaluations.
The output of this SAP Finance report includes :

Dynamic sorting of output for a particular item (Shift+F5)

Sorting capability (by column): Select a column, then choose Edit → Sort in ascending/descending order (Ctrl+shift+F5/F4)

Summation by column: Select a column, then choose Edit → Add up values (Shift+F7)

Additional field selection (Shift+F6)

Graphics for displayed data (F5)

Example ABAP report :

Generate a due-date analysis for all companies. Then, drill down by one company to a particular customer for items due. Finally, drill down to the line items and the original accounting document.

To access the first screen for this report, choose

Information systems → Accounting → Financial accounting
Accounts receivable → Select report
Information system → Accounts Receivable Information System → Due date analysis.

It gives a SAP screen as shown below.

A partially exploded view of the Accounts Receivable Information System’s standard evaluations
displays with the following nodes:
  1. Due date analysis
  2. Payment history
  3. Currency analysis
  4. Overdue items
Each node has additional levels of evaluation at subnodes, or deeper levels of detail.

1. Click Evaluation by Company code.

Evaluation by company code has three subnodes:
  1. For group
  2. For credit controlling area
  3. For business area

2. Under Evaluation by company code, double-click on a subnode to execute its evaluation (for
example, 800 IDES-ALE: Central FI Syst).

This can be further drilled down for many details.

You may be also interested in

SAP Finance General Ledger report
Finance general ledger line items SAP ABAP report

SAP Finance Accounting Customer Open Item Analysis Report

This SAP Finance accounting sample report with default ABAP Code lets you select and analyze customer open items that are overdue and exceed a predefined amount. You can search by customer account number, company, deduction, and a specific level of balance.

The report’s dynamic options let you refine your search to allow for even greater levels of detail You can search by industry, country, accounting clerk, etc.

To run this ABAP report, use one of the following access options:

1. Information systems → Accounting → Financial accounting Accounts receivable → Select report

2.Information system → Account information → Days overdue analysis → Customer open
item analysis .

3.Choose System → Services → Reporting and enter RFDOPR10 in the Program field.

Then, choose Execute to run the report.

The selection screen of this report includes:

Variants
Dynamic selection options
User variables
Execution (and print) in background

This report contains data obtained from A/R customer balances. As such, the data cannot be changed or manipulated from the report.

Example SAP Finance customer open items report :Generate a report to analyze open items for a customer, with summarization levels set at 0 for the highest level of detail.

To access the first screen for this report, choose

Information systems → Accounting → Financial accounting

Accounts receivable → Select report

Information system → Account information → Days overdue analysis → Customer open item analysis.

When you select the above SAP menu path you will be seeing the following screen.

Each part of the screen numbered represent the following.

1. Enter AESC04D in Customer account.

2. Enter 0001 in Company code.

3. Enter 08/07/1998 in Open items at key date.

The system selects all items that posted before the specified key date and remain open for this period. The current date defaults to the system setting.

4. The Due date sorted list is set to a user-defined setting of 20, 50, 80, 100, and 180 days.

5. Choose Execute.

The SAP finance Customer Open Item Analysis screen provides several key pieces of information, including the customer’s name and address.

It is displayed in the following screen.

Each letter of the screen explains the following.

A Total current liabilities for the customer (for example, USD 3,200)

B Annual purchases and deductions .

C Terms of payment (for example, ZB00 indicates that the payable is immediately due in full)

D Aging breakdown (for example, the open item total is 3,200. At 20 days and less there is a credit of 1,000.)

The previous post deals with SAP Finance sample report on Ledger Balance Sheet.

Dr. Y S Rajasekhara Reddy The Andhra Pradesh Chief Minister

Being a person of Andhra Pradesh I am very sad to write about the missing and unfolding accidental death of Dr Yeduguri Sandinti Rajasekhara Reddy who is a true hero here in Hyderabad and Andhra Pradesh .

Andhra Pradesh today morning the death of its beloved leader and chief minister Dr. Raja Sekhera Reddy.

It is even difficult to digest the truth that YSR is no more.

He is a leader with courage and stick to the ideas that he believe.

There is no other one in the state and even in the south India who has that much strong fighting attitude who spared his life in reviving the fortunes of Congress party in the state.

He walked more than 1700 kilo meters in the name of Pada Yatra to know the ground realities of problems that the people facing and tried to solve all of them after getting into the power.


He is a leader with vision and farmers of Andhra Pradesh can not forget him. He completed and started so many water projects to keep the life of farmers happy and hope all of them will be completed in the coming future.

He believes people , friends and puts confidence on them which made him a true leader and all the followers literally feel that he is their man and Andhra Farmers are really saddened to hear this bad news.

We do your smiles for ever and it is for sure that no one can replace you and you are permanent in the peoples heart of Andhra Predash.

May god bless his soul.

What do you say dear friends ?