Module

Infocube Name

Infocube Description

Query Technical Name

SD

0SD_MC01

Conditions: Order and Billing

0SD_MC01_Q0003
Document

SD

0SD_MC01

Conditions: Order and Billing

0SD_MC01_Q0002
Document

SD

0SD_MC01

Conditions: Order and Billing

0SD_MC01_Q0001
Document

SD

0SD_C15

Condition Value

0SD_C15_Q0001

SD

0SD_C03

Sales: Overview

0SD_C03_Q007

SD

0SD_C03

Sales: Overview

0SD_C03_Q006

SD

0SD_C03

Sales Overview

0SD_C03_Q011

SD

0SD_C03

Sales Overview

0SD_C03_Q008

SD

0SD_C03

Sales Overview

0SD_C03_Q0014

SD

0SD_C03

Sales Overview

0SD_C03_Q004

SD

0SD_C03

Sales Overview

0SD_C03_Q005

SD

0SD_C03/0SD_MP02 Sales Overview

0SD_C03_Q0003 /
0SD_MP02_Q0001

SD

0SD_C03

Sales Overview

0SD_C03_Q010

SD

0SD_C03

0SD_C03_Q003

SD

0SD_C03

Sales: Overview

0SD_C03_Q009

0SD_C04

Delivery Service

0SD_C04_Q0004

SD

0SD_C04

Delivery Service

0SD_C04_Q0002

SD

0SD_C04

Delivery Service

0SD_C04_Q0001

SD

0SD_C05

Offers/Orders

0SD_C05_Q0003

0SD_C05

Offers/Orders

0SD_C05_Q0001

SD

0SD_C05

Offers/Orders

0SD_C05_Q0006

SD

0SD_C05

Offers/Orders

0SD_C05_Q0004

SD

0SD_C05

Offers/Orders

0SD_C05_Q0005

SD

0SD_C05

Offers/Orders

0SD_C05_Q0002

SD

0SD_C01

Customer

0SD_C01_Q026

SD

0SD_C01

Customer

0SD_C01_Q024

SD

0SD_C01

Customer

0SD_C01_Q011

SD

0SD_C01

Customer

0SD_C01_Q0002

SD

0SD_C01

Customer

0SD_C01_Q021

SD

0SD_C01

Customer

0SD_C01_Q012

SD

0SD_C01

Customer

0SD_C01_Q022

SD

0SD_C01

Customer

0SD_C01_Q010

SD

0SD_C01

Customer

0SD_C01_Q0003

SD

0SD_C01

Customer

0SD_C01_Q025

SD

0SD_C01

Customer

0SD_C01_Q0001

SD

0SD_C04

Delivery service

0SD_C04_Q0003

SD

0SD_C02

Deliveries

0SD_C02_Q0002

SD

0SD_C01

Customer

0SD_C01_Q013

SD

0SD_C12

Service Level: Order Items

0SD_C12_Q0001

SD

0SD_C12

Service Level: Order Items

0SD_C12_Q0005

SD

0SD_C01

Customer

0SD_C01_Q023

SD

0SD_C02

Deliveries

0SD_C02_Q0001

SD

0SD_C12

Service Level: Order Items

0SD_C12_Q0007

SD

0SD_C12

Service Level: Order Items

0SD_C12_Q0006

SD

0SD_C11

Service Level - Order

Quantities

0SD_C11_Q0005

SD

0SD_C14

Backorders

0SD_C14_Q0003

SD

0SD_C14

Backorders

0SD_C14_Q0001

Query Technical Description

Condition rate Deviation (Sales Order & Billing Document) -shows the deviation of the condition rate of
various condition types between a sales order and the associated billing document (if the condition
rate in the sales order is different from that in the billing document).

Condition Amount (Billing Document) -shows the condition value and condition amount of the billing
document on the position level.

Condition Amount (Sales Order) -shows the condition value and condition amount of the sales order
on the position level.

Condition Amount By Customer -shows the cumulated order quantity, condition value and average
condition value for each sold-to party and condition type.

Billing Report -Provides billing document data

Deliveries Report -Provides delivery data.

Faultless Sales Order Processing Report -Shows which sales orders were processed without
problems.

FulFillment Rates Report -Provides data about sales orders that are still open.

FulFillment Rates - Values -Provides you with the percentage value of monthly order fulfillment rates
by comparing the value of incoming orders with the value of open orders .

Incoming Orders Per Customer -displays incoming order data for specific customers

Proportion Of Credit Memos to Billing Documents Report -displays credit memo values in proportion to
the total billing document values.

Warehouse Workload - Inbound Delievries -

Order, Delivery & Sales Quantities -displays the order, delivery and sales quantities

Proportion of Returns to Incoming Orders Report -display the returns and their value in proportion to
all incoming orders.

Sales & Order Values Report -Displays information about order and sales values.

Average Delivery Processing Time -provides figures about the time taken between certain stages of
the delivery process, such as average time taken between loading and goods issue.

Delivery Delays per Sales Area Report -Provides differences between requested and confirmed
delivery times with actual delivery times per sales area

Delivery Delays Per Sold To Party Report -Provides differences between requested and confirmed
delivery times with actual delivery times per sold-to party

General Quotation report at Sales Area Level -Provides general information about quotations placed
in a particular sales area.

General Quotation Report per Customer -Provides general information about quotations placed by a
particular customer

Quatation Success Rate Per Sales Area -Gives the success rate of quotations, in other words, how
many orders result from quotations for a particular sales area.

Quatation Success Rate Per Customer -Gives the success rate of quotations, in other words, how
many orders result from quotations for a particular customer.

Quotation Tracking per Customer -Shows how many quotations have been rejected by particular
customers.

Quotation Tracking per Sales Area -Shows how many quotations have been rejected by particular
sales areas.

Distribution Channel Analysis Report -Gives analysis of the volume of orders for each distribution
channel.

Incoming Orders Analysis Report -Provides analysis on the amount of incoming orders in relation to
the amount of open orders

Incoming Orders Report (per Calendar Year and Month) -Provides detailed data about incoming orders
per month and year.

Monthly Incoming Orders & Revenue -shows incoming orders und revenues per month of current year

Product Analysis Report -List the Products of a company by incoming orders, sales and contribution
margin.

Proportion Of Credit Memos to Sales Volume -display credit memos and their value in proportion to
the sales volume.

Product Profitability Analysis Report -analyses profitability of your products.

Returns Per Customer Report -displays information about returns and their value in proportion to all
orders.

Quantity & Value Of Returns -shows returns quantities and values

Sales/Cost Analysis -Compares amount sold with the cost of the sales on a monthly basis.

Sales Figues Comparison -Provides comparisons of planned and actual sales values for the current
and previous years.

Incorrect Delivery Quantities -provides information about deliveries that have been delivered too early,
too late or correctly

Monthly Deliveries Report -analyses deliveries going out every month.

Sales & Orders Volumes Report -Displays sales volume data.

Service Level - Item Level / Schedule Line Delay Report -Displays the value of delays from the
requested date and from the schedule line date. It also displays the total value of delays along with the
list of customers having the highest values.

Service Level - Item Level / Schedule Line Delay (In Six Months) -Displays the value of delays from
the requested date and those from the schedule line date for the last six months.

Top Customers Report (Based on Sales) -analyses the amount of sales generated by a customer over
a period of time.

Weekly Deliveries / Deliveries per Shipping Point (Weekly) -provides you with information to evaluate
delivery performance. For each sold-to party, you can view both the value and also quantity of a
material that was delivered later than the requested date or schedule line date

Material Availability Analystics Stocks -provides you with information about the number of document
items and your customers' requested delivery values that you could execute as requested, which
allows you to perform analyses with regard to material availability. In addition to this, various views
allow you to, for example, view the five customers with the highest and lowest sales, or the five
customers with the most and least supplier confirmations.

Delivery Performance -

Delivery Performance Sales Report -provides you with information about requested delivery quantities
per plant and sold-to party for each material, which you can use to analyze the delivery performance.

Material Availability Analystics Backorders -

Open order Quantity For Last Week -displays the value of outstanding orders with delay from the
requested date and those with delay from the schedule line date

Key Figures

Characteristics

Condition amount (order) Sold-to party

Condition amount (billing

Calendar day
document)

Deviation condition
amount = condition
amount (order)
Sales organization
condition amount (billing
document)

Material

Condition Value

Sold-to party

Condition Amount

Calendar day

Sales organization

Material

Condition Value

Sold-to party

Condition Amount

Calendar day

Sales organization

Material

Cumulated Order
Amount

Customer Group

Condition Value

Calendar day

Average condition value

= condition value /
Sales organization
cumulated order amount

Number of invoiced
items

Sales organization

Invoiced quantities

Distribution channel

Net value of all invoices Division

Invoiced cost * quantity

Material Number

Number of delivery items Sales organization

Quantity of delivered
goods

Distribution channel

Gross weight of
deliveries

Division

Net weight of deliveries

Material Number

Volume of deliveries

Number of orders items Sales Organization

Number of returns items Distribution Channel

(Number of orders items

- number of returns
Division
items) / Number of
orders items in %

Number of orders Number of returns

Quantity of goods in
incoming orders

Quantity of goods in
returned deliveries

(Incoming order quantity

returns quantity) /
Incoming order quantity
in %

Incoming order quantity

returns quantity

Net value of incoming

orders

Net value of deliveries

that were returned

Material Number

(Incoming order value

returns value) / Incoming
order value in %

Incoming order value returns value

Quantity of order goods

that have not yet been Sales Organization
delivered

Quantity of goods in
incoming orders

Distribution Channel

(Incoming order quantity

open order quantity) / Division
incoming order quantity

Material Number

Restricted key figure

1KYFNM

Sales Organization

Restricted key figure

1KYFNM = net value of
open orders in statistic
currency

Distribution Channel

Formula: (Incoming
order value - Net value
of open orders) %A
incoming order value

Division

Material Number

Calendar year/month

Number of order items

Sales organization

Quantity of items in
incoming orders

Distribution channel

Net value of incoming

orders

Division

Value of incoming orders

Material number
/ Number of orders in %

Number of credit memos

Sales organization
items

Number of billing
documents items

Distribution channel

Number of credit memos

/ Number of billing
Division
documents in %

Quantity of credit memos

(quantity of goods in
Material number
credit memos)

Quantity of invoiced
goods

Credit memo quantity /

Invoiced quantity in %

Net value of credit

memos

Net value of invoiced

sales

Credit memo value /

Invoiced value in %

Credited cost * quantity

Invoiced cost * quantity

Credit value / Invoiced

value in %

Number of Document
Items

Sales Organization

Quantity in Base Unit of

Distribution Channel
Measure

Gross Weight in
Kilograms

Division

Net Weight in Kilograms Material

Volume in Cubic
Decimeters

Calendar Year/Month

Quantity of incoming
order goods in items

Sales organization

Quantity of returns
goods in items

Distribution channel

Quantity of delivered
goods in items

Division

Quantity of return
Material number
deliveries goods in items

Quantity of invoiced
goods in items

Quantity of credit memos

goods in items

Number of returns items Sales organization

Number of order items

Distribution channel

Number of return items /

Number of order items in Division
%

Number of returns
(number of return
documents)

Material number

Number of orders

Number or returns /
Number of orders in %

Quantity of returns
(quantity = total quantity
of returned goods)

Quantity in incoming
orders

Percentage of incoming
orders that are returns

Net value of deliveries

that have been returned

Net value of incoming

orders

Percentage value of net

incoming order value
that are returns

Net value of incoming

orders

Sales organization

Net value of deliveries

Distribution channel
that have been returned

Net value of invoiced

sales

Division

Net value of credit

memos

Material number

Difference between
material availability date Sales organization
and loading date

Difference between
Distribution channel
loading and goods issue

Average travelling time

to customer

Division

Difference between
loading and arrival of
goods at customer

Plant

Difference between
planned goods issue and Shipping Point
actual goods issue

Calender Year/Month

Material

Average delay between

confirmed and actual
Sales organization
delivery date

Average delay between

requested delivery date Distribution channel
and actual delivery date

Average difference
between requested and Division
confirmed delivery date

Calender Year & Month

Average delay between

confirmed and actual
Sales organization
delivery date

Average delay between

requested delivery date Distribution channel
and actual delivery date

Average difference
between requested and Division
confirmed delivery date

Shipping Point

Material

Sold to Party

Calender Year & Month

Number of quotations

Quotations Valid From

Date

Number of quotation
items

Quotations Valid to Date

Average number of
quotation items

Sales Group

Net value of quotation

Sales Office

Average quotation item

value

Calender Year/Month

Average order probability

Order probability of
quotation item

Number of quotations

Sales Organization

Number of quotation
items

Distribution Channel

Average number of
quotation items

Division

Net value of quotation

Material

Average quotation item

value

Quotations Valid From

Date

Quotation quantity in
base units of measure

Quotations Valid to Date

Average quantity of
quotation items

Sold To Party

Average order probability Calender Year/Month

Order probability of
quotation item

Number of quotation
items

Sales organization

Net value of quotation

Distribution channel

Number of orders that

result from quotations

Division

Number of order items

Quotations Valid from date

Proportion of order items

that result from quotation Quotations Valid to date
items

Net value of order items

that result from
Sold to Party
quotations

Net order value

Calendar Year/Month

Proportion of order value

from quotation items

Number of quotation
items

Sales organization

Net value of quotation

Distribution channel

Number of orders that

result from quotations

Division

Number of order items

Quotations Valid from date

Proportion of order items

that result from quotation Quotations Valid to date
items

Net value of order items

that result from
Sold to Party
quotations

Net order value

Calendar Year/Month

Proportion of order value

from quotation items

Number of quotation
items

Sales organization

Number of rejected
quotation items

Distribution channel

Proportion of rejected
items

Division

Net value of quotation

Quotations Valid from date

Net value of rejected

quotation items

Quotations Valid to date

Proportion of rejected
net value

Sold to Party

Order value from

quotation

Calendar Year/Month

Share order value

Quotation value
expired/open

Share Quotation value

(expired/open)

Number of quotation
items

Number of rejected
quotation items

Proportion of rejected
items

Net value of quotation

Net value of rejected

quotation items

Proportion of rejected
net value

Net value of invoiced

sales (sold products)

Distribution Channel

Percentage of Total
Sales

Country of the Sold-to

party (customer)

Stock value of Invoiced

Sales (Stock value
multiplied by the
order/invoice quantity)

Industry of the Sold-to

party (customer)

Percentage of Total Cost

of Sales

Contribution Margin
(Sales Cost of Sales)

Contribution Margin in
percent

Percentage of Total
Contribution Margin

Net value of incoming

orders

Distribution Channel

Orders which have not

yet been delivered

Division

Percentage open orders Industry of the Sold-to

of incoming orders
party (customer)

Incoming orders open Country of the Sold-to

orders
party (customer)

Sold to party (customer)

Quantity of incoming
orders

Fiscal year / period

Costs of incoming orders Fiscal year variant

Net value of incoming

orders

Sales organization

Number of order items

Distribution channel

Net value of incoming

orders / Number of order Division
items in percent

Material number

Open incoming orders

net value

Sales organization

Incoming orders net

value

Distribution channel

Incoming orders cost

value

Division

Material cost share

Country

Net value of invoiced

sales

Sold To Party

Net value of credit

memos

Industry

Net value of invoices

sales minus Net value of
credit memos

Net value of incoming

orders

Material Group

Quantity of incoming
orders

Material Type

Net value of invoiced

sales (sold products)

Material

Invoiced Quantity

Order, which has not

been delivered yet

Open orders quantity

Quantity in credit memos Fiscal year / period

Cost is net value minus

costs for an order

Fiscal year variant

Credit memo in net value

Gutschrift ber einen
Sales organization
Nettowert

Credit memo quantity /

Sales volume quantity in Distribution channel
percent

Credit memo net value /

Sales volume net value Division
in percent

Material number

Net value of invoiced

sales (sold products)

Material Type

Percentage of Total
Sales

Material

Stock value of Invoiced

Sales (Stock value
multiplied by the
order/invoice quantity)

Country of the Sold-ToParty

Percentage of Total Cost

Material Group
of Sales

Contribution Margin
(Sales Cost of Sales)

Contribution Margin in
percent

Percentage of Total
Contribution Margin

Number of return items

Fiscal year / period

Number of order items

Fiscal year variant

Number of return items /

Number of order items in Sales organization
%

Quantity of deliveries
Distribution channel
that have been returned

Quantity of incoming
orders

Division

Quantity of returns as a
percentage of sales
Material number
volume

Net value of deliveries

that have been returned

Net value of incoming

orders

Value of returns as a
percentage of sales
volume value (net
values)

Net value of incoming

returns

Sales organization

Returns quantity

Distribution channel

Division

Sold to party

Material

Net value of invoiced

sales (sold products)

Stock value of Invoiced

Sales (Stock value
multiplied by the
order/invoice quantity)

Cost of Sales as
percentage of Sales

Contribution Margin
(Sales Cost of Sales)

Contribution Margin in
percent

Planed sales cumulative

CalYear/Month
year

Actual sales cumulative

Industry
year

Actual sales in previous

Country
year

Plan variance

Material type

Variance of sales in
percent (current year)

Material

Variance of sales in
percent (previous year)

Product hierarchy

Distribution channel

Division

Sales organization

Quantity delivered too

early

Sales organization

Correctly delivered
quantity

Distribution channel

Quantity delivered too

late

Division

Sold To Party

Calendar Year & Month

Material

Gross weight of delivery Route

Workload for delivery

Recipient country

Delivery volume

Forwarding agent

Gross weight of returns

delivery

Calendar year/month

Workload for returns

delivery

Shipping point

Total quantity of
delivered items

Fiscal year / period

Total value of deliveries Fiscal year variant

Total cost of deliveries

Sales organization

Distribution channel

Division

Material number

Delivery performance to
customer request date Material
(number)

Delivery performance to
customer request date Sold-to party
(value)

Delivery performance to
scheduled commit date Plant
(number)

Delivery performance to
scheduled commit date Distribution channel
(value)

Value of items delivered

late/ requested delivery Forwarding agent
date

Value of items delivered

Calendar year/month
late/ schedule line date

Delivery performance to
customer request date Material
(number)

Delivery performance to
customer request date Sold-to party
(value)

Delivery performance to
scheduled commit date Plant
(number)

Delivery performance to
scheduled commit date Distribution channel
(value)

Value of items delivered

late/ requested delivery Forwarding agent
date

Value of items delivered

Calendar year/month
late/ schedule line date

Net value of invoiced

sales (sold products)

Sold-to party (Customer)

Stock value of invoiced

sales (stock value
multiplied by the
order/invoice quantity)

Division

Contribution margin
(Sales Cost of Sales)

Material

Contribution margin in
percent

Gross weight of
deliveries

Route

Labour required for

deliveries on hand

Destination

Volume of deliveries

Carrier

Gross weight of returns

deliveries

Labour required for

returns on hand

Confirmed as Requested Sold To Party

Requested Delivery
Value

Material

Number of Document
Items

Calendar Year/Month

Value Confirmed as
Requested

Delivery Performance
According To Requested Material
Delivery Date (Order)

Delivery Performance
According To Requested
Sold-To Party
Delivery Date
(Quantities)

Delivery Performance
According To Schedule
Line Date (Order)

Delivery Performance
According To Schedule
Line Date (Quantities)

Calendar Year/Month

Requested Delivery
Quantity

Material

Calendar Year/Month

Plant

Sold To Party

Backorders

Calendar Year/Month

Backorders = 1D

Plant

Backorders <=7D

Sold To Party

Backorders <=30D

Backorders >30D

Outstanding Order
Quantity for Schedule
Line Date

Sold To Party