List of SAP FC Excel @GetCtData formulas

[taab22]

Is there/does anyone have an exhaustive list of all the possible @GetCtData formulas for SAP FC for use in the Excel add-in please?

I am looking for a list of the formulas along with columns which give the definition/function of the formula and its parameters.

[Former Member]

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.
First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.
I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.
Now for some specific suggestions on how you might improve your question:
* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.
* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.
Should you wish, you can revise your question by selecting Actions, then Edit.
The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond. As it stands, I don't know if there is enough information here for members to understand your issue. So please consider revising your question because I'd really like to see you get a solution to your problem!
I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[Olga_Vasileva]

Hello taab22 , have you seen Formula functions chapter (on GetCtData and PutCtData) and chapter on GetCtLabel in FC Excel Link User Guide?

[taab22]

Yes I have. I know for data retrieval the two possible starts to a formula are GetCtData and GetCtLabel. But I am after an exhaustive list of what can go inside the brackets to retrieve different information.

For example, I have the formula =@GetCtLabel(Cell with the account number,"CURINIT(AC)!LDESC","#Account name")

How would a person with no knowledge of SAP FC know what to put inside the brackets? Particularly that the bold "CURINIT(AC)!LDESC" is what they needed to type to pull the long description for an account number? Is there an exhaustive listing available?

In the chapters you reference I do not see an exhaustive list.

[Olga_Vasileva]

taab22 , please take a look at Objects and properties in Syntax section of FC User guide. Is that what you're looking for?

[Olga_Vasileva]

taab22 , and if you're interested in the properties part of the reference (after the "!" sign), you can open a schedule in FC application and in Language and Formula wizard there will be a list of all possible operation objects, and selection and properties available for each.

[taab22]

Thank you for your continued support Olga. I think we are getting closer.

I have the language and formula wizard up now. As an example, I get the below preview. How would you translate this into a GetCtData or GetCtLabel Excel formula please?

Preview: VALUE(AC)!c#I1!p#SDESC[en]

Also I can't figure out which option on the menus in the wizard would give a formula to retrieve the amount.

[Olga_Vasileva]

Hi taab22 , the formula on your screenshot is to show short description of "I1" characteristic of a chosen account.

To show the same in FC Excel Link, enter the following in a cell: =@GetCtLabel("AC=NNNNNN","VALUE(AC)!I1!SDESC[en]","#") and import data.

[en] is for English, it can be changed to other languages.

[taab22]

Thanks! That works.

Two further questions please:

1. I can't find the formula to retrive the amount (say the closing balance) for an account. I see only these options:

2. How can I export the text for everyone single possible formula on the Language and Formula Wizard?

[Olga_Vasileva]

taab22 ,
1. To retrieve amount use GetCtData formula - please check the link to the User guide I mentioned earlier.
The formula for closing balance for consolidated data would look like:
=@GetCtData("COAMOUNT","CONSAMOUNT","CA=NNN","SC=NNN","VA=NNN","AU sum NNN","RU sum NNN", "CC=NNN","DP=NNN","FL=Y99","AC=NNN","#")

2. Sorry, I don't really get the question - each dimension has different list of characteristics (#c) and properties (#p) including user defined ones. So you can go through each of them individually, but it doesn't make much sense, since you can use Wizard when needed - similar to FC Windows app, there's "Define Schedule" menu in FC Excel Link add-in: first compose table filters, rows and columns with "Insert dimension members", then fill the table in with "Define table" - this process is explained in the User guide too.

[taab22]

1. Understood thanks.

2. I find the wizards clunky. I want to be able to quickly adjust my formulas in Excel so I can pull whatever data I need by quickly selecting through dropdowns. I use Excel sheets to analyse balances and movements etc on a monthly basis. But I want exhaustive lists of the dimensions and formulas so I can build these dropdowns and formula builders please.