Show TOC

Sales Order Query Locate this document in the navigation structure

Query Query: /CRMBW/SLO_C01_Q0001

 

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).

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Report Area

/CRMBW/REPORTA

Sales Order (SALESORDER)

Characteristic Characteristic

Application Server

/CRMBW/APPLS

Application server (/CRMBW/V_APPLS)

Characteristic Characteristic

Logical System

/CRMBW/LOGSYS

Source system (/CRMBW/V_LOGSY)

Characteristic Characteristic

Selection ID

/CRMBW/SELID

Selection ID (/CRMBW/V_SELID)

Characteristic Characteristic

User Name

/CRMBW/UNAME

Current User (/CRMBW/V_UNAME)
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Currency

/CRMBW/CURNCY

Characteristic Characteristic

Sales Order ID

/CRMBW/TA_ID

Characteristic Characteristic

Day (Posting Date)

0CALDAY

Characteristic Characteristic

Week (Posting Date)

0CALWEEK

Characteristic Characteristic

Month (Posting Date)

0CALMONTH

Characteristic Characteristic

Quarter (Posting Date)

0CALQUARTER

Characteristic Characteristic

Year (Posting Date)

0CALYEAR

Characteristic Characteristic

Posting Date

/CRMBW/POSTING

Characteristic Characteristic

Created On

/CRMBW/CREA_AT

Characteristic Characteristic

Reference Date

/CRMBW/REF_DAT

Characteristic Characteristic

External Reference Number

/CRMBW/PO_NUMB

Characteristic Characteristic

Territory

/CRMBW/TERRITO

Characteristic Characteristic

Territory ID

/CRMBW/TERR_ID

Characteristic Characteristic

Country

/CRMBW/SOL_COU

Characteristic Characteristic

Region

/CRMBW/SLQ_REG

Characteristic Characteristic

Channel Partner

/CRMBW/CHA_PAR

Characteristic Characteristic

Channel Partner Program

/CRMBW/CP_PROG

Characteristic Characteristic

Channel Partner Status

/CRMBW/CP_STAT

Characteristic Characteristic

Responsible Person at Partner

/CRMBW/RES_ATP

Characteristic Characteristic

Channel Partner Type

/CRMBW/CP_TYPE

Characteristic Characteristic

Distribution Channel

/CRMBW/DIS_CHA

Characteristic Characteristic

Responsible Sales Org. Unit

/CRMBW/SLS_RES

Characteristic Characteristic

Sales Organization

/CRMBW/SLS_ORG

Characteristic Characteristic

Product

/CRMBW/PROD_GU

Characteristic Characteristic

Product Category

/CRMBW/PRO_CAT

Characteristic Characteristic

Product ID

/CRMBW/PRODUCT

Characteristic Characteristic

Transaction Type

/CRMBW/PROCESS

Characteristic Characteristic

Sold-To Party

/CRMBW/SLO_STP

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

Characteristic Characteristic

Division

/CRMBW/DIVISIO

Characteristic Characteristic

Status

/CRMBW/QUO_STC

Characteristic Characteristic

Sales Order

/CRMBW/SLO_GUI

Characteristic Characteristic

Base Unit

/CRMBW/BASE_UN

Characteristic Characteristic

Sales Unit

/CRMBW/UNIT_PR
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure 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 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 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 Key Figure

Open Order Value (Document Currency)

/CRMBW/O_SLO_V_DC

—

Key Figure Key Figure

Delivered Order Value (Document Currency)

/CRMBW/DEVL_VA_DC

—

Key Figure Key Figure

Billed Order Value (Document Currency)

/CRMBW/BILL_VA_DC

—

Key Figure Key Figure

Gross Value (Document Currency)

/CRMBW/GRO_VAL_DC

—

Key Figure Key Figure

Open Billed Value (Document Currency)

/CRMBW/O_B_VAL_DC

—

Key Figure Key Figure

Gross Value

/CRMBW/GROSS_V

—

Key Figure Key Figure

Net Value

/CRMBW/SO_NETV

—

Key Figure Key Figure

Net Value (Document Currency)

/CRMBW/SO_NEDC

—

Key Figure Key Figure

Quantity

/CRMBW/QUANTIT

—

Key Figure Key Figure

Billed Order Quantity

/CRMBW/BILL_QU

—

Key Figure Key Figure

Billed Order Value

/CRMBW/BILL_VA

—

Key Figure Key Figure

Delivered Order Quantity

/CRMBW/DELV_QU

—

Key Figure Key Figure

Delivered Order Value

/CRMBW/DEVL_VA

—

Key Figure Key Figure

Open Billed Value

/CRMBW/O_B_VAL_DC

—

Key Figure Key Figure

Open Order Quantity

/CRMBW/O_SLO_Q

—

Key Figure Key Figure

Open Order Value

/CRMBW/O_SLO_V

—

Key Figure Key Figure

No. of Items

/CRMBW/N_ITEM

—

Key Figure Key Figure

No. of Closed Items

CRMBW_NOCI

—

Key Figure Key Figure

No. of Sales Orders

/CRMBW/NUM_SLO

—

Key Figure Key Figure

No. of Back Order Items

/CRMBW/N_BITEM

—

Key Figure Key Figure

No. of Open Items

CRMBW_NOOOI

—

Key Figure Key Figure

Average Sales Order Value per Item

CRMBW_ASOVPI

Sum of sales order net value / number of items

Key Figure Key Figure

Percentage of Billed Value

CRMBW_POBV

Billed sales order value / net value (/CRMBW/SO_NETV) * 100

Key Figure Key Figure

Average No. of Items per Sales Order

CRMBW_ANOFOIPSO

Number of items / number of sales orders

Key Figure Key Figure

Average Sales Order Value

CRMBW_ASOV

Sum of sales order net value / number of sales orders

Key Figure Key Figure

Order Quantity in Base Unit

/CRMBW/QUANBAS

—

Key Figure Key Figure

Sum of Sales Order Net Value

CRMBW_SOSONV

Net value