Sales 
Analytic View: sap.is.retail.posdm.AN_SALES
Used to calculate gross sales, net sales and discounts.
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 |
ROWKEY |
A |
Row key |
No |
|
/POSDW/TLOGF |
TRANSINDEX |
A |
Transaction Index |
No |
|
/POSDW/TLOGF |
BUSINESSDAYDATE |
A |
Business Day Date |
No |
|
/POSDW/TLOGF |
RETAILSTOREID |
A |
Store |
No |
|
/POSDW/TLOGF |
TRANSCURRENCY |
A |
Transaction Currency |
No |
|
/POSDW/TLOGF |
TRANSTYPECODE |
A |
Transaction Type Code |
No |
|
/POSDW/TLOGF |
BEGINTIME |
A |
Begin Time |
No |
|
/POSDW/TLOGF |
BEGINDATE |
A |
Begin Date |
No |
|
/POSDW/TLOGF |
RETAILTYPECODE |
A |
Sales Item Type |
No |
|
/POSDW/TLOGF |
ITEMID |
A |
Article Identifier |
No |
|
/POSDW/TLOGF |
MERCHANDISECAT |
A |
Material Group |
No |
|
/POSDW/TLOGF |
PROMOTIONID |
A |
Promotion ID |
No |
|
/POSDW/TLOGF |
CALWEEK |
A |
Calendar Week |
No |
|
/POSDW/TLOGF |
CALHOUR |
A |
Calendar Hour |
No |
|
/POSDW/TLOGF |
CALDAY |
A |
Calendar Day |
No |
|
/POSDW/TLOGF |
CALMONTH |
A |
Calendar Month |
No |
|
/POSDW/TLOGF |
CALYEAR |
A |
Calendar Year |
No |
|
/POSDW/TLOGF |
DATASTATUS |
A |
Data Status |
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 |
BUSINESSTYPE |
A |
Business Transaction Type |
No |
|
/POSDW/TLOGF |
TRANSDEBITFLAG |
A |
Debit/Credit Indicator |
No |
|
/POSDW/TLOGF |
TASK_CANCELED |
A |
Transaction Canceled via Task |
No |
|
/POSDW/TLOGF |
ITEMIDQUALIFIER |
A |
Qualifier for Article Identifier |
No |
|
/POSDW/TLOGF |
MATERIALNUMBER |
A |
Material Number |
No |
|
/POSDW/TLOGF |
TAXINC |
M |
Tax Included |
No |
|
/POSDW/TLOGF |
SALESAMOUNT |
M |
Sales Amount |
No |
|
/POSDW/TLOGF |
ITEMDISC |
M |
Item Discount |
No |
|
/POSDW/TLOGF |
DISTDISC |
M |
Distributed Discount |
No |
|
/POSDW/TLOGF |
DISTTAX |
M |
Distributed Header Tax |
No |