Answer / 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

What are the differences between domain and data element?

0 Answers  

---

can anyone told me name of abap interview question book with autor name?

7 Answers  

---

What are the event key words in interactive reporting?

1 Answers  

---

If u r working with call transaction method .any problem occurs error records r stored in BDCMSGCOLL structure.How do u find that an error has occured at a particular point,how can u handle to rectify and process it successfully? If a file has 10000 records where 3 records doent having right format,how do u tackle with this issue either by using call transaction or session method to transfer data perfectly into database table?tell me the steps how to procede?

1 Answers   Deloitte,

---

WHAT IS THE USE AND DIFF B/W INSERT, UPDATE AND MODIFY WHILE UPDATING THE DATABASE TABLES?

3 Answers   Sony,

---

can u create internal table dynamically ? how?

4 Answers   Bristle Cone, Cap Gemini, HP, IBM, MetaMorph, Satyam, Wipro,

---

Back ground job .. Transaction code?

8 Answers   Cap Gemini,

---

what is the difference between at line selection and at line selection on field.

1 Answers  

---

is it possible to upload material master data through BDC with one flat file containing both semifinished material & row material combined?????????

1 Answers  

---

Hi Gurus, I have 250 records in an internal table, tell me how to randomly delete the each 5th record...i,e 5,10,15,20 like this.

2 Answers   Accenture,

---

What are the input parameters to be passed to the BAPI 'BAPI_QUOTATION_CREATEFROMDATA'

1 Answers   SGT,

---

If u use US Database server? How can access the client?

1 Answers   Intelligroup,

---