Skip to Content
0
Former Member
Mar 19, 2009 at 11:54 AM

IP FOX CODE

150 Views

Hi IP Experts,

I have a requirement to get a value from 2 different cubes STORE and MERCHANDISE belongs to a multiprovider.

I want to calculate sales from all my stores and store it in a keyfigure(Store)

I want to calculate contribution of sales for my each store with my merchandise levels(SBU,CAT,GBB) as Total sale of all my stores/each store sale)*Merchendise sale.

DATA D1 TYPE 0INFOPROV.

DATA D2 TYPE ZCATHKB.

DATA D3 TYPE ZGBB1.

DATA D4 TYPE ZPLANT.

DATA D5 TYPE ZSBUH.

DATA STORE TYPE F.

DATA MERCH TYPE F.

*FOREACH D4.

*STORE = STORE+{CY_SMSLS,ZICHOPP1,#,#,D4,#}.

*ENDFOR.

*{ZGRTE_CY,ZICHOPP1,#,#,#,#} = STORE.

FOREACH D4.

FOREACH D1,D2,D3,D4,D5.

MERCH = ({ZCY_SLSXM,ZICHOPP1,D2,#,#,#}/STORE)*{ZCY_SLSA,ZICHMPP2,D2,D3,D4,D5}.

{ZASSRT,ZICHAPP1,D2,D3,D4,D5} = MERCH.

ENDFOR.

ENDFOR.

Thanks in Advance,

Pushpa M