SAP FMCCAVC_PRL Cluster table for different purposes Table data and field list

FMCCAVC_PRL is a standard SAP Table which is used to store Cluster table for different purposes data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMCCAVC_PRL table consists of various fields, each holding specific information or linking keys about Cluster table for different purposes data available in SAP. These include RELID (Region in IMPORT/EXPORT Data Table), SRTFD (CHAR40 for SYST), SRTF2 (Next record counter in EXPORT/IMPORT data tables), LOEKZ (CHAR01 data element for SYST)... 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. .

FMCCAVC_PRL 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: Cannot Be Enhanced

SAP FMCCAVC_PRL 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 FMCCAVC_PRL 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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
RELID	Region in IMPORT/EXPORT Data Table	INDX_RELID	CHAR	2			SYCHAR02
SRTFD	CHAR40 for SYST	SYCHAR40	CHAR	40			SYCHAR40
SRTF2	Next record counter in EXPORT/IMPORT data tables	INDX_SRTF2	INT4	10			SYBIN4
LOEKZ	CHAR01 data element for SYST	SYCHAR01	CHAR	1			SYCHAR01
SPERR	CHAR01 data element for SYST	SYCHAR01	CHAR	1			SYCHAR01
AEDAT	(8-character) Date for SYST	SYDATS	DATS	8			SYDATS
USERA	User name	USERNAME	CHAR	12			USERNAME
PGMID	ABAP Program Name	PROGNAME	CHAR	40			PROGNAME
BEGDT	(8-character) Date for SYST	SYDATS	DATS	8			SYDATS
ENDDT	(8-character) Date for SYST	SYDATS	DATS	8			SYDATS
CLUSTR	Length field for user data in EXPORT/IMPORT tables	INDX_CLSTR	INT2	5			SYBIN2
CLUSTD	Data field for IMPORT/EXPORT database tables	INDX_CLUST	LRAW	2886			INDX_CLUST

Key field

Non-key field

< FMCCAVCT_KEY - Key fields lock object for FMCCAVCT FMCCAVC_PRLS_ITEM_DATA - FMCCAVC append structure for PRL structures >

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

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

SELECT SINGLE *
FROM FMCCAVC_PRL
INTO CORRESPONDING FIELDS OF WA_FMCCAVC_PRL
WHERE...

How to access SAP table FMCCAVC_PRL

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

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