S068 SAP (Vendor statistics) Table details

Dictionary Type: Table
Description: Vendor statistics




ABAP Code to SELECT data from S068
Related tables to S068
Access table S068




Table field list including key, data, relationships and ABAP select examples

S068 is a standard SAP Table which is used to store Vendor statistics data and is available within R/3 SAP systems depending on the version and release level.

The S068 table consists of various fields, each holding specific information or linking keys about Vendor statistics data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. 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: Cannot Be Enhanced


SAP S068 table 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
MANDTClient MANDTCLNT3T000MANDT
SSOURStatistic(s) origin SSOURCHAR4SSOUR
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
LIFNRVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
ARTInspection Type QPARTCHAR8TQ30QPARTQLA
WERKPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
BASME_QMBase Unit of Measure for The Inspection Lot Quantity QLOSMENGEHUNIT3T006CUNITMEINS
PROMEBase Unit of Measure for the Sample Unit QPROBEMGEHUNIT3T006CUNITMEINS
EHTAGLead Time Unit (Day) QEINHTAGUNIT3T006CUNITMEINS
ZHLSELECTNumber of Summarized Inspection Lots (Without Cancellation) QZHLSELECTINT410QANZAHL4
ZHLANGENSNumber of Accepted Inspection Lots (Including Skips) QZHLANGENSINT410QANZAHL4
ZHLRUECKNumber of Rejected Inspection Lots QZHLRUECKINT410QANZAHL4
ZHLSKIPNumber of Skipped Inspection Lots QZHLSKIPINT410QANZAHL4
ZHLABBRNumber of Inspection Lots with Discontinued Inspections QZHLABBRINT410QANZAHL4
ZHLOFFMKNumber of Insp. Lots with Outstanding Long-Term Characs QZHLOFFMKINT410QANZAHL4
SMGSELECTCumulated Quantity of Summarized Inspection Lots QSMGSELECTQUAN17(3) QKUMMENGE
SMGANGENSAccumulated Quantity of Accepted Inspection Lots (with Skip) QSMGANGENSQUAN17(3) QKUMMENGE
SMGRUECKCumulated Quantity of Rejected Inspection Lots QSMGRUECKQUAN17(3) QKUMMENGE
SMGSKIPCumulated Quantity of Skipped Inspection Lots QSMGSKIPQUAN17(3) QKUMMENGE
SMGGEPRFTCumulated Sample Quantity QSMGGEPRFTQUAN17(3) QKUMMENGE
SMGGEPRFTICumulated Sample Quantity (Actual) QSMGGPRFTIQUAN17(3) QKUMMENGE
SMGDIFFAccumulated Qty Difference Between Target Qty and Actual Qty QSMGDIFFQUAN17(3) QKUMMENGE
SMGZERSTRCumulated Quantity Destroyed During Inspection QSMGZERSTRQUAN17(3) QKUMMENGE
SMGFREIBEAccumulated Qty that Was Posted to Unrestricted-Use Stock QSMGFREIBEQUAN17(3) QKUMMENGE
SMGSCHRTTCumulated Quantity Posted to Scrap QSMGSCHRTTQUAN17(3) QKUMMENGE
SMGSTPRCumulated Quantity Posted to Sample QSMGSTPRQUAN17(3) QKUMMENGE
SMGSPERRCumulated Quantity Posted to Blocked Stock QSMGSPERRQUAN17(3) QKUMMENGE
SMGRUECKLCumulated Quantity Posted to Reserves QSMGRUECKLQUAN17(3) QKUMMENGE
SMGANDMATCumulated Quantity that Was Posted to Another Material QSMGANDMATQUAN17(3) QKUMMENGE
SMGRLIEFCumulated Quantity Posted Back to the Vendor QSMGRLIEFQUAN17(3) QKUMMENGE
QKZDEFDefinition of Quality Score Classes QQKZDEFCHAR2TQ56QQKZDEF
KLASSE_AAbsolute Frequency of Quality Score Class A QKLASSE_AINT410QANZAHL4
KLASSE_BAbsolute Frequency of Quality Score Class B QKLASSE_BINT410QANZAHL4
KLASSE_CAbsolute Frequency of Quality Score Class C QKLASSE_CINT410QANZAHL4
KLASSE_DAbsolute Frequency of Quality Score Class D QKLASSE_DINT410QANZAHL4
KLASSE_EAbsolute Frequency of Quality Score Class E QKLASSE_EINT410QANZAHL4
ZHLLOSQKZNumber of Summarized Inspection Lots for Quality Score QZHLLOSQKZINT410QANZAHL4
SUMQKZTotal of Quality Scores QSUMQKZFLTP16(16) QSTATWERT
SUM2QKZSquare Total of Quality Score QSUM2QKZFLTP16(16) QSTATWERT
ZHLLOSANTLNumber of Summarized Lots (Including Share of Scrap) QZHLLOSANTINT410QANZAHL4
SUMANTLTotal Share of Nonconforming Units QSUMANTLFLTP16(16) QSTATWERT
SUM2ANTLSquare Total of the Share of Nonconforming Units QSUM2ANTLFLTP16(16) QSTATWERT
ZHLLOSDRNumber of Summarized Inspection Lots (Lead Time) QZHLLOSDRINT410QANZAHL4
SUMDLZTTotal Lead Time QSUMDLZTFLTP16(16) QSTATWERT
SUM2DLZTSquare Total of Lead Time QSUM2DLZTFLTP16(16) QSTATWERT
SMGSCHLCumulated Inspected and Defective Quantity QSMGSCHLQUAN17(3) QKUMMENGE

Key field Non-key field



How do I retrieve data from SAP table S068 using ABAP code

The following ABAP code Example will allow you to do a basic selection on S068 to SELECT all data from the table
DATA: WA_S068 TYPE S068.

SELECT SINGLE *
FROM S068
INTO CORRESPONDING FIELDS OF WA_S068
WHERE...

How to access SAP table S068

Within an ECC or HANA version of SAP you can also view further information about S068 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!