Skip to Content
author's profile photo Former Member
Former Member

Data transfer

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 03, 2006 at 09:03 PM

    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)?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.