Skip to Content
0
Sep 23, 2014 at 01:35 AM

ABAP Routine to fill Selection for BW-InfoPackage

1694 Views

Hi Abap gurus,

Currently I am trying to extract data from source (ECC) by referring to the table: /bic/azpur_d0200 to fill up the filter selection.


This is the screenshot of the ABAP routine in BW - InfoPackage Filter Selection (EBELN).

Basically what I am trying to do is:-

  1. I have fill up 2 columns (PO Number and SourceSysID) in table /bic/azpur_d0200. (around 60,000 POs)
  2. When I trigger the InfoPackage, the ABAP routine will get the list of POs from table (/bic/azpur_d0200), and insert into this filter selection: EBELN.
  3. Expected Result: the infoPackage loading will only select the POs populated in the selections.

The code I have tried as below, but its not working.

DATA:

wa TYPE /bic/azpur_d0200,

it_po TYPE TABLE OF /bic/azpur_d0200.

DATA:

s_t_range TYPE rssdlrange .

s_t_range-fieldname = 'EBELN'.

s_t_range-sign = 'I'.

s_t_range-option = 'EQ'.

s_t_range-low = '00'.

*To select the POs from DSO ZPUR_D02

SELECT /bic/zpo_ref

FROM /bic/azpur_d0200

INTO TABLE it_po

WHERE soursystem = '30'.

LOOP AT it_po INTO wa.

s_t_range-low = wa-/bic/zpo_ref.

APPEND s_t_range TO l_t_range.

ENDLOOP.

Any help would be greatly appreciated.

Many thanks,

Vince

SAP Business Warehouse

Attachments