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.
 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
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
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
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
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.
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
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)
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
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.
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
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.