Thursday, 26 May 2016

Define condition tables

Now, when we know what is a condition table, what it is used for, we can see where a condition table can be defined, and what option we have while creating it.

As you have seen in the previous topic, we have used table 18 – Material Info Record in our example.
Let's see where and how it is defined.
Step 1)
  1. Execute the transaction code V/05 and on the initial screen enter our table number - 18.
  2. In the section 2, you can see our table definition, table number, description, and two options that can be selected. First means use of the validity period (always recommended) and the other is a check for release status of the record. If checked, only released info records will be taken into account while searching for the condition.
  3. Here is the list of fields you have already seen in the Define access sequence topic.
You can see how is the table defined for later use in customizing the access sequence.
V/05 transaction is used for displaying a condition table.
V/04 transaction is used for changing a condition table.
V/03 transaction is used for creating a condition table.
Now you can define a new condition table if it is required, in order to use it in the access sequence definition. Most of the times new access tables aren't required since a vast number of predefined tables.
Step 1)
  1. Enter t-code M/03 and execute it.
  2. Choose your new table number (must be unused, e.g. 818).
  3. If you want to copy an existing table into your new table, you can select the source table here. This is useful if your table is similar to another existing table, and needs only a simple change to fulfill the requirements.
Step 2) On the next screen, you can do all of the settings for a condition table, and generate it.
  1. Click this button if you want to edit the description.
  2. Choose if your table should check validity periods and release statuses.
  3. List of current fields. You can select any field you want to remove (by single clicking it) and choose the remove icon (List icon with a red minus sign).
  4. You can add fields from field catalog by double clicking them.
  5. You need to generate the table in order for it to be used by pricing functions.
You can also use right click to delete or add a field to your table, as well as to navigate the Field catalog on the right side of the screen. Not all of the fields can be shown in a single page of field catalog.
After successful creation, you will be prompted to create a change request and afterwards, you will be presented a log screen like you can see on the following screen.
You have successfully generated a condition table let's see if we can see it in the access sequence maintenance screens.
It's there, so now we can create an access using this table. We will not cover this in detail as it is extremely straight forward process.
On the accesses node of our access sequence, choose New entries button. You can create access like in the below screen for testing purposes.
Fields should also be assigned to our access PB01 – 96 in order for it to work properly

3 comments:

  1. My friend Suggest me this blog and I can say this is the best blog to get the basic knowledge.Thank you so much for this SAP MM Training in Chennai blog

    ReplyDelete
  2. Thanks for the great information ,was looking for this information from long.Great blog SAP Basis Training in Chennai

    ReplyDelete
  3. Best blog.Got to learn new things.Thanks for this Blog SAP HR Training in Chennai blog

    ReplyDelete