This query provides you with an overview of sales orders. 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 Orders
.
For information about the report areas in SAP CRM, see Report Areas for Interactive Reports.
This query is based on the InfoProvider /CRMBW/SLO_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 Order (SALESORDER) |
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 | Currency |
/CRMBW/CURNCY |
|
Characteristic | Sales Order ID |
/CRMBW/TA_ID |
|
Characteristic | Day (Posting Date) |
0CALDAY |
|
Characteristic | Week (Posting Date) |
0CALWEEK |
|
Characteristic | Month (Posting Date) |
0CALMONTH |
|
Characteristic | Quarter (Posting Date) |
0CALQUARTER |
|
Characteristic | Year (Posting Date) |
0CALYEAR |
|
Characteristic | Posting Date |
/CRMBW/POSTING |
|
Characteristic | Created On |
/CRMBW/CREA_AT |
|
Characteristic | Reference Date |
/CRMBW/REF_DAT |
|
Characteristic | External Reference Number |
/CRMBW/PO_NUMB |
|
Characteristic | Territory |
/CRMBW/TERRITO |
|
Characteristic | Territory ID |
/CRMBW/TERR_ID |
|
Characteristic | Country |
/CRMBW/SOL_COU |
|
Characteristic | Region |
/CRMBW/SLQ_REG |
|
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 | Product |
/CRMBW/PROD_GU |
|
Characteristic | Product Category |
/CRMBW/PRO_CAT |
|
Characteristic | Product ID |
/CRMBW/PRODUCT |
|
Characteristic | Transaction Type |
/CRMBW/PROCESS |
|
Characteristic | Sold-To Party |
/CRMBW/SLO_STP |
|
Characteristic | Employee Responsible |
/CRMBW/PERSON |
|
Characteristic | Division |
/CRMBW/DIVISIO |
|
Characteristic | Status |
/CRMBW/QUO_STC |
|
Characteristic | Sales Order |
/CRMBW/SLO_GUI |
|
Characteristic | Base Unit |
/CRMBW/BASE_UN |
|
Characteristic | Sales Unit |
/CRMBW/UNIT_PR |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Key Figure | Percentage of Delivered Value |
/CRMBW/PER_DEL_VAL |
Delivered sales order value (/CRMBW/DEVL_VA) / net value (/CRMBW/SO_NETV) * 100 |
Key Figure | Average Sales Order Value (Document Currency) |
/CRMBW/AVG_SLO_NV_DC |
Net value in document currency (/CRMBW/SO_NEDC) / number of sales orders (/CRMBW/NUM_SLO) |
Key Figure | Average Sales Order Value per Item (Document Currency) |
/CRMBW/AVG_SLO_VA_I |
Net value / number of items (/CRMBW/N_ITEM) |
Key Figure | Open Order Value (Document Currency) |
/CRMBW/O_SLO_V_DC |
— |
Key Figure | Delivered Order Value (Document Currency) |
/CRMBW/DEVL_VA_DC |
— |
Key Figure | Billed Order Value (Document Currency) |
/CRMBW/BILL_VA_DC |
— |
Key Figure | Gross Value (Document Currency) |
/CRMBW/GRO_VAL_DC |
— |
Key Figure | Open Billed Value (Document Currency) |
/CRMBW/O_B_VAL_DC |
— |
Key Figure | Gross Value |
/CRMBW/GROSS_V |
— |
Key Figure | Net Value |
/CRMBW/SO_NETV |
— |
Key Figure | Net Value (Document Currency) |
/CRMBW/SO_NEDC |
— |
Key Figure | Quantity |
/CRMBW/QUANTIT |
— |
Key Figure | Billed Order Quantity |
/CRMBW/BILL_QU |
— |
Key Figure | Billed Order Value |
/CRMBW/BILL_VA |
— |
Key Figure | Delivered Order Quantity |
/CRMBW/DELV_QU |
— |
Key Figure | Delivered Order Value |
/CRMBW/DEVL_VA |
— |
Key Figure | Open Billed Value |
/CRMBW/O_B_VAL_DC |
— |
Key Figure | Open Order Quantity |
/CRMBW/O_SLO_Q |
— |
Key Figure | Open Order Value |
/CRMBW/O_SLO_V |
— |
Key Figure | No. of Items |
/CRMBW/N_ITEM |
— |
Key Figure | No. of Closed Items |
CRMBW_NOCI |
— |
Key Figure | No. of Sales Orders |
/CRMBW/NUM_SLO |
— |
Key Figure | No. of Back Order Items |
/CRMBW/N_BITEM |
— |
Key Figure | No. of Open Items |
CRMBW_NOOOI |
— |
Key Figure | Average Sales Order Value per Item |
CRMBW_ASOVPI |
Sum of sales order net value / number of items |
Key Figure | Percentage of Billed Value |
CRMBW_POBV |
Billed sales order value / net value (/CRMBW/SO_NETV) * 100 |
Key Figure | Average No. of Items per Sales Order |
CRMBW_ANOFOIPSO |
Number of items / number of sales orders |
Key Figure | Average Sales Order Value |
CRMBW_ASOV |
Sum of sales order net value / number of sales orders |
Key Figure | Order Quantity in Base Unit |
/CRMBW/QUANBAS |
— |
Key Figure | Sum of Sales Order Net Value |
CRMBW_SOSONV |
Net value |