internal table in FOX

[former_member310653]

Hi expert,

can you please give an example about how to use internal table in sap bw-ip FOX planning function

thx.

[mani0587]

Hi, Please find the below details for declaring tables, accessing them in FOX.

Declaring: (Use KEY as key word at the end of the variable to identify them as primary key which can used while retriving the data).

Table INT_TAB { ZACC TYPE ZACCOUNT KEY, ZPROD TYPE ZPRODUCT KEY, ZPER TYPE 0FISCPER KEY, ZPTYPE TYPE ZPTYPE, ZVAL TYPE F}.

Updating or inserting.

INT_TAB.{ ZVAL, BILLED_REV, PROD1, 2020002, RETAIL} = 5000.

Accessing Table.

{ZAMT, PROFIT, PROD1, 2020002, TOTAL} = INT_TAB.{ ZVAL, BILLED_REV, PROD1, 2020002} - INT_TAB.{ ZVAL, COGP, PROD1, 2020002}.

Hope this helps. Please Note: Am not aware the performance impacts while using tables and also not aware of clearing this tables.