Business objects ACCOUNTS RECEIVABLE RAPID MART XI 3.2 User Manual

SAP BusinessObjects Accounts
Receivable Rapid Mart XI 3.2, version for
SAP solutions - Business Guide

Version 12.2.0.0

October 2009

Copyright

Trademarks

© Copyright 2009 SAP AG. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose

without the express permission of SAP AG. The information contained herein may be
changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary
software components of other software vendors.

All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business
ByDesign, and other SAP products and services mentioned herein as well as their respective
logos are trademarks or registered trademarks of SAP AG in Germany and other countries.

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal
Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services
mentioned herein as well as their respective logos are trademarks or registered trademarks
of Business Objects S.A. in the United States and in other countries. Business Objects is an
SAP company.

All other product and service names mentioned are the trademarks of their respective
companies. Data contained in this document serves informational purposes only. National
product specifications may vary.

These materials are subject to change without notice. These materials are provided by SAP
AG and its affiliated companies ("SAP Group") for informational purposes only, without
representation or warranty of any kind, and SAP Group shall not be liable for errors or
omissions with respect to the materials. The only warranties for SAP Group products and
services are those that are set forth in the express warranty statements accompanying such
products and services, if any. Nothing herein should be construed as constituting an
additional warranty.

Contents

Chapter 1 Introduction 7

What is a Rapid Mart? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Rapid Marts packages accelerate Time to Value . . . . . . . . . . . . . . . . . 9

SAP BusinessObjects Rapid Marts packages architecture . . . . . . . . . 10

About this document . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

Chapter 2 Overview 13

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

What you can do with this Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

Supported analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16

Related Rapid Marts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

Components shared with other SAP BusinessObjects Rapid Marts . . 20

The Rapid Mart Schema . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21

Where the Rapid Mart Fits in the Sales Cycle . . . . . . . . . . . . . . . . . . . . . . 22

Chapter 3 Subject Areas 23

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24

Customer Items Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24

Rapid Mart Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

Rapid Mart Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28

Customer Summary Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29

Rapid Mart Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31

Rapid Mart Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32

Chapter 4 Reports 35

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 5

Contents

Accounts Receivable Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37

Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37

Recommended Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57

Accounts Receivable Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59

Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .59

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74

Invalid Documents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .76

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76

SAP Master Data Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77

Data Discovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .77

Data Auditing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .90

Recommended table joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .91

6 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business

Introduction

chapter

Introduction

1

What is a Rapid Mart?

What is a Rapid Mart?

SAP BusinessObjects Rapid Marts packages are blueprints for building data
marts with SAP BusinessObjects technology:

• Data Services

• Universe Designer

• Web Intelligence.

Rapid Marts packages deliver jump-start ETL (extract, transform & load)
mappings, schema, and initial reporting content, accelerating the deployment
of BI (business intelligence) for enterprise applications from SAP, PeopleSoft,
Oracle, and Siebel.

Each Rapid Mart is designed to address the reporting needs of a specific
business area (or department) like accounting, sales, or purchasing. A
component-based framework allows conducting analysis across these
selected business areas by combining different packages within the same
source application suite.

Rapid Marts focus on basic standard configuration of the enterprise
applications. They are country and industry neutral templates meant to be
easily modified and extended to suit customer specific application
implementation and reporting needs.

Rapid Marts incorporate best practices, and provide easily modifiable
templates. With Rapid Marts total development time of a data mart solution is
greatly reduced.

Each customer situation is different. You will probably encounter one or more
of these:

• Customizations you have made to SAP solutions the Rapid Mart does not

cover.

• Standard SAP solutions data fields important for your specific business,

but not included in the Rapid Mart templates.

• Optimization and performance challenges unique to your environment.

• Reporting requirements not covered within the Rapid Mart template

reports.

Rapid Marts are flexible templates that you can adjust to account for these
unique situations. It is expected that some customization and optimization will
be needed to suit your individual environment. Rapid Marts are not an out-of­the-box solution.

8 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

BI tools and analytic tools can access Rapid Mart data through SQL queries.
Rapid Marts can be implemented individually, or in any combination, to form a
single platform that delivers the infrastructure for your company’s internal and
external information needs. They can also serve as a staging area for
enterprise analytic applications.

Rapid Marts provide your business with an accelerated time to value through
rapid BI deployments because you can implement them quickly and easily
customize them to meet specific analytic requirements.

Rapid Marts packages accelerate Time to Value

Rapid Marts are packaged data solutions that you can quickly deploy to
address specific areas of business analysis.

Available Rapid Marts packages for SAP solutions include:

Financial Suite:

• SAP BusinessObjects General Ledger Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Accounts Payable Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Accounts Receivable Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions

Operational Suite:

• SAP BusinessObjects Inventory Rapid Mart, version for SAP solutions

• SAP BusinessObjects Purchasing Rapid Mart, version for SAP solutions

• SAP BusinessObjects Sales Rapid Mart, version for SAP solutions

Manufacturing Suite:

• SAP BusinessObjects Plant Maintenance Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Production Planning Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Project System Rapid Mart, version for SAP

solutions

Human Capital Management (HCM) Suite:

• SAP BusinessObjects Human Resources Rapid Mart, version for SAP

solutions

Introduction

What is a Rapid Mart?

1

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 9

Introduction

1

What is a Rapid Mart?

You can combine multiple Rapid Marts packages into a single environment to
build the foundation for your data warehouse or use them as a staging area
for business intelligence applications.

SAP BusinessObjects Rapid Marts packages architecture

Rapid Marts architecture is driven by SAP BusinessObjects technology.
Rapid Mart Architecture:

Rapid Marts packages include the following components:

10 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Introduction

About this document

• Data Movement Jobs - packaged source-to-target mappings and data

transformations. Each job is designed to perform initial and incremental
data movement;

• Data Model & Schema - set of data mart database objects designed with

dimensional data modeling approach. Rapid Marts packages for SAP
solutions has a single integrated data model. The schema are available
for Oracle, SQL Server IBM DB2, and Teradata;

• Semantic Layer (Universes) - SAP BusinessObjects metadata packages

for efficient query generation. There can be one or more universes per
Rapid Mart. Each universe is developed using Rapid Marts design
principles to ensure compatibility, code readability, and component re­use. In addition, there is one Master universe for development/
maintenance of multiple use objects (like Customer, Material, Currency,
etc.);

• Reports (Samples) - set of 15-20 Web Intelligence reports per Rapid

Mart. They represent answers to mostly asked business questions (for
example, in the SAP BusinessObjects Sales Rapid Mart, version for SAP
solutions - 'What is the monthly Revenue trend by Division for this
year?'). The reports are developed using Rapid Mart color/layout
templates. Reports are examples of Web Intelligence best practice
development (trends, listing, guided analysis, roll ups and downs, etc.).

1

About this document

This document describes the SAP BusinessObjects Accounts Receivable
Rapid Mart XI 3.2 for SAP solutions Business Guide. This document contains
information for a variety of users—information that helps you understand the
use of the Rapid Mart, the data in the Rapid Mart, the reports you can create
with the Rapid Mart, and how to use and update the Rapid Mart.

This document contains the following chapters:

• Chapter 2: Overview — Describes the business problems you can solve

and the types of analyses you can do with this Rapid Mart

• Chapter 3: Subject Areas — Contains detailed information about each

section in the Rapid Mart, including the processes each section captures

• Chapter 4: Reports — Provides examples of reports you can produce

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 11

Introduction

1

About this document

12 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Overview

chapter

Overview

2

Overview

Overview

This chapter describes the business problems you can solve with the SAP
BusinessObjects Accounts Receivable Rapid Mart, version for SAP solutions
and the types of analyses you can do with this Rapid Mart. The information in
this chapter is useful for those who want a business-level overview of the
Rapid Mart and its benefits.

This chapter contains the following sections:

• What you can do with this Rapid Mart

• Supported analyses

• Related Rapid Marts

• The Rapid Mart Schema

• Where the Rapid Mart Fits in the Sales Cycle

What you can do with this Rapid Mart

The SAP BusinessObjects Accounts Receivable Rapid Mart, version for SAP
solutions extracts data from SAP solutions’s FI module, which covers the
financial accounting process of accounts receivable. You can use the
information that the Rapid Mart extracts to analyze your company’s accounts
receivable processes—for example, you can measure actual performance
and evaluate future external commitments for tracking and planning
purposes.

The SAP BusinessObjects Accounts Receivable Rapid Mart, version for SAP
solutions consists of two components or sections. Each section supports a
subject related to analysis of the accounts receivable process:

• Customer Items Section— Tracks customer invoices and customer

payments at a detailed, line-item level. You can roll-up the information by
various dimensions such as customer, and company,. The fact table in
this section stores data for each financial document line item.

The section stores measures in several monetary currencies including:
Transaction Currency, Local (or Company Code) Currency and Global
Currency. Additional measures include quantities ordered, invoiced,
shipped, and recorded for each financial document line item.

Reporting dimensions include customer, payment terms, posting key
type, financial document type, GL account, risk category, various
customer “blocking” codes, fiscal periods, time, company code, customer
by company, and others.

14 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Overview

What you can do with this Rapid Mart

• Customer Summary Section — Tracks customer balances. The fact

table in this section is a summary table of periodic, quarterly, and annual
customer activity totals. Stored data includes customer total debits,
credits, and sales by fiscal year and period, quarter, and year.

Additionally , the “Rolling16 Fiscal periods” A/R tot als provides a measure
of A/R activity over the last 16 periods relative to any fiscal year and fiscal
period combination. This in turn is used in the DSO (Days Sales
Outstanding) calculation.

Note: The 16 periods refer to the 12 regular periods in the fiscal year,

plus 4 special or adjustment periods used for year end reconciliation.
Use this table to analyze periodic, quarterly and yearly balances.
This section also stores measures in several monetary currencies

including: Transaction Currency, Local (or Company Code) Currency and
Global Currency.

Reporting dimensions include accounting clerk, customer, posting key
type, financial document type, risk category, various customer “blocking”
codes, fiscal periods, company code, customer by company, and others.

Chapter 3: Subject Areas discusses each of these sections in more detail and

how to link them together for a complete analysis of accounts receivable.

2

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 15

Overview

2

Supported analyses

Supported analyses

The SAP BusinessObjects Accounts Receivable Rapid Mart, version for SAP
solutions supports several types of analyses.

Business Area Type of Analyses Measures available in Rapid Mart

Accounts
Receivable Details

Discount and
Payment Trend
Analysis

Late Payment Trend
Analysis

AR Customer Item
Listing

Accounts
Receivable
Expected Cash Flow
Ranking

• Total Customer Discounts taken

• Late Payment Amount

• Discount Percentage Taken

• Total Payment Amount

• Invoice Amount

• Average Net Due Period

• Average Cash Discount

• Average Discount Period

• Amts Paid per Discount Period

All by fiscal period, quarter, year, and Company

• Amt Paid Late as Percent of Total Paid

• Avg Number of days Late

• Amount Paid Late

• Amount Paid Net

All by Company, Fiscal Periods

• Percentage Paid Late

• Percentage Past Due

• Amts Paid Late, Net, On Time, and Past Due

• Total Amts Due

• Total Tax Amount

• Number of days Open and Late

• Net Due Date

All by Customer and Company

• Future Amounts due in 4 User Defined Aging

Intervals

• Net Amount Open

• Total Amount Due

• Total Open tax Amount

• Total Tax Amount

All by Company and Customer Geography

16 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Supported analyses

Business Area Type of Analyses Measures available in Rapid Mart

Accounts
Receivable Details
(continued)

Aging of Open
(Unpaid) and Past
Due Receivables

• Amounts Open and Past Due in 4 User

Defined Aging Intervals

• Percentage of A/R balance past due

• Total Amount Due

All by Fiscal Period, Company, Customer
Geography, & Customer Industry

Aging of
Receivables Paid
Late

• Amts Paid Late in 4 User Defined Aging

Intervals

• Percentage Paid Late

• Percentage Paid Late

• Total Amt Paid Late

• Total Amt Paid

All by Customer & Geography, Company,
Industry, Fiscal Period

Open Receivables
Targeting

• Number of Days Open

• Amount Open

• Amount Due

All by Risk Category, Fiscal Period, Customer,
Top Amounts or Days overdue

Accounts
Receivable
Summary

AR Revenue Trend
Analysis & Ranking

AR Revenue Year
Trend Comparison

• Customer Revenue

• Top 10 Customer’s Revenue

By Fiscal Period, Quarter, Company, Country

• Revenue Amount

• Revenue Variance vs. Previous Fiscal Period

• Percent of variance vs. previous fiscal period

• Percent of variance vs. Avg. Annual Sales

All by Company and fiscal period,

Cumulative Trend
Vertical

• A/R Credit Balance

• A/R Debit Balances

• A/R YTD total balance

All by Company for Fiscal Period, Quarter, and
Year

Overview

2

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 17

Overview

2

Supported analyses

Business Area Type of Analyses Measures available in Rapid Mart

Accounts
Receivable
Summary
(continued)

Revenue Rolling 16
Periods versus
Period Comparison

DSO (Days Sales
Outstanding)
Analysis

360 Customer
Snapshot & Trend

• Avg. Rolling 16 Period A/R total

• Total Revenue (Sales)

• Revenue as Percent of Sales

All by Fiscal Period

• Average DSO (Days Sales Outstanding)

• A/R Balance Open

All by Company , Customer, Customer Geography
and Fiscal Period

• Credit Limit

• Credit Rating

• Last Payment Amt

• Recommended Credit Limit

• Total Sales

All by Fiscal Periods, Customer & Customer
Geography

Accounts
Receivable Audit

Customer Item
Validation

Unapplied Payment
Analysis

Audit Financial Document Dates for inaccuracies

• Unapplied Payment Amt

Financial Document Details for Payments not
applied to customer invoices

To support analysis, the Rapid Mart includes currency units, such as United
States dollars or German marks, and the quantities ordered, invoice, and
shipped. The Rapid Mart records quantities for individual financial document
line items, and for sales order line items. The Rapid Mart also includes the
total customer activity that SAP solutions collects each financial period, and a
table of daily balances.

Reporting dimensions available in the Rapid Mart include enterprise entities,
such as country, region, division, plant code, company code, and customer
data, and information specific to the SAP solutions FI module, such as
document types and status, posting keys, payment terms, and bank
information.

18 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Related Rapid Marts

Each Rapid Mart is composed of multiple components. A component is a
stand-alone work flow that completes a particular task, such as loading a
specific dimension table. Components can contain other components. A
section is a set of components that address a particular business problem or
subject area. A section is itself a component.

Components of the SAP BusinessObjects Accounts Receivable Rapid Mart,
version for SAP solutions are related to other SAP BusinessObjects Rapid
Marts components. For example:

• The customer component is used in the Sales Rapid Mart.

• Common dimensions are included in appropriate Rapid Marts.

Overview

Related Rapid Marts

2

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 19

Overview

2

Related Rapid Marts

Components shared with other SAP BusinessObjects Rapid Marts

The same components can be used in multiple Rapid Marts. For example, a
component that extracts information about materials bought, produced, and
sold is needed for a Rapid Mart that supports sales analysis and also for a
Rapid Mart that supports inventory analysis. Work flows that extract star
schema “dimensions” are components. You can add a component to any
Rapid Mart using a simple import procedure.

A Data Services job can include multiple instances of a component. For
example, each section includes all the required dimension components.
Therefore, a job with several sections may include several instances of a
particular dimension component. Components are set to execute only once
within a job. This “execute once” feature ensures that shared components do
not cause duplicate data extraction from SAP solutions. For more information
about the “execute once” feature, see the Data Integrator/Data Services
Designer Guide.

Each of the sections listed in “What you can do with this Rapid Mart” on

page 14 are considered components. You can identify a component within a

SAP BusinessObjects job by a “C_” prefix before its name. For example, the
component that tracks customer invoicing and receivable information is
named C_CustomerItems_Section.

20 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

The Rapid Mart Schema

The following diagram shows an overview of the SAP BusinessObjects
Accounts Receivable Rapid Mart, version for SAP solutions components and
their relationships.

Overview

The Rapid Mart Schema

2

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 21

Overview

Requisition Invoice PaymentQuotation

Contract

Sales

Accounts Receivable

Rapid Mart

Order

2

Where the Rapid Mart Fits in the Sales Cycle

Where the Rapid Mart Fits in the Sales Cycle

The SAP BusinessObjects Accounts Receivable Rapid Mart, version for SAP
solutions fits into the sales cycle from the time a sales order is received until
the time the customer pays for the order.

22 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Subject Areas

chapter

Subject Areas

3

Overview

Overview

Each section in the SAP BusinessObjects Accounts Receivable Rapid Mart,
version for SAP solutions pertains to a particular subject area. This chapter
describes each section and the processes each section captures.

The information in this chapter is useful for readers who use the Rapid Mart to
design and support a real-time system, such as a Web application, and need
to understand the data in the Rapid Mart and how it relates to SAP solutions.

This chapter discusses:

• Customer Items Section

• Customer Summary Section

Customer Items Section

The customer items section stores information about all customer related
documents in SAP-FI (SAP solutions Financials). These include, invoices,
credit memos, payments, etc. at a detailed line-item level.

You can roll up this information to any aggregated level supported by the
associated dimensions. The fact table for this section contains data for each
financial document line item. Specifically, the table stores monetary amounts
and quantities for each financial document line item.

SAP solutions processes vendor related financial documents and stores them
in two tables: BSID (Secondary Index for Open Customer Items) and BSAD
(Secondary Index for Cleared Customer Items). These include all customer
invoices, payments, credit memos, etc.

When an invoice or other customer document is received, SAP solutions
posts a corresponding financial document, to the BSID table. As these items
are cleared (by payment, credit memo, etc.) SAP solutions posts entries to
the BSAD table. Therefore, these two tables are the source for Customer
Items in the Rapid Mart.

If the clearing procedure is separate from the invoice receipt procedure, SAP
solutions keeps the payment and the invoice open until it posts the clearing.
Thus, until the clearing procedure is complete you may have unapplied
payments (or credits). When clearing an item, SAP solutions updates the item
with the date and document number of the payment document (or the
financial document that cleared the item).

24 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

The Customer Items section loads data into fact table
CUSTOMER_ITEM_FACT. This fact table contains data from the vendor
related financial document line items (tables BSID and BSAD in SAP
solutions).

The Accounts Receivable Rapid Mart calculates past due amounts, amounts
paid on time, amounts paid late, amounts due in the future, and other
measures from the SAP solutions source tables.

There is also a database view based on CUSTOMER_ITEM_FACT (called
CUSTOMER_ITEM_AR_BALANCE_VIEW). The view is used in the DSO
calculation.

Additionally, any records with containing dates before the year 1900 are
loaded into the CUSTOMER_ITEM_FACT_BAD table. We reject these
records because a date before the year 1900 is legal in SAP solutions but not
in the Microsoft SQL-Server database, and would otherwise cause an error.

Rapid Mart Processing

Customer Items data is stored in the CUSTOMER_ITEM_FACT table of the
target database. Additionally this section captures the following dimensional
attributes and their associated dimension tables

Subject Areas

Customer Items Section

3

Attribute Name Dimension Table(s)

Accounting Clerk ACCOUNTING_CLERK
Aging Interval AGING_INTERVAL
Business Area BUSINESS_AREA
Chart Of Accounts CHART_OF_ACCOUNTS
Company Code COMPANY_CODE
Credit Control Area CREDIT_CONTROL_AREA
Currency CURRENCY
Currency Conversion Rate CURRENCY_CONVERT_RATE
Customer CUSTOMER
Customer By Company CUSTOMER_BY_COMPANY
Debit Credit Indicator DEBIT_CREDIT_INDICATOR
Document Type DOCUMENT_TYPE &

DOCUMENT_CATEGORY
Fiscal Period FISC_PERIOD
GL Account By Company GL_ACCOUNT_BY_COMPANY

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 25

Subject Areas

3

Customer Items Section

Fact Table Fields

Attribute Name Dimension Table(s)

Monetary Currency CURRENCY
Payment Block PAYMENT_BLOCK
Payment Reason Code PAYMENT_REASON_CODE
Payment Terms PAYMENT_TERM
Posting Key Type POSTING_KEY_TYPE
Special GL Indicator SPECIAL_GL_INDICATOR
Time Dimension TIME_DIM, TIME_DIM_WEEKLY

The Customer Items table (CUSTOMER_ITEM_FACT) contains the following
measures

Note: Suffixes indicate the monetary currency of the measure.

• LOC - Local or Company Currency

• TRX - Transaction or Document Currency

• UPDT - Update Currency

Note: Intervals “A” through “G” are user definable aging periods set up in the

Data Services job
At the universe level, we use the currency conversion rates to obtain

measures in a user-defined global currency.

Column Name Description

AMT_DISCNT_TAKEN_LOC Discount amount taken
AMT_DUE_IN_E_DAYS_LOC Amount due in interval “E” days in

local (company) currency

AMT_DUE_IN_F_DAYS_LOC Amount due in interval “F” days in

local (company) currency

AMT_DUE_IN_G_DAYS_LOC Amount due in interval “G” days in

local (company) currency

AMT_DUE_OVER_G_DA YS_LOC Amount due in more than interval “G”

days in local (company) currency

AMT_ELIGBL_FOR_DISCNT_TRX Amount of invoice that can be

discounted as appropriate

AMT_LOC Amount in local (company) currency

26 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Subject Areas

Customer Items Section

Column Name Description

AMT_PAID_DISCNT_PER01_LOC Local currency amount paid during

the first discount period (includes any

discounts applicable)
AMT_PAID_DISCNT_PER02_LOC Local currency amount paid after the

first and during the second discount

period (includes any discounts

applicable)
AMT_PAID_LATE_LOC Paid after due date
AMT_PAID_NET_LOC Local currency amount paid before

due date and after any discount

periods (includes only non-time-

related discounts)
AMT_PAID_ON_TIME_LOC Local currency amount paid by due

date (includes any discounts

applicable)
AMT_PAST_DUE_GT_A_LOC Local currency amount past due

more than interval “A” days
AMT_PAST_DUE_GT_B_LOC Local currency amount past due

more than interval “B” days
AMT_PAST_DUE_GT_C_LOC Local currency amount past due

more than interval “C” days
AMT_PAST_DUE_GT_D_LOC Local currency amount past due

more than interval “D” days
AMT_PD_GT_A_LATE_LOC Local currency amount paid more

than interval “A” days late
AMT_PD_GT_B_LATE_LOC Local currency amount paid more

than interval “B” days late
AMT_PD_GT_C_LATE_LOC Local currency amount paid more

than interval “C” days late
AMT_PD_GT_D_LATE_LOC Local currency amount paid more

than interval “D” days late
AMT_TAX_LOC Tax amount in local (company)

currency
AMT_TAX_TRX Tax amount in document

(transaction) currency
AMT_TRX Amount in document (Transaction)

currency

3

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 27

Subject Areas

3

Customer Items Section

Rapid Mart Data

Column Name Description

AMT_TTL_PAST_DUE_LOC Total Amount Past Due in local

(Company) currency
AMT_UPDT Update Currency Amt.
AMT_WEIGHT_P AST_DUE_LOC Total Amt. Past Due times Number of

Days Past Due

The Customer Items section includes customer transaction detail. The
CUSTOMER_ITEM_FACT table stores these details.
CUSTOMER_ITEM_FACT table and associated dimension tables are
organized as a star schema as shown below

You can analyze Vendor Items along several dimensions:

• Accounting Clerk

• Aging Interval - user definable A/P Aging Intervals

• Business Area

• Company

28 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Subject Areas

Customer Summary Section

• Currency Conversion Rates

• Monetary Currency

• Payment Block

• Payment Reason

• Fiscal Periods

• Time - By posting date and document creation dates

• Customer by Company - A snowflaked dimension that cross-references

Customer with Company

• Customer

• Debit / Credit Indicator

• Special GL Indicator

• Payment Terms

• Document Type - Financial Document Type

• GL Account by Company - Also a snowflaked dimension. Includes both

the regular and “special” GL account numbers from SAP solutions, cross­referenced by Company Code

• Posting Key

For the customer items section, typical queries include:

• “What is a current snapshot of my Accounts Receivables?”

• “Which fiscal periods show the slowest payment rates?”

• “Which customers are blocked for delivery?”

• “Which customers should I focus on to reduce the aging receivables?”

• “Do my best paying customers have the most favorable credit limit?”

• “Are my customers taking advantage of discounts offered on payment

terms to pay early?”

• “Are my customers trending towards earlier or later payments?”

• “What are my top 25 open invoices (by invoice value)?”

• “Which customer payments or credit memos have not been applied to an

outstanding receivable?”

3

Customer Summary Section

The customer totals section of this Rapid Mart stores customer balances. The
two fact tables for this section summarizes yearly, periodic, and quarterly
customer activity totals.

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 29

Subject Areas

3

Customer Summary Section

Information includes customer total debits, credits, and sales by fiscal year,
quarter, and period. The data is organized into two fact tables.

The first, carries the data in horizontal
each combination of customer, company code, and fiscal year. This mimics
the organization of the source SAP solutions table (KNC1 - Customer
Transaction Figures). There are separate fields for debits, credits, and sales
figures for each fiscal period in the fiscal year. This includes the 12 regular
fiscal periods supported by SAP solutions, as well as the 4 “special”
adjustment periods for a total of 16 fiscal periods. It also includes aggregated
debit, credit and sales figures for each of the 4 quarters of the fiscal year , and
aggregated debit, credit, and sales figures for the year to date.

The second fact table, carries data in a vertical
for each customer, company code, fiscal year, and fiscal period
The vertical table includes the same debit, credit, and sales figures as the
horizontal table. It also includes additional fields for the DSO calculation:

format with one row of information for

format. That is one row of data

combination.

• Rolling 16 Fiscal Periods Total: (the 4 Special Fiscal Periods are

included)

• Period To Date Balance

• Period Beginning Balance

The Customer Summary section stores information in two fact tables:

• CUSTOMER_SUMMARY_FACT_HZ — The horizontal summary table

that contains periodic and quarterly vendor activity totals. The table
stores total vendor debits, credits, and purchases by fiscal year.

• CUSTOMER_SUMMARY_FACT_VR — The vertical summary table that

contains the periodic and quarterly vendor activity totals. The table stores
total vendor debits, credits, and purchases by fiscal year, and fiscal
period.

There is also a staging table CUSTOMER_SUMMARY_STAGE_VR that is
used to transform the horizontal format into the vertical one. You can do
ongoing daily customer balance analyses with this data. The KNC1 table is
updated constantly by SAP solutions as transactions occur. Therefore each
daily refresh of the Rapid Mart will provide a daily snapshot of changes to the
customer balances.

30 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Rapid Mart Processing

The Customer Summary section captures the following dimensional
attributes, and their associated dimension tables

Attribute Name Dimension Table(s)

Aging Interval AGING_INTERVAL
Company Code COMPANY_CODE
Credit Control Area CREDIT_CONTROL_AREA
Currency CURRENCY
Currency CURRENCY
Currency Conversion Rate CURRENCY_CONVERT_RATE
Customer CUSTOMER
Customer By Company CUSTOMER_BY_COMPANY
Fiscal Period FISC_PERIOD
Time Dimension TIME_DIM, TIME_DIM_WEEKLY

Fact Table Fields

The Customer Summary tables (CUSTOMER_SUMMARY_FACT_HZ &
CUSTOMER_SUMMARY_FACT_VR) contain the following measures

Note: At the universe level, we use the currency conversion rates to obtain

measures in a user-defined global currency.

CUSTOMER_SUMMARY_FACT_HZ:

Subject Areas

Customer Summary Section

3

Measure Definition

AMT_CR_PER01_LOC ­AMT_CR_PER16_LOC

AMT_CR_QTR01_LOC ­AMT_CR_QTR04_LOC

AMT_CR_YTD_LOC Total of the credit postings for the

AMT_DR_PER01_LOC ­AMT_DR_PER16_LOC

AMT_DR_QTR01_LOC ­AMT_DR_QTR04_LOC

AMT_DR_YTD_LOC T otal of the debit postings for the year

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 31

Total Credit Postings for the fiscal
period (1 - 16)

Total Credit Postings for the quarter
(1 - 4)

year to date
Total Debit Postings for the fiscal

period (1 - 16)
T ot al Debit Postings for the quarter (1

- 4)

to date

Subject Areas

3

Customer Summary Section

Measure Definition

AMT_PER_BEGIN_LOC Balance carried forward in local cur-

rency
AMT_SALES_PER01_LOC -

AMT_SALES_PER16_LOC
AMT_SALES_QTR01_LOC -

AMT_SALES_QTR04_LOC
AMT_SALES_YTD_LOC Total of the sales postings for the

CUSTOMER_SUMMARY_FACT_VR:

Measure Definition

AMT_CR_LOC Total Credit Postings for the Fisc.

AMT_DR_LOC Total Debit Postings for the Fisc.

AMT_PER_BEGIN_LOC Balance carried forward in local cur-

AMT_PER_ROLLING_LOC Rolling 16 Periods Total
AMT_PTD_LOC Period To Date Balance
AMT_SALES_LOC Total Sales Postings for the Fisc.

Total Sales Postings for the fiscal

period (1 - 16)

Total Sales Postings for the quarter

(1 - 4)

year to date

period

period

rency for the Fisc. Period

period

Rapid Mart Data

The Customer Summary is organized as a Star Schema as shown below
You can analyze Customer summary data along several dimensions

including:

• Accounting Clerk

• Aging Intervals (Aging Time Periods)

• Billing Block

• Company

• Credit Control Area

• Currency Exchange Rates - used to convert from local currency to global

currency

• Customer

32 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Subject Areas

Customer Summary Section

3

• Customer by Company - this is a snow-flaked dimension with subsidiary

dimensions

• Fiscal Periods

• Monetary Currency - including local (company code) currency , and global

currency

For the customer totals section, typical queries include:

• “What is the monetary value locked up in DSO (days sales outstanding)

by customer, or company?”

• “Which customers have the worst/best DSO?”

• “What are my revenue trends?”

• “Are my late payments trending up or down?”

• “Can you give me a ‘snapshot’ of how a specific customer is doing?”

• “How is cumulative A/R activity trending by fiscal period?”

• “How does current period revenue compare to the last 12 months?”

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 33

Subject Areas

3

Customer Summary Section

34 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

chapter

Reports

4

Overview

Overview

You can use the SAP BusinessObjects Accounts Receivable Rapid Mart,
version for SAP solutions to perform ad hoc analysis and produce many kinds
of reports. This chapter provides examples of reports you could generate
using the SAP Accounts Receivable universe. The information in this chapter
is useful for those who design reporting solutions for

Accounts Payable module of SAP solutions.

This chapter provides reports and the recommended joins for each
componentized section in the Rapid Mart including:

analysis of data in the

• Accounts Receivable Details (Customer Items)

• Accounts Receivable Summary (Customer Summary)

• Invalid Documents

• SAP Master Data Reports

Note that all report SQL is located in the Rapid Mart installation directory
under "\Sample\DML".

36 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Accounts Receivable Details

Accounts Receivable Details tracks customer invoices and customer
payments at a line-item level. These correspond to the Customer Items
subject area in the Universe. These details can be analyzed by various
dimensions including, customer and company. The fact table in this section
stores data for each financial document line item.

Reports

This Rapid Mart comes with several reports providing accounts receivable
detail analysis for discount and late payments trends, late payment trends,
AR Customer Item Listing, expected cash flow ranking, receivables aging,
and more. There are 11 template reports included with this Rapid Mart,
including:

• Discount and Payment Trend Analysis

• Discount Trend Analysis

• Late Payment Trend Analysis

• AR Customer Item Listing

• Accounts Receivable Expected Cash Flow Ranking

• Aging Receivables Ranking

• Receivable Amounts Past Due Aging

• Receivables Paid Late Ranking

• Receivables Paid Late Trend Analysis

• Open Receivables Targeting

• Unapplied Payment Analysis

Reports

Accounts Receivable Details

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 37

Reports

4

Accounts Receivable Details

Discount and Payment Trend Analysis

View Discounts and Payments trend analysis for a selected Company Code
and Fiscal Year-Period range.

This report contains two tabs, by Period and by Quarter to analyze discount
and payment trends by different period calendar dimensions.

Calculations

• Invoice Amount =[GC Amt Paid Net]+[GC Discount Amt Taken]

• Amount Paid Discount =[GC Amt Paid Discount1]+[GC Amt Paid

Discount2]

• Discount % Taken =If([Invoice Amount] <> 0; [GC Discount Amt Taken]/

([Invoice Amount]); 0)

Report SQL

SELECT DISTINCT
CUSTOMER_ITEM_FACT.CASH_DISCNT_PRCNT_01,
CUSTOMER_ITEM_FACT.CURR_ID_GBL,
PAYMENT_TERM.PAYMNT_TERM_DESCR,
SUM(CUSTOMER_ITEM_FACT.AMT_PAID_NET_LOC *

CURRENCY_CONVERT_RATE.EXCH_RATE /
CURRENCY_CONVERT_RATE.FROM_FACTOR /
CURRENCY_CONVERT_RATE.TO_FACTOR),

38 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

Accounts Receivable Details

SUM(CUSTOMER_ITEM_FACT.AMT_PAID_LATE_LOC *

CURRENCY_CONVERT_RATE.EXCH_RATE /
CURRENCY_CONVERT_RATE.FROM_FACTOR /
CURRENCY_CONVERT_RATE.TO_FACTOR),

SUM(CUSTOMER_ITEM_FACT.AMT_PAID_DISCNT_PER01_LOC *

CURRENCY_CONVERT_RATE.EXCH_RATE /
CURRENCY_CONVERT_RATE.FROM_FACTOR /
CURRENCY_CONVERT_RATE.TO_FACTOR),

SUM(CUSTOMER_ITEM_FACT.AMT_PAID_DISCNT_PER02_LOC *

CURRENCY_CONVERT_RATE.EXCH_RATE /
CURRENCY_CONVERT_RATE.FROM_FACTOR /
CURRENCY_CONVERT_RATE.TO_FACTOR),

SUM(CUSTOMER_ITEM_FACT.AMT_DISCNT_TAKEN_LOC *

CURRENCY_CONVERT_RATE.EXCH_RATE /
CURRENCY_CONVERT_RATE.FROM_FACTOR /

CURRENCY_CONVERT_RATE.TO_FACTOR),
FISC_PERIOD.FISC_YEAR,
FISC_PERIOD.FISC_YEAR_PERIOD,
FISC_PERIOD.FISC_YEAR_QUARTER,
COMPANY_CODE.CMPNY_CODE_ID,
COMPANY_CODE.CMPNY_CODE_NAME
FROM
CUSTOMER_ITEM_FACT,
PAYMENT_TERM,
CURRENCY_CONVERT_RATE,
FISC_PERIOD,
COMPANY_CODE
WHERE
( CUSTOMER_ITEM_FACT .CMPNY_CODE_ID =

COMPANY_CODE.CMPNY_CODE_ID )
AND (

CUSTOMER_ITEM_FACT.PAYMNT_TERM_ID=PAYMENT_TERM.PAYMNT_

TERM_ID AND
PAYMENT_TERM.P AYMNT_TERM_DAY_LIMIT = '?' )
AND ( CUSTOMER_ITEM_FACT.FISC_YEAR=FISC_PERIOD.FISC_YEAR and

CUSTOMER_ITEM_FACT.FISC_PERIOD=FISC_PERIOD.FISC_PERIOD and

CUSTOMER_ITEM_FACT.FISC_YR_VARIANT_ID=FISC_PERIOD.FISC_YR_

VAR IA NT _I D )
AND ( CUSTOMER_ITEM_F ACT.EXCH_TYPE_ID_GBL =

CURRENCY_CONVERT_RATE.EXCH_TYPE_ID AND
CUSTOMER_ITEM_FACT.CURR_ID_LOC =

CURRENCY_CONVERT_RATE.CURR_ID_FROM AND
CUSTOMER_ITEM_FACT.CURR_ID_GBL =

CURRENCY_CONVERT_RATE.CURR_ID_TO AND
CUSTOMER_ITEM_FACT.POST_DATE >=

CURRENCY_CONVERT_RATE.VALID_FROM_DATE AND
CUSTOMER_ITEM_FACT.POST_DATE <

CURRENCY_CONVERT_RATE.VALID_TO_DATE )
AND
FISC_PERIOD.FISC_YEAR_PERIOD BETWEEN '2000-P07' AND '2001-P07'
GROUP BY
CUSTOMER_ITEM_FACT.CASH_DISCNT_PRCNT_01,
CUSTOMER_ITEM_FACT.CURR_ID_GBL,
PAYMENT_TERM.PAYMNT_TERM_DESCR,
FISC_PERIOD.FISC_YEAR,
FISC_PERIOD.FISC_YEAR_PERIOD,

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 39

Reports

4

Accounts Receivable Details

FISC_PERIOD.FISC_YEAR_QUARTER,
COMPANY_CODE.CMPNY_CODE_ID,
COMPANY_CODE.CMPNY_CODE_NAME

40 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Discount Trend Analysis

View Discount trends for all Company Codes given the selected Fiscal Year­Period range. There are two tabs in this report, Overall and by Company.

Overall

View Discount % Year-Period trend for the selected Year-Period range. Also
view discount 1 and discount 2 information by Fiscal Year- Quarter.

Reports

Accounts Receivable Details

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 41

Reports

4

Accounts Receivable Details

by Company

View comparison of discount information by Company for the selected Fiscal
Year-Period range.

Calculations

• Discount % Taken = If([GC Amt Paid Net] <> 0; [GC Discount Amt T aken]/

[GC Amt Paid Net]; 0)

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML"

42 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Late Payment Trend Analysis

View Late Payment trends for all Company Codes over the selected Fiscal
Year-Period range. The report shows late payment trends by Fiscal Year­Period as well as Fiscal Year-Quarter (both in two separate tabs).

There is a hyperlink on GC Amt Paid Late for each Fiscal Y ear-Period to allow
users to drill to 360 Customer Snapshot for more details.

Reports

Accounts Receivable Details

4

Calculations

• % Paid Late = If([GC Amt Paid Net] <> 0; [GC Amt Paid Late]/[GC Amt

Paid Net]; 0)

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML"

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 43

Reports

4

Accounts Receivable Details

AR Customer Item Listing

View financial documents listing for the selected Company Code and list of
Customers. View AR document listing, Open Documents, and Cleared
Documents. The report uses an alert to display Financial Doc Id in red font
when Amount Past Due does not equal zero.

AR Document Listing

View listing of all documents for the Company and Customers.

44 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

Accounts Receivable Details

Open Documents

This report tab limits the document listing to all Open documents using a
report level filter of Cleared Flag = ‘O - Open’ and Financial Doc Id Is not null.

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 45

Reports

4

Accounts Receivable Details

Cleared Documents

This report tab limits the document listing to all Open documents using a
report level filter of Cleared Flag = ‘C - Cleared’.

Calculations

• % Paid Late =If([LC Total Amount Due] <> 0; [LC Amt Paid Late]/[LC

Total Amount Due]; 0)

• % Past Due = =If([LC Total Amount Due] <> 0; [LC Amt Past Due]/[LC

Total Amount Due]; 0)

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML"

46 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Accounts Receivable Expected Cash Flow Ranking

View snapshot of AR expected cash flow (or aging amounts due) on open
documents for all Company Codes. This report contains two tabs: Overall and
by Customer Geography.

Reports

Accounts Receivable Details

4

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML"

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 47

Reports

4

Accounts Receivable Details

Aging Receivables Ranking

AR Aging Receivables Ranking provides a snapshot of receivables amounts
past due across all Company Codes. This report contains two tabs: Overall
and by Company Code and Customer Industry.

Overall

View AR aging by Company Name.

48 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

by Company Code and Customer Industry

View AR aging by Customer Industry.

Reports

Accounts Receivable Details

4

Calculations

• % AR Past Due =If([GC Total Amount Due] <> 0; [GC Amt Past Due]/[GC

Total Amount Due]; 0)

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML"

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 49

Reports

4

Accounts Receivable Details

Receivable Amounts Past Due Aging

View all invoices with receivables amounts past due. Aging analysis in this
case is based on terms defined 31-60 days, 61-90 days, 91-120 days, and
121+ days. This report contains two tabs: by Company Code and by
Customer Geography.

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML"

50 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Receivables Paid Late Ranking

View amounts paid late for all Company Codes over a selected Fiscal Year­Period range. Analyze amounts paid late in the following age bands: 31-60
days, 61-90 days, 91-120 days, and 121+ days. This report contains two tabs:
by Company Code and by Customer Geography.

Reports

Accounts Receivable Details

4

Calculations

• % Paid Late =If([GC Amt Paid Net] <>0; [GC Amt Paid Late]/[GC Amt

Paid Net]; 0)

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML"

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 51

Reports

4

Accounts Receivable Details

Receivables Paid Late Trend Analysis

View trends of AR amounts paid late all Company Codes over a selected
Fiscal Year-Period range. This report has two tabs to analyze the data by
Company Code and Top 25 Customers for each Company.

By Company

View receivables paid late trend for the selected Fiscal Year-Period range.

52 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

Accounts Receivable Details

Top 25 Late Customers

View Top 25 Late Customers according to GC Amt Paid Late for each
Company Code.This report tab uses the Webi report ranking feature for the
top 25 analysis. It is easily customizable to allow for Top X customer
categories.

4

Calculations

• % Paid Late = If([GC Amt Paid Net] <>0; [GC Amt Paid Late]/[GC Amt

Paid Net]; 0)

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML"

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 53

Reports

4

Accounts Receivable Details

Open Receivables Targeting

View all open receivables invoices for selected Company Codes and
Accounting Clerks. This report has two report tabs for Top 25 Invoices by
Amount Remaining and Top 25 Invoices by Age. The report uses the Webi
report ranking feature for the top 25 analysis. It is easily customizable to allow
for Top X invoices.

Top 25 Invoices by Amount Remaining

View Top 25 invoices based on Amount Remaining.

54 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Top 25 Invoices by Age

View Top 25 invoices based on number of days open.

Reports

Accounts Receivable Details

4

Calculations

• # Days = Sum([Number Days Open])

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML"

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 55

Reports

4

Accounts Receivable Details

Unapplied Payment Analysis

View a listing of all unapplied payments - all financial documents for payme nts
not applied to customer invoices.

Summary

View listing of all unapplied payments.

Details by Customer

View details of all unapplied payments with a break by Customer.

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

56 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

Accounts Receivable Details

Recommended Joins

To analyze Accounts Receivable Detail data you will need to create joins between
the fact and dimension tables as follows

Note: Additional joins between dimension and hierarchy tables are shown in

“Recommended table joins” on page 27 for master reports.

Fact Table Dimension Table Join Text

CUSTOMER_ITEM_FACT ACCOUNTING_CLERK CUSTOMER_ITEM_FACT.CMPNY_CODE_ID=ACCO

CUSTOMER_ITEM_FACT AGING_INTERVAL AGING_INTERVAL.AGING_INTERVAL_ID=CUSTOME

CUSTOMER_ITEM_FACT BUSINESS_AREA CUSTOMER_ITEM_FACT.BUS_AREA_ID=BUSINESS

CUSTOMER_ITEM_FACT CHART_OF_ACCOUNTSCUSTOMER_ITEM_FACT.CHART_OF_ACCT_ID=CH

CUSTOMER_ITEM_FACT COMPANY_CODE CUSTOMER_ITEM_FACT.CMPNY_CODE_ID =

CUSTOMER_ITEM_FACT CREDIT_CONTROL_A

CUSTOMER_ITEM_FACT CURRENCY CURRENCY.CURR_ID =

CUSTOMER_ITEM_FACT CURRENCY CURRENCY.CURR_ID=CUSTOMER_ITEM_FACT.CU

CUSTOMER_ITEM_FACT CURRENCY CURRENCY.CURR_ID =

CUSTOMER_ITEM_FACT CURRENCY CURRENCY.CURR_ID=CUSTOMER_ITEM_FACT.CU

CUSTOMER_ITEM_FACT CURRENCY_CONVER

CUSTOMER_ITEM_FACT CUSTOMER CUSTOMER_ITEM_FACT.CUSTOMER_ID =

CUSTOMER_ITEM_FACT CUSTOMER_BY_COM

REA

T_RATE

PANY

UNTING_CLERK.CMPNY_CODE_ID and
CUSTOMER_ITEM_FACT.ACCTNG_CLERK_ID=ACC
OUNTING_CLERK.ACCTNG_CLERK_ID

R_ITEM_FACT.AGING_INTERVAL_ID

_AREA.BUS_AREA_ID

ART_OF_ACCOUNTS.CHART_OF_ACCT_ID

COMPANY_CODE.CMPNY_CODE_ID
CUSTOMER_ITEM_FACT.CR_CTRL_AREA_ID=CRE

DIT_CONTROL_AREA.CR_CTRL_AREA_ID

CUSTOMER_ITEM_FACT.CURR_ID_TRX

RR_ID_GBL

CUSTOMER_ITEM_FACT.CURR_ID_UPDT

RR_ID_LOC
CUSTOMER_ITEM_FACT.EXCH_TYPE_ID_GBL =

CURRENCY_CONVERT_RATE.EXCH_TYPE_ID AND
CUSTOMER_ITEM_FACT.CURR_ID_LOC =
CURRENCY_CONVERT_RATE.CURR_ID_FROM
AND CUSTOMER_ITEM_FACT.CURR_ID_GBL =
CURRENCY_CONVERT_RATE.CURR_ID_TO AND
CUSTOMER_ITEM_FACT.POST_DATE >=
CURRENCY_CONVERT_RATE.VALID_FROM_DATE
AND CUSTOMER_ITEM_FACT.POST_DATE <
CURRENCY_CONVERT_RATE.VALID_TO_DATE

CUSTOMER.CUSTOMER_ID
CUSTOMER_ITEM_FACT.CMPNY_CODE_ID=CUSTO

MER_BY_COMPANY.CMPNY_CODE_ID and
CUSTOMER_ITEM_FACT.CUSTOMER_ID=CUSTOM
ER_BY_COMPANY.CUSTOMER_ID

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 57

Reports

4

Accounts Receivable Details

Fact Table Dimension Table Join Text

CUSTOMER_ITEM_FACT DEBIT_CREDIT_INDIC

CUSTOMER_ITEM_FACT DOCUMENT_TYPE CUSTOMER_ITEM_FACT.DOC_TYPE_ID=DOCUMEN

CUSTOMER_ITEM_FACT FISC_PERIOD CUSTOMER_ITEM_FACT.FISC_YEAR=FISC_PERIO

CUSTOMER_ITEM_FACT GL_ACCOUNT_BY_C

CUSTOMER_ITEM_FACT GL_ACCOUNT_BY_C

CUSTOMER_ITEM_FACT PAYMENT_BLOCK CUSTOMER_ITEM_FACT.PAYMNT_BLOCK_ID=PAY

CUSTOMER_ITEM_FACT PAYMENT_REASON_

CUSTOMER_ITEM_FACT PAYMENT_TERM CUSTOMER_ITEM_FACT.PAYMNT_TERM_ID=PAYM

CUSTOMER_ITEM_FACT POSTING_KEY_TYPE CUSTOMER_ITEM_FACT.POST_KEY_ID=POSTING_

CUSTOMER_ITEM_FACT SPECIAL_GL_INDICATORCUSTOMER_ITEM_FACT.SPECL_GL_ID=SPECIAL_

CUSTOMER_ITEM_FACT TIME_DIM TIME_DIM.CALENDAR_DATE=CUSTOMER_ITEM_FA

CUSTOMER_ITEM_FACT TIME_DIM TIME_DIM.CALENDAR_DATE=CUSTOMER_ITEM_FA

ATOR

OMPANY

OMPANY

CODE

CUSTOMER_ITEM_FACT.DR_CR_ID=DEBIT_CREDI
T_INDICATOR.DR_CR_ID AND
DEBIT_CREDIT_INDICATOR.DIM_SRC_ID =
'FINANCIAL'

T_TYPE.DOC_TYPE_ID and
DOCUMENT_TYPE.DOC_CATEG_ID = 'FINANCIAL'
and DOCUMENT_TYPE.DIM_SRC_ID = 'FINANCIAL'

D.FISC_YEAR and
CUSTOMER_ITEM_FACT.FISC_PERIOD=FISC_PERI
OD.FISC_PERIOD and
CUSTOMER_ITEM_FACT.FISC_YR_VARIANT_ID=FIS
C_PERIOD.FISC_YR_VARIANT_ID

CUSTOMER_ITEM_FACT.CMPNY_CODE_ID=GL_AC
COUNT_BY_COMPANY.CMPNY_CODE_ID and
CUSTOMER_ITEM_FACT.CHART_OF_ACCT_ID=GL_
ACCOUNT_BY_COMPANY .CHAR T_OF_ACCT_ID and
CUSTOMER_ITEM_FACT.GL_ACCT_ID=GL_ACCOU
NT_BY_COMPANY.GL_ACCT_ID

CUSTOMER_ITEM_FACT.CMPNY_CODE_ID=GL_AC
COUNT_BY_COMPANY.CMPNY_CODE_ID and
CUSTOMER_ITEM_FACT.CHART_OF_ACCT_ID=GL_
ACCOUNT_BY_COMPANY .CHAR T_OF_ACCT_ID and
CUSTOMER_ITEM_FACT.GL_ACCT_ID_SPECL=GL_
ACCOUNT_BY_COMPANY.GL_ACCT_ID

MENT_BLOCK.PAYMNT_BLOCK_ID
CUSTOMER_ITEM_FACT.CMPNY_CODE_ID =

PAYMENT_REASON_CODE.CMPNY_CODE_ID and
PAYMENT_REASON_CODE.PAYMNT_REASON_CO
DE_ID =
CUSTOMER_ITEM_FACT.PAYMNT_REASON_CODE
_ID

ENT_TERM.PAYMNT_TERM_ID AND
PAYMENT_TERM.PAYMNT_TERM_DAY_LIMIT = '?'

KEY_TYPE.POST_KEY_ID and
CUSTOMER_ITEM_FACT.SPECL_GL_ID=POSTING_
KEY_TYPE.SPECL_GL_ID

GL_INDICATOR.SPECL_GL_ID AND
SPECIAL_GL_INDICATOR.ACCT_TYPE_ID = 'D'

CT.POST_DATE

CT.DOC_DATE

58 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Accounts Receivable Summary

Accounts Receivable Summary is used to analyze periodic, quarterly, and
yearly balances. These correspond to the Customer Summary Subject Area
in the Universe. The fact table in this section is a summary table of periodic,
quarterly, and annual customer activity totals. Data stored includes customer
total debits, credits, and sales by fiscal year-period, quarter, and year.

Additionally, the “Rolling Fiscal periods” A/R tot als provides a measure of A/R
activity over the last 16 periods (12 regular and 4 adjustment periods) relative
to any fiscal year and fiscal period combination.

Reports

Accounts receivable summary allows for a variety of trend and high level
analysis, including:

• AR Revenue Trend Analysis

• Top 10 Customer AR Revenue Analysis

• AR Revenue Year Trend Comparison

• Cumulative AR Activity Period Trend

• Revenue Rolling 16 Periods versus Period Comparison

• DSO Analysis

• 360 Customer Snapshot

• 360 Customer Trend

Reports

Accounts Receivable Summary

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 59

Reports

4

Accounts Receivable Summary

AR Revenue Trend Analysis

View revenue trends for selected Fiscal Year-Period range for all Company
Codes. This report has two tabs to allow for trend analysis by Period and by
Quarter.

Report SQL

SELECT DISTINCT
FISC_PERIOD.FISC_PERIOD,
FISC_PERIOD.FISC_QUARTER,
FISC_PERIOD.FISC_YEAR,
FISC_PERIOD.FISC_YEAR_PERIOD,
FISC_PERIOD.FISC_YEAR_QUARTER,
CUSTOMER_SUMMARY_FACT_VR.CURR_ID_GBL,
SUM(CUSTOMER_SUMMARY_FACT_VR.AMT_SALES_LOC *

CURRENCY_CONVERT_RATE.EXCH_RATE /
CURRENCY_CONVERT_RATE.FROM_FACTOR /

CURRENCY_CONVERT_RATE.TO_FACTOR),
COMPANY_CODE.COUNTRY_NAME,
COMPANY_CODE.CMPNY_CODE_NAME
FROM
FISC_PERIOD,
CUSTOMER_SUMMARY_FACT_VR,
CURRENCY_CONVERT_RATE,
COMPANY_CODE

60 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

Accounts Receivable Summary

WHERE
( CUSTOMER_SUMMARY_FACT_VR.FISC_YEAR=FISC_PERIOD.FISC_YEAR

and
CUSTOMER_SUMMARY_FACT_VR.FISC_PERIOD=FISC_PERIOD.FISC_PER
IOD and
CUSTOMER_SUMMARY_FACT_VR.FISC_YR_VARIANT_ID=FISC_PERIOD.
FISC_YR_VARIANT_ID )

AND ( CUSTOMER_SUMMARY_FACT_VR.CMPNY_CODE_ID =

COMPANY_CODE.CMPNY_CODE_ID )

AND ( CUSTOMER_SUMMARY_FACT_VR.EXCH_TYPE_ID_GBL =

CURRENCY_CONVERT_RATE.EXCH_TYPE_ID AND

CUSTOMER_SUMMARY_FACT_VR.CURR_ID_LOC =

CURRENCY_CONVERT_RATE.CURR_ID_FROM AND

CUSTOMER_SUMMARY_FACT_VR.CURR_ID_GBL =

CURRENCY_CONVERT_RATE.CURR_ID_TO AND

CUSTOMER_SUMMARY_FACT_VR.CREATE_DATE >=

CURRENCY_CONVERT_RATE.VALID_FROM_DATE AND

CUSTOMER_SUMMARY_FACT_VR.CREATE_DATE <

CURRENCY_CONVERT_RATE.VALID_TO_DATE )

AND ( CUSTOMER_SUMMARY_FACT_VR.FISC_YEAR =

CUSTOMER_SUMMARY_FACT_VR.PARTITION_YEAR )
AND
FISC_PERIOD.FISC_YEAR_PERIOD BETWEEN '2001-P01' AND '2001-P15'
GROUP BY
FISC_PERIOD.FISC_PERIOD,
FISC_PERIOD.FISC_QUARTER,
FISC_PERIOD.FISC_YEAR,
FISC_PERIOD.FISC_YEAR_PERIOD,
FISC_PERIOD.FISC_YEAR_QUARTER,
CUSTOMER_SUMMARY_FACT_VR.CURR_ID_GBL,
COMPANY_CODE.COUNTRY_NAME,
COMPANY_CODE.CMPNY_CODE_NAME

4

Top 10 Customer AR Revenue Analysis

View top 10 customers by revenue amount for selected fiscal years.The
report uses the Webi report ranking feature for the top 10 analysis. It is easily
customizable to allow for Top X sales.

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 61

Reports

4

Accounts Receivable Summary

Top 10 Sales Overall

View top 10 Sales according to revenue (LC Sales Ttl).

62 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

Accounts Receivable Summary

Top10 Sales - by Fiscal Year

View top 10 Sales according to revenue (LC Sales Ttl) for each Fiscal Year.

4

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 63

Reports

4

Accounts Receivable Summary

AR Revenue Year Trend Comparison

View revenue trend by period for selected Fiscal Years. Compare Total
Amounts, Variance Amount versus Previous Period, Variance % Against
Previous Period, and V ariance % against Average. There are four tabs in this
report to analyze revenue year trends: Total Amount, Variance Amount vs
Previous Period, Variance % against Previous Period, and Variance %
Previous Period against Average.

Total Amount

View GC Period Sales Total amounts for each period.

64 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

Accounts Receivable Summary

Variance Amount vs Previous Period

View variance amounts for each period compared to the previous period.

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 65

Reports

4

Accounts Receivable Summary

Variance % against Previous Period

View variance percentages for each period compared to the previous period.

66 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

Accounts Receivable Summary

Variance % Previous Period against Average

View variance percentages for the period compared to the average sales
total.

4

Calculations

• Average GC Sales Ttl =([GC Per 01 Sales Ttl]+ [GC Per 02 Sales

Ttl]+[GC Per 03 Sales Ttl]+[GC Per 04 Sales Ttl]+[GC Per 05 Sales

Ttl]+[GC Per 06 Sales Ttl]+[GC Per 07 Sales Ttl]+[GC Per 08 Sales

Ttl]+[GC Per 09 Sales Ttl]+[GC Per 10 Sales Ttl]+[GC Per 11 Sales

Ttl]+[GC Per 12 Sales Ttl])/12

• Variance Amount vs Previous Period (Example):

=[GC Per 02 Sales Ttl]-[GC Per 01 Sales Ttl]

• Variance % vs Previous Period (Example):

=If([GC Per 02 Sales Ttl] <> 0; Abs(100*([GC Per 02 Sales Ttl]-[GC Per

01 Sales Ttl])/[GC Per 02 Sales Ttl]); 0)

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 67

Reports

4

Accounts Receivable Summary

• Variance % Previous Period vs Average (Example):

=If([GC Per 02 Sales Ttl] <> 0; Abs(100*([GC Per 02 Sales Ttl]-[GC Per
01 Sales Ttl])/[Average GC Sales Ttl]); 0)

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

Cumulative AR Activity Period Trend

View trend of YTD Balance totals for a selected Fiscal Year-Period range.

Calculations

• YTD Balance =[GC Period Begin Balance]+[GC Debit Ttl]-[GC Credit Ttl]

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

68 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Accounts Receivable Summary

Revenue Rolling 16 Periods versus Period Comparison

View comparison of Average Rolling 16 Revenue Total versus Period
Revenue for a specified Fiscal Year-Period range.

Reports

4

Calculations

• Revenue % =If([GC Avg Rolling Ttl] <> 0;Abs([GC Sales Ttl]/[GC Avg

Rolling Ttl]); 0)

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 69

Reports

4

Accounts Receivable Summary

DSO Analysis

View snapshot of DSO (Days Sales Outstanding) ranking snapshot by
Company Code. The report has three tabs: Overall, Top 10 DSO by
Customer, and Top 10 DSO by Customer (Geography). The report uses the
Webi report ranking feature for the top 10 analysis. It is easily customizable to
allow for Top X sales.

Overall

View overall DSO by Company.

70 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Top 10 DSO by Customer

View Top 10 DSO by Customer Name.

Top 10 DSO by Customer (Geography)

View Top 10 DSO by Customer Geography.

Reports

Accounts Receivable Summary

4

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 71

Reports

4

Accounts Receivable Summary

360 Customer Snapshot

View overview of customer credit, geography, and summary of invoice and
payments for a selected Company Code, Fiscal Year-Period range, and
single or multiple Customers. There are two hyperlinks to allow users to drill
to the 360 Customer Trend report for either a single customer or for all
customers chosen in this 360 Customer Snapshot report.

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

72 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

360 Customer Trend

View trends of original invoice amounts for selected Company Code, Fiscal
Year-Period range, and single or multiple customers.

This report contains a hyperlink to AR Customer Item Listing to allow for
drilling into an item listing for the selected customer.

Reports

Accounts Receivable Summary

4

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 73

Reports

4

Accounts Receivable Summary

Recommended Table Joins

To analyze Accounts Receivable Summary data you will need to create joins
between the fact and dimension tables as follows

Note: Additional joins between dimension and hierarchy tables are shown in

“Recommended table joins” on page 27 for master reports

Fact Table Dimension Table Join Text

CUSTOMER_SUMMARY
_FACT_HZ

CUSTOMER_SUMMARY
_FACT_HZ

CUSTOMER_SUMMARY
_FACT_HZ

CUSTOMER_SUMMARY
_FACT_HZ

CUSTOMER_SUMMARY
_FACT_HZ

CUSTOMER_SUMMARY
_FACT_HZ

CUSTOMER_SUMMARY
_FACT_HZ

CUSTOMER_SUMMARY
_FACT_HZ

CUSTOMER_SUMMARY
_FACT_HZ

CUSTOMER_SUMMARY
_FACT_HZ

CUSTOMER_SUMMARY
_FACT_VR

CUSTOMER_SUMMARY
_FACT_VR

CUSTOMER_SUMMARY
_FACT_VR

CUSTOMER_SUMMARY
_FACT_VR

CUSTOMER_SUMMARY
_FACT_VR

AGING_INTERVAL AGING_INTERVAL.AGING_INTERVAL_ID=CUSTOMER_S

COMPANY_CODE CUSTOMER_SUMMARY_FACT_HZ.CMPNY_CODE_ID =

CREDIT_CONTROL

_AREA

CURRENCY CURRENCY.CURR_ID=CUSTOMER_SUMMARY_FACT_H

CURRENCY CURRENCY.CURR_ID=CUSTOMER_SUMMARY_FACT_H

CURRENCY_CONV

ERT_RATE

CUSTOMER CUSTOMER_SUMMARY_FACT_HZ.CUSTOMER_ID =

CUSTOMER_BY_C

OMPANY

CUSTOMER_SUM

MARY_FACT_HZ

TIME_DIM TIME_DIM.CALENDAR_DATE=CUSTOMER_SUMMARY_F

AGING_INTERVAL AGING_INTERVAL.AGING_INTERVAL_ID=CUSTOMER_S

COMPANY_CODE CUSTOMER_SUMMARY_FACT_VR.CMPNY_CODE_ID =

CREDIT_CONTROL

_AREA

CURRENCY CURRENCY.CURR_ID=CUSTOMER_SUMMARY_FACT_V

CURRENCY CURRENCY.CURR_ID=CUSTOMER_SUMMARY_FACT_V

.

UMMARY_FACT_HZ.AGING_INTERVAL_ID

COMPANY_CODE.CMPNY_CODE_ID
CUSTOMER_SUMMARY_FACT_HZ.CR_CTRL_AREA_ID=

CREDIT_CONTROL_AREA.CR_CTRL_AREA_ID

Z.CURR_ID_GBL

Z.CURR_ID_LOC
CUSTOMER_SUMMARY_FACT_HZ.EXCH_TYPE_ID_GBL

= CURRENCY_CONVERT_RATE.EXCH_TYPE_ID AND
CUSTOMER_SUMMARY_FACT_HZ.CURR_ID_LOC =
CURRENCY_CONVERT_RATE.CURR_ID_FROM AND
CUSTOMER_SUMMARY_FACT_HZ.CURR_ID_GBL =
CURRENCY_CONVERT_RATE.CURR_ID_TO AND
CUSTOMER_SUMMARY_FACT_HZ.CREATE_DATE >=
CURRENCY_CONVERT_RATE.VALID_FROM_DATE AND
CUSTOMER_SUMMARY_FACT_HZ.CREATE_DATE <
CURRENCY_CONVERT_RATE.VALID_TO_DATE

CUSTOMER.CUSTOMER_ID
CUSTOMER_SUMMARY_FACT_HZ.CMPNY_CODE_ID=C

USTOMER_BY_COMPANY.CMPNY_CODE_ID and
CUSTOMER_SUMMARY_FACT_HZ.CUSTOMER_ID=CUS
TOMER_BY_COMPANY.CUSTOMER_ID

CUSTOMER_SUMMARY_FACT_HZ.FISC_YEAR =
CUSTOMER_SUMMARY_FACT_HZ.PARTITION_YEAR

ACT_HZ.CREATE_DATE

UMMARY_FACT_VR.AGING_INTERVAL_ID

COMPANY_CODE.CMPNY_CODE_ID
CUSTOMER_SUMMARY_FACT_VR.CR_CTRL_AREA_ID=

CREDIT_CONTROL_AREA.CR_CTRL_AREA_ID

R.CURR_ID_GBL

R.CURR_ID_LOC

74 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Fact Table Dimension Table Join Text

CUSTOMER_SUMMARY
_FACT_VR

CUSTOMER_SUMMARY
_FACT_VR

CUSTOMER_SUMMARY
_FACT_VR

CUSTOMER_SUMMARY
_FACT_VR

CUSTOMER_SUMMARY
_FACT_VR

CUSTOMER_SUMMARY
_FACT_VR

CUSTOMER_SUMMARY
_FACT_VR

CURRENCY_CONV
ERT_RATE

CUSTOMER CUSTOMER_SUMMARY_FACT_VR.CUSTOMER_ID =

CUSTOMER_BY_C
OMPANY

CUSTOMER_ITEM_
AR_BALANCE_VIE
W

CUSTOMER_SUM
MARY_FACT_VR

FISC_PERIOD CUSTOMER_SUMMARY_FACT_VR.FISC_YEAR=FISC_P

TIME_DIM TIME_DIM.CALENDAR_DATE=CUSTOMER_SUMMARY_F

CUSTOMER_SUMMARY_FACT_VR.EXCH_TYPE_ID_GBL
= CURRENCY_CONVERT_RATE.EXCH_TYPE_ID AND
CUSTOMER_SUMMARY_FACT_VR.CURR_ID_LOC =
CURRENCY_CONVERT_RATE.CURR_ID_FROM AND
CUSTOMER_SUMMARY_FACT_VR.CURR_ID_GBL =
CURRENCY_CONVERT_RATE.CURR_ID_TO AND
CUSTOMER_SUMMARY_FACT_VR.CREATE_DATE >=
CURRENCY_CONVERT_RATE.VALID_FROM_DATE AND
CUSTOMER_SUMMARY_FACT_VR.CREATE_DATE <
CURRENCY_CONVERT_RATE.VALID_TO_DATE

CUSTOMER.CUSTOMER_ID
CUSTOMER_SUMMARY_FACT_VR.CMPNY_CODE_ID=C

USTOMER_BY_COMPANY.CMPNY_CODE_ID and
CUSTOMER_SUMMARY_FACT_VR.CUSTOMER_ID=CUS
TOMER_BY_COMPANY.CUSTOMER_ID

CUSTOMER_ITEM_AR_BALANCE_VIEW.CUSTOMER_ID
=CUSTOMER_SUMMARY_FACT_VR.CUSTOMER_ID and
CUSTOMER_ITEM_AR_BALANCE_VIEW.FISC_YEAR=CU
STOMER_SUMMARY_FACT_VR.FISC_YEAR and
CUSTOMER_ITEM_AR_BALANCE_VIEW.CMPNY_CODE_
ID=CUSTOMER_SUMMARY_FACT_VR.CMPNY_CODE_I
D and
CUSTOMER_ITEM_AR_BALANCE_VIEW.FISC_PERIOD=
CUSTOMER_SUMMARY_FACT_VR.FISC_PERIOD

CUSTOMER_SUMMARY_FACT_VR.FISC_YEAR =
CUSTOMER_SUMMARY_FACT_VR.PARTITION_YEAR

ERIOD.FISC_YEAR and
CUSTOMER_SUMMARY_FACT_VR.FISC_PERIOD=FISC
_PERIOD.FISC_PERIOD and
CUSTOMER_SUMMARY_FACT_VR.FISC_YR_VARIANT_I
D=FISC_PERIOD.FISC_YR_VARIANT_ID

ACT_VR.CREATE_DATE

Reports

Accounts Receivable Summary

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 75

Reports

4

Invalid Documents

Invalid Documents

This Rapid Mart comes with a single invalid document table called

CUSTOMER_ITEM_FACT_BAD. Upon running the Rapid Mart load, data is

loaded into this table where there are issues with financial document dates.
You have the ability to report on this table via the Universe.

Customer Item Validation

View Invalid Customer Item records identified during Rapid Mart load. These
records are identified as those financial document with inaccurate dates.

Report SQL

SELECT DISTINCT
CUST_ITEMS_FACT_BAD.ALLOC_ID,
CUST_ITEMS_FACT_BAD.BASELINE_DATE,
CUST_ITEMS_FACT_BAD.CLEARING_DOC_ID,
CUST_ITEMS_FACT_BAD.CLEARED_ON,
CUST_ITEMS_FACT_BAD.CUSTOMER_ID,
CUST_ITEMS_FACT_BAD.DI_ERRORACTION,
CUST_ITEMS_FACT_BAD.DI_ERRORCOLUMNS,
CUST_ITEMS_FACT_BAD.DOCUMENT_DATE,
CUST_ITEMS_FACT_BAD.ENTRY_DATE,
CUST_ITEMS_FACT_BAD.FINANCIAL_DOC_ID,
CUST_ITEMS_FACT_BAD.FISCAL_YEAR,
CUST_ITEMS_FACT_BAD.LINE_ITEM_ID,
CUST_ITEMS_FACT_BAD.LOAD_DATE,
CUST_ITEMS_FACT_BAD.LOAD_TIME,
CUST_ITEMS_FACT_BAD.NET_DUE_DATE,
CUST_ITEMS_FACT_BAD.POSTING_DATE,
CUST_ITEMS_FACT_BAD.SPECIAL_GL_IND,
CUST_ITEMS_FACT_BAD.SPECIAL_GL_TTYPE,
CUST_ITEMS_FACT_BAD.COMPANY_CODE_ID
FROM
CUST_ITEMS_FACT_BAD

Recommended Table Joins

Invalid record tables do not join to other tables.

76 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

SAP Master Data Reports

SAP Master Data reports provide a tool for Data Discovery and Data Auditing.
These reports are used by all Rapid Marts in the SAP BusinessObjects Rapid
Mart Suite for SAP.

Note: This universe only includes joins for hierarchy dimensions. No other

joins are provided as they are specific to each Rapid Mart. Recommended

table joins contains a complete list of joins provided in the SAP Master Data

universe.

Data Discovery

These reports allow users to view hierarchy data. The full breadth of the data
can be ascertained and used to make informed decisions when designing a
report for any given subject area. The reports are:

• Activity Hierarchy Data Discovery

• Cost Center Hierarchy Data Discovery

• Profit Center Hierarchy Data Discovery

• Cost Element Hierarchy Data Discovery

• Internal Order Hierarchy Data Discovery

• Functional Area Hierarchy Data Discovery

• GL Account Hierarchy Data Discovery

• FS Account Hierarchy Data Discovery

• Project Element Hierarchy Data Discovery

• Equipment Hierarchy Data Discovery

• Functional Location Hierarchy Data Discovery

• Work Center Hierarchy Data Discovery

• BOM Hierarchy Data Discovery

• Organization Unit Data Discovery

• Position Data Discovery

Reports

SAP Master Data Reports

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 77

Reports

4

SAP Master Data Reports

Activity Hierarchy Data Discovery

View Activity Hierarchies for a specified Controlling Area, Parent Activity, and
Activity Hierarchy.

Report SQL

SELECT DISTINCT
ACTIVITY_HIER_HR.ACTIVITY_ID,
ACTIVITY_HIER_HR.CTRL_AREA_ID,
ACTIVITY_HIER_HR.LEAF_LEVEL,
ACTIVITY_HIER_HR.LEVEL_0_FULLNAME,
ACTIVITY_HIER_HR.LEVEL_1_FULLNAME,
ACTIVITY_HIER_HR.LEVEL_2_FULLNAME,
ACTIVITY_HIER_HR.LEVEL_3_FULLNAME,
ACTIVITY_HIER_HR.LEVEL_4_FULLNAME,
ACTIVITY_HIER_HR.LEVEL_5_FULLNAME,
ACTIVITY_HIER_HR.LEVEL_6_FULLNAME,
ACTIVITY_HIER_HR.LEVEL_7_FULLNAME
FROM
ACTIVITY_HIER_HR,
ACTIVITY_HIER_VR,
ACTIVITY
WHERE
( ACTIVITY.CTRL_AREA_ID = ACTIVITY_HIER_VR.CTRL_AREA_ID and
ACTIVITY.ACTIVITY_ID = ACTIVITY_HIER_VR.DESCENDANT_ID )
AND ( ACTIVITY.CTRL_AREA_ID=ACTIVITY_HIER_HR.CTRL_AREA_ID and

ACTIVITY.ACTIVITY_ID=ACTIVITY_HIER_HR.ACTIVITY_ID )

AND

78 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

(
( ACTIVITY_HIER_VR.ANCESTOR_ID in ('A1') AND

ACTIVITY_HIER_HR.LEVEL_0_ID in ('A1') )
AND
ACTIVITY_HIER_HR.CTRL_AREA_ID = '1000'
AND
ACTIVITY_HIER_HR.CTRL_AREA_ID <> '?'
AND
ACTIVITY_HIER_HR.LEVEL_0_ID <> '?'
)

Cost Center Hierarchy Data Discovery

View Cost Center Hierarchies for a specified Controlling Area, Parent Cost
Center, and Cost Center Hierarchy.

Reports

SAP Master Data Reports

4

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 79

Reports

4

SAP Master Data Reports

Profit Center Hierarchy Data Discovery

View Profit Center Hierarchies for a specified Controlling Area, Parent Profit
Center(s), and Profit Center Hierarchy (or Hierarchies).

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

Cost Element Hierarchy Data Discovery

View Cost Element Hierarchies for a specified Chart of Accounts, Parent Cost
Element, and Cost Element Hierarchy.

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

80 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Internal Order Hierarchy Data Discovery

View Internal Order Hierarchies for a specified Controlling Area, Parent
Internal Order, and Internal Order Hierarchy.

Reports

SAP Master Data Reports

4

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 81

Reports

4

SAP Master Data Reports

Functional Area Hierarchy Data Discovery

View Functional Area Hierarchies for a specified Parent Functional Area and
Functional Area Hierarchy.

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

82 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

GL Account Hierarchy Data Discovery

View GL Account, Profit Center GL Account, and Financial Statement (FS)
Hierarchies for a specified Chart of Accounts, Parent GL Account, and GL
Account Hierarchy.

This report uses a prompt to indicate which type of financial hierarchy should
be analyzed:

• GL Account Hierarchy = @GL

• Profit Center GL Account Hierarchy = @PC

• FS Hierarchy = code of the financial statement (ex: CAUS)

Reports

SAP Master Data Reports

4

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 83

Reports

4

SAP Master Data Reports

FS Account Hierarchy Data Discovery

View account information for a specified Chart of Accounts and FS Account
hierarchy, along with account ranges, credit and debit flags, and account full
names.

Report SQL

SELECT DISTINCT
GL_ACCOUNT_HIER_HZ.LEVEL_0_FULLNAME,
GL_ACCOUNT_HIER_HZ.LEVEL_1_FULLNAME,
GL_ACCOUNT_HIER_HZ.LEVEL_2_FULLNAME,

84 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

SAP Master Data Reports

GL_ACCOUNT_HIER_HZ.LEVEL_3_FULLNAME,
GL_ACCOUNT_HIER_HZ.LEVEL_4_FULLNAME,
GL_ACCOUNT_HIER_HZ.LEVEL_5_FULLNAME,
GL_ACCOUNT_HIER_HZ.LEVEL_6_FULLNAME,
GL_ACCOUNT_HIER_HZ.LEVEL_7_FULLNAME,
FS_HIERARCHY_DISCOVERY_HZ.CREDIT_FLAG,
FS_HIERARCHY_DISCOVERY_HZ.DEBIT_FLAG,
FS_HIERARCHY_DISCOVERY_HZ.LOWER_ACCT_LIMIT,
FS_HIERARCHY_DISCOVERY_HZ.UPPER_ACCT_LIMIT,
GL_ACCOUNT_DISCOVERY_HZ.LEAF_FLAG,
GL_ACCOUNT_DISCOVERY_HZ.HIERARCHY_NAME
FROM
GL_ACCOUNT_HIER_HZ,
FS_HIERARCHY FS_HIERARCHY_DISCOVERY_HZ,
GL_ACCOUNT_HIER GL_ACCOUNT_DISCOVERY_HZ,
GL_ACCOUNT_MASTER
WHERE
(

GL_ACCOUNT_MASTER.CHART_OF_ACCTS_ID=GL_ACCOUNT_HIER_HZ.

CHART_OF_ACCTS_ID and

GL_ACCOUNT_MASTER.GL_ACCOUNT_ID=GL_ACCOUNT_HIER_HZ.CUR

RENT_LEAF AND
GL_ACCOUNT_MASTER.HIERARCHY_NAME in ('ACCOUNT','CAUS')
AND GL_ACCOUNT_HIER_HZ.HIERARCHY_NAME = 'CAUS' )
AND (

GL_ACCOUNT_HIER_HZ.HIERARCHY_NAME=GL_ACCOUNT_DISCOVER

Y_HZ.HIERARCHY_NAME and

GL_ACCOUNT_HIER_HZ.CHART_OF_ACCTS_ID=GL_ACCOUNT_DISCOVE

RY_HZ.CHART_OF_ACCTS_ID and

GL_ACCOUNT_HIER_HZ.CURRENT_LEAF=GL_ACCOUNT_DISCOVERY_H

Z.CHILD_ID )
AND (

GL_ACCOUNT_HIER_HZ.CHART_OF_ACCTS_ID=FS_HIERARCHY_DISCO

VERY_HZ.CHART_OF_ACCTS_ID and

GL_ACCOUNT_HIER_HZ.HIERARCHY_NAME=FS_HIERARCHY_DISCOVE

RY_HZ.FS_VERSION_ID and

GL_ACCOUNT_HIER_HZ.CURRENT_LEAF=FS_HIERARCHY_DISCOVERY_

HZ.CHILD_ID )
AND
(
GL_ACCOUNT_HIER_HZ.CHART_OF_ACCTS_ID = 'CAUS'
AND
( GL_ACCOUNT_MASTER.HIERARCHY_NAME NOT IN ( '@PC', '@GL') )
AND
GL_ACCOUNT_HIER_HZ.LEVEL_2_ID <>

GL_ACCOUNT_HIER_HZ.LEVEL_1_ID
AND
GL_ACCOUNT_HIER_HZ.LEVEL_3_ID <>

GL_ACCOUNT_HIER_HZ.LEVEL_2_ID
AND
GL_ACCOUNT_HIER_HZ.LEVEL_4_ID <>

GL_ACCOUNT_HIER_HZ.LEVEL_3_ID
AND
GL_ACCOUNT_HIER_HZ.LEVEL_5_ID <>

GL_ACCOUNT_HIER_HZ.LEVEL_4_ID
)

Reports

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 85

Reports

4

SAP Master Data Reports

Project Element Hierarchy Data Discovery

View Project Element Hierarchies for a specified Parent Project Element and
Project Element Hierarchy.

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

Equipment Hierarchy Data Discovery

View Equipment Hierarchies for a specified Parent Equipment and Equipment
Hierarchy.

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

86 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Functional Location Hierarchy Data Discovery

View Functional Location Hierarchies for a specified Parent Functional
Location and Functional Location Hierarchy.

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

Work Center Hierarchy Data Discovery

View Work Center Hierarchies for a specified Parent Work Center and Work
Center Hierarchy.

Reports

SAP Master Data Reports

4

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 87

Reports

4

SAP Master Data Reports

BOM Hierarchy Data Discovery

View BOM Hierarchies for a specified BOM Id and Parent BOM Hierarchy.

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

88 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Organization Unit Data Discovery

View Organization Unit Hierarchies for a specified Parent Organization
Unit(s).

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

Reports

SAP Master Data Reports

4

Position Data Discovery

View Position Hierarchies for the specified Parent Position(s).

Report SQL

All report SQL is located in the Rapid Mart installation directory under
"\Sample\DML".

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 89

Reports

4

SAP Master Data Reports

Data Auditing

These reports allow users to view hierarchy data records that have failed
validation in Data Services. This enables correction of the data in the SAP
solutions source system.

Nine data auditing reports are included with the SAP Master Data universe.
These reports display data in validation tables as follows:

Report Name Invalid Data Table

Invalid Cost Center Hierarchy COST_CENTER_HIER_BAD

Invalid Activity Hierarchy ACTIVITY_HIER_BAD
Invalid Cost Element Hierarchy COST_ELEMENT_HIER_BAD
Invalid Functional Area Hierarchy FUNCTIONAL_AREA_HIER_BAD
Invalid GL Account Hierarchy GL_ACCOUNT_HIER_BAD
Invalid Internal Order Hierarchy INTERNAL_ORDER_HIER_BAD
Invalid Profit Center Hierarchy PROFIT_CENTER_HIER_BAD
Invalid Project Element Hierarchy PROJECT_ELEMENT_HIER_BAD
Invalid Work Center Hierarchy WORK_CENTER_HIER_BAD

All data auditing reports are all similar in structure. Invalid Cost Center
Hierarchy is show below as an example of the hierarchy data auditing reports.

Invalid Cost Center Hierarchy

Show Cost Center Hierarchy records that have failed validation in Data
Services.

Report SQL

SELECT DISTINCT
COST_CNTR_HIER_BAD.PARENT_ID,
COST_CNTR_HIER_BAD.PARENT_DESC,
COST_CNTR_HIER_BAD.CTRL_AREA_ID,
COST_CNTR_HIER_BAD.CHILD_ID,

90 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

SAP Master Data Reports

COST_CNTR_HIER_BAD.CHILD_DESC,
COST_CNTR_HIER_BAD.DI_ERRORACTION,
COST_CNTR_HIER_BAD.DI_ERRORCOLUMNS,
COST_CNTR_HIER_BAD.LEAF_FLAG,
COST_CNTR_HIER_BAD.LOAD_DATE,
COST_CNTR_HIER_BAD.LOAD_TIME,
COST_CNTR_HIER_BAD.ROOT_FLAG
FROM
COST_CNTR_HIER_BAD

Recommended table joins

When analyzing data hierarchy data, you need to create joins between the
dimension table and the hierarchy tables in the Rapid Mart. The following
shows joins provided in the SAP Master Data universe.

Dimension Table Hierarchy Table Join Text

ACTIVITY ACTIVITY_HIER_HZ ACTIVITY.CTRL_AREA_ID=ACTIVITY_HIER_H

ACTIVITY ACTIVITY_HIER_VR ACTIVITY.CTRL_AREA_ID =

BILL_OF_MATERIALS BILL_OF_MATERIALS_HIE

BILL_OF_MATERIALS BILL_OF_MATERIALS_HIE

COST_CENTER COST_CENTER_HIER_HZ COST_CENTER.CTRL_AREA_ID=COST_CENT

R_HZ

R_VR

Z.CTRL_AREA_ID and
ACTIVITY.ACTIVIT Y_ID=ACTIVITY_HIER_HZ.A
CTIVITY_ID

ACTIVITY_HIER_VR.CTRL_AREA_ID and
ACTIVITY.ACTIVIT Y_ID =
ACTIVITY_HIER_VR.CHILD_ID

BILL_OF_MATERIALS.BOM_CATEG_ID=BILL_
OF_MATERIALS_HIER_HZ.BOM_CATEG_ID
and
BILL_OF_MATERIALS.BOM_ID=BILL_OF_MAT
ERIALS_HIER_HZ.BOM_ID and
BILL_OF_MATERIALS.ALT_BOM_ID=BILL_OF_
MATERIALS_HIER_HZ.ALT_BOM_ID and
BILL_OF_MATERIALS.BOM_NODE_ID=BILL_O
F_MATERIALS_HIER_HZ.BOM_NODE_ID

BILL_OF_MATERIALS.BOM_CATEG_ID=BILL_
OF_MATERIALS_HIER_VR.BOM_CATEG_ID
and
BILL_OF_MATERIALS.BOM_ID=BILL_OF_MAT
ERIALS_HIER_VR.BOM_ID and
BILL_OF_MATERIALS.ALT_BOM_ID=BILL_OF_
MATERIALS_HIER_VR.ALT_BOM_ID and
BILL_OF_MATERIALS.BOM_NODE_ID=BILL_O
F_MATERIALS_HIER_VR.CHILD_ID

ER_HIER_HZ.CTRL_AREA_ID and
COST_CENTER.COST_CNTR_ID=COST_CEN
TER_HIER_HZ.COST_CNTR_ID

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 91

Reports

4

SAP Master Data Reports

Dimension Table Hierarchy Table Join Text

COST_CENTER COST_CENTER_HIER_VR COST_CENTER.CTRL_AREA_ID=COST_CENT

COST_ELEMENT COST_ELEMENT_HIER_HZCOST_ELEMENT.COST_ELEM_ID=COST_ELE

COST_ELEMENT COST_ELEMENT_HIER_VRCOST_ELEMENT.CHART_OF_ACCT_ID=COST

COUNTRY_GROUP COUNTRY_GROUP_STATUSCOUNTRY_GROUP.COUNTRY_GRP_ID =

EQUIPMENT EQUIPMENT_HIER_HZ EQUIPMENT.EQUIPMNT_ID=EQUIPMENT_HIE

EQUIPMENT EQUIPMENT_HIER_VR EQUIPMENT.EQUIPMNT_ID=EQUIPMENT_HIE

FS_HIERARCHY GL_ACCOUNT_HIER_HZ GL_ACCOUNT_HIER_HZ.CHART_OF_ACCT_I

FS_HIERARCHY GL_ACCOUNT_HIER_VR GL_ACCOUNT_HIER_VR.CHART_OF_ACCT_I

FUNCTIONAL_AREA FUNCTIONAL_AREA_HIER

FUNCTIONAL_AREA FUNCTIONAL_AREA_HIER

FUNCTIONAL_LOCATION FUNCTIONAL_LOCATION_

FUNCTIONAL_LOCATION FUNCTIONAL_LOCATION_

GL_ACCOUNT_HIER GL_ACCOUNT_HIER_HZ GL_ACCOUNT_HIER_HZ.HIER_ID=GL_ACCO

_HZ

_VR

HIER_HZ

HIER_VR

ER_HIER_VR.CTRL_AREA_ID and
COST_CENTER.COST_CNTR_ID=COST_CEN
TER_HIER_VR.CHILD_ID

MENT_HIER_HZ.COST_ELEM_ID and
COST_ELEMENT.CHART_OF_ACCT_ID=COST
_ELEMENT_HIER_HZ.CHART_OF_ACCT_ID

_ELEMENT_HIER_VR.CHART_OF_ACCT_ID
and
COST_ELEMENT.COST_ELEM_ID=COST_ELE
MENT_HIER_VR.CHILD_ID

COUNTRY_GROUP_STATUS.COUNTRY_GRP
_ID

R_HZ.EQUIPMNT_ID

R_VR.CHILD_ID

D=FS_HIERARCHY.CHART_OF_ACCT_ID and
GL_ACCOUNT_HIER_HZ.HIER_ID=FS_HIERA
RCHY.FS_VERSION_ID and
GL_ACCOUNT_HIER_HZ.GL_ACCT_ID=FS_HI
ERARCHY.CHILD_ID

D=FS_HIERARCHY.CHART_OF_ACCT_ID and
GL_ACCOUNT_HIER_VR.HIER_ID=FS_HIERA
RCHY.FS_VERSION_ID and
GL_ACCOUNT_HIER_VR.CHILD_ID=FS_HIER
ARCHY.CHILD_ID

FUNCTIONAL_AREA.FUNCTNL_AREA_ID=FU
NCTIONAL_AREA_HIER_HZ.FUNCTNL_AREA
_ID

FUNCTIONAL_AREA.FUNCTNL_AREA_ID=FU
NCTIONAL_AREA_HIER_VR.CHILD_ID

FUNCTIONAL_LOCATION.FUNCTNL_LOCATN
_ID=FUNCTIONAL_LOCATION_HIER_HZ.FUN
CTNL_LOCATN_ID

FUNCTIONAL_LOCATION.FUNCTNL_LOCATN
_ID=FUNCTIONAL_LOCATION_HIER_VR.CHIL
D_ID

UNT_HIER.HIER_ID and
GL_ACCOUNT_HIER_HZ.CHART_OF_ACCT_I
D=GL_ACCOUNT_HIER.CHART_OF_ACCT_ID
and
GL_ACCOUNT_HIER_HZ.GL_ACCT_ID=GL_A
CCOUNT_HIER.CHILD_ID

92 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide

Reports

SAP Master Data Reports

Dimension Table Hierarchy Table Join Text

GL_ACCOUNT_HIER GL_ACCOUNT_HIER_VR GL_ACCOUNT_HIER_VR.HIER_ID=GL_ACCO

GL_ACCOUNT_MASTER GL_ACCOUNT_HIER_HZ GL_ACCOUNT_MASTER.CHART_OF_ACCT_I

GL_ACCOUNT_MASTER GL_ACCOUNT_HIER_VR GL_ACCOUNT_MASTER.CHART_OF_ACCT_I

INTERNAL_ORDER INTERNAL_ORDER_HIER_HZINTERNAL_ORDER.INTERNAL_ORDER_ID=IN

INTERNAL_ORDER INTERNAL_ORDER_HIER_VRINTERNAL_ORDER.INTERNAL_ORDER_ID=IN

MATERIAL PRODUCT_HIERARCHY MATERIAL.PROD_HIER_ID=PRODUCT_HIERA

OBJECT_STATUS_HZ OBJECT_STATUS OBJECT_STATUS_HZ.OBJ_ID=OBJECT_STAT

ORGANIZATION_UNIT ORGANIZATION_UNIT_HIE

ORGANIZATION_UNIT ORGANIZATION_UNIT_HIE

PAYROLL_PERIOD PAYROLL_PERIOD_PARA

R_HZ

R_VR

METER

UNT_HIER.HIER_ID and
GL_ACCOUNT_HIER_VR.CHART_OF_ACCT_I
D=GL_ACCOUNT_HIER.CHART_OF_ACCT_ID
and
GL_ACCOUNT_HIER_VR.CHILD_ID=GL_ACC
OUNT_HIER.CHILD_ID

D=GL_ACCOUNT_HIER_HZ.CHART_OF_ACC
T_ID and
GL_ACCOUNT_MASTER.GL_ACCT_ID=GL_A
CCOUNT_HIER_HZ.GL_ACCT_ID AND
GL_ACCOUNT_MASTER.HIER_ID in
('ACCOUNT',@Prompt('Select GL Account
Hierarchy Code','A','GL Account\Hierarchy
Name',mono,free)) AND
GL_ACCOUNT_HIER_HZ.HIER_ID =
@Prompt('Select GL Account Hierarchy
Code','A','GL Account Hierarchy Hz\Hierarchy
Name',mono,free)

D=GL_ACCOUNT_HIER_VR.CHART_OF_ACC
T_ID and
GL_ACCOUNT_MASTER.GL_ACCT_ID=GL_A
CCOUNT_HIER_VR.CHILD_ID AND
GL_ACCOUNT_MASTER.HIER_ID in
('ACCOUNT',@Prompt('Select GL Account
Hierarchy Code','A','GL Account\Hierarchy
Name',mono,free)) AND
GL_ACCOUNT_HIER_VR.HIER_ID =
@Prompt('Select GL Account Hierarchy
Code','A','GL Account Hierarchy Vr\Hierarchy
Name',mono,free)

TERNAL_ORDER_HIER_HZ.INTERNAL_ORDE
R_ID

TERNAL_ORDER_HIER_VR.CHILD_ID

RCHY.PROD_HIER_ID

US.OBJ_ID
ORGANIZATION_UNIT.ORG_UNIT_KEY

=ORGANIZATION_UNIT_HIER_HZ.ORG_UNIT
_KEY

ORGANIZATION_UNIT.ORG_UNIT_KEY=ORG
ANIZATION_UNIT_HIER_VR.CHILD_KEY

PAYROLL_PERIOD.PERIOD_PARAMETER_ID
=
PAYROLL_PERIOD_PARAMETER.PERIOD_PA
RAMETER_ID

4

SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide 93

Reports

4

SAP Master Data Reports

Dimension Table Hierarchy Table Join Text

POSITION POSITION_HIER_HZ POSITION.POSITION_ID=POSITION_HIER_HZ

POSITION POSITION_HIER_VR POSITION.POSITION_ID=POSITION_HIER_VR

PROFIT_CENTER PROFIT_CENTER_HIER_HZPROFIT_CENTER.CTRL_AREA_ID=PROFIT_C

PROFIT_CENTER PROFIT_CENTER_HIER_VRPROFIT_CENTER.CTRL_AREA_ID=PROFIT_C

PROJECT_ELEMENT PROJECT_ELEMENT_HIE

PROJECT_ELEMENT PROJECT_ELEMENT_HIE

WORK_CENTER WORK_CENTER_HIER_HZ WORK_CENTER.WORK_CNTR_ID=WORK_CE

WORK_CENTER WORK_CENTER_HIER_VR WORK_CENTER.WORK_CNTR_ID=WORK_CE

R_HZ

R_VR

.POSITION_ID

.CHILD_ID

ENTER_HIER_HZ.CTRL_AREA_ID and
PROFIT_CENTER.PROFIT_CNTR_ID=PROFIT
_CENTER_HIER_HZ.PROFIT_CNTR_ID

ENTER_HIER_VR.CTRL_AREA_ID and
PROFIT_CENTER.PROFIT_CNTR_ID=PROFIT
_CENTER_HIER_VR.CHILD_ID

PROJECT_ELEMENT. PROJ_ELEM_ID=PROJE
CT_ELEMENT_HIER_HZ.PROJ_ELEM_ID

PROJECT_ELEMENT. PROJ_ELEM_ID=PROJE
CT_ELEMENT_HIER_VR.CHILD_ID

NTER_HIER_HZ.WORK_CNTR_ID and
WORK_CENTER.PLANT_ID=WORK_CENTER_
HIER_HZ.PLANT_ID

NTER_HIER_VR.CHILD_ID AND
WORK_CENTER.PLANT_ID=WORK_CENTER_
HIER_VR.PLANT_ID

94 SAP BusinessObjects Accounts Receivable Rapid Mart XI 3.2 for SAP solutions Business Guide