topic Re: Z-table row valdiations in Application Development and Automation Discussions

Z-table row valdiations

jogeswararao_kavala — Thu, 13 Feb 2014 10:21:44 GMT

Hi ABAP Experts,

My Z table has 4 fields.

The Conditions for uniqueness are

1. Filed1 value should be unique.

2. The combination of Fields 2,3 and 4 should be unique.

How do I achieve both these, using Primary keys OR in combination of Primary Key and other methods.

Regards

Jogeswara Rao K

Re: Z-table row valdiations

Former Member — Thu, 13 Feb 2014 10:28:11 GMT

1. For that u will have to use

EVENTS

generated in table maintanance.

2. There u can write your own code,

to validate the entries.

Re: Z-table row valdiations

Former Member — Thu, 13 Feb 2014 10:29:56 GMT

hi jogeswara,

only one ztabel is required or is there option to creation one another z-table?

regard,

vikas

Re: Z-table row valdiations

Former Member — Thu, 13 Feb 2014 10:30:19 GMT

Hi,

You can do the validation in events of TMG. Just concatentate the 2nd, 3rd and 4th fields and check in the other records similar combination is there or not. If exists, throw one error message.

Regards,

DPM

Re: Z-table row valdiations

VijayaKrishnaG — Thu, 13 Feb 2014 10:37:33 GMT

Hi all, I have a doubt will this TMG events get triggered if I am updating/modifying table from ABAP Report???

-Vijay

Re: Z-table row valdiations

Former Member — Thu, 13 Feb 2014 10:48:21 GMT

Hi,

If you are updating in custom report. Do the validations first and once the data is clean, update the database.

Regards,

DPM

Re: Z-table row valdiations

jogeswararao_kavala — Thu, 13 Feb 2014 10:51:37 GMT

Hi DPM,

Mine is TMG situation.

I'm in need of a sample code, and the event where I put this.

Jogeswara Rao K

Re: Z-table row valdiations

Former Member — Thu, 13 Feb 2014 11:00:31 GMT

Go to the Table Maintenance Generator Function group in SE80.

Go to the Screen flow logic .

Write your Code in PAI event

e.g

PROCESS AFTER INPUT.

MODULE LISTE_EXIT_COMMAND AT EXIT-COMMAND.

MODULE LISTE_BEFORE_LOOP.

LOOP AT EXTRACT.

MODULE LISTE_INIT_WORKAREA.

CHAIN.

FIELD ZTABLENAME-fldname.

FIELD ZTABLENAME-fldname .

FIELD ZTABLENAME-fldname.

MODULE SET_UPDATE_FLAG ON CHAIN-REQUEST.

MODULE validtate. " This is custom Module . write your validation logic with in this module.

ENDCHAIN.

FIELD VIM_MARKED MODULE LISTE_MARK_CHECKBOX.

CHAIN.

MODULE LISTE_UPDATE_LISTE.

ENDCHAIN.

ENDLOOP.

MODULE LISTE_AFTER_LOOP.

Re: Z-table row valdiations

Former Member — Thu, 13 Feb 2014 11:01:59 GMT

check this Table Maintenance Generator for event Number 01 and 05 - Contributor Corner - SCN Wiki

Re: Z-table row valdiations

Former Member — Thu, 13 Feb 2014 11:10:54 GMT

Hi,

Check event 01 for view V_FMFG_T095.

Otherwise, go to table TVIMF, display the entries, check on modules with 'CHECK' or 'VALIDATE' on its description.

Regards,

DPM

Re: Z-table row valdiations

Former Member — Thu, 13 Feb 2014 11:18:29 GMT

Hi,

The Conditions for uniqueness are

1. Filed1 value should be unique.

2. The combination of Fields 2,3 and 4 should be unique.

1. Create primary key

2. Create unique index in se11 .