Function Module to create BW Transformations from ABAP

[Former Member]

Hi, i have to create a bunch of data flows with 1:1 transformations and I'm wondering if there is a chance to do it with abap. Does anybody know the fm to create transformations in BW? Thx

[arun_purohit]

Hi All,

I am in need of similar information.

It is required for the cases where we need to automate the mapping for following cases where number of manual mappings required are too large:

1) source infoobject & target infoobject is different (description can be exact same or one is reference of another)

2) transformation where source is infoset, even though infoobjects are exact same, infoset assigns different tech name

For covering these cases I thought of writing a program which can create a mapping in transformation based on logic I write.

In short, need a standard FM or pgm to create a transformation mapping.

Thanks

Arun Purohit

[roland_szajko]

Hi Arun

There is no such FM, which would create a transformation from scratch or which would do the mapping from code.

An alternative approach would be to use expert routine in the created transformations where you can code the mapping yourself.

br

Roland

[former_member209202]

Hi Christian,
I believe if it is a BW to BW transformation for the same fields system is intelligent enough to map the same source and target with same technical name, for example, 0DOC_DATE to 0DOC_DATE, you just need to create the transformation. Correct m3 if my understanding is wrong.

Regards
Sourav

[roland_szajko]

Hi Christian

I think the best approach for that is to use the graphical dataflow designer. Additionally you can copy a complete dataflow and create new ones.

As far i know there is no possibility to create transformations procedurally with an FM or BADI or something else.

br

Roland

[sander_vanwilligen]

Hi Christian,

I am not sure if your Transformations concern DataSource to a BW object (e.g. InfoSource or DSO) or any Transformation from BW object to BW object (e.g. InfoSource to DSO or DSo to InfoCube).

In the first case I suggest to have a look at my Mapping Services approach. Please refer to my blog .

In the second case I suggest to create the Transformation as an Expert Routine. You can the use the following simple piece of coding to map every field of the Source Package to the respective Result Package field:

loop at source_package assigning <source_fields>.
 move-corresponding <source_fields> to result_fields.
 append result_fields to result_package.
endloop.

Best regards,

Sander