SAP ABAP Table S166 (Quantitative Inspection Results: Customer)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S166	Table Relationship Diagram
Short Description	Quantitative Inspection Results: Customer

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	KUNNR	☑	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	KNA1
9	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	PRPLATZWRK	☑	WERKARBPL	WERKS	CHAR	4	0	Plant/Work Center	T001W
11	PRPLATZ	☑	QPRPLATZ	ARBPL	CHAR	8	0	Work Center
12	WERKSTPRUE	☑	WERKSTPRUE	QWERKSTPRF	CHAR	12	0	QMIS Plant/Master Inspection Characteristic
13	PLGRPLTYP	☑	QPLGRTYP	QPLGRTYP	CHAR	9	0	Combined Field Task List Type/Task List Group
14	PPLNKN	☑	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
15	MERKNR	☑	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
16	WERK	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
17	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
18	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
19	MASSEINHSW	☐	QMASSEH	MEINS	UNIT	3	0	Unit of Measurement, in Which Quantitative Data Is Stored	T006
20	ZHLN	☐	QZHLN	QANZAHL4	INT4	10	0	Number of Inspected and Closed Samples
21	ZHLNA	☐	QZHLNA	QANZAHL4	INT4	10	0	Number of Accepted Samples
22	ZHLNR	☐	QZHLNR	QANZAHL4	INT4	10	0	Number of Rejected Samples
23	ZHLNF	☐	QZHLNF	QANZAHL4	INT4	10	0	No. of Defects
24	ZHLNFEH	☐	QZHLNFEH	QANZAHL4	INT4	10	0	Number of Nonconforming Units
25	ZHLNTOLU	☐	QZHLNTOLU	QANZAHL4	INT4	10	0	Number of Values Below Lower Tolerance
26	ZHLNTOLO	☐	QZHLNTOLO	QANZAHL4	INT4	10	0	Number of Values Above Upper Tolerance
27	ZHLNSTPF	☐	QZHLNSTPF	QANZAHL4	INT4	10	0	Sample Size (No. of Valid Values in Sample)
28	SUMFANT	☐	QSUMFANT	QSTATWERT	FLTP	16	16	Total Nonconforming Shares
29	SUMFEHEH	☐	QSUMFEHLEH	INT4	INT4	10	0	Total of Nonconforming Units
30	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
31	VORNR	☐	QMISVORNR	VORNR	CHAR	4	0	QMIS Operation Number
32	ZHLNSTAT	☐	QZHLNSTAT	QANZAHL4	INT4	10	0	Number of Valid Single Values
33	SUMEW	☐	QSUMEW	QSTATWERT	FLTP	16	16	Total of Valid Single Values
34	SUMMW	☐	QSUMMW	QSTATWERT	FLTP	16	16	Total of Mean Values
35	SUMVARIN	☐	QSUMVARIN	QSTATWERT	FLTP	16	16	Total of Single Value Variances
36	SUMSIGMAST	☐	QSUMSIGMASTP	QSTATWERT	FLTP	16	16	Total of Sample Dispersions
37	SUMVAR	☐	QSUMVAR	QSTATWERT	FLTP	16	16	Total of Sample Variances
38	TOLUN	☐	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
39	TOLUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
40	TOLOB	☐	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
41	TOLOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
42	CP	☐	QCP	QSTATWERT	FLTP	16	16	Process Capability Index (Cp Value)
43	CPK	☐	QCPK	QSTATWERT	FLTP	16	16	Process Capability Index (Cpk Value)
44	SIGMA	☐	QMISSTD	QSTATWERT	FLTP	16	16	Standard Deviation
45	XQUER	☐	QMISMITTEL	QSTATWERT	FLTP	16	16	Mean Value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S166	KUNNR	KNA1	KUNNR
2	S166	MANDT	T000	MANDT
3	S166	MASSEINHSW	T006	MSEHI
4	S166	MATNR	MARA	MATNR
5	S166	PRPLATZWRK	T001W	WERKS
6	S166	WERK	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in