EVENT 01-Table Maintenance Generator

[kiran_k8]

Hi,

I had created a TMG having one field as BUKRS.Now I want to have a check on this field so that I can validate the entries based on the T001 entries.This way only the Company codes that are exisiting in this instance can be maintained in the table.For this I had created a subroutine using the EVENT 01.Now in this subroutine I will write a select query on t001 comparing it with the table entires that are maintained.If a wrong company code is entered it should shown an error message and stay on the same screen.

1.How to capture the details that are entered by the User.I had checked the internal tables TOTAL and EXTRACT.I am finding the entries in this but it seems I have to use offset to get the details.Isn't there any internal table which will capture the details fieldwise.

2.I want to check only the new entries or changes entries and not the whole table everytime the user SAVES.I think there should be some internal table within the include LSVIMF14 or some other includes of the function group.To be prcise any internal table which will hold only the modified entries and new entries.(Internal tables within the standard includes of TMG)

Do anyone here can throw some light on the above.

Thanks,

K.Kiran

[Former Member]

Hi,

if you assign a check table to your BUKRS table field, after creating a TMG the check is done automatically.

You need no additional subroutines.

Regards,

Klaus

[kiran_k8]

Klaus,

Thanks a ton

select the field BUKRS in the table and click on the FOREGIN KEYS icon

Shown me a pop up with a message "create a proposal with values table T001 as check table

Here I got a pop up screen with many options for ex screen check where check required is ticked.Clicked on COPY.Now the check on BUKRS field is set at the level of TMG.

Do we need to regenerate the TMG again ?

What is generate proposal and other options that we see while setting the check table like cardinality,foregin key type etc

[Sandeep_Panghal]

regenerate the TMG again -> i dont think you need to regenerate the view again as only technical settings have been changed.

What is generate proposal and other options that we see while setting the check table like cardinality,foregin key type etc -> this depends on the reuirement.

[kiran_k8]

Sandeep,

Any example you can share with on using those options.

Thanks,

K.Kiran.

[Wil_Wilstroth]

Hi Kiran,

You should try using EVENT 21, it allows you to click 'Enter' then it will go into the coding to check your validation...

Cos your issue description looks very much like what i had recently did...

hope it helps...

Thanks,

Wilstroth

[Former Member]

Hi,

yes you have to gererate the TMG again, because the screen of the view has to be generated for activation of the value checking.

Regards,

Klaus

[kiran_k8]

William,

Assignng a Check table to the field BUKRS is serving the purpose.

Thanks,

K.Kiran.