Show TOC

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

Query Query: /CRMBW/SLQ_V01_001

 

This query provides you with an overview of sales-relevant quotations. 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 Quotations (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/SLQ_V01.

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

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

Sales Quotation

/CRMBW/SLQ_GUI

SAP HANA VDM Field: SalesQuotationUUID

Characteristic Characteristic

Sales Quotation ID

/CRMBW/SLQ_ID

SAP HANA VDM Field: SalesQuotation

Characteristic Characteristic

Responsible Sales Org. Unit

/CRMBW/SLS_RES

SAP HANA VDM Field: ResponsibleSalesOrganization

Characteristic Characteristic

Sales Organization

/CRMBW/SLS_ORG

SAP HANA VDM Field: SalesOrganization

Characteristic Characteristic

Distribution Channel

/CRMBW/DIS_CHA

SAP HANA VDM Field: DistributionChannel

Characteristic Characteristic

Division

/CRMBW/DIVISIO

SAP HANA VDM Field: Division

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

SAP HANA VDM Field: ResponsibleEmployee

Characteristic Characteristic

Territory

/CRMBW/TERRITO

SAP HANA VDM Field: Territory

Characteristic Characteristic

Transaction Type

/CRMBW/PROCESS

SAP HANA VDM Field: CRMBusinessTransactionType

Characteristic Characteristic

Sold-To Party

/CRMBW/SLO_STP

SAP HANA VDM Field: SoldToParty

Characteristic Characteristic

Territory ID

/CRMBW/TERR_ID

SAP HANA VDM Field: Territory

Characteristic Characteristic

Country

/CRMBW/SOL_COU

SAP HANA VDM Field: SoldToPartyCountry

Characteristic Characteristic

Region

/CRMBW/SLQ_REG

SAP HANA VDM Field: SoldToPartyRegion

Characteristic Characteristic

External Reference Number

/CRMBW/PO_NUMB

SAP HANA VDM Field: SoldToPartyExtRefID

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

Responsible Person at Partner

/CRMBW/RES_ATP

SAP HANA VDM Field: ResponsibleEmployeeAtPartner

Characteristic Characteristic

Channel Partner Type

/CRMBW/CP_TYPE

SAP HANA VDM Field: ChannelPartnerType

Characteristic Characteristic

Contact Person

/CRMBW/CONTACT

SAP HANA VDM Field: ContactPerson

Characteristic Characteristic

Week (Valid To)

/CRMBW/CALYWEE

SAP HANA VDM Field: ValidityEndDateYearWeek

Characteristic Characteristic

Month (Valid To)

/CRMBW/CALYMON

SAP HANA VDM Field: ValidityEndDateYearMonth

Characteristic Characteristic

Quarter (Valid To)

/CRMBW/CALYQTR

SAP HANA VDM Field: ValidityEndDateYearQuarter

Characteristic Characteristic

Year (Valid To)

/CRMBW/CALYEAR

SAP HANA VDM Field: ValidityEndDateYear

Characteristic Characteristic

Posting Date

/CRMBW/POSTING

SAP HANA VDM Field: PostingDate

Characteristic Characteristic

Valid From

/CRMBW/VALID_F

SAP HANA VDM Field: ValidityStartDate

Characteristic Characteristic

Valid To

/CRMBW/VALID_T

SAP HANA VDM Field: ValidityEndDate

Characteristic Characteristic

Created On

/CRMBW/CREA_AT

SAP HANA VDM Field: CreationDate

Characteristic Characteristic

Reference Date

/CRMBW/REF_DAT

SAP HANA VDM Field: ReferenceDate

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

Currency

/CRMBW/CURNCY

SAP HANA VDM Field: TransactionCurrency

Characteristic Characteristic

Status

/CRMBW/QUO_STC

SAP HANA VDM Field: GeneralStatus

Characteristic Characteristic

Status: Credit Not OK

/CRMBW/STAT_C0

SAP HANA VDM Field: CreditWorthinessIsNotGranted

Characteristic Characteristic

Status: Credit OK

/CRMBW/STAT_CR

SAP HANA VDM Field: CreditWorthinessIsGranted

Characteristic Characteristic

Base Unit

/CRMBW/BASE_UN

SAP HANA VDM Field: BaseUnit

Characteristic Characteristic

Sales Unit

/CRMBW/UNIT_PR

SAP HANA VDM Field: QuantityUnit
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Average Net Value of Accepted Quotation Items

CRMBW_AVNVAQI

Net Value of Accepted Quotation Items (/CRMBW/NETVAQI) / Number of Accepted Quotation Items (/CRMBW/NUMAQI)

Key Figure Key Figure

Avg. Net Value of Acc. Quotation Items (Document Currency)

CRMBW_ANAQIDC

Net Value of Accepted Quotation Items (Document Currency) (/CRMBW/NVAQIDC) / Number of Accepted Quotation Items (/CRMBW/NUMAQI)

Key Figure Key Figure

Net Value of Accepted Quotation Items (Document Currency)

/CRMBW/NVAQIDC

SAP HANA VDM Field: AcceptedNetAmount

Key Figure Key Figure

Net Value of Expired Quotation Items (Document Currency)

/CRMBW/NVEQIDC

SAP HANA VDM Field: ExpiredNetAmount

Key Figure Key Figure

Net Value of Open Quotation Items (Document Currency)

/CRMBW/NVOQIDC

SAP HANA VDM Field: OpenNetAmount

Key Figure Key Figure

Net Value of Rejected Quotation Items (Document Currency)

/CRMBW/NVRQIDC

SAP HANA VDM Field: RejectedNetAmount

Key Figure Key Figure

Gross Value Quotation Items

/CRMBW/GROVLQI

SAP HANA VDM Field: GrossAmountInDisplayCurrency

Key Figure Key Figure

Average Net Value of Quotation Items (Document Currency)

CRMBW_ANVQIDC

Net Value of Quotation Items (Document Currency) (/CRMBW/NET_QDC) / Number of Quotation Items (/CRMBW/NUM_QIT)

Key Figure Key Figure

Success Rate

CRMBW_SUCCRATE

Net Value of Accepted Quotation Items (/CRMBW/NETVAQI) / Net Value of Quotation Items (/CRMBW/NETVLQI)

Key Figure Key Figure

Average Net Value of Quotation Items

CRMBW_ANVALQI

Net Value of Quotation Items (/CRMBW/NETVLQI) / Number of Quotation Items (/CRMBW/NUM_QIT)

Key Figure Key Figure

Rate of Rejected Quotation Items

CRMBW_RATREQI

Net Value of Rejected Quotation Items (/CRMBW/NETRQI)/ Net Value of Quotation Items (/CRMBW/NETVLQI)

Key Figure Key Figure

Rate of Expired Quotation Items

CRMBW_RATEXQI

Net Value of Expired Quotation Items (/CRMBW/NETVEQI) / Net Value of Quotation Items (/CRMBW/NETVLQI)

Key Figure Key Figure

Rate of Open Quotation Items

CRMBW_RATOPQI

Net Value of Open Quotation Items (/CRMBW/NETVOQI) / Net Value of Quotation Items (/CRMBW/NETVLQI)

Key Figure Key Figure

Net Value Quotation Items (Document Currency)

/CRMBW/NET_QDC

SAP HANA VDM Field: NetAmount

Key Figure Key Figure

Order Quantity in Base Unit

/CRMBW/QUANBAS

SAP HANA VDM Field: BaseUnit, QuantityInBaseUnit

Key Figure Key Figure

Gross Value Quotation Items (Document Currency)

/CRMBW/GQUOIDC

SAP HANA VDM Field: GrossAmount

Key Figure Key Figure

Net Value Quotation Items

/CRMBW/NETVLQI

SAP HANA VDM Field: NetAmountInDisplayCurrency

Key Figure Key Figure

No. of Quotation Items

/CRMBW/NUM_QIT

SAP HANA VDM Field: NumberOfSalesQuotationItems

Key Figure Key Figure

No. of Quotations

/CRMBW/NUM_QUO

SAP HANA VDM Field: NumberOfSalesQuotations

Key Figure Key Figure

Order Quantity

/CRMBW/SLQ_QUA

SAP HANA VDM Field: Quantity, QuantityUnit

Key Figure Key Figure

Net Value of Accepted Quotation Items

/CRMBW/NETVAQI

SAP HANA VDM Field: AcceptedNetAmountInDisplayCrcy

Key Figure Key Figure

Net Value of Expired Quotation Items

/CRMBW/NETVEQI

SAP HANA VDM Field: ExpiredNetAmountInDisplayCrcy

Key Figure Key Figure

Net Value of Open Quotation Items

/CRMBW/NETVOQI

SAP HANA VDM Field: OpenNetAmountInDisplayCrcy

Key Figure Key Figure

Net Value of Rejected Quotation Items

/CRMBW/NETRQI

SAP HANA VDM Field: RejectedNetAmountInDisplayCrcy

Key Figure Key Figure

No. of Accepted Quotation Items

/CRMBW/NUMAQI

SAP HANA VDM Field: NmbrOfAcceptedSlsQtanItems

Key Figure Key Figure

No. of Expired Quotation Items

/CRMBW/NUMEQI

SAP HANA VDM Field: NmbrOfExpiredSlsQuotationItems

Key Figure Key Figure

No. of Open Quotation Items

/CRMBW/NUMOQI

SAP HANA VDM Field: NmbrOfOpenSlsQuotationItems

Key Figure Key Figure

No. of Rejected Quotation Items

/CRMBW/NUMTRQI

SAP HANA VDM Field: NmbrOfRejectedSlsQtanItems

Key Figure Key Figure

Net Value of Sales Order

/CRMBW/ONETVAL

SAP HANA VDM Field: SlsOrderItmNetAmtInDisplayCrcy

Key Figure Key Figure

Accepted Item Ratio in Percent

CRMBW_ACCITMR

Number of Accepted Quotation Items (/CRMBW/NUMAQI) / Number of Quotation Items (/CRMBW/NUM_QIT)