SAP VFPRCC_VIEW_DET Pricing View Determination Table data and field list

VFPRCC_VIEW_DET is a standard SAP Table which is used to store Pricing View Determination data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VFPRCC_VIEW_DET table consists of various fields, each holding specific information or linking keys about Pricing View Determination data available in SAP. These include KAPPL (Application), KALSM (Procedure (Pricing, Output Control, Acct. Det., Costing,...)), ROLE (Role Name), SORT_SEQ (Prioritization of Assigned Profiles)... 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. .

VFPRCC_VIEW_DET 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: Can be enhanced (character-type or numeric)

SAP VFPRCC_VIEW_DET 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 VFPRCC_VIEW_DET 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
CLIENT	Client	MANDT	CLNT	3	T000		MANDT
KAPPL	Application	KAPPL	CHAR	2	Assigned to domain		KAPPL	KAP
KALSM	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	KALSM_D	CHAR	6	T683		KALSM
ROLE	Role Name	AGR_NAME	CHAR	30	AGR_DEFINE		AGR_NAME		AGR_NAME
SORT_SEQ	Prioritization of Assigned Profiles	VFPRC_PROFILE_SORT_SEQ	NUMC	3
PROFILE	Profile Identifier	VFPRC_VIEW_PROFILE_ID	CHAR	30	VFPRCC_PROFILE		VFPRC_VIEW_PROFILE_ID

Key field

Non-key field

< VFPRCC_VIEW_ASGN - Pricing View - Allowed View Assignment VFPRCC_VIEW_FCFG_ALV - Pricing View - Field Configuration for ALV >

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

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

SELECT SINGLE *
FROM VFPRCC_VIEW_DET
INTO CORRESPONDING FIELDS OF WA_VFPRCC_VIEW_DET
WHERE...

How to access SAP table VFPRCC_VIEW_DET

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

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