What is the use of Structure in BEX/Query?
Combination of characteristics and key figures are called Structure. Structures are basically a grouping of key figures which can be created for a Infocube and reused in any other queries for that cube. Structures find the biggest use in financial reports. Take an example of a financial report which has about 20 normal keyfigures, 10 calculated keyfigures and another 10 restricted keyfigures. Now assume that someone asks for a new report with all of these as well as 5 more keyfigures. Normally you would have to create a new query and manually re-create all the complex key-figures. However, if you had saved them as a structure, you just have to drag-and-drop the structure into the query. So if there was a change in the calculation of one key-figure, you just have to change the key-figure in the structure and not change all the 10 reports which show that key-figures. We get a default structure for key-figures. That is most people use structures for key-figures and SAP has designed it tha
