BW Extraction

[Former Member]

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

[Former Member]

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

[Sandra_Rossi]

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.

[Former Member]

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

[Former Member]

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.

[Sandra_Rossi]

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!

[Former Member]

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