S117 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of S117 in SAP.
- Table description : Receipt/article
- 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 S117 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SPTAG | Period to analyze - current date | SPTAG | DATUM |
| BONNR | Transaction number (till receipt) | W_BONNR | W_BONNR |
| WERKS | Plant | WERKS_D | WERKS |
| MATKL | Material Group | MATKL | MATKL |
| MATNR | Material Number | MATNR | MATNR |
| AFLAG | Promotion indicator | MCW_AFLAG | MCW_AFLAG |
| KALWOC | Calendar week | MCW_KALWOC | NUM02 |
| WOCHTG | Weekday | MCW_WOCHTG | DAYS17 |
| TGZTKL | Time of day class | MCW_TGZTKL | MCW_TGZTKL |
| VKSTD | Hour of sale | W_VKSTD | W_VKSTD |
| 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 |
| BASME | Base Unit of Measure | MEINS | MEINS |
| VRKME | Sales unit | VRKME | MEINS |
| WAERK | SD document currency | WAERK | WAERS |
| ATTYP | Material Category | ATTYP | ATTYP |
| MTART | Material type | MTART | MTART |
| PLGTP | Price band category | PLGTP | PLGTP |
| SAISO | Season Category | SAISO | SAISO |
| SAISJ | Season Year | SAISJ | CJAHR |
| SATNR | Cross-Plant Configurable Material | SATNR | MATNR |
| MAKTX | Material description | MAKTX | TEXT40 |
| AKTNR | Promotion | WAKTION | WAKTION |
| AKTYP | Promotion Category | W_AKTYP | AKTTY |
| AKTHE | Promotion theme | W_AKTHE | THEMA |
| WMINR | Product catalog number | WMINR | WMINR |
| KUNDK | Customer ID | W_KUNDK | W_KUNDK |
| KUNNR | Customer No. | KUND1 | KUNNR |
| CCNUM | Payment cards: Card number | CCNUM | CCNUM |
| UMSMNG | Transaction sales - quantity in base unit of measure | W_UMSMNG | MENGV15_3 |
| VKMNG | Transaction sales - quantity in sales unit | W_VKMNG | MENGV15_3 |
| UMSATZ | Sales POS | MCW_UMSATZ | WERTV10 |
| PRSNLS | Price reduction from sales as per receipts/aggregated sales | W_PRSNLS | WERTV10 |
| ANZPOS | Number of transaction items (till receipts) | MCW_ANZPOS | MCZAEHLINT |
| ANZAAR | Number of promotion items | MCW_ANZAAR | MCZAEHLINT |
| KMONAT | Calendar month | MCW_MONAT | AM_MONAT |
| QUARTAL | Quarter | MCW_QUARTL | NUM01 |
| JAHR | Year | MCJAHR | GJAHR |
| UHZEIT | Time sale was entered | MCW_UHZEIT | UZEIT |
S117 related tables
| Table | Note |
|---|---|
| FRE_ARTHIER_SKU | Article Hierarchy Article assignments |
| S117 | Receipt/article |
| CMMATGRP_CUST | Customizing Table for Article Hierarchy |
| CMMATGRP_HIER | Article Hierarchy Properties |
| CMMATGRP_HIERT | Article Hierarchy Description |
| CMMATGRP_SKU | Article Assignment Table |
| CRMC_KA_NOTETEXT | Maintenance Table for Knowledge Article Text |
| CRMC_KA_STATUS | Maintenance table for knowledge article status |
| CRMC_KA_TEXT_UI | Assign Knowledge Article Text to UI Attribute Name |
| DMF_D_ART_SITE | Transfer Status of Article/Site Combinations |
| DMF_D_MTART | Relevant Article Types |
| FRE_ARTHIER_STRU | Article Hierarchy Structure |
| FRE_DB_ART_SITE | Relevant article/site-combinations for F&R |
| FRE_REF_ART_SITE | Article/site-combination of ref. module for initial load |
| JKSD_ASORT_ITEMS | IS-M: Assignment of Contract Item to Article from Assortment |
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