S120BIW2 - S120BIW2 * Sales as Per Receipts
S120BIW2 * Sales as Per Receipts information is stored in SAP table S120BIW2.
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 S120BIW2
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 |