CRM Bp TRX Doubt about validation field TAX NUMBER tab Identification

[Former Member]

Good afternoon,

I have the following problem, is required to make a validation on the Tax Number field in the Identification tab. I searched for Badis or exits without success.

Anyone knows if there is any other way to do this validation? I meant, maybe there is any trx where some fields validations are include

I know little or nothing of CRM.

Any help is welcome and if there is some missing information please let me know,

Thanks a lot,

Sorry for my english

Tulio G.

[Former Member]

Hello Tulio,

As per my understanding, you want to make validation on the tax number field in the identification tab. If this is the case, then below you can find the details as how you can achieve this.

Suppose you want to do the validation check for Germany. Country code DE.

1. In transaction OY17, select this country and maintain the length and check rule for tax numbers. On maintaining this, your length of the tax number (which you maintain in transaction BP) will be checked. Also the check rule will be considered to see if it is numeric, alphanumeric, etc..

2. Every tax type is legally defined and so the tax numbers are to fulfill certain criteria. Thus there are algorithms written to check if the tax numbers are acceptable by goverment or not. These validation are written in function modules TAX_NUMBER_CHECK and EU_TAX_NUMBER_CHECK.

To activate these algorithmic checks, you need to go to transaction OY17 -> select the country -> tick mark the check box with text 'OTHER DATA'.

3. to enable the duplicate check functionality, you need to maintain the customizing in view V_TFKTAXNUMTYPEC. For the required tax type, you need to set the option as ON.

Hope this helps you. If you have any specific problem with tax numbers, please mention in detail.

Best regards,

Rimzhim

[Former Member]

Thanks for your reply Rimzhim Agarwal

I´ve found something useful, the requirement is avoid one validation when taxcategory is repeated and it has to let me complete the tax number with one specific word in every position.

For example:

Tax category Tax number

BR3 SPECIFICWORD

BR3 SPECIFICWORD

I hope this information is clearer.

They told me that in the past they use the tRX BUS7 event DCHCK. But it´s not the validation they mentioned.

There is a way to, knowing the function, know which event call it?

Thank you!

[Former Member]

Hi Tulio,

This kind of check is best implemented in the view PAI level. This does the check on the sceen level. THe DCHCK event does a global level check..

Go to transaction BUPT and search for 'Views'. Within this menu, look for the Tax Number view..now select this and click on 'Further Checks'. You can register your Z module here.

In case you want to avoid some checks made in the standard, you would need to modify the standard code. The standard PAI module can be seen by selecting the view and double clicking - it will show you the PBO . PAI, PBC modules.

Please note - its not advisable to modify std checks, esp for tax fields since it is a legally important field !

Hope this helps you.

Cheers,

Rishu.

[Former Member]

Thanks Rishu.

It´s been a modification on requirement:

On first tab (Adress) there is a validation which checks NAME1 and shows the following error "The use of the last 5 characters in field NAME1 is restricted (40 of 40)".

When i go to the next tab (Identification) and i enter a TAX CAT with the same country as costumer in tab ADRESS it shows the error:

"Tax Category must be of the same country as the customer"

The requirement is avoid this message because the country is the same.

Any ideas? I look on BUPT 'Views' but i can´t avoid this message which is a Z message but i don´t know how they configure it.

Thanks a lot..

[Former Member]

I´ve found a validation exactly where you said.

The only thing i have left is find the way to obtain the value of the field COUNTRY on first tab.

Thanks.

[Former Member]

Hi Tulio,

To get the country that was entered on the first tab, you need to use the memory query modules of the Address management.

For a person address, you can use ADDR_PERSONAL_GET, and for organization you can use ADDR_GET.

You would probably need to pass some details to these modules - such as address number, person number etc.

You can get those details from a bupa BUP_BUPA_BUT000_GET AND BUA_BUPA_BUT020_GET...( sorry, i dont have access to an SAP system so i'm not 100% sure about the module interface..basically, you need to use some but000_get and but020_get modules from the function group BUD0/BUD1 and BUA0/BUA1 respectively since these func groups have access to memory structures during the BP processing. One look at the names of the modules in the function groups will make it quite obvious as to which FM will help you !)

Hope this solves your issue.

Regards,

Rishu.

[Former Member]

Thanks again Rishu!!!

They decided to stop the requirement but i find one function : BUA_ADDRESS_GET, and they use it to compare the country.

I sew they obtain every field empty, it seems that the PARTNER is not saved (All this problem occurs when they created a BP).

So i think that this function doesn´t "access to memory structures during the BP processing".

I really apreciate your help, it was very helpful.

Again sorry for my english.

Tulio.