Markdown Sales 
Analytic View: sap.is.retail.posdm.AN_MARKDOWN_SALES
Used to calculate net sales for all markdown sales.
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 |
Posting 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 |
Time at which POS Transaction starts |
No |
|
/POSDW/TLOGF |
BEGINDATE |
A |
Date at which POS transaction starts |
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 |
Calender Week |
No |
|
/POSDW/TLOGF |
CALHOUR |
A |
Calender Hour |
No |
|
/POSDW/TLOGF |
CALDAY |
A |
Calender Day |
No |
|
/POSDW/TLOGF |
CALMONTH |
A |
Calender Month |
No |
|
/POSDW/TLOGF |
CALYEAR |
A |
Calender Year |
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 taxes |
No |
ID |
Description |
Formula |
Hidden |
|---|---|---|---|
MARKDOWN_SALES |
Markdown Sales Transactions Flag |
if( "DISTDISC" > 0 or "ITEMDISC" > 0 or strlen("PROMOTIONID") > 0, 0, 1) |
No |