Request ID/ Number in Transformation

[Former Member]

Dear Experts,

Can somebody share ABAP code required for getting the Request ID or number in transformation? We require this information for getting more details from RSSELDONE table.

Thanks a lot .

Best regards,

BW user

[Former Member]

Hello,

Check this code..I didn't check the syntax..correct it if needed.

data: itab_/BI0/SREQUID type standard table of /BI0/SREQUID,

itab_RSBKDATAPAKSEL type standard table of RSBKDATAPAKSEL,

itab_rsseldone type standard table of rsseldone,

select_options: s_dtpreq type RSBKDATAPAKSEL-requid.

select * from RSBKDATAPAKSEL

into table itab_RSBKDATAPAKSEL

where requid in s_dtpreq

and fieldnm = 'REQUID'.

if sy-subrc eq 0.

select * from /BI0/SREQUID

into table itab_/BI0/SREQUID

for all entries in itab_RSBKDATAPAKSEL

where sid eq itab_RSBKDATAPAKSEL-low.

endif.

If sy-subrc eq 0.

select * from rsseldone

into table itab_rsseldone

for all entries in itab_/BI0/SREQUID

where rnr eq itab_/BI0/SREQUID-requid.

endif.

Thanks

Viswa