Please someone give me the details of the below mentioned infocubes 0UCSA_C01, 0UCTS_C15.
THESE CUBES ARE ONLY AVAILABLE FROM VERSIONS 3.0D.
Please send me the copy of charectarstics and key figures, technical name.

This is all I have about it:
Technical name: 0UCTS_C15

This InfoCube provides the data basis for analyzing billing-related installations/removals, that is, when the devices were allocated to a utility installation. The data is recorded on a monthly basis.
 

Technical name: 0UCSA_C01

This InfoCube allows you to analyze the services for which a utilities company has billed. This includes evaluated consumption quantities and the revenue obtained for them. They are classified according to component such as energy, demand and rental price.

You can use the posting date or consumption month as time dimensions for the consumption and revenue data. In addition, you can analyze the data according to various criteria. For example,  you can drill down according to attributes of the business partner, premise, contract, rate or according to the industry and regional aspects. You can also visualize consumption and revenue data for divisions other than those offered.

The number of billed contracts provides an important key figure and allows the achieved and outstanding demands to be estimated. You can also store discount and surcharge information relevant to amounts and quantities in separate key figures.

Invoiced billing documents provide the basis for sales statistics. To archive the data after the consumption month, the consumptions and achieved revenues are transferred to the Business Information Warehouse (BW) using a weighting procedure for each consumption month.
 

Sales Statistics extractors - which one is the right one??

Currently working on a IS-U CCS BW project. We are designing a solution based on the Sales Statistics cube 0UCSA_C01. We have to enhance the extract structure with a number of fields and are faced with a choice of two enhancements. The first is RSAP0001 and we could use the function module EXIT_SAPLRSAP_001 for the transaction data. The second is BWESTA01 and in this case we could use function module EXIT_SAPLE71ESTA01_001. It is not obvious to me which enhancement I should use. I have been told that the second enhancement may be the way to go as the first enhancement effectively repeats what the second one does, which means it is extracting the data twice. Obviously for performance reasons this is very bad.

We are on 2.1C and I did not see the second enhancement. Is it in 3.0B?? If it is yes, then I presume the second option is the latest and you should be able to use it.

Also, I do not think two enhancements are supported at the same time. Could you verify this and let us know.
 

yeah, we are on 3.0b now. When we built the initial solution we were on 2.1c and it was a complete surprise when an sap consultant told us we were using the wrong enhancement.

I wonder if projects should be aware of this when they upgrade. We sure as hell would not have picked it up if not shown by somebody in the know. The problem with the new enhancement is that the function module seems to be using different tables as well, so we can't simply cut and paste the code. The plus side is that performance will improve.....so we have been told
 

Excellent ! This is a very good feed back.
 

I can't find BWESTA01 enhancement in my system.
We are in BW30B and R/3 4.6C PI 2001.2. but not using Industry solution.

I guess this enhancement is in R/3. right?
let me know your PI version and R/3 version.
 

Try having a look in the Object Navigator (SE80) under Dev Class EE71_R461 to find BWESTA01. We have PI version 2002.1.

Back to:
SAP BW (Business Warehouse) Hints and Tips

Return to :-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips