S120 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of S120 in SAP.
- Table description : Sales as per receipts
- Module : CRM
- Parent Module : CRM
- Package : MCS
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP S120 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SPTAG | Period to analyze - current date | SPTAG | DATUM |
| WERKS | Plant | WERKS_D | WERKS |
| KSKRS | POS controller | W_KSKRS | W_KSKRS |
| KASNR | POS number | W_KASNR | KASNR |
| BONNR | Transaction number (till receipt) | W_BONNR | W_BONNR |
| MATNR | Material Number | MATNR | MATNR |
| EANNR | International Article Number (EAN/UPC) | EAN11 | EAN11 |
| KSCHL | Condition type, sales | V_KSCHA | KSCHL |
| KVORG | Transact. type | POSUVORG | POSUVORG |
| CONDNR | Consecutive condition number | MCW_CONDNR | NUMC6 |
| VRSIO | Version number in the information structure | VRSIO | VRSIO |
| SPMON | Period to analyze - month | SPMON | MCPERIOD |
| SPWOC | Period to analyze - week | SPWOC | MCPERIOD |
| SPBUP | Period to analyze - posting period | SPBUP | MCPERIOD |
| SSOUR | Statistic(s) origin | SSOUR | SSOUR |
| PERIV | Fiscal Year Variant | PERIV | PERIV |
| VWDAT | Pointer to administrative data | VWDAT | VWDAT |
| VRKME | Sales unit | VRKME | MEINS |
| BASME | Base Unit of Measure | MEINS | MEINS |
| WAERK | SD document currency | WAERK | WAERS |
| VKMNG | Transaction sales - quantity in sales unit | W_VKMNG | MENGV15_3 |
| UMSMNG | Transaction sales - quantity in base unit of measure | W_UMSMNG | MENGV15_3 |
| UMSGVP | Retail price w/tax from sales as per receipts/aggreg.sales | W_UMSVPM | WERTV10 |
| UMSGVO | Rtl price from sales as per receipts/aggreg.sales | W_UMSVPO | WERTV10 |
| UMSGEO_01 | Sales transactions (till receipts) at cost | W_UMSEP | WERTV10 |
| PRSNLS | Price reduction from sales as per receipts/aggregated sales | W_PRSNLS | WERTV10 |
| PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | W_PDIFF | WERTV10 |
| AZBON | Number of transactions from sales as per till receipts | W_AZBON | BCSP6 |
| BONPOS | No. of material items per transaction (till receipt) | W_BONPOS | DEC9_3 |
| AKTNR | Promotion | WAKTION | WAKTION |
| MATKL | Material Group | MATKL | MATKL |
| VKSTD | Hour of sale | W_VKSTD | W_VKSTD |
| ZMTTL | Payment method as condition | W_ZAHLART | KSCHL |
| KUNNR | Customer No. | KUND1 | KUNNR |
| KTONR | Bank account number | BANKN | BANKN |
| BNKLZ | Bank Keys | BANKK | BANKK |
| CCINS | Payment cards: Card type | CCINS | CCINS |
| CCNUM | Payment cards: Card number | CCNUM | CCNUM |
| KRFNR | Card Sequence Number | POSKARFNR | CHAR15 |
| BZIRK | Sales district | W_BEZIRK | BZIRK |
| EZEIT | Entry time | ERZET | UZEIT |
| KASNAM | Cashier name | W_KASNAM | CHAR35 |
| KKENN | Condition type identification | W_KKENN | W_KKENN |
| ZMUMS | Means of payment sales from sales as per receipts/aggr.sales | W_ZMUMS | WERTV10 |
| SERNR | BOM Explosion Number | W_SERNR | CHAR25 |
| KUNDK | Customer ID | W_KUNDK | W_KUNDK |
| ANZCOND | Number of conditions from sales as per receipt/aggregated | W_ANZCOND | BCSP6 |
| VKGRP | Sales group | VKGRP | VKGRP |
| VKFNR | Salesperson number | W_VKFNR | PERNR |
| PRVBT | Commission amount, sales | W_PRVBT | WERTV10 |
| UMART | Sales type (sales/returns/empties) | W_UMART | CHAR1 |
| DUMMY1 | Dummy element 1 POS (10 characters) | W_DUMMY1 | CHAR6 |
| DUMMY2 | Dummy element 2 POS (10 characters) | W_DUMMY2 | CHAR4 |
| DUMMY3 | Dummy element 3 POS (10 characters) | W_DUMMY3 | CHAR4 |
| DUMMY4 | Dummy element 4 POS (10 characters) | W_DUMMY4 | CHAR10 |
| DUMMY5 | Dummy element 5 POS (10 characters) | W_DUMMY5 | CHAR10 |
| VKORG | Sales Organization | VKORG | VKORG |
| VTWEG | Distribution Channel | VTWEG | VTWEG |
| KBDNR | Cashier number | W_KBDNR | PERNR |
| CONDID | Condition Type Identification | W_CONDID | CHAR20 |
| PAYDIR | Direction of payment type (outbound/inbound) | W_PAYDIR | W_PAYDIR |
| UMSGVC | Retail price from sales without manufacturer's coupons | W_UMSVPC | WERTV10 |
| BBYNR | Bonus buy | BBYNR | BBYNR |
S120 related tables
| Table | Note |
|---|---|
| S120 | Sales as per receipts |
| S120BIW1 | S120BIW1 * Sales as Per Receipts |
| S120BIW2 | S120BIW2 * Sales as Per Receipts |
| TWPIB | Transaction-type-based control of sales as per receipts POS |
| TWPIR | General control of upload of sales as per receipts POS |
| TWPPB | Transaction types for sales as per receipts |
| TWPPBT | Transaction types for sales as per receipts / description |
| CKMLMV003 | Process model: Receipts / mixing strategies |
| FAIBSV02 | Valuated Receipts |
| FITV_HINZ_WERB_B | Additional Amounts and Income-Related Expenses for Receipts |
| FITV_MEAL_ACCOM | Additional Amounts for Meals in Accommodations Receipts |
| FMFGBLDRVAREAMR | Derivation rule:Set Miscellaneous Receipts - Actuals (MIR) |
| JITOGR | Goods Receipts for JIT Outbound Calls |
| J_1BIV04 | Goods Receipts Passed to Notas Fiscais via Inv. Verification |
| J_1IRGSUM | RG23 Summary of receipts and issues |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP