Analysis Customizing
SAP R/3 analysis program for pricing
Price procedures and output determination
Information, requests and contact via
To avoid you email will regards as a spam email, don't change the title

Pricing as word document

Target
This program is for the Pricing Analysis or for the correct output determination. It is recommended for SAP Consultants who wish to adjust and check the pricing or output determination in their SAP system. It will check to see if their customising can be designed in a more efficient manner, whether numerous records are valid and identify processes which are not necessary as well as find errors in why certain prices cannot be determined.

umschalten zur deutschen Version
Version
change to the english version
version

The program presents the whole customising section of pricing or output determination in a neat summary, that will give you a complete overview without the need to jump between transactions. It is designed as an explorer, all the information are stored under nodes in a tree formation. Therefore allowing you to concentrate solely on the area of interest and allowing you to bypass the other areas of the tree sub-structure. The information is kept pertinent so that even inside the tree you have no need to search out desired information. At this time this is in display mode only and no option is available to change the configuration.

Performance scope
Via the Selection screen the user can concentrate on specific sections and solely evaluate these parts. You will be presented with all pricing calculations or output procedures, as well as all access sequences. All conditions (when printing output, the output forms are included too) and the condition tables that meet the selection criteria, are built into the summary of collected data for the tree display. Additional data is faded in, which is outside the selection and is relevant for the procedures.

You have the option to start an analysis against sales documents or purchase orders, to check which conditions inside which access sequences are accessed. Thereby a single comparison of each value of the conditions table is done against the value of the order. The result is shown in a kind of an ABAP-List-Viewer (ALV). This gives the possibility to organize your data of the new comparisons by filtering and sorting into your required format, aided by the colours in the display. The system uses for the comparison and detection the customizing settings and not the stored data (like output data in the NAST)

In the case of maintaining foreign languages and their translated values, it is possible to enter the language on the selection screen at the beginning. This will then determine which texts shall be displayed, therefore you can easily and quickly see where your maintenance in translation still has to be done.

For pricing you can enter and give a date, against which to compare. All condition records, which have already expired at this date and have lost their validity, you can organize and archive by an additional program away from the databases to reduce volume and contribute to release the accesses and performance of the condition tables.

Requirements
To use the analysis program fort he pricing and output determination, you need the SAP R/3 trade system. Special installed modules or program packages are not necessary, because this functionality works with the standard tables, functions, classes and methods.

This program uses for the display the simple tree control and is based on splitting containers, which are put on an empty carrier dynpro screen. Therefore as a minimum the SAP 4.6c version has to be installed and be in service, because in older versions the needed class and its methods arenít in the delivery scope of SAP.

Preparation
The program works with the SAP standard tables and the SAP standard. You donít have to create or install client specific databases. The development is after installation and compilation immediately available for use.

Order of events
Selection screen

SAP Analysis program pricing, output determination. Selection screen

In the first part of the screen you enter your selection relating to the customizing, but the data does not have to show its dependencies. Condition and access sequence are joined as a combination, the system will only build up conditions, where its sequence is inside the range. The procedure is detached, it has no influence. All procedures are regarded, independently, if the condition is inside the procedure or not. But conditions outside your given range will be placed under a separate top node, therefore they will not impact on the display mask.

The second selection block serves as control for the customizing. The language shows all texts and descriptions to the conditions, access sequences and procedures in the desired language, independent in which language you are logged in. In the logged in language only the topics, summaries, error messages and field explanation outside the tree control, like in the ALV screen, are displayed. The set statistical flag causes a load of the data from the condition tables. In you have well filled condition tables with a lot of records and you will clean them very seldom, this process can take some time from starting until bringing up the display. The date is only valid for the pricing and checks which condition records are already invalid, lost their validity and are substituted by newer ones at this date.

The third selection block is the part of the analysis of data of the condition tables against data in order documents. Thereby is the selection, which documents have to be read, dependent upon your selection, which usage and application you have chosen. If you entered a B = output and as application V1 = sales, the system will search and check the given document numbers inside the VBAK = sales order database.

Display Customizing

SAP Customizing. Tree control summary to the customizing sections

In the section customizing the complete customizing for pricing and output determination is illustrated. To all top node the according descriptions are given and inside all nodes cross information are built up as well, so that a jumping is not necessary between the particular classes and can be avoided.

Calculation procedure / output determination procedure

SAP pricing: Calculation procedure / output determination procedure

An output determination procedure joins all type of output possibilities together. For pricing procedure it is equal. At the same time you define the sequence, which conditions shall be regarded in this process. Inside the procedure you can enter of conditions a requirement, which has to be fulfilled, what this condition will be processed. Which output determination procedure is taken by the system depends to the order type. All order, delivery, invoice or shipment types, which are using this procedure, are displayed in a group as well. Inside pricing the detection of the right pricing procedure is a little bit more complicate and hasnít been implemented into the program yet.

Further the program shows, if the procedures are active, which order types are using this procedure und which condition are included and therefore as a result in collected kind, which different access sequences are assigned.

Access sequence

SAP pricing access sequence with conditions and condition tables

The access sequence is required for the definition of the conditions for the output or price calculation. The access sequence is a search strategy, with that help SAP can look for valid condition records for each condition. The sequence is maintained in the condition itself and refer to condition tables, which are assigned to a sequence on fields, which are relevant for finding the right price or printer. In the summary of the access sequence all conditions are displayed, which are related to this sequence. For each condition table minimum one sequence has to be defined and assigned. Further you can see, which field in the database of the condition table refer to which field in the structure of the order to do the comparison on values in each.

In case of an analysis, which contains a loading of data out of the condition tables, you can find out, if the actually assigned condition table to a sequence is still necessary or needless and reduce the performance. If all condition tables have no data for this sequence, so it is doubtful, why this sequence or even its conditions are still in the system.

SAP pricing access sequence with condition tables

In the example above the access sequence 0009 has an assignment to the tables B150 and B001. Both tables have data inside, B150 anyhow 2031 records, but both tables have no records for any conditions, which belong to sequence 0009. Does sequence 0009 still needs this conditions tables ?

Condition types

SAP condition types of pricing and output determination

The conditions or condition types are responsible, which action will be processed during an output determination or pricing. This conditions circuitous by the access sequence serve inside the condition table for the comparison against values of an order or document and indicates, if this condition is in this instance active or not.

In the part of the output determination the system will generate to an active condition the assigned forms to print or send a fax in the output procedure or trespassing program.

In the example condition AN00 has access to the condition table B001, but this condition has no records in the mentioned table. In case that AN00 is valid and will be processed, the system will perform when printing or faxing the form RVORDER01, which will be controlled by the print program RVADOR01. The condition type AN00 is allocated only to the procedure V06000 and no further ones. BAIN is a manual condition, therefore the different icon in the layout.

Forms (printing)

SAP printing. Print forms and the executing programs

The section of forms will only appear when you have chosen an output usage. Under this top node all different forms are displayed, which can be printed or faxed inside all selected conditions. Next to the language, which is ticked in the selection for display, the program will show also the form in the other languages available and configured in the system. The program passes the databases of SAP Scripts forms as well as the database of Smartforms. The form document type, if SAP Script or Smart Forms, is shown in a similar, but not identical, icon or symbol in the tree control to each node.

Condition tables

SAP condition tables with amount of records

This chapter describes the different condition tables for the output or the pricing. In the structure of a condition table you define the fields, which the system uses for the comparison database versus document.

Actions
If you have entered a or some document numbers in the selection screen or if you like to have a statistical evaluation, then you are able in the section customizing part sequence and condition by double clicking your desired condition table to jump and see all values in your given range (all data records to the sequence or condition). The preparation of the result is done on an ALV (ABAP List Viewer) screen and you have fully access to all SAP functionalities which are integrated in this SAP tool. It is possible to you to reorganize and sort the data contents of the condition table in another manner or you set a filter to make a faster error analysis. A save of the layout is not very sensible, because the creation of the list is done is a dynamic way and orientates to the structure and fields of the condition table. In the section condition table this possibility is deactivated due to the lots of records a table can have.

SAP output determination, values in the condition table

Next to the general information some additional values will be mixed in out of the output or price records.

Comparison
The comparison corresponds to the analysis of the SAP standard transactions, but has a little bit more of power, because this programm shows the comparison of each single field and its values in the table and the document. Also this program doesnít check against saved and dynamic data (like outputs in the NAST table), it checks against the customizing itself.

Analysis

SAP analysis, comparison document - output or prices

On level of the comparison condition table to values of a document it is also possible to make a double click to confront the single values. If the values of the condition table are the same as in the document, can be header or position, this cell will be shown in green in the ALV, if imparity then in red. If all values are the same in the table and in the document, the whole row will appear in green. In the light blue line the values of the document are build up against which the system makes the comparison. In the display below the sort is done on the country key, it is very nice to see, that Russia is maintained for the sales organization 0200 und 0210, but not the Seychelles (country code SC). Singapore (Country code SG) is missing completely. A detection of an error is in this case very easy possible, missing records can be detected by a simple view on the screen instead of a long listing. If you are looking for usage equal output than instead of a green light to a node the system already shows you the way of output, can be a print, a fax, an email, interface via EDI or anyhow. The yellow warning triangle in front of condition B013 means, that also in this condition table a hit was found, but for condition B602 the exclusive flag is set, so the master record for B013 keeps discounted.

Program enhancement
This program in his present appearance and functionality is only a snap shot. The program doesnít claim to be completed and cover all possibilities and eventualities. Enhancements are everytime possible and you as an user are kindly requested, to make suggestions, what can be for interest, what can help you to make your work more effective.

Further program enhancements are on the list to do: Requirements: Single click on a node and button F4, then a textedit control shall open and display the programming of this requirement. Only for customizing.

For your documentation
This manual or user guide and all descriptions you can copy as word document to save it on your computer. I recommend to open the winword document in a separate window, that you have all buttons and functions of Word available. If you open the document here, you keep inside the frame of the bmksound web presentation.

Questions, information, interest ?
If you like to get more information about the analysis tool or even have interest in buying the software, we kindly ask you to sign the form or send an to us. Thank you.