Average Number of Items per Transaction 
Analytic View:sap.is.retail.posdm.AN_COUNT
Used to calculate the number of transactions and retail line items.
Prerequisites
SAP POS DM installed on SAP NetWeaver BW powered by SAP HANA and SAP HANA Business Content installed as described in SAP Note 1720277.
Data Modeling
Table |
Description |
|---|---|
/POSDW/TLOGF |
SAP POS DM POS transaction log table |
Table |
Field Name |
Attribute(A), Measure(M) |
Description |
Description Mapping |
Hidden |
|---|---|---|---|---|---|
/POSDW/TLOGF |
TRANSINDEX |
A |
Transaction Index |
No |
|
/POSDW/TLOGF |
BUSINESSDAYDATE |
A |
Posting Date |
No |
|
/POSDW/TLOGF |
RETAILSTOREID |
A |
Store |
No |
|
/POSDW/TLOGF |
BEGINTIME |
A |
Time on which POS Transactions starts |
No |
|
/POSDW/TLOGF |
BEGINDATE |
A |
Date on which POS Transactions Starts |
No |
|
/POSDW/TLOGF |
MERCHANDISECAT |
A |
Material group |
No |
|
/POSDW/TLOGF |
TRANSTYPECODE |
A |
Transaction Type |
No |
|
/POSDW/TLOGF |
RETAILTYPECODE |
A |
Sales Item Type |
No |
|
/POSDW/TLOGF |
ITEMID |
A |
Article Identifier |
No |
|
/POSDW/TLOGF |
CALWEEK |
A |
Calendar Week |
No |
|
/POSDW/TLOGF |
CALMONTH |
A |
Calendar Month |
No |
|
/POSDW/TLOGF |
CALYEAR |
A |
Calendar Year |
No |
|
/POSDW/TLOGF |
CALHOUR |
A |
Calendar hour |
No |
|
/POSDW/TLOGF |
CALDAY |
A |
Calendar day |
No |
|
/POSDW/TLOGF |
RETAILREASONCODE |
A |
Retail Reason Code |
No |
|
/POSDW/TLOGF |
DATASTATUS |
A |
Data Status |
No |
|
/POSDW/TLOGF |
BUSINESSTYPE |
A |
Business Transaction Type |
No |
|
/POSDW/TLOGF |
TRANSDEBITFLAG |
A |
Debit/Credit Indicator |
No |
|
/POSDW/TLOGF |
RETL_ITEM_CAT |
A |
Classification of Sales Item: Category |
No |
|
/POSDW/TLOGF |
RETL_ITEM_SCAT |
A |
Classification of POS Segments: Subcategory |
No |
|
/POSDW/TLOGF |
RETAILDEBITFLAG |
A |
Debit/Credit Indicator |
No |
|
/POSDW/TLOGF |
TASK_CANCELED |
A |
Transaction Cancelled via Task |
No |
|
/POSDW/TLOGF |
ITEMIDQUALIFIER |
A |
Qualifier for Article Identifier |
No |
|
/POSDW/TLOGF |
MATERIALNUMBER |
A |
Material Number |
No |
|
/POSDW/TLOGF |
SALESUOM |
A |
Sales Unit |
No |
|
/POSDW/TLOGF |
BASEUOM |
A |
Base Unit of Measure |
No |
|
/POSDW/TLOGF |
RETAILQUANTITY |
M |
Quantity in Sales Unit |
No |
|
/POSDW/TLOGF |
BASEQUANTITY |
M |
Quantity in Base Unit of Measure |
No |
ID |
Description |
Formula |
Hidden |
|---|---|---|---|
ALL_KEY |
Retailstoreid, Businessdaydate, Transindex |
"RETAILSTOREID"+string("BUSINESSDAYDATE")+string("TRANSINDEX") |
No |