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