Skip to Content
Author's profile photo Former Member

Payment Term Text Determination in VK11 Using BTE

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.

Assigned tags

      31 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ' MoazzaM '
      ' 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$

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks ' MoazzaM '

      Author's profile photo Suhaib Bin Aziz
      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

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Suhaib 🙂

      Author's profile photo Former Member
      Former Member

      Thanks Ammarah for such a valuable documents...its very much useful...... 🙂

      Regards,

      Pankaj

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you pankaj for the kind words. Stay blessed.

      Author's profile photo Former Member
      Former Member

      Very Informative...Many Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Naresh. Stay blessed 🙂

      Author's profile photo Former Member
      Former Member

      Thanks a lot , i am always intersted in the condition technique as i found it from the strongest techniques that sap use , flexible and effective

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      🙂

      Author's profile photo venu gopal
      venu gopal

      Thanks a lot for sharing

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks venu 🙂

      Author's profile photo Former Member
      Former Member

      Hi Dear,

      Thanks for such an informative document... 🙂

      Regards,

      Khushi

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you for the appreciation Khushi 🙂

      Author's profile photo Srinu S
      Srinu S

      Hi Ammarah,

      Very nicely presented. helpful document.thanks for sharing.keep sharing this kind of docs.

      thanks,

      Srinu.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thankyou Srinivas S.

      Author's profile photo Pradeep Mani
      Pradeep Mani

      Very Informative document..

      Thanks,

      Pradeep

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Pradeep Mani 🙂

      Author's profile photo Former Member
      Former Member

      Very Informative and Nicely presented.

      Thanks

      Pronojit

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Author's profile photo Amit Tunara
      Amit Tunara

      Hi,

      It is very informative and useful document.

      Thanks for sharing.

      Amit Tunara

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Amit Tunara and i hope this will be useful for many of us.

      Author's profile photo Suman Sardar
      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$

      Author's profile photo Former Member
      Former Member
      Blog 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.

      Author's profile photo Modadugu Hemanth Kumar
      Modadugu Hemanth Kumar

      Hi  * Ammarah *  thanks for posting very useful and informative document.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Modadugu Hemanth Kumar. Appreciate the kind words. 🙂

      Author's profile photo rajesh bethamcharla
      rajesh bethamcharla

      Hi * Ammarah *  thanks for sharing the article....new to me.... 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you once again rajesh bethamcharla

      Author's profile photo Former Member
      Former Member

      Very nice document.

      Thanks.

      Ramesh Kumar.

      Author's profile photo Former Member
      Former Member

      Very usefull document,

      Thank you

      Regards,

      mahaboob shaik

      Author's profile photo Shiva Vasireddy
      Shiva Vasireddy

      This is Beautiful.and Thank you