Using FOX to read Master Data

[Former Member]

Dear All,

I would like to set up a FOREACH fox formula that would read the initial 2 characters of master data for chracteristic 0COST_CTR e.g. sum all records for cost centers beginning with "CP"

Does anyone know if FOX can do this and the relevant code that wouild have to be used, or is an EXIT function required?

Thanks

[Former Member · Accepted solution]

Hallo Donald

Fox can do it (FOR EACH). if you have an address I can forward an example oder if you press F1 in the fox editor you can find some exmaple.

Also with exit, of course with ABAP you can do it.

have also a look:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/g-i/how to loop over reference data in fox formulas.pdf

Mike

[Former Member]

Donal,

You can certaily do that with Fox Formula. You will actually need to use FOREACH, IF and SUBSTR expressions.

Cheers,

Alberto Sabate

[Former Member]

Albert,

That sounds great. How does the SUBSTR function work on a practical level. I have already used FOREACH and IF functions in the past so it shouldn't be too much applying this.

Many Thanks

Donal

[Former Member]

Hi,

About SUBSTR see here:

Best regards,

Eugene