When i create a Table Maintenance Generator ,which is the event that will Trigger ?
Answer Posted / ravi
While creating the tables, sometimes we may need to update
the table fields in the background.
Lets take an example, if create a table with 10 fields in
those 10 fields there are 2 fields which are User name and
the Date, these 2 fields should update automatically when a
record Inserted/Updated in the table.
For this, we need to create a table maintenance generator
for that table. There in the table maintenance generator we
have an option to create EVENTS.
In the table maintenance generator,
Environment --> Modifications --> Events
then a screen will be appear here,we need to create the
Events, for updating the
fields create 05(Creating a new entry) and 21(Fill hidden
fields) .
In the EVENTS screen, press new Entries, there give 05 and
give a name(This will
become a PERFORM), then click the Editor pushbutton, this
will be there at the right side of the entry, then a popup
will be appear, you can create an include program,there
inside of the include program write the below code
form CREATE_ENTRY.
TABLE-USERNAME = sy-uname.
TABLE-CHANGED_ON = sy-datum.
endform.
Then in the events screen enter 21 and give the form name
as HIDDEN_FIELDS, then
press the editor button, then in the editor
form HIDDEN_FIELDS.
TABLE-USERNAME = sy-uname.
TABLE-CHANGED_ON = sy-datum.
update TABLE.
endform.
This CREATE_ENTRY Perform will be triggered for every new
entry and the
HIDDEN_FIELDS fields will be triggered for every changed
value in the table, so the
Fields USERNAME and the CHANGED_ON fields will be updated
automatically when a
new record inserted into the table or an existed record
changes through the table maintenance generator.
If you want any more functions, and then look at the
events, you can press the F4 and look at the description of
the event, then you come to know how to use and where to
use.
Regards
Ravi Palanivel
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What are logical databases?
What is the difference between skip and reserve?
What is the bapi?
Can i Have Some Realtime Examples On Modulepool programming.
Difference between .Include and .append?
How to know if the value entered contains records or not?
How to call transaction in session method without recording?
What is repository info. Systems? : abap data dictionary
What is the difference between commit-work and rollback-work tasks?
What is a type group?
What are the fields in a bdc_tab table? : abap bdc
Explain the call transaction method? : abap bdc
What are two methods of modifying sap standard tables? : abap data dictionary
Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?
What is a multiple line field?