S120BIWS SAP (S120BIWS * Sales as per Receipts) Structure details
Description: S120BIWS * Sales as per Receipts
Structure field list including key, data, relationships and ABAP select examples
S120BIWS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "S120BIWS * Sales as per Receipts" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_S120BIWS TYPE S120BIWS.
The S120BIWS table consists of various fields, each holding specific information or linking keys about S120BIWS * Sales as per Receipts data available in SAP. These include WRTTP (Value type for Reporting), VRSIO (Version number in the information structure), SPMON (Calendar year / month), SPTAG (Calendar day).. 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: Not classified
SAP S120BIWS structure 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 |
STORNO | Indicator: Data to Be Canceled | STORNO | CHAR | 1 | CHAR1_X | ||||
WRTTP | Value type for Reporting | RSVTYPE | NUMC | 3 | Assigned to domain | RSVTYPE | |||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
SPMON | Calendar year / month | RSCALMONTH | NUMC | 6 | PERI6 | RSCALMONTH | |||
SPTAG | Calendar day | RSCALDAY | DATS | 8 | DATUM | ||||
SPWOC | Calendar year / week | RSCALWEEK | NUMC | 6 | PERI6 | RSCALWEEK | |||
SPBUP | Fiscal year / period | RSFISCPER | NUMC | 7 | PERI7 | RSFISCPER | |||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
KSKRS | POS controller | W_KSKRS | NUMC | 5 | W_KSKRS | ||||
KASNR | POS number | W_KASNR | NUMC | 10 | KASNR | ||||
BONNR | Transaction number (till receipt) | W_BONNR | NUMC | 15 | W_BONNR | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
EANNR | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
KSCHL | Condition type, sales | V_KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
KVORG | Transact. type | POSUVORG | CHAR | 4 | Assigned to domain | POSUVORG | |||
CONDNR | Consecutive condition number | MCW_CONDNR | NUMC | 6 | NUMC6 | ||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BASME | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
VKMNG | Transaction sales - quantity in sales unit | W_VKMNG | QUAN | 15(3) | MENGV15_3 | ||||
UMSMNG | Transaction sales - quantity in base unit of measure | W_UMSMNG | QUAN | 15(3) | MENGV15_3 | ||||
UMSGVP | Retail price w/tax from sales as per receipts/aggreg.sales | W_UMSVPM | CURR | 19(2) | WERTV10 | ||||
UMSGVO | Rtl price from sales as per receipts/aggreg.sales | W_UMSVPO | CURR | 19(2) | WERTV10 | ||||
UMSGEO_01 | Sales transactions (till receipts) at cost | W_UMSEP | CURR | 19(2) | WERTV10 | ||||
PRSNLS | Price reduction from sales as per receipts/aggregated sales | W_PRSNLS | CURR | 19(2) | WERTV10 | ||||
PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | W_PDIFF | CURR | 19(2) | WERTV10 | ||||
AZBON | Number of transactions from sales as per till receipts | W_AZBON | DEC | 11 | BCSP6 | ||||
BONPOS | No. of material items per transaction (till receipt) | W_BONPOS | DEC | 12(3) | DEC9_3 | ||||
AKTNR | COUPON | WAKTION | CHAR | 10 | Assigned to domain | ALPHA | WAKTION | WAK | |
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
VKSTD | Hour of sale | W_VKSTD | NUMC | 2 | W_VKSTD | ||||
ZMTTL | Payment method as condition | W_ZAHLART | CHAR | 4 | Assigned to domain | KSCHL | |||
KUNNR | Customer number | KUND1 | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KTONR | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BNKLZ | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
CCINS | Payment cards: Card type | CCINS | CHAR | 4 | Assigned to domain | CCINS | |||
CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | Assigned to domain | CCNUM | |||
KRFNR | Card Sequence Number | POSKARFNR | CHAR | 15 | CHAR15 | ||||
BZIRK | Sales district | W_BEZIRK | CHAR | 6 | Assigned to domain | BZIRK | |||
EZEIT | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
KASNAM | Cashier name | W_KASNAM | CHAR | 35 | CHAR35 | ||||
KKENN | Condition type identification | W_KKENN | CHAR | 1 | W_KKENN | ||||
ZMUMS | Means of payment sales from sales as per receipts/aggr.sales | W_ZMUMS | CURR | 19(2) | WERTV10 | ||||
SERNR | BOM Explosion Number | W_SERNR | CHAR | 25 | CHAR25 | ||||
KUNDK | Customer ID | W_KUNDK | CHAR | 1 | W_KUNDK | ||||
ANZCOND | Number of conditions from sales as per receipt/aggregated | W_ANZCOND | DEC | 11 | BCSP6 | ||||
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
VKFNR | Salesperson number | W_VKFNR | NUMC | 8 | PERNR | ||||
PRVBT | Commission amount, sales | W_PRVBT | CURR | 19(2) | WERTV10 | ||||
UMART | Sales type (sales/returns/empties) | W_UMART | CHAR | 1 | CHAR1 | ||||
DUMMY1 | Dummy element 1 POS (10 characters) | W_DUMMY1 | CHAR | 6 | CHAR6 | ||||
DUMMY2 | Dummy element 2 POS (10 characters) | W_DUMMY2 | CHAR | 4 | CHAR4 | ||||
DUMMY3 | Dummy element 3 POS (10 characters) | W_DUMMY3 | CHAR | 4 | CHAR4 | ||||
DUMMY4 | Dummy element 4 POS (10 characters) | W_DUMMY4 | CHAR | 10 | CHAR10 | ||||
DUMMY5 | Dummy element 5 POS (10 characters) | W_DUMMY5 | CHAR | 10 | CHAR10 | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
KBDNR | Cashier number | W_KBDNR | NUMC | 8 | PERNR | ||||
CONDID | Condition Type Identification | W_CONDID | CHAR | 20 | CHAR20 | ||||
PAYDIR | Direction of payment type (outbound/inbound) | W_PAYDIR | CHAR | 1 | W_PAYDIR |
Key field | Non-key field |
How do I retrieve data from SAP structure S120BIWS using ABAP code?
As S120BIWS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on S120BIWS as there is no data to select.How to access SAP table S120BIWS
Within an ECC or HANA version of SAP you can also view further information about S120BIWS 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