| MANDT |
✔ |
Client |
MANDT |
CLNT |
3 |
T000 |
| SPMON |
✔ |
Period to analyze - month |
SPMON |
NUMC |
6 |
|
| WERKS |
✔ |
Plant |
WERKS_D |
CHAR |
4 |
T001W |
| KBDNR |
✔ |
Cashier number |
W_KBDNR |
NUMC |
8 |
|
| KASNR |
✔ |
POS number |
W_KASNR |
NUMC |
10 |
|
| KSKRS |
✔ |
POS controller |
W_KSKRS |
NUMC |
5 |
|
| KSCHL |
✔ |
Condition type, sales |
V_KSCHA |
CHAR |
4 |
T685 |
| KVORG |
✔ |
Transact. type |
POSUVORG |
CHAR |
4 |
TWPPB |
| VRSIO |
✔ |
Version number in the information structure |
VRSIO |
CHAR |
3 |
* |
| SPTAG |
✔ |
Period to analyze - current date |
SPTAG |
DATS |
8 |
|
| SPWOC |
✔ |
Period to analyze - week |
SPWOC |
NUMC |
6 |
|
| SPBUP |
✔ |
Period to analyze - posting period |
SPBUP |
NUMC |
6 |
|
| SSOUR |
✔ |
Statistic(s) origin |
SSOUR |
CHAR |
4 |
|
| PERIV |
|
Fiscal Year Variant |
PERIV |
CHAR |
2 |
* |
| VWDAT |
|
Pointer to administrative data |
VWDAT |
NUMC |
10 |
|
| WAERK |
|
SD Document Currency |
WAERK |
CUKY |
5 |
TCURC |
| WRUMS |
|
Retail price with tax from cashier statistics |
C_UMSVPM |
CURR |
19 |
|
| UMSGVO |
|
Retail price without tax from cashier statistics |
C_UMSVPO |
CURR |
19 |
|
| PRSNLS |
|
Price reduction based on cashier statistics |
C_PRSNLS |
CURR |
19 |
|
| PDIFF |
|
Cashier: price difference between R/3 -> and POS rtl price |
C_PDIFF |
CURR |
19 |
|
| KBSOL |
|
Means of payment target amount |
W_KBSOL |
CURR |
19 |
|
| KBIST |
|
Means of payment actual amount |
W_KBIST |
CURR |
19 |
|
| KDNEG |
|
Negative till difference |
W_KDNEG |
CURR |
19 |
|
| KDPOS |
|
Positive till difference |
W_KDPOS |
CURR |
19 |
|
| AZBON |
|
Number of transactions based on cashier statistics |
C_ANZBON |
DEC |
11 |
|
| AZPOS |
|
Number of items based on cashier statistics |
C_ANZPOS |
DEC |
11 |
|
| AZBST |
|
Number of canceled transactions (till receipts) |
W_AZBST |
DEC |
7 |
|
| ANZCOND |
|
Number of conditions based on cashier statistics |
C_ANZCOND |
DEC |
11 |
|
| WRBST |
|
Value of canceled transactions (till receipts) |
W_WRBST |
CURR |
19 |
|
| AZSST |
|
Number of immediate cancellations |
W_AZSST |
DEC |
7 |
|
| WRSST |
|
Value of immediate cancellations |
W_WRSST |
CURR |
19 |
|
| AZZST |
|
Number of line cancelations |
W_AZZST |
DEC |
7 |
|
| WRZST |
|
Value of cancelled lines |
W_WRZST |
CURR |
19 |
|
| AZSCA |
|
Number of materials scanned |
W_AZSCA |
DEC |
7 |
|
| AZWGV |
|
Number of material group sales |
W_AZWGV |
DEC |
7 |
|
| AZABB |
|
Number of terminations |
W_AZABB |
DEC |
7 |
|
| WRABB |
|
Value of terminations |
W_WRABB |
CURR |
19 |
|
| AZABS |
|
Number of times till has been emptied (cash removals) |
W_AZABS |
DEC |
7 |
|
| UMABS |
|
Cash removed |
W_UMABS |
CURR |
19 |
|
| AZSUL |
|
Number of checks over limit |
W_AZSUL |
DEC |
7 |
|
| WRSUL |
|
Value of checks over the limit |
W_WRSUL |
CURR |
19 |
|
| AMDZT |
|
Logon time |
W_AMDZT |
DEC |
17 |
|
| REGZT |
|
Register time |
W_REGZT |
DEC |
17 |
|
| AZBRT |
|
Number of reports |
W_AZBRT |
DEC |
7 |
|
| WRSCA |
|
Value of scanned material |
W_WRSCA |
CURR |
19 |
|
| WRWGV |
|
Value of material group sales |
W_WRWGV |
CURR |
19 |
|
| AZKSB |
|
Number of times till drawer was opened |
W_AZKSB |
DEC |
7 |
|
| AZFAV |
|
Number of failed logon attempts |
W_AZFAV |
DEC |
7 |
|
| BNKUMS |
|
Bank business volume |
W_BNKUMS |
CURR |
19 |
|
| KASNAM |
|
Cashier name |
W_KASNAM |
CHAR |
35 |
|
| KKENN |
|
Condition type identification |
W_KKENN |
CHAR |
1 |
|
| BZIRK |
|
Sales district |
W_BEZIRK |
CHAR |
6 |
T171 |
| VKORG |
|
Sales Organization |
VKORG |
CHAR |
4 |
TVKO |
| VTWEG |
|
Distribution Channel |
VTWEG |
CHAR |
2 |
TVTW |
| UMSGVP |
|
Retail price w/tax from sales as per receipts/aggreg.sales |
W_UMSVPM |
CURR |
19 |
|
| UMSGVO_01 |
|
Rtl price from sales as per receipts/aggreg.sales |
W_UMSVPO |
CURR |
19 |
|
| PRSNLS_02 |
|
Price reduction from sales as per receipts/aggregated sales |
W_PRSNLS |
CURR |
19 |
|
| PDIFF_03 |
|
Trnsctn price diff. between R/3 -> and sales price at POS |
W_PDIFF |
CURR |
19 |
|
| ZMUMS |
|
Means of payment sales from sales as per receipts/aggr.sales |
W_ZMUMS |
CURR |
19 |
|
| ANZPOS |
|
Number of items from sales as per receipts/aggregated sales |
W_ANZPOS |
DEC |
11 |
|
| AZBON_04 |
|
Number of transactions from sales as per till receipts |
W_AZBON |
DEC |
11 |
|
| ANZCOND_05 |
|
Number of conditions from sales as per receipt/aggregated |
W_ANZCOND |
DEC |
11 |
|