topic Re: BW Extraction in Application Development and Automation Discussions

BW Extraction

Former Member — Sat, 20 Feb 2010 18:39:11 GMT

I have written a BW function module extractor.

The problem I am having is with enabling a delta mechanism using timestamps.

The table that I am extracting data from has timestamps of length 21 (long UTC)

I need to know whether there exists a standard function module to convert between long and short UTC (lenght 15)

Thanks

Re: BW Extraction

Sandra_Rossi — Sat, 20 Feb 2010 21:35:20 GMT

Time Stamp in Long Form: YYYYMMDDhhmmss,mmmuuun (TYPE p LENGTH 11 DECIMALS 7)

Time Stamp in Short Form:YYYYMMDDhhmmss (TYPE p LENGTH 8 DECIMALS 0)

So, you don't need a function module, just do:

longform = shortform.

shortform = longform.

Re: BW Extraction

Former Member — Mon, 22 Feb 2010 06:46:29 GMT

Thanks, does not work in my case.

What I am trying to do is following:

1. I am looking to get data from a table which consists of a changed on timestamp which is defined as DEC 21

2. BW requires that in order to capture the change records that the timestamp is UTC short DEC 15

3. I can do this and get the timestamp range

4. Where I am having problems is grabbing the set of records which fall in this timestamp range since I now have a DEC15 value whereas the table entries are DEC21

Sorry if not clear but let me know if more info is needed

Re: BW Extraction

Former Member — Mon, 22 Feb 2010 07:12:22 GMT

Hi,

You can try this


DATA: lv_longtime TYPE TZNTSTMPL.
CONVERT DATE sy-datum TIME sy-timlo INTO TIME STAMP lv_longtime TIME ZONE sy-zonlo.

Re: BW Extraction

Sandra_Rossi — Mon, 22 Feb 2010 10:15:42 GMT

To make things clear:

1) ABAP declaration TYPE p LENGTH 11 = DDIC declaration DEC 21

2) ABAP declaration TYPE p LENGTH 8 = DDIC declaration DEC 15

The only thing we don't know is the number of decimals

If you have 2 timestamps of the same time zone (it seems to be your case), you don't need to use CONVERT DATE statement.

Debug your extractor function module to make sure where the problem is, exactly, and revert back.

And paste your code please!

Re: BW Extraction

Former Member — Tue, 23 Feb 2010 06:20:02 GMT

Hi Sandra, Nitwick,

I do not have access to the system until later this week.

At the moment the code is being tested without conversion and results so far are correct. Will comeback early next week after testing has completed and if ok will wait till than to awards points or post code + questions

Thanks for all your help