Table maintenance generator Events

[Former Member]

Hi Experts,

I am facing the problem with table maintenance generator events.

According to my requirement, I have to validate the data while saving based on KNVV table. Here for some fields there is no foreign key relation. so i had to write the code in the EVENT BEFORE SAVE. In this Event i have used the statement like "select * from KNNVV' and i am validating the data. But the system is giving the message saying that the select statement is not accessable.

Please let me know, How to validate the data based on the table?

Regards,

TMR.

[Former Member]

Hi Experts,

I am facing the problem with table maintenance generator events.

According to my requirement, I have to validate the data while saving based on KNVV table. Here for some fields there is no foreign key relation. so i had to write the code in the EVENT BEFORE SAVE. In this Event i have used the statement like "select * from KNNVV' and i am validating the data. But the system is giving the message saying that the select statement is not accessable.

Please let me know, How to validate the data based on the table?

Regards,

TMR.

[deepak_dhamat]

Hi ,

tables: KNVV .

select single * from  KNVV
where KUNNR = kunnr
VKORG = vkorg
VTWEG = vtweg
SPART = spart.

if  sy-subrc  = 0 .

table entry is there  .

else .

No entry .

endif.

Which SAP version you are using .

regards

Deepak.

Edited by: Deepak Dhamat on Oct 12, 2011 1:30 PM

[Former Member]

Hi Deepak,

As you mentioned i have used the same code, even though the system is giving the same messages saying that "statement can not be accessable" .

I am working on ECC 6.0

Regards,

TMR.

[Former Member]

Hi,

Have you re-activated your function group in SE80 after creating your event form?

If yes, can you paste your exact code over here?

Kr,

Manu.

[Former Member]

Have you entered FORM...ENDFORM statements manually at the include where you're making your select statement?

If I remember it right, they're not automatically entered by system.

Regards

Mauricio

[Former Member]

Hi,

lol... indeed... I would not tought of such a mistake...;) good catch, mate!

so, as Mauricio said, add the FORM/ENDFORM and don't forget to activate your FG afterwards...

Kr,

Manu.

[Former Member]

Thx manu!

That FORM..ENDFORM thing in SM30 events already made me very nervous in the past!

BR

Mauricio

[Former Member]

Mauricio Robert is correct..... u have to use FORM.... ENDFORM