Show TOC

 Customer Invoice Header Query Locate this document in the navigation structure

 

This query view enables you to use SAP CRM master data to analyze your customer invoice 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 customer invoice 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 customer invoice headers (CustomerInvoiceHeader)

Business Objects

This view is built on the following business object:

  • Customer Invoice

Attributes

Some important attributes are:

  • CRM Logical System

  • SD Logical System

  • CRM SAP Client

  • SD SAP Client

  • Customer Invoice

  • Customer Invoice Date (int)

  • Overall SD Process Status

  • Account

  • Account Name

  • Sales Organization

  • Sales Organization Name

  • Distribution Channel

  • Distribution Channel Name

  • Division

  • Division Name

  • Country

  • Country Name

  • Region

  • Region Name

  • Year

  • Year Month

  • Year Month Name

  • Year Week

  • Year Week Name

  • Year Quarter

  • Year Quarter Name

  • Transaction Currency

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