How can i capture system time in an infoobject

[Sujai]

Hi

Can I get the current system time and date into infoobjects?? if yes how??

Regards

Sujai

[Former Member]

Hi,

The system tyme and other system parameters are maintained in the SYST table. You could surely capture the system time in a infoObject by writing a routine and picking time from syst table.

Sorry but I am not in front of system and dont remember the field name for system time. But you could go in table syst from tcode se11 and check it.

Please let me know if you are not able to find it, I will help you find it.

Regards,

Pankaj

[Former Member]

sy-uzeit for current time

sy-datum for current date

-Raghu

Edited by: Raghu tej harish reddy on Mar 17, 2009 10:22 PM

[Sujai]

Thanks Pankaj and Raghu.

but what i actually want is that I have an infoObject which is going to be maintained manually. I need to create a datasource with delta capability on this to update an ODS. So to do that is there a way to populate 2 attributes of the infoobject with the current system time and date for delta when new records are added or existing ones modified? In case i have to use routines where can i put the code to update the values while in infoobject maintenance screen?

and can you tell me what the "characteristic is export data source" check box do?? is it just like the export datasource on an ODS?

Regards

Sujai

[shanthi_bhaskar]

hey please create a Z objects say ZDATETIME of 14 length. In transforamtion you can put below routine.

CONCATENATE SY-DATUM SY-UZEIT INTO SOOURCE-FIELDS-ZDATETIME.
RESULT = SOOURCE-FIELDS-ZDATETIME.

[Former Member]

Suraj,

Write routines in update or transfer rules or transformations to capture time and date using system parameters: sy-datum & sy-uzeit. Date and time will be updated while loading data into that particular object.

can you tell me what the "characteristic is export data source" check box do?? is it just like the export datasource on an ODS?

--> Yes, to generate export datasource on that particular infoobject. same as ODS

Srini

[Sujai]

Hi

i guess i wasn't clear with the requirement.

the data is going to be entered in the infoObject manually thru the infoObject maintenance screen (RSD1), i will not be able to put the code in the transformation since there is no transformation at all.

I wanted to know if i could populate the fields without the user's help in keying in the values for the date and time attributes.

can i acheive this thru a custom coversion routine???

Hope i am clear this time.

Regards,

Sujai

Edited by: Sujai S on Mar 18, 2009 5:55 PM

[Sujai]

found the solution myself. created a conversion routine and assigned it to the attribute IObj.

Code:

CONVERSION_EXIT_ZDAT_INPUT / CONVERSION_EXIT_ZDAT_OUTPUT

set output = sy-datum. in FM..

Thanx all for ur suggestions.

Regards

Sujai