Sales Contract Query

Query Query: /CRMBW/SLC_C01_001

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

Structure

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

Rows
Object Type	Name	Technical Name
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/QUO_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`

Columns
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 Cancellation Party (Item) (/CRMBW/CANCPAI) is filled.
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 Cancellation Party (/CRMBW/CANCPAR) (at header level) is filled.
Key Figure	No. of Cancelled Contract Items	`/CRMBW/CCONITM`	Is only filled if the characteristic Cancellation Party (Item) is filled.
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 Cancellation Party (Item) is filled.
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`	—