S122 SAP (Cashier) Table details
Dictionary Type: Table
Description: Cashier
Description: Cashier
Table field list including key, data, relationships and ABAP select examples
S122 is a standard SAP Table which is used to store Cashier data and is available within R/3 SAP systems depending on the version and release level.
The S122 table consists of various fields, each holding specific information or linking keys about Cashier data available in SAP. These include SPTAG (Period to analyze - current date), WERKS (Plant), KBDNR (Cashier number), KASNR (POS number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP S122 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
KBDNR | Cashier number | W_KBDNR | NUMC | 8 | PERNR | ||||
KASNR | POS number | W_KASNR | NUMC | 10 | KASNR | ||||
KSKRS | POS controller | W_KSKRS | NUMC | 5 | W_KSKRS | ||||
KSCHL | Condition type, sales | V_KSCHA | CHAR | 4 | T685 | KSCHL | VKS | ||
KVORG | Transact. type | POSUVORG | CHAR | 4 | TWPPB | POSUVORG | |||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | VWDAT | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
WRUMS | Retail price with tax from cashier statistics | C_UMSVPM | CURR | 19(2) | WERTV10 | ||||
UMSGVO | Retail price without tax from cashier statistics | C_UMSVPO | CURR | 19(2) | WERTV10 | ||||
PRSNLS | Price reduction based on cashier statistics | C_PRSNLS | CURR | 19(2) | WERTV10 | ||||
PDIFF | Cashier: price difference between R/3 -> and POS rtl price | C_PDIFF | CURR | 19(2) | WERTV10 | ||||
KBSOL | Means of payment target amount | W_KBSOL | CURR | 19(2) | WERTV10 | ||||
KBIST | Means of payment actual amount | W_KBIST | CURR | 19(2) | WERTV10 | ||||
KDNEG | Negative till difference | W_KDNEG | CURR | 19(2) | WERTV10 | ||||
KDPOS | Positive till difference | W_KDPOS | CURR | 19(2) | WERTV10 | ||||
AZBON | Number of transactions based on cashier statistics | C_ANZBON | DEC | 11 | BCSP6 | ||||
AZPOS | Number of items based on cashier statistics | C_ANZPOS | DEC | 11 | BCSP6 | ||||
AZBST | Number of canceled transactions (till receipts) | W_AZBST | DEC | 7 | BCSP4 | ||||
ANZCOND | Number of conditions based on cashier statistics | C_ANZCOND | DEC | 11 | BCSP6 | ||||
WRBST | Value of canceled transactions (till receipts) | W_WRBST | CURR | 19(2) | WERTV10 | ||||
AZSST | Number of immediate cancellations | W_AZSST | DEC | 7 | BCSP4 | ||||
WRSST | Value of immediate cancellations | W_WRSST | CURR | 19(2) | WERTV10 | ||||
AZZST | Number of line cancelations | W_AZZST | DEC | 7 | BCSP4 | ||||
WRZST | Value of cancelled lines | W_WRZST | CURR | 19(2) | WERTV10 | ||||
AZSCA | Number of materials scanned | W_AZSCA | DEC | 7 | BCSP4 | ||||
AZWGV | Number of material group sales | W_AZWGV | DEC | 7 | BCSP4 | ||||
AZABB | Number of terminations | W_AZABB | DEC | 7 | BCSP4 | ||||
WRABB | Value of terminations | W_WRABB | CURR | 19(2) | WERTV10 | ||||
AZABS | Number of times till has been emptied (cash removals) | W_AZABS | DEC | 7 | BCSP4 | ||||
UMABS | Cash removed | W_UMABS | CURR | 19(2) | WERTV10 | ||||
AZSUL | Number of checks over limit | W_AZSUL | DEC | 7 | BCSP4 | ||||
WRSUL | Value of checks over the limit | W_WRSUL | CURR | 19(2) | WERTV10 | ||||
AMDZT | Logon time | W_AMDZT | DEC | 17(5) | DEC17_5 | ||||
REGZT | Register time | W_REGZT | DEC | 17(5) | DEC17_5 | ||||
AZBRT | Number of reports | W_AZBRT | DEC | 7 | BCSP4 | ||||
WRSCA | Value of scanned material | W_WRSCA | CURR | 19(2) | WERTV10 | ||||
WRWGV | Value of material group sales | W_WRWGV | CURR | 19(2) | WERTV10 | ||||
AZKSB | Number of times till drawer was opened | W_AZKSB | DEC | 7 | BCSP4 | ||||
AZFAV | Number of failed logon attempts | W_AZFAV | DEC | 7 | BCSP4 | ||||
BNKUMS | Bank business volume | W_BNKUMS | CURR | 19(2) | WERTV10 | ||||
KASNAM | Cashier name | W_KASNAM | CHAR | 35 | CHAR35 | ||||
KKENN | Condition type identification | W_KKENN | CHAR | 1 | W_KKENN | ||||
BZIRK | Sales district | W_BEZIRK | CHAR | 6 | T171 | BZIRK | |||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
UMSGVP | Retail price w/tax from sales as per receipts/aggreg.sales | W_UMSVPM | CURR | 19(2) | WERTV10 | ||||
UMSGVO_01 | Rtl price from sales as per receipts/aggreg.sales | W_UMSVPO | CURR | 19(2) | WERTV10 | ||||
PRSNLS_02 | Price reduction from sales as per receipts/aggregated sales | W_PRSNLS | CURR | 19(2) | WERTV10 | ||||
PDIFF_03 | Trnsctn price diff. between R/3 -> and sales price at POS | W_PDIFF | CURR | 19(2) | WERTV10 | ||||
ZMUMS | Means of payment sales from sales as per receipts/aggr.sales | W_ZMUMS | CURR | 19(2) | WERTV10 | ||||
ANZPOS | Number of items from sales as per receipts/aggregated sales | W_ANZPOS | DEC | 11 | BCSP6 | ||||
AZBON_04 | Number of transactions from sales as per till receipts | W_AZBON | DEC | 11 | BCSP6 | ||||
ANZCOND_05 | Number of conditions from sales as per receipt/aggregated | W_ANZCOND | DEC | 11 | BCSP6 |
Key field | Non-key field |
How do I retrieve data from SAP table S122 using ABAP code
The following ABAP code Example will allow you to do a basic selection on S122 to SELECT all data from the tableDATA: WA_S122 TYPE S122.
SELECT SINGLE *
FROM S122
INTO CORRESPONDING FIELDS OF WA_S122
WHERE...
How to access SAP table S122
Within an ECC or HANA version of SAP you can also view further information about S122 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects