Routine

[Former Member]

Hi mates,I have a cube z_pck which is having a field 0employee, this cube hv a update rules for 2 ods.one ODS(z_TO) give the tranfer order details but it will not cintain any details of employee and 2nd ODS(Z_pk) give the pickur details , which is maintain the employee detials how hv picked the goods.

Now with help of Routine with respect to transfer orders i need to find the 0employee and fill in field of the cube.plz help me how to write routine.

Z_TO z_pk.

0deliv_num 0deliv_num.

0stge_bin 0stge_bin.

zcwm_tbtc zcwm_tbtc.

These fiels are common in both ODS.

Message was edited by: hari reddy

[Former Member · Accepted solution]

hi,

Tables /BIC/Az_pk00.

DATA: S_DATA TYPE STANDARD TABLE OF DATA_PACKAGE_STRUCTURE

WITH HEADER LINE

WITH NON-UNIQUE DEFAULT KEY INITIAL SIZE 0.

DATA: ITEM_TABLE TYPE STANDARD TABLE OF /BIC/Az_pk00

WITH HEADER LINE

WITH NON-UNIQUE DEFAULT KEY INITIAL SIZE 0.

*start of modification

*Populating the item status data from the item status ODS table

SELECT * FROM /BIC/Az_pk00 INTO TABLE ITEM_TABLE.

LOOP AT DATA_PACKAGE INTO S_DATA.

LOOP AT ITEM_TABLE WHERE 0deliv_num = S_DATA-0deliv_num

AND

0stge_bin = S_DATA-0stge_bin AND zcwm_tbtc = S_DATA-zcwm_tbtc .

MOVE item_table-oemployee to s_data-0employee.

APPEND S_DATA.

ENDLOOP.

ENDLOOP.

DATA_PACKAGE[] = S_DATA[].

hi i have used name of infoobject as you have given in you post. Code need modification for that. It is not tuned also.

Hope i m clear.

Regards,

San!