Start of Content Area

Query Sales Statistics: Contract Analysis Locate the document in its SAP Library structure

Technical Name: 0CSA_01_Q0004

Based on InfoCube: 0UCSA_01 (sales statistics).

Use

You can use this query to analyze revenue data (for example, revenues through consumption, flat rates, total revenue) and consumption data (for example, energy, demand, ® columns) by contract information (for example, account class, rate category ® free characteristics/rows). You can construct this survey using account assignment information (for example, profit center ® free characteristics) or industry-specific features (for example, industry, division ® free characteristics/rows).

This analysis can take place on an aggregated level or for a selection of business partners you need to restrict yourself.

To improve the meaningfulness of this survey, we recommend you restrict to a point in time (for example, consumption month, posting month ® temporal, free characteristics).

Free Characteristics

InfoObject

Description

Structure link0COMP_CODE

Company code

0BPARTNER

Business partner

Structure link0CO_AREA

Controlling area

Structure link0PROFIT_CTR

Profit center

Structure link0COSTCENTER

Cost center

0IND_CODE

Industry code

Structure link0UCOWNCONS

Plant or company consumption

Structure link0UCRATE_KEY

Rate number

Structure link0UCRATE_STA

Statistical rate

Structure link0UCRATE_TY

Rate type

Structure link0UCRATE_CAT

Rate category

Structure link0UCBILL_CLA

Billing class

Structure link0CALYEAR

Calendar year

Structure link0CALMONTH

Calendar year/month

0UCPSTNGYR

Posting year

0UCPSTNGMO

Posting month

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Structure link0DIVISION

Division

Structure link0UCACC_CLAS

Account class

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Structure link0UCNET_AMT

Total amount

Structure link0UCWRK_AMT

Energy amount

Structure link0UCDEM_AMT

Demand amount

Structure link0UCRENTCHRG

Rental price amount

Structure link0UCFLATRATE

Flat-rate amount

Structure link0UCMISC_AMT

Miscellaneous amount

Structure link0UCWRK_QNT

Energy quantity

Structure link0UCDEM_QNT

Demand quantity

Structure link0UCCNTRCNT

Billed contract months

 

 

End of Content Area