SAP ABAP Table S165 (Inspection Results (General): Customers)
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 S165   Table Relationship Diagram
Short Description Inspection Results (General): Customers    
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 ZHLN QZHLN QANZAHL4 INT4 10   0   Number of Inspected and Closed Samples  
20 ZHLNA QZHLNA QANZAHL4 INT4 10   0   Number of Accepted Samples  
21 ZHLNR QZHLNR QANZAHL4 INT4 10   0   Number of Rejected Samples  
22 ZHLNF QZHLNF QANZAHL4 INT4 10   0   No. of Defects  
23 ZHLNFEH QZHLNFEH QANZAHL4 INT4 10   0   Number of Nonconforming Units  
24 ZHLNTOLU QZHLNTOLU QANZAHL4 INT4 10   0   Number of Values Below Lower Tolerance  
25 ZHLNTOLO QZHLNTOLO QANZAHL4 INT4 10   0   Number of Values Above Upper Tolerance  
26 ZHLNSTPF QZHLNSTPF QANZAHL4 INT4 10   0   Sample Size (No. of Valid Values in Sample)  
27 SUMFANT QSUMFANT QSTATWERT FLTP 16   16   Total Nonconforming Shares  
28 SUMFEHEH QSUMFEHLEH INT4 INT4 10   0   Total of Nonconforming Units  
29 PLNAL PLNAL ALTNR CHAR 2   0   Group Counter  
30 VORNR QMISVORNR VORNR CHAR 4   0   QMIS Operation Number  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S165 KUNNR KNA1 KUNNR    
2 S165 MANDT T000 MANDT    
3 S165 MATNR MARA MATNR    
4 S165 PRPLATZWRK T001W WERKS    
5 S165 WERK T001W WERKS    
History
Last changed by/on SAP  20050411 
SAP Release Created in