Show TOC

Sales Agreement Query Locate this document in the navigation structure

Query Query: /CRMBW/SLA_C01_001

 

This query provides you with an overview of sales agreements. The query contains characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Sales Agreements.

For information about the report areas in SAP CRM, see Report Areas for Interactive Reports.

This query is based on the InfoProvider /CRMBW/SLA_C01.

To use this query, you must activate the business functions SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB) and Interactive Reporting: Report Area for Sales Agreement (CRM_ANA_SLSAGR)

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Report Area

/CRMBW/REPORTA

Sales agreement (SALESAGREEMENT)

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

Sold-To Party

/CRMBW/SLO_STP

Characteristic Characteristic

Cancellation Party

/CRMBW/CANCPAR

Characteristic Characteristic

Reason for Cancellation

/CRMBW/CANC_RE

Characteristic Characteristic

Cancellation Party (Item)

/CRMBW/CANCPAI

Characteristic Characteristic

Cancellation Reason (Item)

/CRMBW/CANC_RI

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 Organization Unit

/CRMBW/SLS_RES

Characteristic Characteristic

Sales Organization

/CRMBW/SLS_ORG

Characteristic Characteristic

Contact

/CRMBW/CONTACT

Characteristic Characteristic

Country

/CRMBW/COUNTRY

Characteristic Characteristic

Created On (Item)

/CRMBW/CR_ON_I

Characteristic Characteristic

Territory ID

/CRMBW/TERR_ID

Characteristic Characteristic

Region

/CRMBW/SLQ_REG

Characteristic Characteristic

Sales Group

/CRMBW/SALES_G

Characteristic Characteristic

Status Profile

/CRMBW/USER_ST

Characteristic Characteristic

Valid From

/CRMBW/VALID_F

Characteristic Characteristic

Valid To

/CRMBW/VALID_T

Characteristic Characteristic

Status

/CRMBW/QUO_STC

Characteristic Characteristic

Credit Status

/CRMBW/CREDSTH

Characteristic Characteristic

Status: Credit Not OK

/CRMBW/STAT_C0

Characteristic Characteristic

Status: Credit OK

/CRMBW/STAT_CR

Characteristic Characteristic

Division

/CRMBW/DIVISIO

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

Characteristic Characteristic

External Reference Number

/CRMBW/PO_NUMB

Characteristic Characteristic

Product

/CRMBW/PROD_GU

Characteristic Characteristic

Product Category

/CRMBW/PRO_CAT

Characteristic Characteristic

Product ID

/CRMBW/PRODUCT

Characteristic Characteristic

Sales Agreement

/CRMBW/SLA_GUI

Characteristic Characteristic

Sales Agreement ID

/CRMBW/SLA_ID

Characteristic Characteristic

Transaction Type

/CRMBW/PROCESS
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Average Expected Total Value per Sales Agreement

/CRMBW/AVG_EX_TV_AGR

Expected total value (/CRMBW/NET_VAL) / number of sales agreements (/CRMBW/NUM_OF)

Key Figure Key Figure

Average Target Quantity per Sales Agreement

/CRMBW/AVG_TQ_AGR

Target quantity / number of sales agreements

Key Figure Key Figure

Average Target Value per Sales Agreement

/CRMBW/AVG_TV_AGR

Target value / number of sales agreements

Key Figure Key Figure

No. of Completed Sales Agreements

/CRMBW/NUOFCA

—

Key Figure Key Figure

Expected Total Value of Cancelled Items (Document Currency)

/CRMBW/NET_VMC_DC_AGR

Is only filled if the characteristic Cancellation Party (Item) (/CRMBW/CANCPAI) is filled.

Key Figure Key Figure

Expected Total Value (per Sales Agreement Item) (Document Currency)

/CRMBW/NET_VAL_DC_AGR

—

Key Figure Key Figure

Released Value (per Sales Agreement Item) (Document Currency)

/CRMBW/REL_VA_DC_AGR

—

Key Figure Key Figure

No. of Cancelled Sales Agreement Items

/CRMBW/CAGRITM

—

Key Figure Key Figure

No. of Completed Sales Agreements

/CRMBW/NUOFCA

—

Key Figure Key Figure

No. of Cancelled Sales Agreements

/CRMBW/NUM_CH

Is only filled if the characteristic Cancellation Party (/CRMBW/CANCPAR) (at header level) is filled.

Key Figure Key Figure

Number of Sales Agreement Items

/CRMBW/AGR_ITM

—

Key Figure Key Figure

Number of Sales Agreement Release Orders

/CRMBW/NUMREOR

—

Key Figure Key Figure

Number of Sales Agreements

/CRMBW/NUM_OF

—

Key Figure Key Figure

Expected Total Value of Cancelled Items

/CRMBW/NET_VMC

Is only filled if the characteristic Cancellation Party (Item) is filled.

Key Figure Key Figure

Expected Total Value

/CRMBW/NET_VAL

—

Key Figure Key Figure

Target Quantity

/CRMBW/QUANTIT

—

Key Figure Key Figure

Target Value

/CRMBW/TARGET

—