on 09-05-2014 10:57 AM
Dear Gurus,
I want to make validation in FI with OB28 to validate WBS number start with D910002* only valid for GL account 400000.
But, I find difficulties on how to create formula for D910002* ( this range is alphanumeric)
I created Basic Set (GS01) ZGL_COS , with dynamic set, I put range as D910002AAAAAA – D910002ZZZZZZ
My plan for validation will be as below :
Prerequisite :
BKPF-BUKRS = ‘1000’ AND BSEG-PROJK IN ZGL_COS
Check :
BSEG-HKONT = ‘400000
But I can’t Save it, SAP give error message as below :
The entry of group ZGL_COS_NONPOC is not valid
Message no. GR383
Diagnosis
The entry of set ZGL_COS_NONPOC2 is invalid, because it is a selection variant or contains a selection variant.
Since values that are selected with selection variants can change at any time without changing the definition of the group, selection variants cannot be used in the following positions:
• In the columns of a Report Writer report
• as default sets for set variables
System Response
The entry is rejected.
Procedure
Enter a group that does not contain a selection variant.
It seems SAP recognizes my data as “selection variant”.
Do you guys know how to validate WBS with alphanumeric ranges in the efficient way?
Thank you.
Hi,
In the message ZGL_COS_NONPOC and ZGL_COS_NONPOC2 are mentioned. However, in the validation formula you described, I see no such sets. So, please, check where did you put a link to these groups.
Regards,
Eli
P.S. Also, if this is a range, you can manage it without a set. Just create a rule: BSEG-PROJK >= X AND BSEG-PROJK <= Y, where X and Y are the extreme values of the range
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Apologize, I mean as below :
Prerequisite :
BKPF-BUKRS = ‘1000’ AND BSEG-PROJK IN ZGL_COS
Check :
BSEG-HKONT = ‘400000
But I can’t Save it, SAP give error message as below :
The entry of group ZGL_COS_COS is not valid
Message no. GR383
Diagnosis
The entry of set ZGL_COS is invalid, because it is a selection variant or contains a selection variant.
Since values that are selected with selection variants can change at any time without changing the definition of the group, selection variants cannot be used in the following positions:
• In the columns of a Report Writer report
• as default sets for set variables
System Response
The entry is rejected.
Procedure
Enter a group that does not contain a selection variant.
**
If I put rule BSEG-PROJK >= X AND BSEG-PROJK <= Y, it only applies for numeric value, Cmiiw, my value are alphanumeric, like D90001.LDD.X1A , D90001.LDD.X1B, etc. So, basically I need to validate all D910001* ,
how should I apply this in the formula ?
Thank you
Hi Narasimhulu
Yes, that is my query. I used set BSEG-PROJK already, but sap give error as above. The point is how to limit only Wbs with D910002* (all Wbs start with the D910002).
I have tried to use >= and =<, no success
Put D910002* in the set and formula, no success
Put D910002AAAA - D910002ZZZZ in the set and formula, also no success.
I can't enter every Wbs element in my set because thats mean I have to maintain two times in Wbs master data and also in the set,
Anyone maybe has other ideas?
You can't use PRPS-PSPNR, because in OB28 I am using BSEG-PROJK,
To make it clear, I will re-write my query :
I want to validate BSEG-PROJK with value only for D910002*, I have many wbs master data that start with D910002, (e.g. D910002.LDD.0010, D910002.XC1.0020, D910002.XY1.0020, etc.)
So I create OB28 as follow :
Prerequisite :
BKPF-BUKRS = ‘1000’ AND BSEG-PROJK IN ZGL_COS
Check :
BSEG-HKONT = ‘400000
ZGL_COS is a set based on BSEG-PROJK, using set with single value, because using Dynamic set will trigger error message as in my first posting.
In the set I can't use asterisk (*), which is required in my formula, I can't enter all my wbs in the set, because I will need to maintain the set every time there is new WBS with D910002*
I already tried to use >= and <= as you suggested, but no success,
Is there any other ideas ?
Hopefully my question is clear.
Really appreciate your response
Thank you very much.
I use PRPS-PSPNR already and sap give error as below as in my previous posting:
"set zgl_cos doesn't exist or can't be used"
I think it is because I used BSEG-PROJK in prerequisite but use different table in the set PRPS-PSPNR.
I need to validate BSEG-PROJK in Fi posting, not PRPS-PSPNR in Wbs master data.
No problem for the font
Ok, I see your point. I did some research and got to the conclusion, that you cannot do it with BSEG-PROJK. The values in BSEG-PROJK are converted WBS codes, i.e. internal codes used by SAP. So, even assuming that you can create a set with the values in question and use it in a validation, won't solve the problem.
You will be forced to use user-exit in your validation and convert the values. You can consult note
77268 - Conversion of sub-fields not correct for conversion information. If you are not familiar with user-exists in validation, consult note 842318.
Hi there,
Have a look to the note below that may help:
169973 - Error GR383 although set variable is used
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.