Skip to Content

Business Requirement:

For our monthly policy customized application, there was a requirement to maintain multiple Pricing records for different Payment Terms but with same Validity period (Payment Term should be at Item level). As per Standard SAP we can’t have multiple records in the same condition under key values Valid on the same date. Condition Valid From and Valid To Dates are part of the primary key in the database table hence date ranges between the records cannot overlap. When we create a new record system will pick the most recent record and overwrite the previous one.


So in order to achieve the same we’ve added ZTERM (Payment Term) so that the system proposed the field in the field catalog.

/wp-content/uploads/2013/08/1_265201.png

/wp-content/uploads/2013/08/2_265229.png

Included ZTERM as a new entry. Now we can use field ZTERM as a key field when we’ll create new Condition Table.

/wp-content/uploads/2013/08/3_265230.png

So what we’ve done is created a Condition Table as:

Sales org./Distr. Chl/Matl Group/Price grp/Mat.pr.grp/Payt T

/wp-content/uploads/2013/08/5_265231.png

Issue arises after this point as when we’ve tried to maintain condition record in this Condition Table system does not display the description from the text table i.e; Payment Term Description was missing.

/wp-content/uploads/2013/08/1_265201.png


Symptom:

In Standard there are some fields which are not prepared in standard condition maintenance regarding field text determination and that does not handle text determination from the relevant text table. Few standards field are ZTERM, REGIO etc.

Solution:

During the condition maintenance for Prices/Surcharges/Discounts in VK11 the descriptive text has not been determined for ZTERM (Payment Term) in the Header/Line item of the condition maintenance so we used BTE (Business Transaction Event) in order to determine the text.

.

Execute FIBF

/wp-content/uploads/2013/08/6_265241.png

Give the Product name that will link the event with the function module. Enter the product name description and check box A is required in order activate the product.

/wp-content/uploads/2013/08/7_265242.png

Select the appropriate event which gets triggered during the execution and against the event assign the Product name which was created above and assign a function module name. Take appropriate event which will fulfill the requirement and in my case it is 00503306 (Maintain conditions: Text determination)

Against the corresponding BTE check the Sample Function Module in SE37 and copy the same into the Custom Function Module Z*.

/wp-content/uploads/2013/08/8_265243.png

/wp-content/uploads/2013/08/9_265250.png

The desired logic will be encoded in the Custom Function Module. Save and Activate the FM. Be noted that the Creation of correct Function Module is necessary.

/wp-content/uploads/2013/08/11_265251.png

Further link the newly created customized Function Module and the Event using the product created.

/wp-content/uploads/2013/08/12_265252.png

/wp-content/uploads/2013/08/13_265253.png

Test the BTE. Now Description field is coming up while Condition Record maintenance.

/wp-content/uploads/2013/08/15_265254.png

NOTE: This might be considered as a common Knowledge but posting on SCN with this surety that it will also be helpful for many. Any feedback will be highly valued and appreciated. Thanks.

To report this post you need to login first.

31 Comments

You must be Logged on to comment or reply to a post.

  1. ' MoazzaM '

    Ammarah

    It is not common but very informative document and the way you presented the issue and its solution is appreciatable. If you add one more screen shot where ZTERM text is missing will add more value to this document and it will help to compare the difference of any field with and without description in create condition screen.

    Keep posting and sharing your ideas and knowledge with others.

    Thank$

    (0) 
  2. Suhaib Bin Aziz

    Dear Ammarah you always been presented your self with significant material on SCN. This is very informative document although this scenario is not very much familiar but very rare and effective for maintaining multiple payment terms against one validity date also you describe its text determination quite well. i hope you will always share your effective and informative material with us on SCN. Thanks!

    Regards,

    Suhaib Bin Aziz

    (0) 
  3. Suman Sardar

    Ammarah,

    Although I think for a description in VK11 we may not go for the BTE you mentioned but your way of presentation is quite cool.Indeed a nice document.

    Thanks for sharing.Keep it up.

    Thanks,

    Suman$

    (0) 
    1. * Ammarah * (Away) Post author

      Dear Suman,

      To avoid Modifications in a Standard Program (dependent on Release Version) or creation of special Routine checks, we’ve implemented BTE functionality against Payment Term Text Determination however thank you for appreciating and liking the document. Rgds.

      (0) 

Leave a Reply