Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi, I think replace BKPF-TCODE by SY-TCODE only. Rest are OK. On Wed, Aug 25, 2010 at 6:24 PM, VidhyaDhar via sap-acct < sap-acct@groups.ittoolbox.com> wrote: > Posted by VidhyaDhar(User-friendly SAP FI Consultant) > on Aug 25 at 8:56 AM Hi > Joe > > Please note that you can use a set and write your validation. The problem > is > not with the set but with the syntax preferred by you. When you re-write > the > pre-requisite with the correct syntax, it becomes usable. > > You had used the syntax for the pre-requisite as: > > > > BKPF-TCODE = 'FBZ1' AND BSEG-HKONT NOT IN BANKACCOUNTS > > You were almost correct but for a minor syntactical change wanting. > > The syntax should have been > > > BKPF-TCODE = 'FBZ1' AND NOT ( BSEG-HKONT IN BANKACCOUNTS) > > Always bring the NOT ahead of the condition and it would work. > > Try it out, please > > Regards > > VidhyaDhar > > On Tue, Aug 24, 2010 at 7:19 AM, Joe Harrison via sap-acct < > sap-acct@groups.ittoolbox.com> <http://groups.ittoolbox.com%3E> wrote: > > > Posted by Joe Harrison(SAP FICO Consultant) > > on Aug 23 at 9:54 PM Thanks > > all > > > > In the end I did not use a set. I put in a range. If the GL was outside > the > > range then the error is prompted. > > > > BKPF-TCODE = 'FBZ1' AND ( BSEG-HKONT < '100000' OR > > BSEG-HKONT > '105000' > > > > > > > > ---------------Original Message--------------- > > From: Joe Harrison > > Sent: Thursday, July 15, 2010 1:30 AM > > Subject: Writing a validation - how do I exclude values in a set > > > > > I always seem to get a red light when I try exclude values in a set I > > have created. > > > > > > My prerequisite statement is: > > > > > > BKPF-TCODE = 'FBZ1' AND BSEG-HKONT NOT IN BANKACCOUNTS > > > > > > BANKACCOUNTS is the set holding a list of GL accounts. > > > > > > How do I rewrite the statement so that the transaction code must be > FBZ1 > > and the GL account is not in my set. | __.____._ Copyright © 2010 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | Related Content White Papers In the Spotlight _.____.__ |