Open Sales Contracts
Technical Name: 0CSAL_C04_Q0003
Based on Info Cube: CRM Sales Contracts: Quantities and Values
Views Created for this Query:
InfoObject |
Description |
0CSAL_C04_Q0003_V001 |
Open sales contracts |
0CSAL_C04_Q0003_V002 |
Open sales contracts for quarter |
Templates Created for this Query:
InfoObject |
Description |
0TPL _0CSAL_C04_Q0003_V001 |
Open sales contracts |
0TPL _0CSAL_C04_Q0003_V002 |
Open sales contracts for quarter |
Use
This query lists all those sales contracts (quantity and value) that are currently new, open, or in processing.
Filter
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
0STATONESYS0 |
Status |
The characteristic for the status has been given the following three values:
· 10 - new
· 20 - open
· 30 - in processing
Free Characteristics
InfoObject |
Description |
0CRM_BEGDAT |
Start date of contract |
0CRM_ENDDAT |
End date of contract |
0CRM_PROD |
Product |
0CRM_SALORG |
Sales organization |
0DISTR_CHAN |
Distribution channel |
0DIVISION |
Division |
0CRM_OBJ_ID |
Contract number |
Rows
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
0CRM_SOLDTO |
Sold-to party |
Columns
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
0CRMTARVALV |
Target value |
0CRMCOVALCV |
Released value |
0CRM_FULTGV |
Fulfillment rate (value) |
0CRMTGQTYCV |
Target quantity |
0CRMCOQTYCV |
Released quantity |
0CRM_FULTGQ |
Fulfillment rate (quantity) |
0CRM_DURFUL |
Duration until contract fulfilled |
0CRMINETVAM |
Expected net value |
0CRMONETVAM |
Open expected net value |
0CRM_NUMDOC |
Number of contracts |
0CRM_NUMOFI |
Number of contract items |
|
Fulfillment rate in
percentage |