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 |