2008 Nov 26 12:34 PM
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
2008 Nov 27 8:49 AM
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
2008 Nov 27 8:49 AM
try se55 - modifications - events - 'AA'
and create a form with you condition
A.
2008 Nov 27 10:49 AM
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
2008 Nov 27 10:55 AM
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
Regards,
Nagaraj
2008 Nov 28 2:16 PM
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..
2008 Nov 28 2:27 PM
I think i have given a summary of what i have done in the previous reply
anyways thanks a lot for those who replied
2008 Dec 09 7:00 AM
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
2008 Dec 09 7:29 AM
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.
2008 Dec 09 8:24 AM
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
2008 Dec 09 9:56 AM
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
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |