Transformation table

[Former Member]

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

[RamanKorrapati · Accepted solution]

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

or

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

[Former Member · Accepted solution]

Very interesting option Raman

Amine

[RajatSahu]

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

[Former Member]

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...

[Former Member]

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...

[Former Member]

Thanks Arun.

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

Amine

[Former Member]

Thanks...

[KodandaPani_KV]

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.

[Former Member]

Thanks Kodana and Raman,

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

Amine

[RamanKorrapati]

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.