Show TOC

 Opportunity Sales Order Query Locate this document in the navigation structure

 

This query view enables you to use SAP CRM master data to analyze your opportunities and sales orders. The query view is designed as an example for answering the following business questions:

  • What is the expected net amount of the opportunities and the total net amount of sales orders at the sales organization level or at the account level?

  • What is the total net amount of the sales orders for the current year and the previous year at the sales organization level or at the account level?

  • What is the net amount of opportunities for the current year at the sales organization level or at the account level?

  • What is the projected amount for the current year at the sales organization level or at the account level?

  • How many opportunities and sales orders exist at the sales organization level or at the account level?

Prerequisites

You are using an analyzing application, such as SAP BusinessObjects Analysis, Edition for Microsoft Excel, which is designed to use this query view.

You have set up a connection between your SAP CRM system and your SAP ERP system.

Structure

The structure of this view hierarchy consists of the following reuse view, which you can find in package sap.hba.x.crm:

  • Opportunity header (OpportunityHeader)

  • Opportunity (Opportunity)

The structure of this view hierarchy consists of the following reuse view, which you can find in package sap.hba.ecc:

  • Reuse view for sales order headers (SalesOrderHeader)

  • Reuse view for sales order items (SalesOrderItem)

Business Objects

This view is built on the following business object:

  • Opportunity

  • Sales Order

Attributes

Some important attributes are:

  • CRM Logical System

  • SD Logical System

  • SAP Client

  • SD SAP Client

  • Opportunity

  • Sales Order

  • Reference SD Document

  • Reference SD Document Category

  • Overall SD Process Status

  • Account

  • Account Name

  • Sales Organization

  • Sales Organization Name

  • Division

  • Division Name

  • Distribution Channel

  • Distribution Channel Name

  • Status

  • Status (Opportunity)

  • Overall SD Process Status

  • Transaction Date (int)

  • Transaction Date

  • Reporting Date (int)

  • Reporting Date

  • Year (Transaction Date)

  • Year Quarter (Transaction Date)

  • Year Quarter Name (Transaction Date)

  • Year Month (Transaction Date)

  • Year Month Name (Transaction Date)

  • Year Week (Transaction Date)

  • Year Week Name (Transaction Date)

  • Currency

  • SD Transaction Currency

  • CRM Transaction Currency

  • Year Quarter Name (Transaction Date)

  • CRM Transaction Currency

  • SD Transaction Currency

  • Transaction Currency

Measures

  • Expected Net Amount (Document Currency)

  • Expected Net Amount

  • Total Net Amount (Document Currency)

  • Total Net Amount

  • Current Year Expected Net Amount

  • Current Year Total Net Amount

  • Current Year Projection Amount

  • Last Year Total Net Amount

  • Item Expected Net Amount (Document Currency)

  • Item Expected Net Amount

  • Net Amount (Document Currency)

  • Net Amount

  • Number Of Opportunities

  • Sales Order Count

Input Parameters

  • Reporting Date (P_ReportingDate)

  • SAP Client (P_SAPClient)

  • Display Currency (P_DisplayCurrency)

  • Exchange Rate Date (P_ExchangeRateDate)

  • Exchange Rate Type (P_ExchangeRateType)

Related Virtual Data Models