SAP PFFLD Period-End Partner: Organizational Log Information Table data and field list

PFFLD is a standard SAP Table which is used to store Period-End Partner: Organizational Log Information data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PFFLD table consists of various fields, each holding specific information or linking keys about Period-End Partner: Organizational Log Information data available in SAP. These include MANDT (Client), LOGSYS (Logical system), TIMESTMP (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)), STEP_TIMESTMP (UTC Time Stamp in Short Form (YYYYMMDDhhmmss))... 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. .

PFFLD table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP PFFLD 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 PFFLD 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 MANDTCLNT3Assigned to domainMANDT
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
TIMESTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS
STEP_TIMESTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LMONAFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
FIELD_LMONAField name NAME_FELDCHAR30Assigned to domainFDNAMEDFD
ERKRSOperating concern ERKRSCHAR4Assigned to domainERKRSERB
RLDNRLedger RLDNRCHAR2Assigned to domainALPHARLDNRGLNH_T881
BWKEYValuation Area BWKEYCHAR4Assigned to domainBWKEYBWK
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
GJAHR_BISFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
FROM_PFirst period FROM_PNUMC3RPMAXVPE
TO_PLast Period TO_PNUMC3RPMAXBPE
VERSNVersion VERSNCHAR3Assigned to domainALPHACOVERSIKVS
KSCYCCycle: Per. Reposting, Assessment, Distrib., Ind.Act .Alloc. KSCYCCHAR6CHAR6KCY
RUN_TYPECosting Run in Actual Costing CKML_RUN_TYPECHAR8Assigned to domainCKML_RUN_TYPECKML_RUN_TYPE
BUDATPosting Date in the Document BUDATDATS8DATUM
KALSTCosting Level CK_KALSTNUMC4CK_KALST
STARTDATEStart Date of Processing PF_STARTDATDATS8DATUM
STARTTIMEStart Time of Processing PF_STARTTIMTIMS6UZEIT
ENDDATEEnd Date for Processing PF_ENDDATDATS8DATUM
ENDTIMEEnd Time of Processing PF_ENDTIMTIMS6UZEIT
STATUSDATEDate of Status Information PF_LOGDATDATS8DATUM
STATUSTIMETime of Status Information PF_LOGTIMTIMS6UZEIT
STATUSERLast changed by UNAMCHAR12SYCHAR12
STATTEXTStatus Change Reason STTEXTSCHAR40CHAR40_LOW
APLSTATProcessing Results from Business View APLSTATCHAR1APLSTAT
USSTATUser Status USSTATCHAR1CHAR1
MSGFLGMessage Log Exists MSGFLGCHAR1CHAR1
ACTLOGWork List Exists ACTFLGCHAR1CHAR1
OBJECTSNumber of Objects Processed OBJNMBRINT410INT4

Key field Non-key field



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

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

SELECT SINGLE *
FROM PFFLD
INTO CORRESPONDING FIELDS OF WA_PFFLD
WHERE...

How to access SAP table PFFLD

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

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