on 2020 Mar 28 4:42 AM
Hi expert,
can you please give an example about how to use internal table in sap bw-ip FOX planning function
thx.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
10 | |
8 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.