Wednesday, September 30, 2009

SAP BUSINESS CONTENT STANDARD CUBES


SAP BW STANDARD BUSINESS CONTENT CUBES

CO PA INFO CUBES

ALWAYS OWN INFO CUBE HAS TO BE CREATE SINCE THE SETTING DEPEND ON THE OPERATING CONCERN. SEETINGS DIFFER.

0MKTG_C04

CO-PA for External List Management

0COPA_C04

CO-PA: Consumer Goods Industry (S_CP)

0COPA_C02

CO-PA: CRM Marketing

0ME_TLC03

CO-PA: Profitability Analysis

0COPA_C01

CO-PA: Published Key Figures

0COPA_C03

CO-PA: Quickstart (S_GO)

0COPA_C05

CO-PA: Route Profitability (S_AL)

0ME_TLC04

CO-PA: Sales Analysis

CO-PA: Published Key Figures

CUBE = 0COPA_C01 DS = 0CO_PA_1

CRM MARKEITNG

CUBE = 0COPA_C02 DS = 0CO_PA_1

CO-PA: Quickstart (S_GO)

CUBE = 0COPA_C03 DS = 0CO_PA_3

CO-PA: Consumer Goods Industry (S_CP)

CUBE = 0COPA_C04 DS = 0CO_PA_4

CO-PA: Route Profitability (S_AL)

CUBE = 0COPA_C05 DS = 0CO_PA_5

PROFITABILITY

0ALM_C03

Profit & Loss- write up / write down

0RTL_C03

Profit Center Analytics Retail BW: Report Stat. Key Fig.

0RTL_C01

Profit Center Analytics Retail BW: Report Transaction Fig.

0RTL_C04

Profit Center Analytics Retail SEM: Plan Stat. Key Fig.

0RTL_C02

Profit Center Analytics Retail SEM: Plan Transaction Fig.

0SEM_C06

Profit, Balance Sheet, and Cash Flow Statement Planning

0ORA_C02

Profitability Analysis

0SEMPA_C1

Profitability Analysis

FI

0REFX_C06

Cash Flow

0CML_C04

Cash Flow Analysis

0ALM_C02

Cash flow and liquidity

FI SL

0METLVC01

FI-SL: Financial Statement

0METL_C02

FI-SL: License Sales Contract Analysis

0METL_C05

FI-SL: License Sales Contract Analysis (Time-Dependent)

0METL_C01

FI-SL: Sales Figures

FI GL

0FIGL_V10

G/L (New): Balance Sheet and Profit and Loss

0FIGL_V11

G/L (New): Balance Sheet and Profit and Loss Remote

0FIGL_C10

General Ledger (New): Transaction Figures

0FIGL_R10

General Ledger (New): Transaction Figures Remote

0FIGL_VC1

General Ledger: Financial Statements

0FIGL_C01

General Ledger: Transaction Figures

FIAP

0FIAP_C03

FIAP: Line Item

0FIAP_C02

FIAP: Transaction Data

FICO

0SR_FIC01

FI Global Spend Data for SRM

FIAR CUSTOMER ACCOUNTS RECEIVABLE

0FIAR_C03

FIAR: Line Item

0FIAR_C05

FIAR: Payment History

0FIAR_C02

FIAR: Transaction Data

Customers: Transaction figures 0FIAR_C02 0FI_AR_1

Customers: Item ODS - 0FIAR_O03 0FI_AR_3

Customers: Payment History 0FIAR_C05 0FI_AR_5

Customers: Central Data for Credit Management ODS - 0FIAR_O08 0FI_AR_8

Customers: Credit Management, Control Area Data ODS- 0FIAR_O09 0FI_AR_9

LO

0RT_C54

Logistics

CUSTOMER: >>>>>>>>>>> DS = 2LIS_01_S001 CUBE = 0SD_C01

SHIPPING POINT: >>>>>>>>>>> DS = 2LIS_01_S005 CUBE = 0SD_C02

SALES ORDER: >>>>>>>>>>>>> CUBE = 0SD_C05 DS = 2LIS_01_S260

CUBE = 0SD_C03 DS = 2LIS_01_S260

CUBE = 0SD_C10 DS = 2LIS_01_S260

CUBE = 0CRM_C03 DS = 2LIS_01_S260

SD - Delivery note:>>>>>>>>> CUBE = 0SD_C03 DS = 2LIS_01_S261

CUBE = 0SD_C04 DS = 2LIS_01_S261

SD - Billing document:>>>>>>>>> CUBE = 0SD_C03 DS = 2LIS_01_S262

SD - Sales order/delivery note:>>>>>>> CUBE: 0SD_C03 DS = 2LIS_01_S263

SD SALES BW---Sales Order Header Data>>>> CUBE = 0SD_C03 DS = 2LIS_11_VAHDR

CUBE = 0SD_C05 DS = 2LIS_11_VAHDR

CUBE = 0SD_O03 DS = 2LIS_11_VAHDR

Sales Order Item Data (As of 2.0B)

CUBE = 0CP_SLSC1 DS = 2LIS_11_VAITM

CUBE = 0RT_C02 DS = 2LIS_11_VAITM

CUBE = 0SD_C10 DS = 2LIS_11_VAITM

CUBE = 0MEMSDC06 DS = 2LIS_11_VAITM

CUBE = 0RT_C03 DS = 2LIS_11_VAITM

CUBE = 0SD_C03 DS = 2LIS_11_VAITM

CUBE = 0SD_C05 DS = 2LIS_11_VAITM

ODS = 0SD_O01 DS = 2LIS_11_VAITM

ODS = 0CDS_DS02 DS = 2LIS_11_VAITM

ODS = 0SD_O02 DS = 2LIS_11_VAITM

HR

0PAPD_C02

Appraisals

0RT_C52

Employee Time and Labor

0PY_C02

Employee-Specific Payroll Data

0RT_C53

Payroll

BW STATISTICS

0BWTC_C06

BW Data Slice

0BWTC_C08

BW Metadata

0BWTC_C04

BW Statistics - Aggregates

0BWTC_C02

BW Statistics - OLAP

0BWTC_C03

BW Statistics - OLAP, Detail Navigation

0BWTC_C05

BW Statistics - WHM

0BWTC_C01

BW Statistics (1.2)

0BWTC_C09

BW Statistics: Condensing InfoCubes

0BWTC_C11

BW Statistics: Deleting Data from InfoCubes

Customer

0RT_C02

Customer

0SD_C01

Customer

0CRM_HIS2

Customer Order History

0LOM_C01

Customer Sales & Visits

0LOM_C08

Customer Sales & Visits (Temporary)

0LOM_C02

Customer Sales & Visits (Unassigned)

0RT_C75

Customer Settlements

0CRM_MRO2

Customer's Most Recent Order

0CRM_C06

Outbound Customer Contact

Delivery

0SD_C02

Deliveries

0MEMSDC03

Deliveries and Complaints

0LES_C13

Delivery data of shipment stages

0MEMSDC02

Delivery Quantities

0SD_C04

Delivery service

MM

0RT_C35

Material Movements

0CP_IC_C1

Material Movements and Stock

0CP_PURC1

Material Procurement

0IC_C03

Material Stocks/Movements (as of 3.0B)

0REFX_C02

Measurements

0MEMSDC06

Media Product Sales & Distribution: Order

0RT_C04

Merchandise Flow (Distribution Center)

0RMP_C05

Merchandise Planning, Plan

0RMP_C06

Merchandise Planning, Plan, Actual Copy

0RMP_C01

Merchandise Planning, POS Sales, Month

0RMP_C02

Merchandise Planning, POS Sales, Week

0RMP_C03

Merchandise Planning, Stock, Month

0RMP_C04

Merchandise Planning, Stock, Week

0RT_C05

Merchandise Procurement

SD

0APO_C02

Order Data

0APO_C03

Order/Customer Assignment

0IS_CDC01

Outstanding Debt Statistics

0UCCM_C03

Overview of Billing Processes

0UCCM_C05

Overview: Error Messages that Occurred

0UCCM_C04

Overview: Successful Invoice Processes

0IPM_C12

Paid Confirmations

0ISCM_C03

Payment Data

0RT_C71

Payment Document (Header) / Remuneration List

0RT_C72

Payment Documents Item

0RT_C31

POS Receipt/Material

0RT_C30

Receipt

SHIPMENT

0LES_C02

Shipment costs details

0LES_C01

Shipment Costs Overview

0LES_C11

Shipment header

0LES_C12

Stage of Shipment

SALES

0MEMAMC16

Sales Agent (Order)

0CP_SLSC1

Sales and Sales Deals

0CP_SLSC7

Sales and Trade Promotions (Actual)

0CP_SLSC6

Sales and Trade Promotions (Planned + Actual)

0CP_SLSCA

Sales and Trade Promotions (Planned+Actual) in SU

0CSAL_C04

Sales Contracts (Quantity and Value Contracts)

0RC_C02

Sales InfoCube

0CSAL_C03

Sales Orders

0HOM_C03

Sales Orders for Host Order Management Scenarios

0CSAL_C02

Sales Planning

0UCCRMC01

Sales statistic NRC (CRM)

0UCCRMC04

Sales statistic NRC for quotation planning (CRM)

0UCSA_C01

Sales Statistics

0UCSA_C02

Sales Statistics - Taxes (Do Not Use)

0UCSA_C05

Sales Statistics (Basic Key Figures)

0SD_C03

Sales: Overview

0RC_C05

Sales2 InfoCube

0GT_C01

Sales-Side Trading Contracts

STOCK

0AFMM_C02

Stock on a Weekly Basis

0LIM_C01

Stock Quantities

0RT_C37

Stock (Month)

0RT_C36

Stock (Week)

0FRE_C10

Stock Exceptions - Dead Stock

0FRE_C04

Stock Exceptions - Overstocks

PLAN / ACTUAL data

0CMCP_C10

Plan Data - Household, Socio-Demographics

0CMCP_C08

Plan Data - Household, Target Consumers

0CMCP_C06

Plan Data - POS

0CMCP_C09

Plan Data - Retail Panel

0CMCP_C07

Plan Data - Stock (Month, Quarter, Year)

0PP_C05

Plan/Actual Comparison Material Consumption

0PP_C03

Plan/Actual Comparison Operation/Work Center View

0TRCM_C01

Planned Amounts

0PU_C31

Planned Budget (BCS)

0PU_C30

Planned Budget (Function Mod.)

0PACP_C02

Planned Personnel Costs Per Cost Object

0D_PP_C01

Planned/Actual Comparison Order/Material View

0PP_C01

Planned/Actual Comparison Order/Material View

0CM_C07

Planning: Actual Data (Stock: Year)

0CM_C06

Planning: Actual Data (Week)

0CM_C09

Planning: Planning Data 'Index for Shelf Optimization'

0CM_C08

Planning: Planning Data 'Performance Measures'

0CM_C10

Planning: Planning Data 'Tactics Assortment'

0CM_C11

Planning: Planning Data 'Tactics Pricing'

0CM_C12

Planning: Planning Data 'Tactics Promotions'

0PACM_C05

Personnel Cost Planning

0PACP_C01

Personnel Cost Plans

PRODUCT LIST

0CRM_PRLI

Product Lists

0IPM_C13

Product Sales

0PP_C14

Production Monitoring

PURCHASING DATA

0D_PU_C01

Purchasing Data

0PUR_C01

Purchasing Data

0PUR_C04

Purchasing Groups

0GT_C03

Purchasing-Side Trading Contracts

RETAIL

0CMCP_C03

Retail POS Data

0MEMSDC05

Retail Sales Statistics

0CMCP_C05

Retail Stock Data

REVENUE

0MEMAMC07

Revenue (Billing)

0MEMAMC05

Revenue (Order)

0MEMAMC08

Revenue Quantities (Billing)

0MEMAMC06

Revenue Quantities (Order)

0IPM_C11

Revenues (Accrual Engine)

SHIPPING

CUBE DS

Shipment Costs Overview 0LES_C01 2LIS_08TRFKP

Shipment costs details 0LES_C02 2LIS_08TRFKZ

Shipment Header Data 0LES_C11 2LIS_08TRTK

Shipment Delivery Item Data per Stage 0LES_C13 2LIS_08TRTLP

Shipment Stage Data 0LES_C12 2LIS_08TRTS

1 comment: