S120BIW1 - S120BIW1 * Sales as Per Receipts
S120BIW1 * Sales as Per Receipts information is stored in SAP table S120BIW1.
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 S120BIW1
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | T001W |
| KSKRS | POS controller | X | W_KSKRS | NUMC | 10 | |
| KASNR | POS number | X | W_KASNR | NUMC | 20 | |
| BONNR | Transaction number (till receipt) | X | W_BONNR | NUMC | 30 | |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| EANNR | International Article Number (EAN/UPC) | X | EAN11 | CHAR | 36 | |
| KSCHL | Condition type, sales | X | V_KSCHA | CHAR | 8 | T685 |
| KVORG | Transact. type | X | POSUVORG | CHAR | 8 | TWPPB |
| CONDNR | Consecutive condition number | X | MCW_CONDNR | NUMC | 12 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| VRKME | Sales unit | VRKME | UNIT | 6 | T006 | |
| BASME | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| WAERK | SD Document Currency | WAERK | CUKY | 10 | TCURC | |
| VKMNG | Transaction sales - quantity in sales unit | W_VKMNG | QUAN | 8 | ||
| UMSMNG | Transaction sales - quantity in base unit of measure | W_UMSMNG | QUAN | 8 | ||
| UMSGVP | Retail price w/tax from sales as per receipts/aggreg.sales | W_UMSVPM | CURR | 10 | ||
| UMSGVO | Rtl price from sales as per receipts/aggreg.sales | W_UMSVPO | CURR | 10 | ||
| UMSGEO_01 | Sales transactions (till receipts) at cost | W_UMSEP | CURR | 10 | ||
| PRSNLS | Price reduction from sales as per receipts/aggregated sales | W_PRSNLS | CURR | 10 | ||
| PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | W_PDIFF | CURR | 10 | ||
| AZBON | Number of transactions from sales as per till receipts | W_AZBON | DEC | 6 | ||
| BONPOS | No. of material items per transaction (till receipt) | W_BONPOS | DEC | 7 | ||
| AKTNR | Promotion | WAKTION | CHAR | 20 | WAKH | |
| MATKL | Material Group | MATKL | CHAR | 18 | T023 | |
| VKSTD | Hour of sale | W_VKSTD | NUMC | 4 | ||
| KUNNR | Customer number | KUND1 | CHAR | 20 | KNA1 | |
| KTONR | Bank account number | BANKN | CHAR | 36 | ||
| BNKLZ | Bank Keys | BANKK | CHAR | 30 | ||
| CCINS | Payment cards: Card type | CCINS | CHAR | 8 | TVCIN | |
| CCNUM | Payment cards: Card number | CCNUM | CHAR | 50 | VCNUM | |
| KRFNR | Card Sequence Number | POSKARFNR | CHAR | 30 | ||
| BZIRK | Sales district | W_BEZIRK | CHAR | 12 | T171 | |
| EZEIT | Entry time | ERZET | TIMS | 12 | ||
| KASNAM | Cashier name | W_KASNAM | CHAR | 70 | ||
| KKENN | Condition type identification | W_KKENN | CHAR | 2 | ||
| SERNR | BOM Explosion Number | W_SERNR | CHAR | 50 | ||
| KUNDK | Customer ID | W_KUNDK | CHAR | 2 | ||
| ANZCOND | Number of conditions from sales as per receipt/aggregated | W_ANZCOND | DEC | 6 | ||
| VKGRP | Sales group | VKGRP | CHAR | 6 | TVKGR | |
| VKFNR | Salesperson number | W_VKFNR | NUMC | 16 | ||
| PRVBT | Commission amount, sales | W_PRVBT | CURR | 10 | ||
| UMART | Sales type (sales/returns/empties) | W_UMART | CHAR | 2 | ||
| DUMMY1 | Dummy element 1 POS (10 characters) | W_DUMMY1 | CHAR | 12 | ||
| DUMMY2 | Dummy element 2 POS (10 characters) | W_DUMMY2 | CHAR | 8 | ||
| DUMMY3 | Dummy element 3 POS (10 characters) | W_DUMMY3 | CHAR | 8 | ||
| DUMMY4 | Dummy element 4 POS (10 characters) | W_DUMMY4 | CHAR | 20 | ||
| DUMMY5 | Dummy element 5 POS (10 characters) | W_DUMMY5 | CHAR | 20 | ||
| VKORG | Sales Organization | VKORG | CHAR | 8 | TVKO | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 4 | TVTW | |
| KBDNR | Cashier number | W_KBDNR | NUMC | 16 | ||
| CONDID | Condition Type Identification | W_CONDID | CHAR | 40 | ||
| PAYDIR | Direction of payment type (outbound/inbound) | W_PAYDIR | CHAR | 2 | ||
| UMSGVC | Retail price from sales without manufacturer's coupons | W_UMSVPC | CURR | 10 | ||
| BBYNR | Bonus buy | BBYNR | CHAR | 24 | KONBBYH |