Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Table Maintenance- Condition Records

Former Member
0 Likes
1,250

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

1 ACCEPTED SOLUTION
Read only

andreas_mann3
Active Contributor
0 Likes
1,204

try se55 - modifications - events - 'AA'

and create a form with you condition

A.

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

9 REPLIES 9
Read only

andreas_mann3
Active Contributor
0 Likes
1,205

try se55 - modifications - events - 'AA'

and create a form with you condition

A.

Read only

Former Member
0 Likes
1,204

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

Read only

former_member404244
Active Contributor
0 Likes
1,204

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%20im...

Regards,

Nagaraj

Read only

Former Member
0 Likes
1,204

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..

Read only

Former Member
0 Likes
1,204

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

anyways thanks a lot for those who replied

Read only

0 Likes
1,204

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

Read only

0 Likes
1,204

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.

Read only

0 Likes
1,204

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

Read only

0 Likes
1,204

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