This query provides you with an overview of sales contracts. The query contains a full set of all characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Sales Contracts
.
For information about the report areas in SAP CRM, see Report Areas for Interactive Reports.
This query is based on the InfoProvider /CRMBW/SLC_C01.
To use this query, you must activate the business function SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB
).
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Report Area |
/CRMBW/REPORTA |
Sales Contract (SALESCONTRACT) |
Characteristic | Application Server |
/CRMBW/APPLS |
Application server (/CRMBW/V_APPLS) |
Characteristic | Logical System |
/CRMBW/LOGSYS |
Source system (/CRMBW/V_LOGSY) |
Characteristic | Selection ID |
/CRMBW/SELID |
Selection ID (/CRMBW/V_SELID) |
Characteristic | User Name |
/CRMBW/UNAME |
Current User (/CRMBW/V_UNAME) |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Sold-To Party |
/CRMBW/SLO_STP |
|
Characteristic | Cancellation Party |
/CRMBW/CANCPAR |
|
Characteristic | Reason for Cancellation |
/CRMBW/CANC_RE |
|
Characteristic | Cancellation Party (Item) |
/CRMBW/CANCPAI |
|
Characteristic | Cancellation Reason (Item) |
/CRMBW/CANC_RI |
|
Characteristic | Channel Partner |
/CRMBW/CHA_PAR |
|
Characteristic | Channel Partner Program |
/CRMBW/CP_PROG |
|
Characteristic | Channel Partner Status |
/CRMBW/CP_STAT |
|
Characteristic | Responsible Person at Partner |
/CRMBW/RES_ATP |
|
Characteristic | Channel Partner Type |
/CRMBW/CP_TYPE |
|
Characteristic | Distribution Channel |
/CRMBW/DIS_CHA |
|
Characteristic | Responsible Sales Org. Unit |
/CRMBW/SLS_RES |
|
Characteristic | Sales Organization |
/CRMBW/SLS_ORG |
|
Characteristic | Contact |
/CRMBW/CONTACT |
|
Characteristic | Territory |
/CRMBW/TERRITO |
|
Characteristic | Territory ID |
/CRMBW/TERR_ID |
|
Characteristic | Country |
/CRMBW/SOL_COU |
|
Characteristic | Region |
/CRMBW/SLQ_REG |
|
Characteristic | Week (Valid To) |
0CALWEEK |
|
Characteristic | Month (Valid To) |
0CALMONTH |
|
Characteristic | Quarter (Valid To) |
0CALQUARTER |
|
Characteristic | Year (Valid To) |
0CALYEAR |
|
Characteristic | Valid From |
/CRMBW/VALID_F |
|
Characteristic | Valid To |
/CRMBW/VALID_T |
|
Characteristic | Status |
/CRMBW/SLC_STC |
|
Characteristic | Credit Status |
/CRMBW/CREDSTH |
|
Characteristic | Status: Credit Not OK |
/CRMBW/STAT_C0 |
|
Characteristic | Status: Credit OK |
/CRMBW/STAT_CR |
|
Characteristic | Division |
/CRMBW/DIVISIO |
|
Characteristic | Employee Responsible |
/CRMBW/PERSON |
|
Characteristic | External Reference Number |
/CRMBW/PO_NUMB |
|
Characteristic | Product |
/CRMBW/PROD_GU |
|
Characteristic | Product Category |
/CRMBW/PRO_CAT |
|
Characteristic | Product ID |
/CRMBW/PRODUCT |
|
Characteristic | Sales Contract |
/CRMBW/SLC_GUI |
|
Characteristic | Sales Contract ID |
/CRMBW/SLC_ID |
|
Characteristic | Transaction Type |
/CRMBW/PROCESS |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Key Figure | Open Expected Net Value |
/CRMBW/OP_EX_NET_V |
Expected total value (/CRMBW/NET_VAL) minus released value (/CRMBW/REL_VA) |
Key Figure | Open Released Value per Contract |
/CRMBW/OP_RV |
— |
Key Figure | Open Released Quantity per Contract |
/CRMBW/OP_RQ |
— |
Key Figure | Fulfillment Rate (Value) |
/CRMBW/FUL_RATE_TV |
Released value / target value (/CRMBW/TARGET) * 100 |
Key Figure | Fulfillment Rate (Quantity) |
/CRMBW/FUL_RATE_TQ |
Released quantity (/CRMBW/REL_QU) / target quantity (/CRMBW/QUANTIT) * 100 |
Key Figure | Average Expected Total Value per Contract |
/CRMBW/AVG_EX_TV |
Expected total value (/CRMBW/NET_VAL) / number of contracts (/CRMBW/NUM_OF) |
Key Figure | Average Target Quantity per Contract |
/CRMBW/AVG_TQ |
Target quantity / number of contracts |
Key Figure | Average Target Value per Contract |
/CRMBW/AVG_TV |
Target value / number of contracts |
Key Figure | Expected Total Value of Cancelled Items (Document Currency) |
/CRMBW/NET_VMC_DC |
Is only filled if the characteristic |
Key Figure | Expected Total Value (per Contract Item) (Document Currency) |
/CRMBW/NET_VAL_DC |
— |
Key Figure | Released Value (per Contract Item) (Document Currency) |
/CRMBW/REL_VA_DC |
— |
Key Figure | Target Value (per Contract Item) (Document Currency) |
/CRMBW/TARGET_DC |
— |
Key Figure | No. of Completed Contracts |
/CRMBW/NUOFCC |
— |
Key Figure | No. of Cancelled Contracts |
/CRMBW/NUM_CH |
Is only filled if the characteristic |
Key Figure | No. of Cancelled Contract Items |
/CRMBW/CCONITM |
Is only filled if the characteristic |
Key Figure | No. of Contract Items |
/CRMBW/CON_ITM |
— |
Key Figure | No. of Release Orders |
/CRMBW/NUMREOR |
— |
Key Figure | No. of Contracts |
/CRMBW/NUM_OF |
— |
Key Figure | Expected Total Value of Cancelled Items |
/CRMBW/NET_VMC |
Is only filled if the characteristic |
Key Figure | Expected Total Value |
/CRMBW/NET_VAL |
— |
Key Figure | Target Quantity |
/CRMBW/QUANTIT |
— |
Key Figure | Released Quantity |
/CRMBW/REL_QU |
— |
Key Figure | Released Value |
/CRMBW/REL_VA |
— |
Key Figure | Target Value |
/CRMBW/TARGET |
— |