Show TOC

Sales Performance Management Query (VDM-Based) Locate this document in the navigation structure

Query Query: /CRMBW/CRM_V04I_Q004

 

This query enables you to compare opportunities and sales orders in sales. The query contains a complete record of all characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Sales Performance Management (Based on SAP HANA VDM).

For information about the report areas in SAP CRM, see Report Areas for Interactive Reports Based on SAP HANA VDM

This query is based on the InfoProvider CRMBW/CRM_V04I.

To use this query, you must activate the business functions SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB) and Interactive Reporting Based on SAP HANA VDM (CRM_ANA_VDM) .

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Report Area

/CRMBW/REPORTA

Opportunities and Sales Orders (OPPORT_SALES_VDM)

Characteristic Characteristic

Selection GUID

/CRMBW/SELGUID

Technical filter that is generated at runtime
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Has Errors

/CRMBW/HAS_ERR

SAP HANA VDM Field: HasError

Characteristic Characteristic

Status: Open

/CRMBW/STATOP

SAP HANA VDM Field: IsOpen

Characteristic Characteristic

Prospect/Sold-To Party

/CRMBW/COMPROS

SAP HANA VDM Field: ProspectOrSoldToParty

Characteristic Characteristic

Territory

/CRMBW/TERRITO

SAP HANA VDM Field: TerritoryName

Characteristic Characteristic

Territory ID

/CRMBW/TERR_ID

SAP HANA VDM Field: Territory

Characteristic Characteristic

Country

/CRMBW/COUNTRY

SAP HANA VDM Field: Country

Characteristic Characteristic

Region

/CRMBW/REGION

SAP HANA VDM Field: Region

Characteristic Characteristic

Industry

/CRMBW/INDUSTR

SAP HANA VDM Field: CRMIndustry

Characteristic Characteristic

Date Opp./Sales Ord.

/CRMBW/COMDATE

SAP HANA VDM Field: ExpectedEndDateOrPostingDate

Characteristic Characteristic

Calendar Year/Week

/CRMBW/CALYWEE

SAP HANA VDM Field: ExpectedEndDateOrPostingDateYearWeek

Characteristic Characteristic

Calendar Year/Month

/CRMBW/CALYMON

SAP HANA VDM Field: ExpectedEndDateOrPostingDateYearMonth

Characteristic Characteristic

Calendar Year/Quarter

/CRMBW/CALYQTR

SAP HANA VDM Field: ExpectedEndDateOrPostingDateYearQuarter

Characteristic Characteristic

Calendar Year

/CRMBW/CALYEAR

SAP HANA VDM Field: ExpectedEndDateOrPostingDateYear

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

SAP HANA VDM Field: ResponsibleEmployee

Characteristic Characteristic

Sales Organization

/CRMBW/SLS_ORG

SAP HANA VDM Field: SalesOrganization

Characteristic Characteristic

Division

/CRMBW/DIVISIO

SAP HANA VDM Field: Division

Characteristic Characteristic

Distribution Channel

/CRMBW/DIS_CHA

SAP HANA VDM Field: DistributionChannel

Characteristic Characteristic

Channel Partner

/CRMBW/CHA_PAR

SAP HANA VDM Field: ChannelPartner

Characteristic Characteristic

Channel Partner Program

/CRMBW/CP_PROG

SAP HANA VDM Field: ChannelPartnerProgram

Characteristic Characteristic

Channel Partner Status

/CRMBW/CP_STAT

SAP HANA VDM Field: ChannelPartnerStatus

Characteristic Characteristic

Channel Partner Type

/CRMBW/CP_TYPE

SAP HANA VDM Field: ChannelPartnerType

Characteristic Characteristic

Responsible Person at Partner

/CRMBW/RES_ATP

SAP HANA VDM Field: ResponsibleEmployeeAtPartner

Characteristic Characteristic

Product

/CRMBW/PROD_GU

SAP HANA VDM Field: ProductUUID

Characteristic Characteristic

Product ID

/CRMBW/PRODUCT

SAP HANA VDM Field: Product

Characteristic Characteristic

Base Unit

/CRMBW/BASE_UN

SAP HANA VDM Field: BaseUnit

Characteristic Characteristic

Status (Opportunity)

/CRMBW/OPP_STC

SAP HANA VDM Field: GeneralStatus

Characteristic Characteristic

Organizational Unit

/CRMBW/SLS_RES

SAP HANA VDM Field: ResponsibleSalesOrganization

Characteristic Characteristic

Sales Stage

/CRMBW/CURR_PH

SAP HANA VDM Field: Analysis Stage
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

No. of Opportunities

/CRMBW/NUM_OF

SAP HANA VDM Field: NumberOfOpportunities

Key Figure Key Figure

No. of Sales Orders

/CRMBW/NUM_SLO

SAP HANA VDM Field: NumberOfSalesOrders

Key Figure Key Figure

Product Quantity

/CRMBW/SLQ_QUA

SAP HANA VDM Field: ProductQuantity

Key Figure Key Figure

Product Quantity in Base Unit

/CRMBW/QUANBAS

SAP HANA VDM Field: ProductQuantityInBaseUnit

Key Figure Key Figure

Product Value

/CRMBW/NETVAMC

SAP HANA VDM Field: ItemExpdNetAmtInDisplayCrcy_E

Key Figure Key Figure

Product Value (Document Currency)

/CRMBW/NET_VAL

SAP HANA VDM Field: ItemExpectedNetAmount_E

Key Figure Key Figure

Net Value

/CRMBW/NETVALC

SAP HANA VDM Field: NetAmountInDisplayCurrency_E

Key Figure Key Figure

Net Value (Document Currency)

/CRMBW/SO_NETV

SAP HANA VDM Field: NetAmount_E

Key Figure Key Figure

Gross Value

/CRMBW/GROVALC

SAP HANA VDM Field: GrossAmountInDisplayCrcy_E

Key Figure Key Figure

Gross Value (Document Currency)

/CRMBW/GROSS_V

SAP HANA VDM Field: GrossAmount_E

Key Figure Key Figure

Expected Sales Volume (Document Currency)

/CRMBW/EXPREV

SAP HANA VDM Field: ExpectedNetAmount_E

Key Figure Key Figure

Expected Sales Volume (Weighted, Document Currency)

/CRMBW/EXPREVW

Expected Sales Volume (Document Currency) (/CRMBW/EXPREV) * Chance of Success % (/CRMBW/PROBABI) / 100

Key Figure Key Figure

Expected Sales Volume

/CRMBW/EXPREVD

SAP HANA VDM Field: ExpectedNetAmtInDisplayCrcy_E

Key Figure Key Figure

Expected Sales Volume (Weighted)

/CRMBW/EXPRVWD

Expected Sales Volume (/CRMBW/EXPREVD) * Chance of Success % (/CRMBW/PROBABI) / 100

Key Figure Key Figure

Conversion Rate: Opportunity to Order

/CRMBW/OPPTOSL_V

No. of Opportunities with Sales Order as Successor (/CRMBW/NUOPSUC) / Number of Opportunities (/CRMBW/NUM_OF) * 100

Key Figure Key Figure

No. of Opportunities with Sales Order as Successor

/CRMBW/NUOPSUC

SAP HANA VDM Field: NmbrOfOpptyWithSuccssrSlsOrder

Key Figure Key Figure

Weighted Prod. Value

/CRMBW/NETVWC

Expected Sales Volume (/CRMBW/EXPREVD) * Chance of Success % (/CRMBW/PROBABI) / 100

Key Figure Key Figure

Weighted Prod. Value (Document Currency)

/CRMBW/NETVALW

Product Value (/CRMBW/NET_VAL) * Chance of Success % (/CRMBW/PROBABI) / 100

Key Figure Key Figure

Order Net Value in Current Quarter

/CRMBW/NETVQD

Net Value (/CRMBW/NETVALC), if Quarter (/CRMBW/CALYQTR) = Current Quarter

Key Figure Key Figure

Order Net Value in Current Year

/CRMBW/NETVYD

Net Value (/CRMBW/NETVALC), if Year (/CRMBW/CALYQTR) = Current Year

Key Figure Key Figure

Expected Sales Volume in Current Year (Weighted)

/CRMBW/EXPRYD

Expected Sales Volume (Weighted) (/CRMBW/EXPRVWD), if Year (/CRMBW/CALYEAR) = Combined Date for Opportunity and Sales Order (/CRMBW/COMDATE) > Current Date

Key Figure Key Figure

Projected Revenue in Current Year

/CRMBW/PROJCYD_V

Order Net Value Current Year (/CRMBW/NETVYD) + Expected Sales Volume Current Year (Weighted) (/CRMBW/EXPRYD)

Key Figure Key Figure

Opportunity Age in Days

/CRMBW/OPPAID

SAP HANA VDM Field: OpportunityAgeInDays

Key Figure Key Figure

Chance of Success in %

/CRMBW/PROBABI

SAP HANA VDM Field: ChanceOfSuccessPercent