S122 - Cashier
Cashier information is stored in SAP table S122.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S122
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 8 | |
| WERKS | Plant | X | WERKS_D | CHAR | 4 | T001W |
| KBDNR | Cashier number | X | W_KBDNR | NUMC | 8 | |
| KASNR | POS number | X | W_KASNR | NUMC | 10 | |
| KSKRS | POS controller | X | W_KSKRS | NUMC | 5 | |
| KSCHL | Condition type, sales | X | V_KSCHA | CHAR | 4 | T685 |
| KVORG | Transact. type | X | POSUVORG | CHAR | 4 | TWPPB |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 3 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 6 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 6 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 6 | |
| SSOUR | Statistic(s) origin | X | 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 | 10 | ||
| UMSGVO | Retail price without tax from cashier statistics | C_UMSVPO | CURR | 10 | ||
| PRSNLS | Price reduction based on cashier statistics | C_PRSNLS | CURR | 10 | ||
| PDIFF | Cashier: price difference between R/3 -> and POS rtl price | C_PDIFF | CURR | 10 | ||
| KBSOL | Means of payment target amount | W_KBSOL | CURR | 10 | ||
| KBIST | Means of payment actual amount | W_KBIST | CURR | 10 | ||
| KDNEG | Negative till difference | W_KDNEG | CURR | 10 | ||
| KDPOS | Positive till difference | W_KDPOS | CURR | 10 | ||
| AZBON | Number of transactions based on cashier statistics | C_ANZBON | DEC | 6 | ||
| AZPOS | Number of items based on cashier statistics | C_ANZPOS | DEC | 6 | ||
| AZBST | Number of canceled transactions (till receipts) | W_AZBST | DEC | 4 | ||
| ANZCOND | Number of conditions based on cashier statistics | C_ANZCOND | DEC | 6 | ||
| WRBST | Value of canceled transactions (till receipts) | W_WRBST | CURR | 10 | ||
| AZSST | Number of immediate cancellations | W_AZSST | DEC | 4 | ||
| WRSST | Value of immediate cancellations | W_WRSST | CURR | 10 | ||
| AZZST | Number of line cancelations | W_AZZST | DEC | 4 | ||
| WRZST | Value of cancelled lines | W_WRZST | CURR | 10 | ||
| AZSCA | Number of materials scanned | W_AZSCA | DEC | 4 | ||
| AZWGV | Number of material group sales | W_AZWGV | DEC | 4 | ||
| AZABB | Number of terminations | W_AZABB | DEC | 4 | ||
| WRABB | Value of terminations | W_WRABB | CURR | 10 | ||
| AZABS | Number of times till has been emptied (cash removals) | W_AZABS | DEC | 4 | ||
| UMABS | Cash removed | W_UMABS | CURR | 10 | ||
| AZSUL | Number of checks over limit | W_AZSUL | DEC | 4 | ||
| WRSUL | Value of checks over the limit | W_WRSUL | CURR | 10 | ||
| AMDZT | Logon time | W_AMDZT | DEC | 9 | ||
| REGZT | Register time | W_REGZT | DEC | 9 | ||
| AZBRT | Number of reports | W_AZBRT | DEC | 4 | ||
| WRSCA | Value of scanned material | W_WRSCA | CURR | 10 | ||
| WRWGV | Value of material group sales | W_WRWGV | CURR | 10 | ||
| AZKSB | Number of times till drawer was opened | W_AZKSB | DEC | 4 | ||
| AZFAV | Number of failed logon attempts | W_AZFAV | DEC | 4 | ||
| BNKUMS | Bank business volume | W_BNKUMS | CURR | 10 | ||
| 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 | 10 | ||
| UMSGVO_01 | Rtl price from sales as per receipts/aggreg.sales | W_UMSVPO | CURR | 10 | ||
| PRSNLS_02 | Price reduction from sales as per receipts/aggregated sales | W_PRSNLS | CURR | 10 | ||
| PDIFF_03 | Trnsctn price diff. between R/3 -> and sales price at POS | W_PDIFF | CURR | 10 | ||
| ANZPOS | Number of items from sales as per receipts/aggregated sales | W_ANZPOS | DEC | 6 | ||
| AZBON_04 | Number of transactions from sales as per till receipts | W_AZBON | DEC | 6 | ||
| ANZCOND_05 | Number of conditions from sales as per receipt/aggregated | W_ANZCOND | DEC | 6 |