We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

Re: [sap-acct] Writing a validation - how do I exclude values in a set

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by SAP_FI_NEW_GL (Financial)
on Aug 26 at 12:40 AM
Mark this reply as helpfulMark as helpful
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
Toolbox.com for iPhone: Ask Questions & Get Answers Anywhere. Use the New iPhone App
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language