Hierarchy
IS-UT (Software Component) SAP Utilities/Telecommunication⤷
IS-U-BI (Application Component) Contract Billing⤷
EE20 (Package) IS-U: Billing
Basic Data
| Data Element | MENGESTREL |
| Short Description | Quantity (billed value) is statistically relevant |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | MENGREL | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | QtyStatRel |
| Medium | 15 | Qty stat. rel. |
| Long | 20 | Qty stat. relevant |
| Heading | 2 | QS |
Documentation
Definition
If you include a rate in a schema, then a check is carried out for all steps to determine whether the corresponding variant generates billing line items relevant for posting. If this is the case, this indicator is set automatically in the schema. However, you can cancel the indicator manually.
Therefore, in billing the quantity is marked as not statistically relevant for all billing line items that are generated by this step. The quantities corresponding to these billing line items (i.e. billed consumption, demand or quantities) are then ignored by statistics.
For schema steps with variants that do not write any billing line items relevant to posting, the indicator is not significant and should not be set.
You can control the statistical relevance of the amount with the AS indicator (amount on billing line item is statistically relevant). Sometimes it is useful to include the amount but not the quantity in statistics.
Example 1
You valuate a consumption with the rate 1000 in two steps and set the indicators as follows:
No. Variant InpOp1 InpOp2 AS QS
0001 QUANTI01 ENERGY PRICE1 X X
0002 QUANTI01 ENERGY PRICE2 X
After billing, you can evaluate statistics in the following way:
- Which revenues were generated with rate 1000?
Result: the amounts from both billing line items were considered.
- How high is the consumption that was billed with rate 1000?
Result: only the consumption from step 0001 is considered. This is correct.
Example 2
In rate 1001 you valuate consumption with an energy price. In addition, consumption that exceeds a certain quantity not subject to duty (hereafter called "free quantity") is to be valuated with a duty price. To do so, subtract the free quantity from the total consumption and valuate the positive difference quantity with the duty price in the subsequent step.
Diagram of the rate:
No. Variant InpOp1 InpOp2 OutOp1 AS QS Sub-trans.
0001 QUANTI01 ENERGY PRICE1 AMOUNT1 X X 0010
...
0013 QUANTI02 ENERGY FREEQTY DIFFQTY - - -
0014 QUANTI01 DIFFQTY DUTY AMOUNT2 X X 0012
Perhaps you are required by law to display the duty amounts together with the duty consumption values. In this case, make sure you do not cancel the QS indicator in any of the steps.
Important: If you use rates like this in your company, you must carefully adjust your sales statistics to the rate structure:
- For the affected rates, identify the fields you can use to distinguish the billing line items that contain redundant quantities.
- According to the rate structure, distinguishing criteria can include the following:
In this example we assume that the schema steps with a duty price always contain a separate sub-transaction. The billing line items for the duty can therefore be identified clearly by means of the sub-transaction. There are two methods for modifying statistics.
Method 1: Enhancement of characteristics
- Create your own information structure. Include the sub-transaction as an additional characteristic.
- When you evaluate these statistics, you must always take into account the sub-transaction. To ensure correct results, make sure you:
- Do not select statistical records with sub-transaction 0012 when you evaluate consumption values billed with rate 1001.
- Process only the statistical records with sub-transaction 0012 when you evaluate duty amounts and duty quantities generated as revenue.
Below is a simplified numerical example to illustrate method 1:
You bill a contract for one month using rate 1001, which generates a billing document with two billing line items:
Rate Amount Quantity Sub-transaction
1001 200.00 1000 0010 (consumption x energy price)
1001 30.00 700 0012 (duty quantity x duty price)
If only this document were provided to statistics, the fields of your information structure would contain the following data:
Characteristics..... Key figures.....
Rate Sub-trans. .. Qty Amount ..
1001 0010 .. 1000 200.00 ..
1001 0012 .. 700 30.00 ..
The disadvantage of method 1 is that the sub-transaction must be included when statistics are being evaluated; otherwise an incorrect consumption value is allocated to rate 1001.
Method 2: Enhancement of key figures
You can also distinguish the billing line items in your information structure by means of key figures instead of characteristics. To do so proceed as follows:
- Extend your communication structure to include two new fields: DUTYQTY (duty quantity) and DUTYAMT (duty amount).
- Include these fields in the field catalog.
- Create your own information structure including the DUTYQTY and DUTYAMT fields as key figures, or extend your existing information structure to include these fields.
- Use the SAP enhancement to provide data in the new fields of the communication structure.
Below is a simplified numerical example to illustrate method 2:
You bill a contract with rate 1001, which generates a billing document with two billing line items. The contents of these billing line items are transferred individually to the communication structure when the statistics are supplied. For this document, both of the following communication structure records are therefore transferred to the SAP enhancement:
Rate Sub-trans. Qty Amount Duty qty Duty amt
1001 0010 1000 200.00 0 0.00
1001 0012 700 30.00 0 0.00
In the SAP enhancement that you must program, identify these records by means of the sub-transaction and modify them as follows:
Rate Sub-trans. Qty Amount Duty qty Duty amt
1001 0010 1000 200.00 0 0.00
1001 0012 0 30.00 700 30.00
When these modified communication structure records are transferred to your information structure, this results in the following contents:
Characteristics.. Key figures........................
Rate .. Qty Amount Duty qty Duty amt..
1001 .. 1000 230.00 700 30.00
Evaluation of these statistics provides the following results:
- Quantity: Consumption billed with rate 1001
- Amount: Total amount generated as revenue with rate 1001 (energy price + duty price)
- Duty quantity: Duty quantity billed with rate 1001
- Duty amount: Duty amount generated as revenue with rate 1001
The advantage of method 2 to method 1 is that no user error can occur when the consumption values billed with rate 1001 are being determined.
History
| Last changed by/on | SAP | 20050224 |
| SAP Release Created in |
