Question Re: Transformation table in Technology Q&A

Transformation table

Former Member — Tue, 18 Mar 2014 14:41:06 GMT

Hi experts,

I would like to know if it exists a table which containes a transformation details. I mean the source infoobject and the target infoobject.

I found the following tables but i cant' really found the information that i am looking for:

-RSTRAN

-RSTRANSTEPMAP

-RSTRANrule

-RSTRANfield

Thanks.

Amine

Re: Transformation table

RamanKorrapati — Tue, 18 Mar 2014 15:05:38 GMT

Compare to 3.x there is no such table to know transformations from source to target info object.

By seeing the other table - RSOSFIELDMAP we can find source and target transformations at first layer of bw only.

Re: Transformation table

KodandaPani_KV — Tue, 18 Mar 2014 15:16:17 GMT

Hi,

check the RSOSFIELDMAP. it give the relationship of ECC fields and BW info objects.

enter the T-code- SE11 -> RSOSFIELDMAP

map the source fields to target fields.

Thanks,

Phani.

Re: Transformation table

RamanKorrapati — Tue, 18 Mar 2014 15:22:34 GMT

double click on your transformations, from Menu Extras-->display generated programs. debug it you may get some clue about table.

From same menu Extras --> Tabular overview, you can see all source and target info objects.

Re: Transformation table

Former Member — Tue, 18 Mar 2014 16:50:21 GMT

Hi,

Try the following code ..

At the end , you get field mapping in p_t_mapping internal table..let me know incase of any issues..I am sure this will work since we are using it..but it will give you only DIRECT MAPPING info objects - not any routines, formulas, or any other rule types other than direct mapping...

Re: Transformation table

Former Member — Tue, 18 Mar 2014 16:52:04 GMT

this code is to get the mapping from PSA -> first level..

If you want mapping details of transformation within BW targets like DSO to Cube or something simialr, you have to enhance the logic..might need ABAP skills...

Re: Transformation table

Former Member — Tue, 18 Mar 2014 17:07:49 GMT

Thanks Kodana and Raman,

I can't find what i need in this table.

Amine

Re: Transformation table

Former Member — Tue, 18 Mar 2014 17:09:07 GMT

Very interesting option Raman

Amine

Re: Transformation table

Former Member — Tue, 18 Mar 2014 17:10:02 GMT

Thanks Arun.

That would be the idea of an Article to upload to SCN

Amine

Re: Transformation table

RajatSahu — Tue, 18 Mar 2014 17:23:26 GMT

HI Amine,

The Two tables from which we can get all the required data is RSTRAN and RSTRANT .

We can take the records from the 2 tables with key(common) field as " tranid " and get the details of source info object and the target info object and the description of Transformation.

Regards,
RKS

Re: Transformation table

Former Member — Tue, 18 Mar 2014 20:13:51 GMT

Thanks...