Skip to Content
author's profile photo Former Member
Former Member

How can I add system date field to Generic DataSource?

Hi all,

We want to add a field to a Generic DataSource containing the system date (so that we can use this field in the transformation(s) on the BW side)?

My Generic DataSource is based on database view, I have tried adding SYST-DATUM to the view, but then I get an error that the SYST table is "not transparant" and so the view cannot be activated.

Can anybody help me out here?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2008 at 03:52 AM

    Hi Jeppe,

    By just adding a date field to the generic data source will not have the system date automatically filled up during data extraction and transfer to BI.

    You still need some coding to populate the system date to this field. As you need the system date in the BI transformation rules, you need not add this field to the generic data source and the necessary coding (in the source system). Unless you anticipate that there will be day(s) difference between the point of data extraction and data loading, and you want to get hold of the system date at the point of data extraction.

    How do you want to use the system date in your transformation?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 12, 2008 at 06:26 AM

    Just add your date infoobject to your datatarget (cube or DSO).

    In the transformation go to field level routine and write code.

    RESULT = SY-DATUM.

    for your date infoobject.

    You neednot bring sy-datum from your datasource.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.