topic Re: Table Maintenance View in Application Development and Automation Discussions

Table Maintenance View

Former Member — Wed, 24 Jan 2007 07:06:24 GMT

I have created a custom table with fields EKORG, EKGRP,APPROVER(XUBNAME), Release Code (FRGAB), Financial Limit (CURR 15), WAERS, USER_CHANGE, DATE_CHANGE, TIME_CHANGE.

Also, created a maintanence view for the table.

If I create an entry in sm30 and save it, my requirement is that the last three fields named User Change, Date Change and Time Change should be populated automatically. Is events will do for this ? If so, please let me know how to find the subroutine to code for!

Re: Table Maintenance View

Former Member — Wed, 24 Jan 2007 07:10:36 GMT

I hope you have to link those fields to a check table or value table.

Re: Table Maintenance View

Former Member — Wed, 24 Jan 2007 07:15:05 GMT

Hello

1. On se11 go to your table.

2. Then go to table maintenance generator on utilities Menu.

3. On Eviroment menu go to modification ->maintenance screens.

4. Create a sy-ucomm flag for enter KEY on the pf-status (PBO).

5. Create a new module on the PAI.

6. Put sometingh like this:

save_ok = function. " function has the value of the pf-status

IF save_ok = 'ENTER'.

....." Do whatever you need on your table

ENDIF.

That is it....

Hope it helps

Gabriel P,

Re: Table Maintenance View

Former Member — Wed, 24 Jan 2007 07:34:51 GMT

hi Josephine,

You can do this; you need to populate these fields in the PBO of the custom screen generated, while table maintenance generator is created.

1->Goto SE11, Enter view name and choose the corresponding radio button

2->from menu, navigate to UTILITIES->TABLE MAINTENANCE GENERATOR

3->double click on the overview screen field (for eg: 9000).

Now you are in the flow logic;

4->create a new module in the PBO, called inside

the loop..endloop of table control

5->replace the "LISTE_SHOW_LISTE" (if this is the one currently used inside your loop..endloop) with your module. But copy the entire code in the existing module and paste them in your module.

your code should be to populate the table control fields with <b>sy-uname, sy-datum and sy-uzeit </b>, based on the validation if other fields are empty of not.

you dont need to validate the sy-ucomm, because, whenever save or delete or edit is done, the values present in the table control will be automatically saved to table.

if you dont want to display the values on edit mode, you need only to change the PAI, to update the table, based on SY-UCOMM (save), and populate the <b>sy-uname, sy-datum and sy-uzeit </b> into the corresponding database fields.

Hope this helps,

Sajan Joseph.

Re: Table Maintenance View

Former Member — Wed, 24 Jan 2007 11:02:51 GMT

Hai Clara

Go through the following Document & Example for Search Helps

The Matchcode is replaced by search help from the version 4.6C.

I will tell u how create the search help.

Name of a search help

A search help is an object of the ABAP Dictionary with which input helps

(F4 helps) can be defined.

There are the following types of search helps:

o Elementary search helps implement a search path for determining the

possible entries.

o Collective search helps contain several elementary search helps. A

collective search help therefore provides several alternative search

paths for possible entries.

o Append search helps can be used to enhance collective search helps

delivered by SAP with customer-specific search paths without

requiring a modification.

The three components of the input help process described by a search

help are the outer interface, the online behavior and the method of data

Go to Tcode SE11. Select the search help radio button.

Give name as ztest and click create

There are two types of search help.

Once is elementary search help

& collective search help

Choose one.

Add the data element.

MatchCode is replaced by search helps.

To attach a search help to a field.

Use this code.

at selection-screen on value-request for source.

progname = sy-repid.

dynnum = sy-dynnr.

clear value_tab.

refresh value_tab.

Filling the Value_tab internal table by itab2 internal table.

*----

loop at itab_desc.

write itab_desc-description to value_tab.

append value_tab.

endloop.

*----

prog = sy-repid.

no = 1000.

clear tab.

refresh tab.

*----

Building the Structure of the Seach Help.

tab-tabname = 'FMFCTRT'.

tab-fieldname = 'BESCHR'.

collect tab.

Function Used to provide Search Help.

call function 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'BESCHR'

dynpprog = prog

dynpnr = no

dynprofield = 'SOURCE'

window_title = 'Function'

TABLES

value_tab = value_tab

field_tab = tab.

Regards

Sreeni