SAP PFA_DINTERVALS TRM-PA: Time Intervals for Period-Based Key Figures Table data and field list

PFA_DINTERVALS is a standard SAP Table which is used to store TRM-PA: Time Intervals for Period-Based Key Figures data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PFA_DINTERVALS table consists of various fields, each holding specific information or linking keys about TRM-PA: Time Intervals for Period-Based Key Figures data available in SAP. These include DINTERVAL (Time Interval for Period-Based Key Figures), Y (Number of Years), M (Number of Months), D (Number of Days)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

PFA_DINTERVALS table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP PFA_DINTERVALS table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the PFA_DINTERVALS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
DINTERVALTime Interval for Period-Based Key Figures PFA_DINTERVALCHAR10PFA_DINTERVAL
YNumber of Years PFA_YEARSINT410INT4
MNumber of Months PFA_MTHSINT410INT4
DNumber of Days PFA_DAYSINT410INT4

Key field Non-key field



How do I retrieve data from SAP table PFA_DINTERVALS using ABAP code

The following ABAP code Example will allow you to do a basic selection on PFA_DINTERVALS to SELECT all data from the table
DATA: WA_PFA_DINTERVALS TYPE PFA_DINTERVALS.

SELECT SINGLE *
FROM PFA_DINTERVALS
INTO CORRESPONDING FIELDS OF WA_PFA_DINTERVALS
WHERE...

How to access SAP table PFA_DINTERVALS

Within an ECC or HANA version of SAP you can also view further information about PFA_DINTERVALS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).