Show TOC

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

Query Query: /CRMBW/SLO_V01_Q0001

 

This query provides you with an overview of sales orders. 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 Orders (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/SLO_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

Report Area

/CRMBW/REPORTA

Sales Order (SALESORDER_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

Currency

/CRMBW/CURNCY

SAP HANA VDM Field: TransactionCurrency

Characteristic Characteristic

Sales Order ID

/CRMBW/TA_ID

SAP HANA VDM Field: SalesOrderUUID

Characteristic Characteristic

Week (Posting Date)

/CRMBW/CALYWEE

SAP HANA VDM Field: PostingDateYearWeek

Characteristic Characteristic

Month (Posting Date)

/CRMBW/CALYMON

SAP HANA VDM Field: PostingDateYearMonth

Characteristic Characteristic

Quarter (Posting Date)

/CRMBW/CALYQTR

SAP HANA VDM Field: PostingDateYearQuarter

Characteristic Characteristic

Year (Posting Date)

/CRMBW/CALYEAR

SAP HANA VDM Field: PostingDateYear

Characteristic Characteristic

Posting Date

/CRMBW/POSTING

SAP HANA VDM Field: PostingDate

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

External Reference Number

/CRMBW/PO_NUMB

SAP HANA VDM Field: SoldToPartyExtRefID

Characteristic Characteristic

Territory

/CRMBW/TERRITO

SAP HANA VDM Field: Territory

Characteristic Characteristic

Territory ID

/CRMBW/TERR_ID

SAP HANA VDM Field: Territory

Characteristic Characteristic

Country

/CRMBW/COUNTRY

SAP HANA VDM Field: SoldToPartyCountry

Characteristic Characteristic

Region

/CRMBW/REGION

SAP HANA VDM Field: SoldToPartyRegion

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

Distribution Channel

/CRMBW/DIS_CHA

SAP HANA VDM Field: DistributionChannel

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

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

Transaction Type

/CRMBW/PROCESS

SAP HANA VDM Field: CRMBusinessTransactionType

Characteristic Characteristic

Sold-To Party

/CRMBW/SLO_STP

SAP HANA VDM Field: SoldToParty

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

SAP HANA VDM Field: ResponsibleEmployee

Characteristic Characteristic

Division

/CRMBW/DIVISIO

SAP HANA VDM Field: Division

Characteristic Characteristic

Status

/CRMBW/SLO_STC

SAP HANA VDM Field: GeneralStatus

Characteristic Characteristic

Sales Order

/CRMBW/SLO_GUI

SAP HANA VDM Field: SalesOrder

Characteristic Characteristic

Base Unit

/CRMBW/BASE_UN

SAP HANA VDM Field: BaseUnit

Characteristic Characteristic

Sales Unit

/CRMBW/UNIT_PR

SAP HANA VDM Field: SalesQuantityUnit

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Percentage of Delivered Value

/CRMBW/PER_DEL_VAL2

Delivered Sales Order Value (/CRMBW/DEVL_VA) / Net Value CRMBW/SO_NET2)

Key Figure Key Figure

Average Sales Order Value (Document Currency)

/CRMBW/AVG_SLO_NV_DC2

Net Value (Document Currency) (/CRMBW/SO_NEDC) / Number of Sales Orders (/CRMBW/NUM_SLO)

Key Figure Key Figure

Average Sales Order Value per Item (Document Currency)

/CRMBW/AVG_SLO_VA_I2

Net Value (Document Currency) (/CRMBW/SO_NEDC) / Number of Items (/CRMBW/N_ITEM)

Key Figure Key Figure

Open Order Value (Document Currency)

/CRMBW/O_SLO_V

SAP HANA VDM Field: OpenNetAmount

Key Figure Key Figure

Delivered Order Value (Document Currency)

/CRMBW/DEVL_VA_DC2

SAP HANA VDM Field: DeliveredAmount

Key Figure Key Figure

Billed Order Value (Document Currency)

/CRMBW/BILL_VA

SAP HANA VDM Field: BilledAmount

Key Figure Key Figure

Gross Value (Document Currency)

/CRMBW/GROSS_V

SAP HANA VDM Field: GrossAmount

Key Figure Key Figure

Open Billed Value (Document Currency)

/CRMBW/O_B_VAL

SAP HANA VDM Field: OpenBilledAmount

Key Figure Key Figure

Gross Value

/CRMBW/GROVALC

SAP HANA VDM Field: GrossAmountInDisplayCurrency

Key Figure Key Figure

Net Value

/CRMBW/SO_NET2

SAP HANA VDM Field: NetAmount

Key Figure Key Figure

Net Value (Document Currency)

/CRMBW/SO_NEDC

SAP HANA VDM Field: NetAmountInDisplayCurrency

Key Figure Key Figure

Quantity

/CRMBW/QUANTIT

SAP HANA VDM Field: Quantity

Key Figure Key Figure

Billed Order Quantity

/CRMBW/BILL_QU

SAP HANA VDM Field: BilledQuantity

Key Figure Key Figure

Billed Order Value

/CRMBW/BILLV_C

SAP HANA VDM Field: BilledAmountInDisplayCurrency

Key Figure Key Figure

Delivered Order Quantity

/CRMBW/DELV_QU

SAP HANA VDM Field: DeliveredQuantity

Key Figure Key Figure

Delivered Order Value

/CRMBW/DEVL_VA

"Delivered Order Value (Document Currency)” (/CRMBW/DEVL_VA) Converted to Display Currency

Key Figure Key Figure

Open Billed Value

/CRMBW/OBILLVC

SAP HANA VDM Field: OpenBilledAmountInDisplayCrcy

Key Figure Key Figure

Open Order Quantity

/CRMBW/O_SLO_Q

SAP HANA VDM Field: OpenQuantity

Key Figure Key Figure

Open Order Value

/CRMBW/O_SLOV_V

"Open Order Value (Document Currency)” (/CRMBW/O_SLO_V) Converted to Display Currency

Key Figure Key Figure

No. of Items

/CRMBW/N_ITEM

SAP HANA VDM Field: NumberOfSalesOrderItems

Key Figure Key Figure

No. of Closed Items

/CRMBW/NOCI

SAP HANA VDM Field: NumberOfClosedSalesOrderItems

Key Figure Key Figure

No. of Sales Orders

/CRMBW/NUM_SLO

SAP HANA VDM Field: NumberOfSalesOrders

Key Figure Key Figure

No. of Back Order Items

/CRMBW/N_BITEM

SAP HANA VDM Field: NumberOfBackorderItems

Key Figure Key Figure

No. of Open Items

/CRMBW/NOOOI

SAP HANA VDM Field: NumberOfOpenSalesOrderItems

Key Figure Key Figure

Average Sales Order Value per Item

CRMBW_ASOVPI2

Total of All "Net Values”((/CRMBW/SO_NET2) / Number of Items (/CRMBW/N_ITEM)

Key Figure Key Figure

Percentage of Billed Value

/CRMBW/POBV

Billed Order Value in Display Currency (CRMBW/BILLV_C) / Net Value (CRMBW/SO_NETV)

Key Figure Key Figure

Average No. of Items per Sales Order

/CRMBW/ANOFOI

Number of Items (/CRMBW/N_ITEM) / Number of Sales Orders (/CRMBW/NUM_SLO)

Key Figure Key Figure

Average Sales Order Value

/CRMBW/ASOV

SAP HANA VDM Field: AverageNetAmountInDisplayCrcy

Key Figure Key Figure

Order Quantity in Base Unit

/CRMBW/QUANBAS

SAP HANA VDM Field: ProductQuantityInBaseUnit