topic Re: Table Maintenance- Condition Records in Application Development and Automation Discussions

Table Maintenance- Condition Records

Former Member — Wed, 26 Nov 2008 12:34:07 GMT

Hi Friends,

I have created a custom table and i have done a Table Maintenance for that custom Table..

In that i have one field called DATBI(which is To-date).

My Requirement is how to set condition in this table maintenance where IF TO-DATE < SYSDATE

those records should not be displayed in Table maintenance but that should be there in Data base table..

Can anyone help me on this.. I think something need to be done in PBO.

Plz help me on this..

Sample code will be helpful.

Thanks in advance.

kishore

Re: Table Maintenance- Condition Records

andreas_mann3 — Thu, 27 Nov 2008 08:49:37 GMT

try se55 - modifications - events - 'AA'

and create a form with you condition

Re: Table Maintenance- Condition Records

Former Member — Thu, 27 Nov 2008 10:49:04 GMT

Hi Andreas ,

I have tried what u have told before ifself....Thats not working for me. I am really new to this.

Donno whether i am doing the things wrong...Can u please eloborate me on this.

Will list what i have done below

1. gone to se55 and then modifications-----Events

2. Then i created as u said one form routine and clicked on editor .It asked for new include to be created . clicked on that.

3. This traversed me to SAPM standard program where the include i created was there.

4 Inside that i have written a piece of code given below.

if zcustdet_171 lt sy-datum.

loop at screen.

IF screen-name EQ 'ZCUSTDET_171-DATBI'.

screen-invisible = '1'.

screen-output = '0'.

screen-input = '0'.

MODIFY SCREEN.

ENDIF.

endloop.

ENDIF.

Is this right?

Regards

kishore

Re: Table Maintenance- Condition Records

former_member404244 — Thu, 27 Nov 2008 10:55:05 GMT

Hi,

Before updating the table itself u can check that and update the valid values in the table..

Try to use table maintainence generator events ..Please have a look at the below link

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

Regards,

Nagaraj

Re: Table Maintenance- Condition Records

Former Member — Fri, 28 Nov 2008 14:16:24 GMT

I found the method to specify the condition.

We need to use one module inside PBO to specify the condition..

Its working fine now...

Thanks Andreas and Nagaraj for replying to this thread..

Re: Table Maintenance- Condition Records

Former Member — Fri, 28 Nov 2008 14:27:03 GMT

I think i have given a summary of what i have done in the previous reply

anyways thanks a lot for those who replied

Re: Table Maintenance- Condition Records

Former Member — Tue, 09 Dec 2008 07:00:16 GMT

Hi,

I am having the same issue with you.

How did you do that? Where did you insert the code in PBO?

I can't hide the date field which is also a primary key field in table maintenance.

Regards,

genji

Re: Table Maintenance- Condition Records

Former Member — Tue, 09 Dec 2008 07:29:09 GMT

Hi genji,

Goto ur table and then utilities----

>table maintenance generator .

Then double click on the overview screen u specifed..It will direct u to PBO screen.

There inside PBO in the beginning create one module X(some name).

inside that specify ur condition whichever you want to..

piece of code which i have done for my condition records inside PBO

module modif_screen output.

data: datbi type datbi.

clear total.

loop at total.

move total+32(8) to datbi.

if datbi < sy-datum.

delete total.

endif.

clear : datbi.

endloop.

Here total is the internal table from where values are populated.

Think this wil solve ur issue.

Re: Table Maintenance- Condition Records

Former Member — Tue, 09 Dec 2008 08:24:36 GMT

Hi,

I want to hide the date field if condition is met. Were you able to hide the field ?

Can you paste the code here?

Thanks a lot

Re: Table Maintenance- Condition Records

Former Member — Tue, 09 Dec 2008 09:56:14 GMT

hi,

If you want to hide the data field means use Screen-invisible = '1'.

My requirement was to remove the record from the table if the condition is not met..

If u want to hide means use Screen-Invisible = '1'.

It will hide the particular field in the table

Regards

kishore