Showing posts with label ASAP. Show all posts
Showing posts with label ASAP. Show all posts

BAPI SAMPLE CODE FOR FLAT FILE in SAP ABAP

BAPI SAMPLE CODE FOR FLAT FILE in SAP ABAP

REPORT ZBAPI.

DATA: BEGIN OF i_data OCCURS 0,
text(255),
END OF i_data.
DATA: i_ekko TYPE bapiekkoc.
DATA: it_ekko LIKE TABLE OF i_ekko INITIAL SIZE 0 WITH HEADER LINE.
DATA: BEGIN OF i_ekpo OCCURS 0,
po_item(5),
pur_mat(18),
plant(4),
net_price(23),
disp_quan(13),
END OF i_ekpo.
DATA: it_ekpo LIKE TABLE OF bapiekpoc INITIAL SIZE 0 WITH HEADER LINE .

DATA: BEGIN OF i_eket OCCURS 0,
po_item(5),
deliv_date(8),
quantity(13),
END OF i_eket.
DATA: it_eket LIKE TABLE OF bapieket INITIAL SIZE 0 WITH HEADER LINE.
DATA: v_index TYPE i.
DATA: return TYPE TABLE OF bapireturn INITIAL SIZE 0 WITH HEADER LINE.
DATA: po_num(10).

START-OF-SELECTION.

CALL FUNCTION 'UPLOAD'
  • EXPORTING
  • CODEPAGE = ' '
  • FILENAME = ' '
  • FILETYPE = ' '
  • ITEM = ' '
  • FILEMASK_MASK = ' '
  • FILEMASK_TEXT = ' '
  • FILETYPE_NO_CHANGE = ' '
  • FILEMASK_ALL = ' '
  • FILETYPE_NO_SHOW = ' '
  • LINE_EXIT = ' '
  • USER_FORM = ' '
  • USER_PROG = ' '
  • SILENT = 'S'
  • IMPORTING
  • FILESIZE =
  • CANCEL =
  • ACT_FILENAME =
  • ACT_FILETYPE =
TABLES
data_tab = i_data
  • EXCEPTIONS
  • CONVERSION_ERROR = 1
  • INVALID_TABLE_WIDTH = 2
  • INVALID_TYPE = 3
  • NO_BATCH = 4
  • UNKNOWN_ERROR = 5
  • GUI_REFUSE_FILETRANSFER = 6
  • OTHERS = 7
.
IF sy-subrc 0.
  • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
  • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

loop at i_data.
if i_data-text(1) = 'H'.
shift i_data-text.
v_index = v_index + 1.
split i_data-text at ',' into i_ekko-doc_type
i_ekko-purch_org
i_ekko-pur_group
i_ekko-vendor.
append i_ekko to it_ekko.

elseif i_data-text(1) = 'I'.
shift i_data-text.
split i_data-text at ',' into i_ekpo-po_item
i_ekpo-pur_mat
i_ekpo-plant
i_ekpo-net_price
i_ekpo-disp_quan.
append i_ekpo.
move-corresponding i_ekpo to it_ekpo.
append it_ekpo.
clear it_ekpo.
else.
shift i_data-text.
split i_data-text at ',' into i_eket-po_item
i_eket-deliv_date
i_eket-quantity.

append it_eket .
move-corresponding i_eket to it_eket.
append it_eket.
clear it_eket.
endif.
endloop.

CALL FUNCTION 'BAPI_PO_CREATE'
EXPORTING
po_header = i_ekko
  • PO_HEADER_ADD_DATA =
  • HEADER_ADD_DATA_RELEVANT =
  • PO_ADDRESS =
  • SKIP_ITEMS_WITH_ERROR = 'X'
  • ITEM_ADD_DATA_RELEVANT =
  • HEADER_TECH_FIELDS =
  • IMPORTING
  • PURCHASEORDER =
tables
po_items = it_ekpo
  • PO_ITEM_ADD_DATA =
po_item_schedules = it_eket
  • PO_ITEM_ACCOUNT_ASSIGNMENT =
  • PO_ITEM_TEXT =
RETURN = return
  • PO_LIMITS =
  • PO_CONTRACT_LIMITS =
  • PO_SERVICES =
  • PO_SRV_ACCASS_VALUES =
  • PO_SERVICES_TEXT =
  • PO_BUSINESS_PARTNER =
  • EXTENSIONIN =
  • POADDRDELIVERY =
.
write: po_num.
loop at return.

write:/ return-message,return-type.
endloop.

Here it is.


RELATED POSTS

SAP ABAP BAPI 1
SAP ABAP BAPI 2
SAP ABAP BAPI 3
SAP ABAP BAPI 4


SAP Business Information Warehouse Explorer

The Business Explorer helps to analyze the data in the SAP Business Information Warehouse.In the Business Explorer Analyzer, you define queries that are based on a selection of InfoObjects or pre-defined query templates for an InfoCube. By navigating through queries, you generate various view of the data which enable you to analyze and present the InfoCube data. You save the queries in workbooks and can manage them in your favorites.The Business Explorer Browser allows you to manage and execute workbooks that are in your favorites folder, or that belong to one of the roles that you are assigned to.








From InfoCube to Workbook

You analyze the database in the Business Information Warehouse, by defining queries for InfoCubes.If you imagine the InfoCube as a multi-dimensional cube, when you select characteristics and key figures in a query, a smaller cube is cut out of the larger InfoCube .The multi-dimensional structure of the query data enables you to generate various views of the data in an InfoCube. The OLAP processor creates the queries from the InfoCube data and provides methods for navigation within this data.

The Business Explorer requests the data that you want for the query and presents the current view of the saved data. Only data which is actually required is transferred. If you want a new data view in the Business Explorer, the OLAP processor calls up the data from the InfoCube while you are navigating through the data.



BEx Browser: Overview


Use the BEx Browser to access all types of documents that have been assigned to you in the role maintenance, or that you saved in your favorites.The administration of the document types displayed in the BEx Browser is based on the role maintenance (activity group maintenance) in the SAP Easy Access Menu. This is where you create new roles, assign them users, and maintain authorizations. You can select and organize documents in the BEx Browser. You can also create folders and specify how you want them presented on the screen regarding their position and any graphics used. You can maintain your favorites and add new folders and objects.Alternatively, you can maintain your favorites in the SAP Easy Access Menu in BW. The objects are displayed in a tree.


Executing Queries in the BEx Analyzer


You can find the query definition you selected under Query in the BEx Analyzer, assigned to the corresponding InfoArea and InfoCube.A search function helps you to find the query quickly. You can either enter the description or the technical name of the query.When you find the query, select it with the mouse and confirm with OK. If the InfoCube contains data, the query result is shown on an Excel worksheet.




Managing Queries in the BEx Browser

If you want to save the query in a new favorites folder, proceed as follows:

ŸOpen the 'Favorites' folder in the tree structure of the BEx Browser. Place the cursor on the right side of the screen and create a new folder (right mouse-click - New -> Folder. Give it an  oppropriate name and specify how you want it presented by choosing Select Color and Symbol. Ÿ Open the BEx Analyzer and execute the selected query. Save the workbook by choosing Save -> Save as new workbook. Enter a name for the query and select the folder you created in your favorites. Confirm with OK. When you call the BEx Browser you see the name of the query in your new folder, as long as your favorites are open. Double -click on the name to start the query.




Creating a Query

Procedure for creating a new query:

ŸChoose the New icon in the toolbar.
ŸChoose the pushbutton Queries. Choose pushbutton New.
ŸThis brings you to the selection screen containing all of the InfoCubes for which you can define a new query. Select the InfoCube on whose data you want the query to be based, by selecting it with the mouse. You can see the technical name of the InfoCube by choosing Technical Name (wrench icon). To create the query, choose New.


Choosing Characteristics and Key Figures


The objects available for the InfoCube you have selected are shown as a tree structure in the left- hand part of the query definition screen. These objects include the key figures and characteristics of the dimensions.The right-hand part contains empty directories for filter selections, rows, columns, and the free characteristics of the query. The bottom right-hand part of the screen shows a preview of the query result area. This area is empty at first.By clicking the plus or minus symbol for the directories, you can expand or compress the directory structure. By expanding the key figure node in the InfoCube tree, for example, you can display a list of all the key figures for the InfoCube. You can drag the characteristics and key figures for the InfoCube into the directories for the query definition (filter, rows, columns, free characteristics).When you have finished defining your query, choose Save Query. Choose Enter (checkmark icon) to start working with the query.

Changing a Query


Choose Change Query to modify the query.
There are two options for changing the query:

ŸChoose the mode Change Query (local view) to easily move or restrict the objects that are already in the query definition. The worksheet is refreshed each time you execute the query, but the changes are not saved in the query definition.

Choose Change Query (global definition) to return to the definition screen, where you can use the same functions you could use when you first defined the query. Before executing the changed query, save the changes in the query definition. This applies the changes to the original query definition.

There are two ways of saving the changed query:
ŸYou can save the changed query under its previous name. To do this, choose Save Query in the toolbar. You can save the changed query under a new name. To do this, choose Save Query as... in the
toolbar. Enter a new technical name and a new description. You can change this description at any time.



Schema: Exception Reporting

There are three types of exception reporting:

ŸThe evaluation of exceptions online when you execute a query.
ŸThe evaluation of exceptions in the background.
ŸAnd the Alert Monitor (notifies you that exceptions have occurred).

BEx Map

SAP has developed a geographical information system for BW: the BEx Map. With it, you can display query data on a designated map.BEx Map is fully integrated in the BEx Analyzer; the user can call up BEx Map for every query that contains geo-relevant characteristics.BW customers receive maps, on which they can display query results immediately after completing a few simple maintenance activities.

Drill-Through

Using the report/report interface you can jump from one BEx query to another query or transaction, to gain additional information for your query result. The contents of the query result cells, from which you start navigating, function as a filter.

You have the following drill-through options:

ŸFrom a BEx query to a BEx query using an InfoCube
ŸFrom a BEx query to a BEx query using an ODS object
ŸFrom a BEx query to an InfoSet query
ŸFrom a BEx query to a transaction in a source system

MultiCube Query

A MultiCube is a virtual InfoCube that contains no data itself, but that accesses data from other InfoCubes that are specified when the MultiCube is created.You can put different InfoCubes together in one MultiCube, as long as they have at least one common key field.You can use the same reporting functions for the MultiCube as for a Basis InfoCube.

Related Posts

SAP Integration Planning Cycle

To fully integrate  SAP Integration Planning Cycle ,ABC into the corporate planning cycle, several new customizing activities should be performed.In order to identify ABC costs in the cost component view of product cost, new cost components for processes may be needed.New value fields may be needed for processes in CO-PA based on the new cost components.New value fields may be needed for processes in CO-PA which are not product related.

Planning Integration - Sales Planning

In the Sales Information System (SIS) component of the Logistics Information System (LIS), the company can plan sales quantities for the following year. Similarly, sales quantity planning can be accomplished in profitability analysis (CO-PA). Both SIS and CO-PA can produce forecasts of sales quantities at the product or product group level. The two sales plans can be reconciled to produce a single consistent “master” sales quantity plan.

CO-PA: Planning

Planning layouts are customized screens for entering plan data. The definition of a planning layout controls not only the appearance of the pla nning screen, but also some of the functionality. This allows for complete flexibility in controlling the planning entry process.A planning layout definition consists of three parts: the general data selection, the lead columns, and the value columns. The general data selection is where characteristic values are specified that are valid for the entire layout. The lead columns are where additional characteristics that are to be planned may be specified. And the value columns contain characteristic/value fie ld combinations.

 Valid values for the special characteristics version, record type (for costing-based CO-PA), and plan/actual indicator, are required for each row/column intersection in a planning layout definition. By employing these intelligently in the layout design, layouts can be created in which values can be planned for more than one version at a time and in which actual history data may be displayed for reference.

Variables may be used when defining planning layouts to give them maximum flexibility. Variables can be used for any characteristic, and they can be installed anywhere they are necessary: rows, columns, or the general data selection. Users will be prompted to enter values for these variables when planning.Separate planning layouts are necessary for costing-based CO-PA and account-based CO-PA, as planning figures on the two sides of CO-PA are not related or linked in any way. When defining layouts in costing-based CO-PA, the characteristic record type is necessary. When defining layouts in account-based CO-PA, the characteristic cost element is mandatory.

Planning in PP

In the Sales Information System (SIS) component of the Logistics Information System (LIS), the company can plan sales quantities for the following year. Similarly, sales quantity planning can be accomplished in profitability analysis (CO-PA). Both SIS and CO-PA can produce forecasts of sales quantities at the product or product group level. The two sales plans can be reconciled to produce a single consistent “master” sales quantity pla n.The sales quantity plan is transferred to Sales and Operation Planning (SOP) in Production Planning.There, a capacity-based comparison of plan quantities with production resources takes place. If the plan cannot be met, additional resources must be obtained or the sales plan changed.

Cost Center Planning

In the Sales Information System (SIS) component of the Logistics Information System (LIS), the company can plan sales quantities for the following year. Similarly, sales quantity planning can be accomplished in profitability analysis (CO-PA). Both SIS and CO-PA can produce forecasts of sales quantities at the product or product group level. The two sales plans can be reconciled to produce a single consistent “master” sales quantity plan.

The sales quantity plan is transferred to Sales and Operation Planning (SOP) in Production Planning. There, a capacity-based comparison of plan quantities with production resources takes place. If the plan cannot be met, additional resources must be obtained or the sales plan changed.The activity requirements are calculated in Production Planning and transferred as scheduled  activities to cost center planning.


 Transferring Plan Values to Cost Centers

Integrated planning supports transfers of data from Cost Center Accounting feeder systems to cost center planning.If you planned this data in the feeder systems and want to transfer it unchanged to cost center planning, you do not have to plan the corresponding data in Cost Center Accounting. To use integrated planning, you must meet various preconditions in Cost Center Accounting and in the feeder systems. For example, if you wish to transfer statistical key figure planned values, you must first have created the necessary statistical key figure master records, and linked them to the Logistics Information System (LIS).

The personnel costs that you planned in Human Resources (HR) can be transferred to relevant cost centers. During integrated planning between Cost Center Accounting (CO-OM-CCA) and Personnel Planning (PD), you can plan personnel costs for target wages, payroll results, or basic pay, and transfer these costs to Cost Center Accounting. A precondition is that the cost centers to which the affected personnel master data is assigned must be valid. If Personnel Cost Planning and Cost Center Accounting are implemented in systems at Release 4.6A or later, the system automatically transfers the personnel costs to Cost Center Accounting. In prior Releases, the user initiates the data transfer.

During integrated planning between the Cost Center Accounting (CO-OM-CCA) and Asset Management (FI-AA) components, you can transfer periodic depreciation and interest of an asset to primary cost planning in Cost Center Accounting.After you calculate the values for services required in SOP, Long-Term Planning (LTP), or MRP,you can transfer these figures as scheduled activity type quantities to Cost Center Accounting.






Planning Scope on Internal Orders

Cost planning is performed mostly on orders with long durations. Orders which only exist for a very short period, such as orders for unexpected small repairs, are usually not planned.Internal order planning provides three different levels of cost planning:

Overall Planning is the simplest way of planning costs for orders. You can estimate overall and annual values for an order independent from cost elements.When more detailed information is available for an internal order, you can use primary and secondary cost and revenue planning. This covers the planning of primary costs, activity inputs and revenues in manual planning. In automatic planning, you can charge the order with overheads, distribution costs, periodic reposting costs, assessment costs, indirect activity allocation costs, process costs, and settlement costs. If the order is a plan-integrated order, you perform a plan credit using periodic reposting or settlement to a cost center.

If you have access to more information on sources of supply, quantities and prices, you can perform unit costing. With unit costing you can plan on a level below the cost element level.You can plan statistical key figures as a basis for allocations and as a means to calculate the management key figures for your orders.

In integrated planning for internal orders, you can integrate cost element and activity input planning for an internal order with cost center or business process planning. This integrated planning capability is activated in the plan version. When planning activity inputs to integrated internal orders, the scheduled activities post to the sender cost center/process. In addition, plan settlement and periodic repostings of integrated orders to cost centers/processes is allowed. And plan allocations of indirect activities, assessments, and distributions from cost centers/processes to plan integrated orders are also allowed.


Planning Integration - Product Cost Planning


In the Sales Information System (SIS) component of the Logistics Information System (LIS), the company can plan sales quantities for the following year. Similarly, sales quantity planning can be accomplished in profitability analysis (CO-PA). Both SIS and CO-PA can produce forecasts of sales quantities at the product or product group level. The two sales plans can be reconciled to produce a single consistent “master” sales quantity plan.

The sales quantity plan is transferred to Sales and Operation Planning (SOP) in Production Planning. There, a capacity-based comparison of plan quantities with production resources takes place. If the plan cannot be met, additional resources must be obtained or the sales plan changed.The activity requirements are calculated in Production Planning and transferred as scheduled activities to cost center planning.

In cost center planning, the plan activity quantities are created on the basis of scheduled quantities. Cost planning is performed for cost centers and internal orders, as well as additional activity planning for overhead cost controlling. Planned costs from the HR and AA components can be transferred to cost center planning. Plan activity prices are then calculated.The calculated plan activity prices go to Product Cost Planning, which estimates the production costs of the planned products with the use of bills of material and routings (quantity structures). Cost center planning data can be transferred to profit center planning.





Product Cost Planning: Overview

When you create a cost estimate with a quantity structure, you enter the costing variant, the material, the plant, and the lot size. The dates are proposed from the costing variant and determine the following:

Ÿthe period of validity of the cost estimate (costing date from/to)
Ÿthe selection date for the bill of material and routing (quantity structure date)
Ÿthe pricing date for the material components and activities (valuation date)
With the Transfer control indicator you specify that you either want to use an existing cost estimate for component materials, or create a new cost estimate.The system selects and values the quantity structure automatically.The costing results can be saved and displayed as an itemization, a cost element itemization, or a cost component split. The itemization shows detailed information on the origin of the costs, such as the quantities and prices of the materials and internal activities used.

The cost element itemization groups the individual costing items into cost elements. The cost elements group the costs according to how they were incurred. For materials, cost elements are determined through account determination; for activities, through the activity type master or through activity type planning; for processes, through the process master record.The cost component split groups the cost elements into cost components. When a multilevel structure is costed, the cost component split is rolled up so that the original identity of the costs is retained for analysis.You can analyze the results of the cost estimate directly or in the information system.






Update Sales Plan/CO-PA

In the Sales Information System (SIS) component of the Logistics Information System (LIS), the company can plan sales quantities for the following year. Similarly, sales quantity planning can be accomplished in profitability analysis (CO-PA). Both SIS and CO-PA can produce forecasts of sales quantities at the product or product group level. The two sales plans can be reconciled to produce a single consistent “master” sales quantity plan.

The sales quantity plan is transferred to Sales and Operation Planning (SOP) in Production Planning. There, a capacity-based comparison of plan quantities with production resources takes place. If the plan cannot be met, additional resources must be obtained or the sales plan changed.The activity requirements are calculated in Production Planning and transferred as scheduled activities to cost center planning.

In cost center planning, the plan activity quantities are created on the basis of scheduled quantities. Cost planning is performed for cost centers and internal orders, as well as additional activity planning for overhead cost controlling. Planned costs from the HR and AA components can be transferred to cost center planning. Plan activity prices are then calculated.The calculated plan activity prices go to Product Cost Planning, which estimates the production costs of the planned products with the use of bills of material and routings (quantity structures). Cost center planning data can be transferred to profit center planning.

Planned production costs are then transferred to profitability planning (CO-PA). These estimated costs are used in conjunction with the sales plan projected revenue to create a profitability plan. Based on the results of this profitability plan, adjustments may be made to the original sales plan, which would flow through the entire integrated planning process as another iteration. This cycle could be repeated until all aspects of the integrated plan are satisfactory.





Transfer of the Product Costing Results to CO-PA

The cost components from a product cost estimate can be used in Profitability Analysis for profit planning, and to value the plan/actual data of billing documents. This enables you to receive detailed information on the origin of your product costs in Profitability Analysis, and analyze your contribution margins.To transfer the product cost estimate, you assign the cost components containing the cost of goods manufactured, and sales and administration costs, to the corresponding value fields of an operating concern, and link these values with the quantity field ‘sales quantity'.

The calculated cost of goods sold is then compared with the forecast revenues, and planned profit margins can be calculated. If the result is unsatisfactory, the entire planning cycle can be repeated with different starting values.You make the necessary settings to transfer data from the cost estimate into Profitability Analysis in Customizing for Profitability Analysis.

Plan Integration in Profit Center Accounting

To make it possible to control and evaluate internal areas of responsibility effectively, you should limit profit center planning to those values which are measurable and can be influenced directly. The people in charge of the profit centers will only be able to use the planned data and targets if they can influence the costs, revenues and inventor ies in their area. Since the organizational structure and scope of your company's responsibility areas depends largely on individual factors, it is necessary to create as flexible and multidimensional a plan as possible.Profit center planning is an integral part of your overall company planning. Profit centers make the integrated character of company planning especially evident, since the plan data here is created principally in other applications, and can be supplemented or changed here. Profit center planning is a part of short-term corporate planning, and encompasses a span of one fiscal year. Short-term corporate planning generally consists of the following partial plans:

sales plan
Ÿmaster production schedule
Ÿcost plan
Ÿsales revenue plan
The planning process combines these individual planning areas into an integrated planning network. You can use different plan versions to reflect changes during the planning process, or different planning scenarios for the same time frame.The planning of profit centers is performed in two stages. First, plan data can be transferred online from the following applications: Cost Center Accounting, Internal Orders, Profitability Analysis, and Product Cost Planning. Second, planning can be carried out directly on profit centers.


Related Posts

SAP Information System Reporting Overview

SAP Information System has the felicity to extract the data using reports.In drilldown reporting, the SAP R/3 System provides an online reporting tool that lets you evaluate the data in Profitability Analysis interactively. With this tool you can select the desired dataset according to any of the characteristics in your CO-PA system and draw on any important business ratios (so-called key figures) you wish using the dynamic drilldown function. You can display several profitability segments for any key figure, or several key figures for any profitability segment.You can also perform variance analyses, such as plan/actual comparisons, fiscal year comparisons, comparisons of profitability segments, and so on.

In drilldown reporting, you can display both reports with a simple, fixed layout (basic reports) and reports with a more complex structure and formatting (form reports).The drilldown functions are divided into three groups, which differ in the amount of options available. Each user can choose the function level that suits his or her requirements. n The menus and the functionality available in the drilldown report make the reporting tool easy to use.n Drilldown reporting is used in both costing-based and account-based CO-PA.

You can summarize the data according to the derived characteristics and then drill down interactively in reporting. At each level of the report, you can display the drilldown list (overview) or detailed information (margin analysis).

Creating Reports

The drilldown reporting tool was designed to provide you with simple means for defining straightforward reports while still offering all the functions necessary for you to create more complex, formatted reports. Consequently, a distinction is made between two different types of report.Basic reports are often used to run a quick, ad hoc analysis to look for a specific effect. These structures have predefined basic structure that can be used for general use.

Form reports, on the other hand, are more complex and can be designed according to their specific purpose. These reports are often used for official reports and are especially suited for printing. Form reports are defined on the basis of so-called “forms”, which are separate objects that can be used for a number of reports. There are different types of form, which differ in terms of what elements are defined where in their structure.

Basic reports do not require the use of a form. When you define a basic report, you simply need to select the characteristics, characteristic values, and key figures that you want to analyze.Remember: Each report that you define is only valid for either costing-based or account-based Profitability Analysis, never both.

Architecture of Drilldown Reporting

You can use characteristics, key figures, and forms to define a report. The result when you display the report is a number of lists and graphics that you can call up and analyze interactively.A form determines the content and formal structure of a report list. A form can be thought of as a semi-finished report, which you complete by specifying characteristics and key figures when you define the individual report. You can specify characteristics in the form as well as in the report. Key figures, however, can only be contained in either the form or the report.

Drilldown reporting in CO-PA provides you with easy-to-use functions for navigating through the dataset. For example, you can move from one segment to the next level or the next segment at the same level, deactivate a level of the drilldown hierarchy, and switch between detail lists and overview lists. You also have a number of other functions available for editing online reports (conditions, sort orders, ranking lists, and so on). And you can send report lists by fax or electronic mail, or download them to Microsoft Word or Microsoft Excel.In addition to the various interactive functions for online lists, drilldown reporting also provides special functions for defining the report layout for printing (page breaks, headers and footers, underscores, and more).



Basic Report

You can access the functions for defining reports from Customizing or from the CO-PA application menu. From the initial screen for creating a report, you can process any of the components of the report in any order you wish.When you define a basic report, the system first asks you to specify a "from" and a "to" period, a plan/actual indicator, a version, and - in costing-based CO-PA - a record type.Then the system displays a list of all the characteristics in the operating concern. Here you can select the ones you want to analyze. These characteristics will form the dimensions of your multidimensional “data cube”. If characteristic groups have been defined for the operating concern, the system also displays the Characteristic group field. If you enter a characteristic group, the system displays only the characteristics in that group, instead of all the characteristics of the operating concern.

On the Create Profitability Report: Key Figures screen in costing-based CO-PA, the system lets you enter a key figure scheme (see the slide “Defining Key Figures”) to display a list of all the key figures in that scheme. By choosing Value fields, you can extend the list to include all the value fields of the operating concern. In account-based CO-PA, the system automatically displays a list of all the fixed basic key figures.If you wish to delete a report, you can do this using the Change report function. However, if you want to delete an entire group of reports, it is easier to do this in Customizing using the Reorganize reports function.


Form Reports

A form determines the content and formal structure of a report list. A form can be thought of as a semi-finished report structure, which you complete by specifying (additional) characteristics and key figures when you define the final report.The content of a form should generally be treated as fixed, and should only be changed under exceptional circumstances. This is because when you change a form, it changes all of the reports that use that form.

A distinction is made between forms with one axis and forms with two axes. Forms with one axis only consist of one dimension - either rows or columns. Forms with two axes, on the other hand, contain both rows and columns.This means, for example, that you can define forms with one axis that may not be useful as a basis for final reports, and use them as templates for creating forms with two axes. Such forms can then be used as often as you like.Which type of form you use will depend on what type of layout and which content you would like to display in your reports.

Different Types of Forms

There are three types of form:

ŸOne axis without key figure In a form with one axis and without key figure, you define either the rows or the columns using characteristics. When you press Basic list, the system displays a blank list with columns. 

One axis with key figure In a form with one axis and with key figure, you define either the rows or the columns using characteristics and key figures. When you press Basic list, the system displays a blank list with rows.

ŸTwo axes with key figure In a form with two axes and with key figure, you define both the rows and the columns using characteristics and key figures. When you press Basic list, the system displays a blank list with both rows and columns. You can decide whether the key figures should appear in the rows or the columns, depending on what you want to report on. Characteristics can be displayed in both the rows and the columns.To create a form, enter a name and the desired type of form.




One Axis Without Key Figure

In a form with one axis and without key figure, you only need to define the columns. You do this by specifying characteristics and characteristic values. If you wish, you can also define additional columns using formulas (such as Plan - Actual = Variance). The characteristics and values you specify determine the content of those columns.

You decide which key figures you want to see (revenue, contribution margins, and so on) and which drilldown characteristics - dimensions through whose characteristic values you navigate (such as “Industry”, “Customer”, and so on) - you want to analyze when you define the report.When you execute a report, you obtain a drilldown list with two headers, with each key figure standing above a group of columns containing the characteristics you specified in the form. The individual values of the first drilldown characteristic (industries “Retail” and “Media”) are displayed  in the rows.

The detail list shows the columns you defined using characteristics in the form definition. The key figures are displayed in the rows. The detail list displays the results of one selected characteristic value (industry “Retail”).


One Axis With Key Figure

In a form with one axis and with key figure, you specify the key figures you want to analyze (planned revenue, actual revenue) in the rows of the form. You can also limit these key figures further by specifying characteristics and their values as well.When you define the report, you only need to select the drilldown characteristics (industry, customer).

The drilldown list shows the key figures and characteristics from the form in the columns, while the values of the first drilldown characteristic (“Retail”, “Media”) are displayed in the rows.The detail list only contains one column showing the selected characteristic value (“Retail”). The key figures are shown in the rows.Remember: In a form with one axis and with key figure, you define either the rows or the columns of the form. When you press Basic list, the system displays a blank list with only rows. However, you can “tip” this form by moving the rows to the columns using the Column display function.Note that when you define a form, you are defining the layout of the detail list. That means that the position of the elements in the form determine their position in the detail list. This is why the key figures are shown in the rows by default in forms with one axis and with key figure.

Two Axes (Matrix)

In a form with two axes (matrix form), you define both the rows and the columns using characteristics and key figures. The key figures must appear in either the rows or the columns of the form, but not both. Characteristics, on the other hand, can be used to define both rows and columns.  When you define the report, you only need to select the drilldown characteristics (industry, customer).When you execute the report, you obtain a drilldown list with two headers, with each key figure (revenue, contribution margin 1) standing above a group of columns containing the characteristics you specified in the form (plan, actual, variance). The individual values of the first drilldown characteristic (industries "Retail" and "Media") are displayed in the rows.

The detail list shows the columns you defined using characteristics in the form definition. The key figures are displayed in the rows. The detail list displays the results of one selected characteristic value (industry “Retail”).Remember: All three types of form offer you a number of functions for determining the final layout of your reports (colors, number format, line spacing, text lines, and so on).



Form Settings

A number of functions are available when you define a form:

ŸColors: You can use this function to highlight certain elements of the form.
Number format: This function lets you specify a display factor and the number of decimal places displayed. This function is always applied to a specific column or row. Once you have executed the report, you can change the settings individually for each row or column.
Reverse signs: With this function you can reverse the signs of a given column. Negative values are displayed as positive, and positive values are displayed as negative.
ŸSuppress zeros: With this function you can have the system hide all rows that have the value “0”. This is shown in the form definition by the small x’s: “xxx.xxx.xxx”.
ŸText type: This function lets you specify whether you want to see the short, medium, or long text of each element.
Column width: This function lets you change the displayed width of a column.
To use any of these functions, first select the desired column and then choose the function. 


Related Posts

SAP Controlling structures

SAP ASAP Implementation Road Map

SAP ASAP Implementation Road Map has project preparation as a major part .The purpose of this Work package is to formally announce to the company the initiation of the R/3 challenge, which incorporates the general targets, detailed task plans, and processes. Consultants, steering committee, senior management, undertaking managers from the corporate and SAP, and every other implementation companions have to be involved. The kickoff meeting is concentrated on the corporate as a entire, whereas the mission crew requirements assembly is concentrated on the project team.Activities are Kickoff meeting and Mission workforce standards meeting.

Project Charter

Outline project mission statements: define the general company goals and vision for the R/3 implementation.Outline enterprise drivers: determine specific firm aims and enterprise drivers for initiating the R/3 implementation. Typical business drivers embrace: Improved stock turnover, decreased shipping prices, improved customer service.Determine business measurements: doc the implementation objectives, and the way they are used to measure the success of the challenge, specifically the business-related goals. Examples of enterprise associated targets are: Integration of enterprise processes, discount of on-hand inventories. Determine venture measurements: document implementation objectives, and the way they are measured,specifically the undertaking-associated goals. Examples of venture-associated targets are: Target dates for completion of particular implementation phases or milestones, measurement of actual expense performance versus budgeted costs, completion of a particular deliverable(s).

Develop the Change Constitution: develop a complete charter for the change challenge throughout the organization.Assemble undertaking constitution components: prepare a doc that consolidates the mission assertion, business drivers, enterprise measurements, and mission measurements.

Approve mission constitution: reach settlement between company govt management, the project sponsor, and members of the venture crew on the mission charter. You will want to have all members in agreement so that whole commitment could be achieved.

Defining Implementation Standards

The aim of this exercise is to ascertain the overall implementation requirements and procedures for the project. A few of these parts must be established by the technical members of the mission
workforce, and others by the enterprise or purposeful members. All group members ought to have enter to this course of, and understand the fundamental procedures, once they've been defined. As with undertaking administration requirements and procedures, you will want to handle the implementation requirements during Part 1 and to establish clear guidelines. A variety of the key issues to be outlined are: Total configuration standards for the project; initial system authorization standards; how system enhancements are dealt with; and the way and when testing occurs.

  1. Stipulations: Input: Challenge organization; R/3 implementation strategy.
  2. Outcome:Output: Configuration standards; end consumer training and documentation strategy; testing strategy;publish-implementation assist strategy; system authorization standards for the project workforce; system problems and error dealing with procedures; system enhancement and modification approval process.
  3. Final result: Implementation standards and procedures are clearly defined and documented. They are input for the activity venture crew requirements meeting.
Kick Off Meeting

This milestone exercise is a vital checkpoint that formally launches the R/3 implementation project to all the company. Make sure to enable satisfactory time for questions and answers, as some points might require clarification.

Stipulations:
  • Trigger: Skilled companies agreement.
  • Input: Undertaking constitution, implementation strategy, undertaking group, mission plan.
Result:
  • Output: Kickoff meeting report; copies of presentation documentation; mission charter; challenge group; organizational chart; undertaking logistics and standards; challenge work plan; communication listing and standards.
  • End result: Official start of the venture; presentation of the enter talked about above; rationalization for any issues or questions in regards to the venture from the kickoff assembly participants.
This assembly must be performed with high energy and ought to be attended by firm senior management. A powerful first impression is important to momentum.

Work Package

The aim of this Work Package deal is to define the enterprise organizational structure utilizing SAP organizational units, such as firm codes and gross sales organizations.In conducting the group structure workshop, several topics are discussed, together with:
  • What enterprise course of areas and business processes will be used in the system
  • What organizational units inside the company can be affected by the implementation
Defining Organization Structure

The purpose of this exercise is to organize for business organization structure workshops to define the organizational structure of the company throughout the system. The organizational structure is established to present construction to the Logistic and Monetary Enterprise Course of Areas.
  • Stipulations: Enter: Enterprise course of space scope doc (Pattern Scope Doc).
  • End result: Output: Documented group construction for the company.
  • Outcome: The organization construction is signed off and is prepared to be implemented.

Associate Items

The questions enable you to gather requirements on specific business situations and their processes.A Query may seem inside several structures. The reply to a query on a selected incidence inside any structure is seen on all other occurrences using that question. Whereas solutions given to a question are seen in any respect occurrences, questions can solely be answered and answers can only be modified on the present construction le vel. These questions are open-ended and promote the move of info between you and the consultants who will configure your system. Utilizing your solutions as a information, consultants outline your company’s requirements in detail and adapt course of models to reflect your organization’s needs.The user roles allows consultants within the Blueprint phase to identify, adapt and describe SAP delivered person roles based mostly on undertaking-specific requirements.

The CI template sections form the heart of the enterprise blueprint document. It could be very important provide as much info as attainable when coming into your answers in these sections. In some instances the knowledge is most likely not identified on the Blueprint stage, if this occurs, it ought to be famous within the CI template answers. For instance, while you enter the Authorization Considerations query throughout the Business Blueprint part only excessive level info is available. As this adjustments, the Q&A needs to be updated with detailed authorization requirements.

Through the initial Q&A setup, you specified the path to SAP and IDES documentation. This documentation is available for view only and cannot be changed. If a SAP or IDES document is out there for a specific perform, the identify of the doc displays within the Associated Items box.Click the document to view it.It's possible you'll add, view, or delete documentation to the Venture Documentation folder in the Associated Gadgets box. It is suggested to place all paperwork to the Undertaking Documentation directory in order that the doc may be found within the Q&Adb directory.

Scoping

Earlier than you start answering questions, resolve which structure items are legitimate and applicable for your business. Setting this stuff In Scope, delimits the knowledge gathering of the Q&A to your specific business. It's endorsed to “scoping” top down along the Q&Adb structure. Any one or all hierarchy gadgets will be set In scope by right-clicking on that merchandise in the tree view and selecting Set In Scope.In Scope areas seem in yellow for straightforward identification.In Scope standing might be faraway from individual hierarchy objects as essential by clicking the checked Item Set In Scope menu merchandise which removes the In scope status.If you'll like to solely see the items in scope, go to main toolbar and select View->In Scope. Only these areas that are In Scope will display in your tree structure.

Organizational Structure

The Organization construction degree comprises objects that describe the system group structure in which framework the SAP system is configured. In the Q&Adb, questionnaires facilitate gathering necessities on the company’s structure and processes that permit an initial mapping of the company’s enterprise to a proposed SAP organizational structure. The solutions to the questions form part of the Business Blueprint.The second degree comprises the available enterprise areas (e.g. Sales and Distribution). It's not really useful that you simply change or enhance this level of the organizational structure.A third degree further defines the organization (e.g., Sales area information).For every level you might set objects in and out of scope.

Business Process Definition

After the definition of the group construction, you define the business processes of the corporate by approach of the R/3 System. The Q&Adb is the device supporting the definition of the business processes. You should utilize the CI (Customer Input) template and the business course of questions inside the Q&A to support the preparation and completion of the business process definition. For detailed analysis, you'll have the ability to entry exterior tools for modeling the enterprise processes by means of the Q&A.Producing the Enterprise Blueprint provides you the corporate´s business course of necessities in one document.Producing Business Course of Grasp Record offers you the business processes which are in scope for Customizing within the Realization Phase.

Initializing IMG

The aim of this exercise is to create the Implementation Guide (IMG ). It is very important create an IMG in order that the Customizing course of and documentation duties are easier. The IMG is used as a reference on the final phases of business course of definition, due to this fact you wish to have this in place before starting that Work Package.Use Venture IMGs to do your project planning and management customizing work. Whenever you arrange your Venture IMGs or Release initiatives, remember to keep to the standards you defined in the Undertaking procedures work bundle underneath the venture documentation job for using standing indicators, for scheduling, and for documentation.There are two methods of generating the Venture IMG:
  1. The Manual creation of the Project IMG. That is the extra common methodology, whereby consultants manually identify the parts of the IMG that should be configured in preserving with the undertaking scope.
  2. The Automated generation of the Mission IMG from the ASAP Question & Answer database (Q&A). It is a new perform that makes use of the scope settings throughout the ASAP Q&A and transfers them mechanically into the R/3 undertaking IMG. Please refer to the accelerator below for extra information.
Related Posts


SAP OOPS ABAP PART 13
SAP OOPS ABAP PART 14
SAP OOPS ABAP PART 15

SAP ASAP Overview

SAP ASAP Overview has a discussion about Team SAP represents a total organizational commitment by SAP and companions to the general success of consumers by serving to them outline the best business resolution, by offering help during implementation and by guiding them as their enterprise changes.Team SAP initiatives have the next standards to assist in the success of shoppers:
  1. . Team SAP Coach - single level of contact for buyer, providing fast answers to any questions.
  2. . ASAP or ”powered-by”* implementation methodologies - ASAP is a clearly defined implementation strategy that ensures clients a fast and predictable implementation, regardless of size or complexity of environment.Powered-by implementation methodologies are SAP Partner methodologies incorporated into the ASAP methodology.
  3. . Managed by SAP or Team SAP Partner - the Team SAP Companion certification program represents the dedication between SAP and its companions to work collectively for the overall advantage of the customer.
  4. . High quality Assurance Examine - this program permits SAP to proactively measure how the undertaking is progressing, how well the implementation methodology is being followed, to confirm performance and to make sure prospects are getting the answer introduced in the software program choice process.
  5. . Steering Committee Representation - SAP representation on the shopper's challenge steering committee will help present strategic direction to the shopper's implementation and for future enterprise changes.
Accelerated SAP (ASAP) is the implementation solution supplied by SAP. ASAP integrates a quantity of elements that work in conjunction to assist the rapid and efficient implementation of the SAP’s R/three System, Trade Solutions and New Dimension products. The elements that make up ASAP are :
  1. Methodology - The ASAP Road map defines the phases of the implementation course of and helps these with a comprehensive venture plan. The undertaking plan contains MS Project templates providing full work breakdown constructions and useful resource assignments.
  2. Instruments - The ASAP process is supported by a comprehensive set of both PC-based mostly and R/3-resident tools.
  3. Service - Hotline, Consulting, Coaching, Project Critiques, SAPNet
  4. Challenge related Knowledge like Undertaking Management, Change Administration, Risk Analysis and Review Programs.


Defining ASAP Points

  1. Undertaking Preparation - Supplies initial planning and preparation for your R/3 project.
  2. Business Blueprint - On this part, you create the Business Blueprint, which is detailed documentation of the outcomes gathered throughout requirements workshops. Moreover, the Business Blueprint serves to doc the business process necessities of the company. On this basis, you will obtain a standard understanding of how the corporate intends to run their enterprise throughout the R/3 System.
  3. Realization - On this section, you implement all of the enterprise and process requirements based on the Business Blueprint. You configure the system step-by-step in two work packages, Baseline and Ultimate configuration.
  4. Final Preparation - On this section, you full testing, finish user training, system management and cut over activities to finalize your readiness to go live. Moreover, the Final Preparation part serves to resolve all essential open issues. Upon profitable completion of this phase, you will be ready to run your enterprise in your live R/three System.
  5. Go Dwell and Assist - Transition from a project-oriented, per-manufacturing environment to profitable and stay production operation.
  6. Continuous Enhancement - Provide on-going support and help for submit go-live. It covers options for those activities which are customary in a productive environment: Enterprise changes;know-how changes; or modifications in the person community.
Key ASAP Deliverable points

  1. Undertaking Preparation - Change Constitution - Targets, aims of org change administration n Challenge Plan - It is a first lower focusing on milestones and Work Packages. Particulars to come.
  2. Scope - Units the preliminary definition of the project; input from sales cycle.
  3. n Venture Group Organization - Sets the who of the project. Requirements & Procedures - Sets the why and how of the project.
  4. Enterprise Blueprint - Reqs reviewed for every SAP Reference Structure & defined using CI Templates (use Q&A). Enterprise Blueprint - This is the output of the Q&Adb and is the key document in Phase 3.
  5. Realization - Master Lists - Outline enterprise eventualities and R/3 transactions to be realized in the system. BPP - Bus Process Procedures representing R/3 transactions; used for unit testing & documentation. Planning - Defines how the configuration shall be accomplished and how will probably be tested.
  6. Growth Programs - Supplies particulars of the exterior programming requirements. EU Training
  7. Material - Finish Person training material and process documentation.
  8. Closing Preparation
  9. Stress & Volume Exams - Plans for confirming the manufacturing hardware’s capabilities.Minimize Over Plan - The details of the manner to transfer to the production setting and go live.
  10. EU Training - Supply of the necessary ranges of R/three coaching prior to going stay
  11. Go Reside & Support: Guaranteeing system efficiency through SAP monitoring and feedback.



For the belief, you may divide the scope of the Reference-IMG into completely different tasks, that are assigned in flip to venture IMGs.Once created, the venture IMG is populated to provide one or more views. You can create views to improve the construction of the mission IMGs. Use the challenge IMG to work on Customizing transactions, project and cross-project documentation, in addition to undertaking administration information.Do this for each view and/or all views combined.With Release 4.6, the opportunity exists to create Project-Views via the IMG-Link.

This functionality transports the Venture Scope which is defined within the Query and Answer Knowledge Base (Q&A) to the R/3 System. The Views generated by the IMG-Hyperlink comprise those Customizing Activities assigned to the Processes which were put in Scope within the Q&A.The IMG hyperlink does not create a Mission IMG. The IMG link is used to generate and consider process assigned, process non-assigned, or whole project IMG views of current IMG projects.

Related Posts

SAP Financial Assets and Liabilities
 SAP Financial Profit and Loss 
SAP Financial Closing Process
SAP Financial Production Start Up


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 :