Show TOC

 Credit Memo Item Query Locate this document in the navigation structure


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

  • What is the item net amount, tax amount, and billing quantity at the sales organization level or at the account level?

  • How many credit memo items exist at the sales organization level or at the account level?


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.


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 items (CreditMemoItem)

Business Objects

This view is built on the following business object:

  • Credit Memo


Some important attributes are:

  • CRM Logical System

  • SD Logical System

  • CRM SAP Client

  • SD SAP Client

  • Credit Memo

  • Credit Memo Item

  • Credit Memo Date (int)

  • Account

  • Account Name

  • Sales Organization

  • Sales Organization Name

  • Distribution Channel

  • Distribution Channel Name

  • Division

  • Division Name

  • Product

  • Product Name

  • Product Category

  • Product Category Name

  • Year

  • Year Quarter

  • Year Quarter Name

  • Year Month

  • Year Month Name

  • Year Week

  • Year Week Name

  • Transaction Currency

  • Base Unit

  • Quantity Unit


  • Billing Quantity

  • Billing Quantity in Base Unit

  • Item Net Amount (Document Currency)

  • Item Net Amount

  • Tax Amount (Document Currency)

  • Tax Amount

  • Billing Document Item 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