Show TOC

Product

InfoCube InfoCube: 0RT_C01

 

This InfoCube was created to model the most important aspects of retailing in a comprehensive manner. In other words, its purpose is to allow you to compare the key figures from Purchasing, Inventory Management and Sales.

The InfoCube is updated from a number of InfoSources. For more information about InfoSources, see Extracting Transaction Data.

Data Modeling

Requires

Object Type

Name

Technical Name

InfoObject

Base Unit of Measure

0BASE_UOM

InfoObject

Calendar Day

0CALDAY

InfoObject

Calendar Year/Month

0CALMONTH

InfoObject

Calendar Year/Quarter

0CALQUARTER

InfoObject

Calendar Year/Week

0CALWEEK

InfoObject

Calendar Year

0CALYEAR

InfoObject

Change Run ID

0CHNGID

InfoObject

Sales / Base Unit of Measure

0CPBAINSABU

InfoObject

Sales /Number of Items

0CPBAINSANI

InfoObject

Sales/Cost Value

0CPBAINSAPV

InfoObject

GI / DC BUn

0CPGOISDCBU

InfoObject

GI / DC Number of Items

0CPGOISDCNI

InfoObject

GI / DC / Cost

0CPGOISDCPV

InfoObject

GR / DC BUn

0CPGOREDCBU

InfoObject

GR / DC Number of Items

0CPGOREDCNI

InfoObject

Goods Receipt /Distribution Center Cost Value

0CPGOREDCPV

InfoObject

Goods Receipt Posting Date / Vendor BUn

0CPGRPDVBU

InfoObject

GR Posting Date / Number of Vendor Schedule Lines

0CPGRPDVNI

InfoObject

Goods Receipt Posting Date / Vendor Cost Value

0CPGRPDVPV

InfoObject

Outbound Merchandise Clearing / BUn

0CPMCAODDBU

InfoObject

Outbound Merchandise Clearing / Number of Items

0CPMCAODDNI

InfoObject

Outbound Merchandise Clearing / Cost Value

0CPMCAODDPV

InfoObject

Inbound Merchandise Clearing / BUn

0CPMCINDDBU

InfoObject

Inbound Merchandise Clearing / Number of Items

0CPMCINDDNI

InfoObject

Inbound Merchandise Clearing / Cost Value

0CPMCINDDPV

InfoObject

Open PO Quantity Delivery Date / Vendor BUn

0CPOPOQDVBU

InfoObject

Open Order Stock Delivery Date / Vendor Cost Value

0CPOPOQDVPV

InfoObject

Purchase Order Delivery Date / Vendor BUn

0CPPODDVBU

InfoObject

Purch. Order Deliv. Date/SchLines

0CPPODDVNI

InfoObject

PO Delivery Date / Vendor Cost Value

0CPPODDVPV

InfoObject

Revaluation at Retail (Negative) / BUn

0CPSPRENBU

InfoObject

Revaluation at Retail (Negative) / Number of Items

0CPSPRENNI

InfoObject

Revaluation at Retail (Positive) / BUn

0CPSPREPBU

InfoObject

Revaluation at Retail (Positive) / No. of Items

0CPSPREPNI

InfoObject

Goods Receipt Total / Vendor BUn

0CPTGOREVBU

InfoObject

Goods Receipt Total / Vendor Number of Items

0CPTGOREVNI

InfoObject

Goods Receipt Total / Vendor Cost Value

0CPTGOREVPV

InfoObject

Total Stock Correction (Negative) / BUn

0CPTINCONBU

InfoObject

Total Stock Correction (Negative)/ Number of Items

0CPTINCONNI

InfoObject

Total Stock Correction (Negative) / Cost Value

0CPTINCONPV

InfoObject

Stock Correction Total (Positive) / BUn

0CPTINCOPBU

InfoObject

Total Stock Correction (Positive) / Number of Items

0CPTINCOPNI

InfoObject

Total Stock Correction (Positive)/ Cost Value

0CPTINCOPPV

InfoObject

Last Valuated Stock Total/BUn

0CPTOTSTOBU

InfoObject

Last Valuated Stock Total/Cost Value

0CPTOTSTOPV

InfoObject

Total Cost Price Revaluation (Negative) /BUn

0CPTPPRENBU

InfoObject

Total Cost Price Revaluation (Negative) / Number of Items

0CPTPPRENNI

InfoObject

Total Revaluation at Cost (Negative)/ Cost Value

0CPTPPRENPV

InfoObject

Total Cost Price Revaluation (Positive)/BUn

0CPTPPREPBU

InfoObject

Total Cost Price Revaluation (Positive)/ Number of Items

0CPTPPREPNI

InfoObject

Total Cost Price Revaluation (Positive)/ Cost Value

0CPTPPREPPV

InfoObject

Total Returns / Vendor BUn

0CPTRETVBU

InfoObject

Total Returns / Vendor Number of Items

0CPTRETVNI

InfoObject

Returns Total / Vendor Cost Value

0CPTRETVPV

InfoObject

Issues from Valuated Stock Total / BUn

0CPTSTISBU

InfoObject

Total Issues from Valuated Stock / Cost Value

0CPTSTISPV

InfoObject

Receipts to Valuated Stock Total / BUn

0CPTSTREBU

InfoObject

Total Receipts to Valuated Stock / Cost Value

0CPTSTREPV

InfoObject

Local currency

0LOC_CURRCY

InfoObject

Material

0MATERIAL

InfoObject

Plant Material

0MAT_PLANT

InfoObject

Plant

0PLANT

InfoObject

Record type

0RECORDTP

InfoObject

Request ID

0REQUID

InfoObject

Sales / Retail Value with Tax

0RTBAINSAST

InfoObject

Sales / Retail Value

0RTBAINSASV

InfoObject

GI / DC RtlT

0RTGOISDCST

InfoObject

Goods Issue / DC Retail Value

0RTGOISDCSV

InfoObject

GR / DC / RtlT

0RTGOREDCST

InfoObject

GR / DC Rtl

0RTGOREDCSV

InfoObject

GR Posting Date / Vendor RtlT

0RTGRPDVST

InfoObject

Goods Receipt Posting Date/Vendor Retail Value

0RTGRPDVSV

InfoObject

Sales Deviation

0RTINSADIST

InfoObject

Merchandise Clearing Output / RtlT

0RTMCAODDST

InfoObject

Outbound Merchandise Clearing / Rtl

0RTMCAODDSV

InfoObject

Merchandise Clearing Input / RtlT

0RTMCINDDST

InfoObject

Merchandise Clearing Input / Retail Value

0RTMCINDDSV

InfoObject

Purchase Order Delivery Date/Vendor RtlT

0RTPODDVST

InfoObject

PO Delivery Date / Vendor Retail Value

0RTPODDVSV

InfoObject

Promotion Sales /BUn

0RTPRINSABU

InfoObject

Promotion Sales / Number of Items

0RTPRINSANI

InfoObject

Promotion Sales / Cost Value

0RTPRINSAPV

InfoObject

Promotion Sales / Retail Value with Tax

0RTPRINSAST

InfoObject

Promotion Sales / Retail

0RTPRINSASV

InfoObject

Value-Based Sales, RtlT

0RTSALEEVST

InfoObject

Sales Value at Retail

0RTSALEEVSV

InfoObject

Revaluation at Retail (Negative)/ Retail Value with Tax

0RTSPRENST

InfoObject

Revaluation at Retail (Negative)/ Retail Value

0RTSPRENSV

InfoObject

Revaluation at Retail (Positive)/ Retail Value with Tax

0RTSPREPST

InfoObject

Revaluation at Retail (Positive) / Retail Value

0RTSPREPSV

InfoObject

Total GR / Vendor RtlT

0RTTGOREVST

InfoObject

Total Goods Receipt / Vendor Retail Value

0RTTGOREVSV

InfoObject

Stock Correction Total (-) / RtlT

0RTTINCONST

InfoObject

Stock Correction Total (-) / Retail

0RTTINCONSV

InfoObject

Stock Correction Total (+) / RtlT

0RTTINCOPST

InfoObject

Stock Correction Total (+) / Retail

0RTTINCOPSV

InfoObject

Total Valuated Stock - / RtlT

0RTTOTSTOST

InfoObject

Total Valuated Stock / Rtl

0RTTOTSTOSV

InfoObject

Total Returns / Vendor Retail Value with Tax

0RTTRETVST

InfoObject

Total Returns / Vendor Retail Value

0RTTRETVSV

InfoObject

Total Issues Valuated Stock / Retail Value with Tax

0RTTSTISST

InfoObject

Total Issues from Valuated Stock / Retail Value

0RTTSTISSV

InfoObject

Total Receipts Valuated Stock / Retail Value with Tax

0RTTSTREST

InfoObject

Total Receipts to Valuated Stock / Retail Value

0RTTSTRESV

InfoObject

Material Number linked to Retail_Activity

0RT_MAT_PRM

InfoObject

Promotion

0RT_PROMO