Data transfer

[Former Member]

Hi -

We have some field types and their values of a table in r/3 to be transferred to bw.

There are 5 field types (Z1, Z2, Z3, Z4, Z5) and there is a corresponding fixed value for each field type for a given record. Ex: Z1 means DEPT1, Z2 means DEPT2, Z3-DEPT3, Z4-DEPT4, Z5-DEPT5). These are fixed.

There are 8 generic fields in the table (Ex: Fld1, Fld2 etc) which store the field types. Any field can store any field type.

In r/3, when I select a record it looks:

FLD1 FLDVALUE

Z1 E-Advertising

FLD2 FLDVALUE

Z2 Marketing Initiatives

FLD3 FLDVALUE

Z5 Field Campaigns

FLD4 FLDVALUE

00 0000

FLD5 FLDVALUE

00 0000

FLD6 FLDVALUE

Z4 Automation

FLD7 FLDVALUE...

Z3 Public Relations

(So, the actual values of Z1 (which has a meaning of DEPT1) is E-Advertising, DEPT2 is Marketing Initiatives, so on..)

We need the data to be trasferred into BW. There are no business content objects that I can use and transfer that data. Since the generic fields do not have to store the field types consistently, users enter these the field type in whichever field they like.

Will a infoobject with the field types and field values as attributes serve the purpose. How should the data validations be done in the start routine ?

Can I use a start routine which reads the records and if it finds a field type "Z1" in any of the fields for a record, checks it as DEPT1 and transfers it to the transfer structure field (field type) and the value to field value ?

(There is only one occurance of 'Z1' for a record but it can be anywhere in the fields).

Please let me know your suggestions ? Thank you.

[Former Member]

IS this to be linked to some other infoobject, or, your field/type is the info-object and you want its attribute(values) to be brought over? If so, would there be only 5 records for your master data (Z1, Z2, Z3, Z4, Z5)?

[Former Member]

Hi Ajay - Thanks for the response. The infoobject is 0bpartner and all others are to be it's attribute. Every partner has a role in each DEPT for which they can be First Contact/Second contact etc.

So, every business partner in the organization has 5 field types (DEPTs) and the corresponding values for the Depts.

If the organization adopts another dept, then there is

a Z6 (DEPT6)- xxxx which has to be extended to each partner.

Does this help ?

Thanks.

[Former Member]

I would think your logic should work just fine (compare the field-type and maybe store the corresponding values in an itab in start routine, and use it in update rules).

Do you have any problem with your approach?

[Former Member]

Ajay - I am creating a Zbpartner with these attributes(dept etc) but these details are to be part of 0bpartner. So, what you mentioned is correct. I have to connect this to the original object.

Using the Start routine, I want to build my transfer structure after I check for the dept code in the data package and then move the values to the fields in the TS. Please confirm if this is the way to do it.

thanks for yor help.