SAP Table S120BIW2
S120BIW2 * Sales as Per Receipts
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table S120BIW2 (S120BIW2 * Sales as Per Receipts) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S120BIW2 |
| Short Text | S120BIW2 * Sales as Per Receipts |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S120BIW2
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SPTAG | ✔ | Period to analyze - current date | SPTAG | DATS | 8 | |
| WERKS | ✔ | Plant | WERKS_D | CHAR | 4 | T001W |
| KSKRS | ✔ | POS controller | W_KSKRS | NUMC | 5 | |
| KASNR | ✔ | POS number | W_KASNR | NUMC | 10 | |
| BONNR | ✔ | Transaction number (till receipt) | W_BONNR | NUMC | 15 | |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| EANNR | ✔ | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | |
| KSCHL | ✔ | Condition type, sales | V_KSCHA | CHAR | 4 | T685 |
| KVORG | ✔ | Transact. type | POSUVORG | CHAR | 4 | TWPPB |
| CONDNR | ✔ | Consecutive condition number | MCW_CONDNR | NUMC | 6 | |
| VRSIO | ✔ | Version number in the information structure | VRSIO | CHAR | 3 | * |
| SPMON | ✔ | Period to analyze - month | SPMON | NUMC | 6 | |
| 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 | ||
| VRKME | Sales unit | VRKME | UNIT | 3 | T006 | |
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | |
| VKMNG | Transaction sales - quantity in sales unit | W_VKMNG | QUAN | 15 | ||
| UMSMNG | Transaction sales - quantity in base unit of measure | W_UMSMNG | QUAN | 15 | ||
| UMSGVP | Retail price w/tax from sales as per receipts/aggreg.sales | W_UMSVPM | CURR | 19 | ||
| UMSGVO | Rtl price from sales as per receipts/aggreg.sales | W_UMSVPO | CURR | 19 | ||
| UMSGEO_01 | Sales transactions (till receipts) at cost | W_UMSEP | CURR | 19 | ||
| PRSNLS | Price reduction from sales as per receipts/aggregated sales | W_PRSNLS | CURR | 19 | ||
| PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | W_PDIFF | CURR | 19 | ||
| AZBON | Number of transactions from sales as per till receipts | W_AZBON | DEC | 11 | ||
| BONPOS | No. of material items per transaction (till receipt) | W_BONPOS | DEC | 12 | ||
| MATKL | Material Group | MATKL | CHAR | 9 | T023 | |
| VKSTD | Hour of sale | W_VKSTD | NUMC | 2 | ||
| ZMTTL | Payment method as condition | W_ZAHLART | CHAR | 4 | T685 | |
| KUNNR | Customer number | KUND1 | CHAR | 10 | KNA1 | |
| KTONR | Bank account number | BANKN | CHAR | 18 | ||
| BNKLZ | Bank Keys | BANKK | CHAR | 15 | ||
| CCINS | Payment cards: Card type | CCINS | CHAR | 4 | TVCIN | |
| CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | VCNUM | |
| KRFNR | Card Sequence Number | POSKARFNR | CHAR | 15 | ||
| BZIRK | Sales district | W_BEZIRK | CHAR | 6 | T171 | |
| EZEIT | Entry time | ERZET | TIMS | 6 | ||
| KASNAM | Cashier name | W_KASNAM | CHAR | 35 | ||
| KKENN | Condition type identification | W_KKENN | CHAR | 1 | ||
| ZMUMS | Means of payment sales from sales as per receipts/aggr.sales | W_ZMUMS | CURR | 19 | ||
| SERNR | BOM Explosion Number | W_SERNR | CHAR | 25 | ||
| KUNDK | Customer ID | W_KUNDK | CHAR | 1 | ||
| ANZCOND | Number of conditions from sales as per receipt/aggregated | W_ANZCOND | DEC | 11 | ||
| VKGRP | Sales Group | VKGRP | CHAR | 3 | TVKGR | |
| VKFNR | Salesperson number | W_VKFNR | NUMC | 8 | ||
| PRVBT | Commission amount, sales | W_PRVBT | CURR | 19 | ||
| UMART | Sales type (sales/returns/empties) | W_UMART | CHAR | 1 | ||
| DUMMY1 | Dummy element 1 POS (10 characters) | W_DUMMY1 | CHAR | 6 | ||
| DUMMY2 | Dummy element 2 POS (10 characters) | W_DUMMY2 | CHAR | 4 | ||
| DUMMY3 | Dummy element 3 POS (10 characters) | W_DUMMY3 | CHAR | 4 | ||
| DUMMY4 | Dummy element 4 POS (10 characters) | W_DUMMY4 | CHAR | 10 | ||
| DUMMY5 | Dummy element 5 POS (10 characters) | W_DUMMY5 | CHAR | 10 | ||
| VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | |
| KBDNR | Cashier number | W_KBDNR | NUMC | 8 | ||
| CONDID | Condition Type Identification | W_CONDID | CHAR | 20 | ||
| PAYDIR | Direction of payment type (outbound/inbound) | W_PAYDIR | CHAR | 1 | ||
| UMSGVC | Retail price from sales without manufacturer's coupons | W_UMSVPC | CURR | 19 | ||
| BBYNR | Bonus buy | BBYNR | CHAR | 12 | KONBBYH |