Lookup via transfer rule

[Former Member]

Hi all,

I want to write from two DSO's to an InfoCube. One DSO contains Sales data and the other Customer data. In case of a matching key in mentioned DSO's customer data must be written to the InfoCube. So therefor i need to do a customer lookup. This key contains ZRBDOCNR and ZRBPOSNR. Customer InfoObject = ZRBCUS. My question is: "how do i realize this in ABAP code?"

Thanks in advance!

[former_member184494 · Accepted solution]

Ruud,

You will have to have a transformation from the sales Data DSO to cube and in there have a routine either a routine in a rule or a start / end routine to get the necessary information.

Arun

[Former Member · Accepted solution]

Ok, I understand. For the Routine: "how do I code this in ABAP?"

[Former Member · Accepted solution]

Hi,

The code can be on foll lines in start routine:

data: itab_cust type standard table of /bic/acustomer_ods00.

select * from customer_ods into table itab_cust.

loop at datapak into wa_datapak.

read table itab_cust into wa_cust with key ZRBDOCNR = wa_datapak-ZRBDOCNR

and ZRBPOSNR = wa_datapak-ZRBPOSNR.

if sy-subrc eq 0.

wa_datapak-ZRBCUS = wa_cust-ZRBCUS.

modify datapak from wa_datapak.

endif.

endloop.

Regds,

Shashank

[Former Member · Accepted solution]

Definition 'datapak' is nog recognized by BI7.0 maybe other suggestions?

Thanks.

[Former Member · Accepted solution]

try source_package

[Former Member · Accepted solution]

I have already tried, but it is not working for 'wa_source_package'

Edited by: Ruud Slenders on Sep 5, 2008 2:43 PM

[Former Member · Accepted solution]

Hi,

You need to define wa_source_package.

data: wa_source_package like line of source_package.

Regds,

Shashank