SAP Table S122BIW2
S122BIW2 * Cashier
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table S122BIW2 (S122BIW2 * Cashier) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S122BIW2 |
| Short Text | S122BIW2 * Cashier |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S122BIW2
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| 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 |