SAP ABAP Data Element QQPTFN (iSeries: Physical File (Dtabhase Monitor))
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-DB4 (Application Component) DB2 for AS/400
     STU4 (Package) CCMS / AS/400
Basic Data
Data Element QQPTFN
Short Description iSeries: Physical File (Dtabhase Monitor)  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type QQTFN    
Data Type CHAR   Character String 
Length 10    
Decimal Places 0    
Output Length 10    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 11 Phy. File 
Medium 21 Physical File 
Long 41 Physical File 
Heading 55 Physical File 
Documentation

Definition

QQPTFN is the name of the physical file accessed in the query.

If the file specified in the query (QQTLN/QQTFN) is a view, then QQPTLN/QQPTFN is the physical file (table) accessed.
If the view is defined over multiple tables, then records exist for each physical file accessed.

(QQPTFN is not available for records with QQRID = 1000).

Example

V_SOFC is a database view over tables SOFM and SOOD.
For the SQL statement
SELECT * FROM V_SOFC WHERE FOLTP = 'RAW'
the following records are created in QAQQPRF:

    QQRID    QQTFN    QQPTFN

    3007    V_SOFC    SOOD

    3007    V_SOFC    SOFM

    3002    V_SOFC    SOFM

    3000    V_SOFC    SOOD

    3001    V_SOFC    SOFM

History
Last changed by/on SAP  20070813 
SAP Release Created in