topic Re: 'Z' table issue in Application Development and Automation Discussions

'Z' table issue

Former Member — Tue, 11 Aug 2009 09:04:24 GMT

Hi Gurus,

I have a Z table with only 2 fields MANDT and KUNNR ( both are key fields )

When i create new entries in this Z table , it is allowing me to save with "Blank entry". It should not allow

Please let me know how can i solve this issue.

Regards,

Avi.

Re: 'Z' table issue

matt — Tue, 11 Aug 2009 09:05:55 GMT

You can only prevent this in your program. I.e. before updating the table, check the values aren't blank.

matt

Re: 'Z' table issue

Former Member — Tue, 11 Aug 2009 09:08:00 GMT

hi,

check not null flag for the field KUNNR in your z-table in SE11.

This is just after the Key Field Flag.

Regds,

Anil

Re: 'Z' table issue

Former Member — Tue, 11 Aug 2009 09:08:48 GMT

Hi ,

have you maintained the foreign key relation for the key fields.

Please let me knwo if you still have any issues on this.

Thanks and regards,

Rajeshwar.

Re: 'Z' table issue

Former Member — Tue, 11 Aug 2009 09:16:05 GMT

Hi Matt,

The table will not be updated through a program

Hi Anil,

What you suggested is fine but ; even if we uncheck not initial entries it will get checked again at the time of activating the table.

Hi Rajeshwar,

I have maintained Foreighn key relation also ; still if i click on new entries and give a space and save its getting saved.

Thanks a lot for all your help .

Gurus,

Please let me know if you have got any knowledge of EVENTs in table maintenance generator.

Regards

Avi

Re: 'Z' table issue

SuhaSaha — Tue, 11 Aug 2009 09:20:22 GMT

Hello Avi,

Here is the SAP documentation on [TMG Events|http://help.sap.com/saphelp_erp2004/helpdata/EN/91/ca9f0ea9d111d1a5690000e82deaaa/frameset.htm]

Can you please explain what do you mean by:

even if we uncheck not initial entries it will get checked again at the time of activating the table.

BR,

Suhas

Re: 'Z' table issue

Former Member — Tue, 11 Aug 2009 09:21:03 GMT

How do you fill the Z-TABLE?

If you don't use a program, probably it was generated a maintenance program for SM30? If it's so, jus as Matt said, u need to change the maintenance program in order to prevent a blank hit.

U can change directly the program or u can create a routine for an event of SM30, u can use the event 05.

Max

Re: 'Z' table issue

Former Member — Tue, 11 Aug 2009 09:21:12 GMT

Hi ,

check what is the data type associated with the field, change the data type( i mean domain ) .

PLease let me know fi you still have any issues on this.

Thanks and regards,

Rajeshwar.

Re: 'Z' table issue

matt — Tue, 11 Aug 2009 09:22:13 GMT


> Hi Matt,
> 
> The table will not be updated through a program
> 
> 
> Please let me know if you have got any knowledge of EVENTs in table maintenance generator.
> 
> Regards
> Avi

Right - you're updating it with the TMG. ( Which is a program ). Why didn't you say that in the first place?

For information about events, why not read the TMG help? The event most useful to you would be '01' - "Before saving the data in the database".

matt

Re: 'Z' table issue

Former Member — Tue, 11 Aug 2009 09:29:27 GMT

Hello rajeshwar,

It has nothing to do with foreign key relationship.

It is just about you want to accept the null entry in table or not. i.e. NOT NULL indicator should be checked.

Thanks,

Augustin.

Re: 'Z' table issue

Former Member — Tue, 11 Aug 2009 09:30:57 GMT

Hello Avi,

<<Copy and paste removed>>

These kind of help you can get in SAP GUI itself or else you can explore SAP help before coming to SDN.

There is lot to explore in SAP! Enjoy SAP!

Thanks,

Augustin.

Edited by: Matt on Aug 11, 2009 12:10 PM - please do not copy and paste from SAP Help or other sources. However, the sentiment is good - try reading the documentation!

Re: 'Z' table issue

Former Member — Thu, 23 Sep 2010 09:37:26 GMT

Answered