Skip to Content
avatar image
Former Member

Determining DataPak ID and Request Number

I have a requirement to include the datapackage id and request number and record number in an ODS.

Ideally I would like to to this in the update rules via a start routine or individual update rule routines for each characteristic. When I debug the start routine i can access global variables G_S_MINFO-DATAPAKID and G_S_MINFO-REQUNR which have the values I need. However when I edit the start routine or attempt to create an update rule routine the code does not syntax check because these variables are then unknow. Does anybody know any way of doing what I want to do.

Many thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 18, 2006 at 03:21 PM

    Hi Simon,

    have you already tried the start-routine within the transfer-rules?

    there G_S_MINFO is available.

    please check.

    hth

    cheers

    sven

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 18, 2006 at 03:24 PM

    In these tables you can find what you search...

    RSSELDONE [Monitor: Selections for executed request]

    and

    RSMONFACT [Fact table monitor].

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 05, 2009 at 03:14 PM

    Hi,

    I got the answer to it & thought of sharing it with everybody so that they can use it. The answer below is for individual routine in Transformation:

    Just type in:

    To get Request number:

    result = request

    To Get Data-Package number:

    result = datapackid

    To Get Record Number:

    result = SOURCE_FIELDS-RECORD

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    Below Code can be used in the Start Routine of the Transformation:

    DATA: U_MODE type RSBKUPDMODE,

    R_REQUEST type RSBKREQUID,

    R_REQUEST30 type RSREQUID.

    call method p_r_request->GET_UPDMODE

    RECEIVING

    R_UPDMODE = U_MODE.

    call method p_r_request->GET_REQUID

    RECEIVING

    R_REQUID = R_REQUEST.

    Hope it helps.

    Mukund.

    Add comment
    10|10000 characters needed characters exceeded