Show TOC

Opportunity Query (Max.) (VDM-Based) Locate this document in the navigation structure

Query Query: /CRMBW/CRM_V04I_Q001

 

This query provides you with an overview of opportunities in sales. The query contains characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Opportunities (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

Opportunitys (OPPORTUNITIES_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

Analysis Phase

/CRMBW/CNTRPH

SAP HANA VDM Field: AnalysisStage

Characteristic Characteristic

Sales Cycle

/CRMBW/SLSCYC

SAP HANA VDM Field: SalesCycle

Characteristic Characteristic

Sales Stage

/CRMBW/CURR_PH

SAP HANA VDM Field: CurrentSalesStage

Characteristic Characteristic

Sales Stage Since

/CRMBW/PHASE_S

SAP HANA VDM Field: InSalesStageSinceDate

Characteristic Characteristic

Competitor

/CRMBW/COMPETI

SAP HANA VDM Field: Competitor

Characteristic Characteristic

Opportunity

/CRMBW/OPP_ID

SAP HANA VDM Field: Opportunity

Characteristic Characteristic

Opportunity Group

/CRMBW/TYPE

SAP HANA VDM Field: OpportunityType

Characteristic Characteristic

Opportunity Type

/CRMBW/PROCESS

SAP HANA VDM Field: CRMBusinessTransactionType

Characteristic Characteristic

Status

/CRMBW/OPP_STC

SAP HANA VDM Field: GeneralStatus

Characteristic Characteristic

Reason

/CRMBW/CODEC

SAP HANA VDM Field: StatusReason

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

Organizational Unit

/CRMBW/SLS_RES

SAP HANA VDM Field: ResponsibleSalesOrganization

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

SAP HANA VDM Field: ResponsibleEmployee

Characteristic Characteristic

Closing Date

/CRMBW/EXPEND

SAP HANA VDM Field: ExpectedEndDate

Characteristic Characteristic

Industry

/CRMBW/INDUSTR

SAP HANA VDM Field: CRMIndustry

Characteristic Characteristic

Origin

/CRMBW/SOURCE

SAP HANA VDM Field: Origin

Characteristic Characteristic

Priority

/CRMBW/IMPORTA

SAP HANA VDM Field: OpportunityPriority

Characteristic Characteristic

Product

/CRMBW/PROD_GU

SAP HANA VDM Field: ProductUUID

Characteristic Characteristic

Product Category

/CRMBW/PRO_CAT

SAP HANA VDM Field: ProductCategory

Characteristic Characteristic

Product ID

/CRMBW/PRODUCT

SAP HANA VDM Field: Product

Characteristic Characteristic

Prospect

/CRMBW/PROSP

SAP HANA VDM Field: Prospect

Characteristic Characteristic

Rel. for Forecast

/CRMBW/FORECAS

SAP HANA VDM Field: OpportunityIsForecastRelevant

Characteristic Characteristic

Start Date

/CRMBW/STARTDA

SAP HANA VDM Field: StartDate

Characteristic Characteristic

Calendar Year/Month

/CRMBW/CALYMON

SAP HANA VDM Field: ExpectedEndDateYearMonth

Characteristic Characteristic

Calendar Year/Quarter

/CRMBW/CALYQTR

SAP HANA VDM Field: ExpectedEndDateYearQuarter

Characteristic Characteristic

Calendar Year

/CRMBW/CALYEAR

SAP HANA VDM Field: ExpectedEndDateYear

Characteristic Characteristic

Currency

/CRMBW/CURNCY

SAP HANA VDM Field: TransactionCurrency

Characteristic Characteristic

Responsible Person at Partner

/CRMBW/RES_ATP

SAP HANA VDM Field: ResponsibleEmployeeAtPartner

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

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Product Value (Document Currency)

/CRMBW/NET_VAL_DC_V

SAP HANA VDM Field: ItemExpectedNetAmount_E

Key Figure Key Figure

Chance of Success %

/CRMBW/PROBABI

SAP HANA VDM Field: ChanceOfSuccessPercent

Key Figure Key Figure

Product Value

/CRMBW/NETVAMC

SAP HANA VDM Field: ItemExpdNetAmtInDisplayCrcy_E

Key Figure Key Figure

No. of Items

/CRMBW/N_ITEM

SAP HANA VDM Field: NumberOfOpportunityItems

Key Figure Key Figure

Conversion Rate: Opportunity to Order

/CRMBW/OPPTOSLO_V

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

Key Figure Key Figure

No. of Opportunities

/CRMBW/NUM_OF

SAP HANA VDM Field: NumberOfOpportunities

Key Figure Key Figure

Expected Sales Volume (Document Currency)

/CRMBW/EXPREV

SAP HANA VDM Field: ExpectedNetAmount

Key Figure Key Figure

Expected Sales Volume (Weighted, Document Currency)

/CRMBW/EXPREVW

SAP HANA VDM Field: WeightedExpectedNetAmount

Key Figure Key Figure

Expected Sales Volume

/CRMBW/EXPREVD

SAP HANA VDM Field: ExpectedNetAmountInDisplayCrcy

Key Figure Key Figure

Expected Sales Volume (Weighted)

/CRMBW/EXPRVWD

SAP HANA VDM Field: WgtdExpdNetAmountInDisplayCrcy

Key Figure Key Figure

Lost Expected Sales Volume

/CRMBW/LEXREVC

SAP HANA VDM Field: LostExptdNetAmtInDisplayCrcy

Key Figure Key Figure

No. of Opportunities with Sales Order as Successor

/CRMBW/NUOPSUC

SAP HANA VDM Field: OpptyNumberOfSuccssrSlsOrder

Key Figure Key Figure

Product Quantity in Base Unit

/CRMBW/QUANBAS

SAP HANA VDM Field: ProductQuantityInBaseUnit

Key Figure Key Figure

% Expected Sales Volume of all Opportunities

CRMBW_PEXPRVI_V

Expected Sales Volume (Weighted) (/CRMBW/EXPRVWD) / SUMCT Expected Sales Volume (Weighted) (/CRMBW/EXPRVWD) * 100

Key Figure Key Figure

% No. of all Opportunities

CRMBW_PEXPRVT_VDM

Number of Opportunitys (/CRMBW/NUM_OF) / SUMCT Number of Opportunitys (/CRMBW/NUM_OF) * 100

Key Figure Key Figure

Product Quantity

/CRMBW/SLQ_QUA

SAP HANA VDM Field: ProductQuantity

Key Figure Key Figure

Closure Rate

/CRMBW/CLRTV

Number of Closed Opportunities (/CRMBW/NUM_CD) % Number of Opportunitys (/CRMBW/NUM_OF)

Key Figure Key Figure

Success Rate

/CRMBW/WINRTV

Number of Won Opportunitys (/CRMBW/NUM_WD) % Number of Won Opportunitys (/CRMBW/NUM_WD)+ Number of Lost Opportunitys (/CRMBW/NUM_LD)

Key Figure Key Figure

Average Sales Cycle Duration

/CRMBW/SLSCYCV

Sales Cycle Duration (/CRMBW/SLSCYCD) / Number of Opportunitys (/CRMBW/NUM_OF)