Kontakt

Ansicht
Dokumentation

Queries for Sales and Distribution (New) ( RELNSD_606_ANALYTICS_QUE )

Queries for Sales and Distribution (New) ( RELNSD_606_ANALYTICS_QUE )

TXBHW - Original Tax Base Amount in Local Currency   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

Short text

Queries for Sales and Distribution (New)

Use

As of SAP Enhancement Package 6 for SAP ERP 6.0 (SAP_APPL 606), Business Function Sales, Analytics 01 (LOG_SD_ANALYTICS_01), queries are available that your managers and employees in Sales and Distribution can use for local operative reporting in the ERP system.

BEx Query Designer is the application you use to create and process the queries.

  • The definition of these queries is based on search and analytics models and the Operational Data Provider (ODP) set up for them.
  • At query runtime, the system generates a TransientProvider for the integrated ODPs. You use the query to specify how the TransientProvider data is evaluated, for example by selecting characteristics and defining calculated key figures.
  • When you start a query, the system runs authorization checks in accordance with the settings in the search and analytics model. These are based on the authorization concept provided in SAP NetWeaver.
  • ABAP authorization objects are assigned to the models. At query runtime, the system compares fields in the model that are linked to a destination point attribute (for example sales organization) with the Sales and Distribution employee's authorization data.

  • So that the system automatically selects data according to user authorizations when starting a query, authorization variables are defined in the query for the corresponding attributes (for example sales organization). At query runtime, the system automatically fills the variables with the corresponding user data.
    In BEx Query Designer, all authorization variables that are defined for an InfoProvider are gathered together in a filter. You can reuse these filters when defining new queries.

You can use these queries as a template and tailor them to your enterprise-specific requirements very easily, using the functions in BEx Query Designer. You can, for example, create new views of previously defined queries.

List of Queries

The following list contains queries that evaluate data from the generated TransientProviders (with the underlying ODPs), with various objectives.

  • Sales Support
  • Quotation Tracking - 0OPS_11_ITM_Q0001

  • Quotation Pipeline - 0OPS_11_ITM_Q0015

  • Quotations: Overview - 0OPS_11_HDR_Q0002

  • Sales Order Tracking - /ERP/SD_M01_Q0001
    MultiProvider

  • Sales Values: Overview - /ERP/SD_M02_Q0001
    MultiProvider

  • Sales Pipeline - 0OPS_11_ITM_Q0014

  • Sales Performance Analysis
  • Quotation Success - 0OPS_11_ITM_Q0002

  • Sales Progress - /ERP/SD_M01_Q0003
    MultiProvider

  • Top 10 Quotations - 0OPS_11_ITM_Q0013

  • Top 10 Sales Orders - 0OPS_11_HDR_Q0007

  • Rejection Reasons in Sales Orders - 0OPS_11_ITM_Q0005

  • Rejected Sales Orders - 0OPS_11_ITM_Q0003

  • Backorder Processing - 0OPS_11_ASCL_Q0001

  • Contract Management
  • Sales Contracts: Overview - 0OPS_11_ITM_Q0018

  • Order Fulfillment
  • Top 10 Delivery Delays - 0OPS_12_ITM_Q0002

  • Fulfillment Rate - /ERP/SD_M01_Q0002
    MultiProvider

  • Deliveries: Overview - 0OPS_12_ITM_Q0001

  • Billing
  • Billing: Overview - 0OPS_13_ITM_Q0001

  • Credit Memos - 0OPS_13_ITM_Q0002

  • Returns
  • Returns: Overview - 0OPS_11_ITM_Q0007

  • Customers
  • Top 10 Customers - 0OPS_11_HDR_Q0008

  • Customers: Sales Data Overview - /ERP/SD_M01_Q0004

  • Materials
  • Top 10 Materials - /ERP/SD_M01_Q0005
    MultiProvider

For further information on the queries, refer to the query documentation.

Effects on Existing Data

Effects on Data Transfer

Effects on System Administration

Effects on Customizing

Make the settings in Customizing for Sales and Distribution, under Search and Operational Reporting:

  • Activate the objects that you want to use for analytics in the areas of Sales, Shipping, and Billing, under Start BI Content Activation Workbench.
    You can find the content in the Business Functions (03) category, in the content bundle of the business function LOG_SD_ANALYTICS_01 (business function Sales, Analytics 01).
    Note that some queries use time hierarchies that are not activated with this function. Time hierarchies must be activated directly in BEx Query Designer.
  • Activate the time hierarchies 0MON_DAY Calendar Year/Month and 0QUA_DAY Calendar Year/Quarter under Define F4 Help and Hierachies for Time Attributes/OLAP Settings.
  • You can restrict query requests using the Employee Responsible field (PZPERS field). This field references the partner role Employee Responsible (ZM for German version, ER for English version). For improved performance at query runtime, define the index update for this partner role, under Define Partner Index Update.
  • Under Business Add-Ins ( BAdIs), you can implement enterprise-specific enhancements:
  • If you want to define enterprise-specific logic for currency conversion in the delivered queries and key figures, you must implement the following Business Add-In (BAdI): Adjust Currency Conversion for Queries and Key Figures. The system determines the target currency based on the sales organization entered (statistics currency), and/or the company code (local currency).
    For more information, refer to the documentation for the queries in question.

  • If you want to include customer-specific fields in the search and analytics functions, and if you want the data to be gathered via direct access to the database in your ERP system, you must implement the Business Add-Ins (BAdIs) for adjusting the extracted data.

For more information, refer to the documentation for the activities.

Further Information

SAP Library for SAP ERP on SAP Help Portal under http://help.sap.com/erp -> ERP Central Component -> SAP ERP Enhancement Packages -> ERP Central Component Enhancement Package 6 -> SAP ERP Central Component -> Logistics -> Sales and Distribution -> Search and Analytics -> BEx Queries






PERFORM Short Reference   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 9910 Date: 20240523 Time: 080033     sap01-206 ( 125 ms )