S069 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of S069 in SAP.
- Table description : Material Statistics
- 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 S069 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SSOUR | Statistic(s) origin | SSOUR | SSOUR |
| VRSIO | Version number in the information structure | VRSIO | VRSIO |
| SPMON | Period to analyze - month | SPMON | MCPERIOD |
| SPTAG | Period to analyze - current date | SPTAG | DATUM |
| SPWOC | Period to analyze - week | SPWOC | MCPERIOD |
| SPBUP | Period to analyze - posting period | SPBUP | MCPERIOD |
| MATNR | Material Number | MATNR | MATNR |
| ART | Inspection Type | QPART | QPART |
| WERK | Plant | WERKS_D | WERKS |
| PERIV | Fiscal Year Variant | PERIV | PERIV |
| VWDAT | Pointer to administrative data | VWDAT | VWDAT |
| BASME_QM | Base Unit of Measure for The Inspection Lot Quantity | QLOSMENGEH | MEINS |
| PROME | Base Unit of Measure for the Sample Unit | QPROBEMGEH | MEINS |
| EHTAG | Lead Time Unit (Day) | QEINHTAG | MEINS |
| ZHLSELECT | Number of Summarized Inspection Lots (Without Cancellation) | QZHLSELECT | QANZAHL4 |
| ZHLANGENS | Number of Accepted Inspection Lots (Including Skips) | QZHLANGENS | QANZAHL4 |
| ZHLRUECK | Number of Rejected Inspection Lots | QZHLRUECK | QANZAHL4 |
| ZHLSKIP | Number of Skipped Inspection Lots | QZHLSKIP | QANZAHL4 |
| ZHLABBR | Number of Inspection Lots with Discontinued Inspections | QZHLABBR | QANZAHL4 |
| ZHLOFFMK | Number of Insp. Lots with Outstanding Long-Term Characs | QZHLOFFMK | QANZAHL4 |
| SMGSELECT | Cumulated Quantity of Summarized Inspection Lots | QSMGSELECT | QKUMMENGE |
| SMGANGENS | Accumulated Quantity of Accepted Inspection Lots (with Skip) | QSMGANGENS | QKUMMENGE |
| SMGRUECK | Cumulated Quantity of Rejected Inspection Lots | QSMGRUECK | QKUMMENGE |
| SMGSKIP | Cumulated Quantity of Skipped Inspection Lots | QSMGSKIP | QKUMMENGE |
| SMGGEPRFT | Cumulated Sample Quantity | QSMGGEPRFT | QKUMMENGE |
| SMGGEPRFTI | Cumulated Sample Quantity (Actual) | QSMGGPRFTI | QKUMMENGE |
| SMGDIFF | Accumulated Qty Difference Between Target Qty and Actual Qty | QSMGDIFF | QKUMMENGE |
| SMGZERSTR | Cumulated Quantity Destroyed During Inspection | QSMGZERSTR | QKUMMENGE |
| SMGFREIBE | Accumulated Qty that Was Posted to Unrestricted-Use Stock | QSMGFREIBE | QKUMMENGE |
| SMGSCHRTT | Cumulated Quantity Posted to Scrap | QSMGSCHRTT | QKUMMENGE |
| SMGSTPR | Cumulated Quantity Posted to Sample | QSMGSTPR | QKUMMENGE |
| SMGSPERR | Cumulated Quantity Posted to Blocked Stock | QSMGSPERR | QKUMMENGE |
| SMGRUECKL | Cumulated Quantity Posted to Reserves | QSMGRUECKL | QKUMMENGE |
| SMGANDMAT | Cumulated Quantity that Was Posted to Another Material | QSMGANDMAT | QKUMMENGE |
| QKZDEF | Definition of Quality Score Classes | QQKZDEF | QQKZDEF |
| KLASSE_A | Absolute Frequency of Quality Score Class A | QKLASSE_A | QANZAHL4 |
| KLASSE_B | Absolute Frequency of Quality Score Class B | QKLASSE_B | QANZAHL4 |
| KLASSE_C | Absolute Frequency of Quality Score Class C | QKLASSE_C | QANZAHL4 |
| KLASSE_D | Absolute Frequency of Quality Score Class D | QKLASSE_D | QANZAHL4 |
| KLASSE_E | Absolute Frequency of Quality Score Class E | QKLASSE_E | QANZAHL4 |
| ZHLLOSQKZ | Number of Summarized Inspection Lots for Quality Score | QZHLLOSQKZ | QANZAHL4 |
| SUMQKZ | Total of Quality Scores | QSUMQKZ | QSTATWERT |
| SUM2QKZ | Square Total of Quality Score | QSUM2QKZ | QSTATWERT |
| ZHLLOSANTL | Number of Summarized Lots (Including Share of Scrap) | QZHLLOSANT | QANZAHL4 |
| SUMANTL | Total Share of Nonconforming Units | QSUMANTL | QSTATWERT |
| SUM2ANTL | Square Total of the Share of Nonconforming Units | QSUM2ANTL | QSTATWERT |
| ZHLLOSDR | Number of Summarized Inspection Lots (Lead Time) | QZHLLOSDR | QANZAHL4 |
| SUMDLZT | Total Lead Time | QSUMDLZT | QSTATWERT |
| SUM2DLZT | Square Total of Lead Time | QSUM2DLZT | QSTATWERT |
| SMGSCHL | Cumulated Inspected and Defective Quantity | QSMGSCHL | QKUMMENGE |
S069 related tables
| Table | Note |
|---|---|
| CNVCDMCUCIA_STAT | Statistics data collected from the Statistics system |
| ESH_QL_ST_STAT | Searchterm Statistics Table for Indexing of Statistics Data |
| S069 | Material Statistics |
| S435 | Statistics: Material Movements for Batches / NOT USED ANYM |
| TVSM | Material statistics groups |
| /BEV1/TSSTMATS | Statistics: Category/Material Status |
| /BEV1/TSSZTYP | Statistics: Categories for Material Assignment |
| /BEV1/TSSZTYPT | Statistics: Categories for Material Assignment |
| A101 | SOrg/DstCh/Material-Main Item/Material Pricing Group |
| A102 | SOrg/DstCh/Material Pricing Group-Main Item/Material |
| A265 | Standard Dummy Customer/Document Type/Material Grp/Material |
| A266 | Standard Dummy Customer/Material Group/Material Number |
| CAD_PARTS | Table for Assignment of Standard Material to Material Nos |
| J_1IMODDET | Modvat Determination Table (Input Material->Output Material) |
| KOTG401 | GG: Listing - Material entered / Material |
Condition is used for statistics Tables"statistics-relevant delivery date" TablesStatistics-relevant delivery date TablesExchange rate for statistics (exch.rate at time of creation) TablesStatistics update indicator (post in/post out) TablesUpdate group for statistics update TablesMaterial masterprofit center material master TablesMaterial master with profit center material master Tables
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