'Z' table issue

[Former Member]

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.

[matt]

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

matt

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[SuhaSaha]

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

[Former Member]

Hi

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

[matt]

>

> 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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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!

[Former Member]

Answered