on 07-29-2014 9:39 PM
I want to create a validation for t-code FB50 so that for any line item that contains a GL Account listed in a table, the validation would then check to see if the field Trading Partner is populated.
My question is How do I set up the validation so that the values in the table are referenced? I don't want to have to continually update the valid GL accounts in a set. I want the table to hold the values. The business users have a custom t-code to update the values in the Z table.
The Z table contains the field HKONT (GL Account). The table contains 1 record (it could contain more) with GL Account 123456.
My attempt was to create a set (Z_TP_ACCTS) that was based on the Z table and the corresponding field. I then set up my validation to compare the value entered in FB50 (BSEG-HKONT) to look at the set. My understanding is that the value would be compared to the values in the table, but my tests are failing. I did not enter any values in the set.
Any advice / help would be appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You will have to use an user exit to call up the Z Table to check for your requirement. There are lot of postings on SDN to use an user exit in FI Validations. The standard module pool provided by SAP is RGGBR000 for FI Validations. You can write a form in this.
Additionally you also have the option of using a BTE for this. The one I can recollect are 00001011 or 00001085
Thanks & Regards
Sanil Bhandari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
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.