SAP CFF_IDXSTA Collaboration Folders - PHIO: Instances Physical Info: Sta Table data and field list

CFF_IDXSTA is a standard SAP Table which is used to store Collaboration Folders - PHIO: Instances Physical Info: Sta data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CFF_IDXSTA table consists of various fields, each holding specific information or linking keys about Collaboration Folders - PHIO: Instances Physical Info: Sta data available in SAP. These include MANDT (Client), CATID (Index category identification), PHIO_ID (Physical document), PHIO_ID (Physical document)... 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. .

CFF_IDXSTA table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CFF_IDXSTA 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 CFF_IDXSTA 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
CATIDIndex category identification SRET_CATIDCHAR32SRETIDCATSRET_CATIDH_SRETIDCAT
MANDTClient MANDTCLNT3Assigned to domainMANDT
CATIDIndex category identification SRET_CATIDCHAR32SRETIDCATSRET_CATIDH_SRETIDCAT
PHIO_IDPhysical document SDOK_PHIDCHAR32SDOK_DOCID
PHIO_IDPhysical document SDOK_PHIDCHAR32SDOK_DOCID
PH_CLASSPhysical document class SDOK_PHCLCHAR10Assigned to domainSDOK_CLASS
LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
PH_CLASSPhysical document class SDOK_PHCLCHAR10Assigned to domainSDOK_CLASS
LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
ACTIONType of action to be performed SDOK_IDACTCHAR1SDOK_IDACT
ACTIONType of action to be performed SDOK_IDACTCHAR1SDOK_IDACT
STATUSIndexing/deindexing status SDOK_STATCHAR1SDOK_STAT
RCODEReturn code SRET_RCODENUMC4SRET_RCODE
STATUSIndexing/deindexing status SDOK_STATCHAR1SDOK_STAT
RCODEReturn code SRET_RCODENUMC4SRET_RCODE
ERROR_CNTNumber of failed attempts at (de)indexing SDOK_ERCNTINT13SDOK_ERCNT
CREA_TIMECreation time (UTC): Long representation SDOK_LCTSTDEC21(7) TZNTSTMPL
ERROR_CNTNumber of failed attempts at (de)indexing SDOK_ERCNTINT13SDOK_ERCNT
CREA_TIMECreation time (UTC): Long representation SDOK_LCTSTDEC21(7) TZNTSTMPL
NBOFCOMPSNumber of components of a PHIO SDOK_CNUMBNUMC10NUM10
SAPCPSAP internal code page SRET_SAPCPNUMC4Assigned to domainCPCODEPAGE
NBOFCOMPSNumber of components of a PHIO SDOK_CNUMBNUMC10NUM10
SAPCPSAP internal code page SRET_SAPCPNUMC4Assigned to domainCPCODEPAGE

Key field Non-key field



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

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

SELECT SINGLE *
FROM CFF_IDXSTA
INTO CORRESPONDING FIELDS OF WA_CFF_IDXSTA
WHERE...

How to access SAP table CFF_IDXSTA

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

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