Need information about some queries

[Former Member]

Hello, I need help in finding the documentation (use, rows, columns, free characteristics etc) about these queries. I've already looked in the BI documentation in help.sap.com but I haven't found anything about these ones. If anyone knows the links where I can find them or has info I would very much appreciate it.

Thank you!

Production capacity ZPP_BW_Q02

Actual Activities - extended 0PP_C04_Q0004

Detailed Activity Analysis 0PP_C03_Q0019

Production Indicator ZPP_C03

Delivery Perfomance 0PP_MP01_Q0003

PP Capacidades ZPPCAPACITY

Repetitive manufacturing ZPP_BW_Q03

Customer: Plan/Actual Sales 0SD_C01_Q030

Incoming Orders by Plant 0SD_C03_Q00004

Sales order material 0SD_C03_Q0012

Most Frequent Product Combination 0SD_C03_Q0020

Direct Business Volume per ADM 0SD_C03_Q0022

Decrease in Sales 0SD_C03_Q006

Sales Order and Sales Revenue Values by Sales Representative 0SD_C03_Q024

Preselection of Top Ten Customers 0SD_C03_Q025

Error-Free Order Processing - Top 10 Customers 0SD_C03_Q026

Amounts and Dates for Delivery Delay - Top 10 Customers 0SD_C04_Q0009

Amounts and Dates for Delivery Delay 0SD_C04_Q0010

Quotation Pipeline 0SD_C05_Q0007

Customer-Related Quotation Success (with Material) 0SD_C05_Q0008

Overview: Freight Documents and Invoices 0SD_MP02_Q0002

Plan Customer I ZCUSTOMER3

Plan Customer II ZCUSTOMER4

Analysis of Due Date for Net Payment (Business Partner) 0FIAR_C03_Q1005

Customers: Overview 0FIAR_C03_Q0007

Overdue Analysis (Business Partner) 0FIAR_C03_Q1004

List of Open Items for Due Date Analyses 0FIAR_O03_Q0001_CR

Asset List 0FIAA_C12_Q0001

Transaction Data Report 0FIAA_C11_Q0001

Depreciation Posted 0FIA_DS13_Q0001

Asset Acquisitions 0FIA_DS11_Q0001

Asset Retirements 0FIA_DS11_Q0004

Investments by Quarter 0FIA_DS11_Q0002

Transaction Data Report 0FIA_DS11_Q0003

Collection Agencies Receivables/Revenues 0FC_C03_Q0001

Monthly Overview of Installment Payments 0FC_C04_Q0001

Completed Installment Plans 0FC_C05_Q0001

Profit Center - Account View (SAP Analytics) 0PCA_MP01_Q0004

Profit Center - Balance Sheet (SAP Analytics) 0PCA_MP01_Q0002

Profit Center - Income Statement (SAP Analytics) 0PCA_MP01_Q0003

Profit Ctr Key Figure - Return on Investment (SAP Analytics) 0PCA_MP01_Q0001

Profit Center: Plan/actual/variance balance sheet accounts 0PCA_C01_Q0016

[Former Member]

Throwing my hat in the ring for updates on this as well. I was searching for a good "Sales Orders by Sales Rep" query and couldn't find anything in the help.sap documentation. I did some where used queries on 0SALESEMPLY and came across all of these queries from just 0SD_C03 that aren't documented (as far as I can tell):

0SD_C03_DB_Q0001	D&B Revenue per Customer with family tree
0SD_C03_DB_Q0002	Dun & Bradstreet Duplicate Customers to one DUNS Number
0SD_C03_DB_Q0003	D&B Customer Revenue Analysis
0SD_C03_DB_Q0010	D&B Customer Details
0SD_C03_Q00004	Incoming Orders by Plant
0SD_C03_Q0001	Overview: Freight Documents and Invoices
0SD_C03_Q0012	Sales order material
0SD_C03_Q0015	Preselection Business Partner (only CRM)
0SD_C03_Q0016	Most Frequent Product Combination (only CRM)
0SD_C03_Q0017	Cross Selling Target Group
0SD_C03_Q0018	Sales Volume for Product Hierarchy
0SD_C03_Q0019	Sales Volume Decrease per Business Partner
0SD_C03_Q0020	Most Frequent Product Combination
0SD_C03_Q0021	Preselection Business Partner
0SD_C03_Q0022	Direct Business Volume per ADM
0SD_C03_Q0023	Sales Order and Sales Revenue Values from the Last 12 Months
0SD_C03_Q0024	Decrease in Sales
0SD_C03_Q0025	Incoming Orders of the Last 12 Months
0SD_C03_Q0026	Top 10 Materials Based on Incoming Orders of Last 12 Months
0SD_C03_Q0100	Returns per Business Partner
0SD_C03_Q0101	Sales Volume Development per Business Partner
0SD_C03_Q012	Returns per Customer Top N
0SD_C03_Q024	Sales Order and Sales Revenue Values by Sales Representative
0SD_C03_Q025	Preselection of Top Ten Customers
0SD_C03_Q026	Error-Free Order Processing - Top 10 Customers
0SD_C03_QDB001	Dun & Bradstreet Rationalization for All Customers

[Former Member]

Hi,

I was just searching for the documentation for a few of these queries myself.

Since SAP did not provide these documentations in the past 5 years, I think it is very unlikely that we will ever see them on the SAP website.

Is anyone from the SAP Documentation Team reading this? Do you have any comment why several queries never got their appropriate documentation?

[Former Member]

Hello Maria,

Most of the Queries you have listed are Business Content Queries So if you Look in to Metadata Repository in the DATAWAREHOUSING WORKBENCH . And evaluate and investigate in to it By Business Content According to That ...you will have clear idea

If helpful reward points

regards

[Former Member]

I found all technical information but I would like to have it in the same format as in the documentation available in help.sap.com portal, there SAP provides extended description of query's use and preview information. I've seen that many queries I'm inquiring about belong to different BW releases, but I can't perform a search before release 3.0B. Do you know of any other source of information to find the documentation?

Thanks in advance