Show TOC

MultiProvider Weekly Cube Locate this document in the navigation structure

MultiProvider MultiProvider: 0RPA_MC22

 

This MultiProvider was developed within the TLOG Analytics Project to provide POS data for BW store manager reports from the PIPE. It is used as a basis for the different store manager reports and contains the basic cube 0RPA_C22 (Weekly Cube).

Data Modeling

Requires

Object Type

Name

Technical Name

InfoObject

Base Sales Quantity in Base Units of Measure

0BASE_QTY

InfoObject

Base Unit of Measure

0BASE_UOM

InfoObject

Calendar Year/Month

0CALMONTH

InfoObject

Calendar Year/Week

0CALWEEK

InfoObject

Calendar Year

0CALYEAR

InfoObject

Change Run ID

0CHNGID

InfoObject

Document currency

0DOC_CURRCY

InfoObject

Fiscal year / period

0FISCPER

InfoObject

Fiscal year variant

0FISCVARNT

InfoObject

Material

0MATERIAL

InfoObject

Record type

0RECORDTP

InfoObject

Request ID

0REQUID

InfoCube

POS DM Week

0RPA_C22

InfoObject

Number of Receipt Returns

0RPA_CNB

InfoObject

Number of POS Receipts

0RPA_CNR

InfoObject

Sales in Cost Value

0RPA_CST

InfoObject

Merchandise Sales at Cost

0RPA_CSTMER

InfoObject

Entry Method

0RPA_EMC

InfoObject

Currency for Sales Totals

0RPA_INDCUR

InfoObject

Cashier Number

0RPA_OID

InfoObject

Discount Value

0RPA_REA

InfoObject

Goods Discount Value

0RPA_REAMER

InfoObject

Goods Returns Value: Sales Price Without Value Added Tax

0RPA_RETMER

InfoObject

Return Sales

0RPA_RETSAL

InfoObject

POS: Returns Quantity (BUn)

0RPA_RQTYB

InfoObject

Sales at Retail Value

0RPA_SAT

InfoObject

Merchandise Sales at Retail

0RPA_SATMER

InfoObject

Tender Identifier

0RPA_TID

InfoObject

Transaction Index

0RPA_TIX

InfoObject

Total Turnover (Receipt Header) in Document Currency

0RPA_TRNOV

InfoObject

Payment Means Group

0RPA_TYG

InfoObject

Customer

0RT_CUST

InfoObject

Budget

0RT_HOUSH

InfoObject

Retail location

0RT_LOCATIO

InfoObject

Promotion

0RT_PROMO