Show TOC

 Credit Memo Header Query Locate this document in the navigation structure

 

This query view enables you to use SAP CRM master data to analyze your credit memo headers. The query view is designed as an example for answering the following business questions:

  • What is the header total net amount and tax amount at the sales organization level or at the account level?

  • How many credit memo headers 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.ecc:

  • Reuse view for credit memo headers (CreditMemoHeader)

Business Objects

This view is built on the following business object:

  • Credit Memo

Attributes

Some important attributes are:

  • CRM Logical System

  • SD Logical System

  • CRM SAP Client

  • SD SAP Client

  • Credit Memo

  • Credit Memo Date (int)

  • Account

  • Account Name

  • Sales Organization

  • Sales Organization Name

  • Distribution Channel

  • Distribution Channel Name

  • Division

  • Division Name

  • Country

  • Country Name

  • Region

  • Region Name

  • Year

  • Year Quarter

  • Year Quarter Name

  • Year Month

  • Year Month Name

  • Year Week

  • Year Week Name

  • Transaction Currency

  • Overall SD Process Status

Measures

  • Total Net Amount (Document Currency)

  • Total Net Amount

  • Tax Amount (Document Currency)

  • Tax Amount

  • Billing Document Count

Input Parameters

  • SAP Client (P_SAPClient)

  • Display Currency (P_DisplayCurrency)

  • Exchange Rate Date (P_ExchangeRateDate)

  • Exchange Rate Type (P_ExchangeRateType)

Related Virtual Data Models