topic Re: table maintenance: address number fields in Application Development and Automation Discussions

table maintenance: address number fields

Former Member — Tue, 09 Aug 2005 09:34:46 GMT

Hi all,

I have an addressnumber field included in a Z-table, which has data element ad_addrnum. I also assigned an external key to this field (ADRC-ADDRNUMBER) and a searchhelp (ADDRESS1).

I created a table maintenance object. Like this, SM30 will not let me do anything with the addrnumber field, as an entry in tsadrv was missing. I added that, but now I get a full-blown address editing function which I don't need and don't want. I just want to be able to check that the addressnumber entered by the user exists in ADRC, that's all.

I tried changing the domain of my address number field, but then using a checktable is no longer possible.

So far trying different settings for my address field intry in table TSADRV als did not help.

I am working with an SRM system, on basis release 6.40.

Any ideas?

Thanks in advance!

p.s. this question was posted earlier in the sapfans forum, my apologies to those of you who also read it there.

Re: table maintenance: address number fields

Former Member — Tue, 09 Aug 2005 09:42:55 GMT

Hi Arjan,

also have a look at table TSAD7 where you have to register your address group as maintainable directly...

hth, Tim

Re: table maintenance: address number fields

Former Member — Tue, 09 Aug 2005 09:54:33 GMT

Have a look at this link

http://help.sap.com/saphelp_40b/helpdata/en/4f/991f82446d11d189700000e8322d00/applet.htm

Re: table maintenance: address number fields

Former Member — Tue, 09 Aug 2005 12:38:46 GMT

good point Tim, I hadn't done that. There was a very inconspicuous remark in a help text on that table I saw now. Unfortunately it didn't solve my problem....

Thanks for your interest Tim!

Re: table maintenance: address number fields

Former Member — Tue, 09 Aug 2005 14:07:41 GMT

Hi Arjan,

If you want to validate the address field you can write your own code in the PAI.

You can write your own code in the screen of table maintenance generator.

I did lots of validation for table maintenance.

Hope this will help you. If you want sample code, i will send to you.

Thanks

Swagatika

Re: table maintenance: address number fields

denis_skuridin — Thu, 08 Aug 2013 08:21:28 GMT

Hi Profis,

has anybody soved this issue in the last 8 years? 😉 The same is addressed in http://scn.sap.com/thread/1393178 but also without result.

Or maybe there is any reliable explanation why the field of type ADDRNUM cannot be viewed as a field and cannot be used in a search filter in SM30?

Thx!

Re: table maintenance: address number fields

denis_skuridin — Thu, 15 Aug 2013 09:53:39 GMT

Though I haven't found a direct answer for it, the issue was solved using some tricks:

1. Change the type of the field to NUM10

2. Regenerate maint. dialog -> field should be now visible

3. Reset field type, do not regenerate main. dialog

4. In SM30 use menu Selection-By Contents and the field is still visible.

But your explanations are welcome anyway!