What is C_ProbSolvingProcStepExect in SAP S/4HANA?

C_ProbSolvingProcStepExect is a consumption CDS view in SAP S/4HANA. Problem-Solving Process Step It contains 33 fields.

Which tables does C_ProbSolvingProcStepExect read from?

C_ProbSolvingProcStepExect reads data from: I_ProbSolvingProcStpTP.

What VDM layer is C_ProbSolvingProcStepExect?

C_ProbSolvingProcStepExect is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ProbSolvingProcStepExect

DDL: C_PROBSOLVINGPROCSTEPEXECT SQL: CPRSOLPROCSTP Type: view CONSUMPTION

33 Fields 1 Data Sources 9 Associations

Problem-Solving Process Step

C_ProbSolvingProcStepExect is a Consumption CDS View that provides data about "Problem-Solving Process Step" in SAP S/4HANA. It reads from 1 data source (I_ProbSolvingProcStpTP) and exposes 33 fields with key fields ProbSolvingProc, ProbSolvingProcStp. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ProbSolvingProcStpTP	_ProbSolvingProcStp	from

Associations (9)

Cardinality	Target	Alias	Condition
[1..1]	C_ProbSolvingProcExect	_ProbSolvingProc	`$projection.ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc`
[0..1]	C_ProbSolvingProcProbDesc	_ProbSolvingProcProbDesc	`$projection.ProbSolvingProc = _ProbSolvingProcProbDesc.ProbSolvingProc`
[0..*]	C_ProbSolvingProcPrtcpnt	_ProbSolvingProcPrtcpnt	`$projection.ProbSolvingProc = _ProbSolvingProcPrtcpnt.ProbSolvingProc`
[0..*]	C_ProbSolvingProcCause	_ProbSolvingProcCause	`$projection.ProbSolvingProc = _ProbSolvingProcCause.ProbSolvingProc`
[0..*]	C_ProbSolvingProcCauseDsp	_ProbSolvingProcCauseDsp	`$projection.ProbSolvingProc = _ProbSolvingProcCauseDsp.ProbSolvingProc`
[0..*]	C_ProbSolvingProcStepQltyTask	_ProbSolvingProcStepQltyTask	`$projection.ProbSolvingProc = _ProbSolvingProcStepQltyTask.ProbSolvingProc and $projection.ProbSolvingProcStp = _ProbSolvingProcStepQltyTask.ProbSolvingProcStp`
[0..1]	C_ProbSolvingProcAssmt	_ProbSolvingProcAssmt	`$projection.ProbSolvingProc = _ProbSolvingProcAssmt.ProbSolvingProc`
[0..*]	C_ProbSolvingProcStpCmnt	_ProbSolvingProcStpCmnt	`$projection.ProbSolvingProc = _ProbSolvingProcStpCmnt.ProbSolvingProc and $projection.ProbSolvingProcStp = _ProbSolvingProcStpCmnt.ProbSolvingProcStp`
[0..1]	I_ProbSolvingProcStpDesc	_StpDescInCurrentLanguage	`$projection.ProbSolvingProcType = _StpDescInCurrentLanguage.ProbSolvingProcType and $projection.ProbSolvingProcStp = _StpDescInCurrentLanguage.ProbSolvingProcStp and _StpDescInCurrentLanguage.Language = $session.system_language`

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	CPRSOLPROCSTP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Problem-Solving Process Step	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.representativeKey	ProbSolvingProcStp	view
ObjectModel.compositionRoot	false	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	false	view
Metadata.allowExtensions	true	view
UI.presentationVariant.id	DefaultLineItem	view

Fields (33)

Key	Field	Source Table	Source Field	Description
KEY	ProbSolvingProc		ProbSolvingProc
KEY	ProbSolvingProcStp		ProbSolvingProcStp
	ProbSolvingProcType		ProbSolvingProcType
	ProbSolvingProcStpSortNumber		ProbSolvingProcStpSortNumber
	ProbSolvingProcStpDesc	_StpDescInCurrentLanguage	ProbSolvingProcStpDesc
	MasterLanguage		MasterLanguage	Primary lang.
	ProbSolvingProcStpLfcycSts		ProbSolvingProcStpLfcycSts
	ProbSolvingProcStpLfcycStsText
	CreatedByUser		CreatedByUser	User Name
	ProbSolvingStpCreatedDateTime		ProbSolvingStpCreatedDateTime
	LastChangedByUser		LastChangedByUser	User Name
	ProbSolvingStpLastChgdDteTime		ProbSolvingStpLastChgdDteTime
	ProbSolvingProcStpHasTeam		ProbSolvingProcStpHasTeam	Step Has Team
	ProbSolvingProcStpHasProbDesc		ProbSolvingProcStpHasProbDesc	Step Has Description
	ProbSolvingProcStpHasFreeTasks		ProbSolvingProcStpHasFreeTasks	Step Has Free Tasks
	ProbSolvingProcStpHasCauses		ProbSolvingProcStpHasCauses	Step Has Causes
	ProbSolvingProcStpHasPlndTsks		ProbSolvingProcStpHasPlndTsks	Step Has Planned Tasks
	ProbSolvingProcStpHasFnshdTsks		ProbSolvingProcStpHasFnshdTsks	Step Has Finished Tasks
	ProbSolvingProcStpHasComments		ProbSolvingProcStpHasComments	Step Has Comments
	ProbSolvingProcStpHasAssmt		ProbSolvingProcStpHasAssmt	Step Has Assessment
	ProbSolvingProcStpHasTimeLine		ProbSolvingProcStpHasTimeLine	Step Has Timeline
	_ProbSolvingProc		_ProbSolvingProc
	_ProbSolvingProcStpCmnt		_ProbSolvingProcStpCmnt
	_ProbSolvingProcProbDesc		_ProbSolvingProcProbDesc
	_ProbSolvingProcPrtcpnt		_ProbSolvingProcPrtcpnt
	_ProbSolvingProcCause		_ProbSolvingProcCause
	_ProbSolvingProcCauseDsp		_ProbSolvingProcCauseDsp
	_ProbSolvingProcStepQltyTask		_ProbSolvingProcStepQltyTask
	_ProbSolvingProcAssmt		_ProbSolvingProcAssmt
	_CreatedByUserContactCard	I_ProbSolvingProcStpTP	_CreatedByUserContactCard
	_LastChangedByUserContactCard	I_ProbSolvingProcStpTP	_LastChangedByUserContactCard
	_ProbSolvingProcStpConfign	I_ProbSolvingProcStpTP	_ProbSolvingProcStpConfign
	_ProbSolvingProcStpLfcycSts	I_ProbSolvingProcStpTP	_ProbSolvingProcStpLfcycSts

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProbSolvingProcStepExect.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CPRSOLPROCSTP

CREATE VIEW C_ProbSolvingProcStepExect AS
SELECT
  ProbSolvingProc,
  ProbSolvingProcStp,
  ProbSolvingProcType,
  ProbSolvingProcStpSortNumber,
  _StpDescInCurrentLanguage.ProbSolvingProcStpDesc AS ProbSolvingProcStpDesc,
  MasterLanguage,
  ProbSolvingProcStpLfcycSts,
  _ProbSolvingProcStpLfcycSts._ProbSolvingProcStpLfcycStsT[1:Language = $session.system_language].ProbSolvingProcStpLfcycStsText AS ProbSolvingProcStpLfcycStsText,
  CreatedByUser,
  ProbSolvingStpCreatedDateTime,
  LastChangedByUser,
  ProbSolvingStpLastChgdDteTime,
  ProbSolvingProcStpHasTeam,
  ProbSolvingProcStpHasProbDesc,
  ProbSolvingProcStpHasFreeTasks,
  ProbSolvingProcStpHasCauses,
  ProbSolvingProcStpHasPlndTsks,
  ProbSolvingProcStpHasFnshdTsks,
  ProbSolvingProcStpHasComments,
  ProbSolvingProcStpHasAssmt,
  ProbSolvingProcStpHasTimeLine,
  _ProbSolvingProcStp._CreatedByUserContactCard AS _CreatedByUserContactCard,
  _ProbSolvingProcStp._LastChangedByUserContactCard AS _LastChangedByUserContactCard,
  _ProbSolvingProcStp._ProbSolvingProcStpConfign AS _ProbSolvingProcStpConfign,
  _ProbSolvingProcStp._ProbSolvingProcStpLfcycSts AS _ProbSolvingProcStpLfcycSts
FROM I_ProbSolvingProcStpTP AS _ProbSolvingProcStp
LEFT OUTER JOIN C_ProbSolvingProcExect AS _ProbSolvingProc ON ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc  -- association [1..1]
LEFT OUTER JOIN C_ProbSolvingProcProbDesc AS _ProbSolvingProcProbDesc ON ProbSolvingProc = _ProbSolvingProcProbDesc.ProbSolvingProc  -- association [0..1]
LEFT OUTER JOIN C_ProbSolvingProcPrtcpnt AS _ProbSolvingProcPrtcpnt ON ProbSolvingProc = _ProbSolvingProcPrtcpnt.ProbSolvingProc  -- association [0..*]
LEFT OUTER JOIN C_ProbSolvingProcCause AS _ProbSolvingProcCause ON ProbSolvingProc = _ProbSolvingProcCause.ProbSolvingProc  -- association [0..*]
LEFT OUTER JOIN C_ProbSolvingProcCauseDsp AS _ProbSolvingProcCauseDsp ON ProbSolvingProc = _ProbSolvingProcCauseDsp.ProbSolvingProc  -- association [0..*]
LEFT OUTER JOIN C_ProbSolvingProcStepQltyTask AS _ProbSolvingProcStepQltyTask ON ProbSolvingProc = _ProbSolvingProcStepQltyTask.ProbSolvingProc AND ProbSolvingProcStp = _ProbSolvingProcStepQltyTask.ProbSolvingProcStp  -- association [0..*]
LEFT OUTER JOIN C_ProbSolvingProcAssmt AS _ProbSolvingProcAssmt ON ProbSolvingProc = _ProbSolvingProcAssmt.ProbSolvingProc  -- association [0..1]
LEFT OUTER JOIN C_ProbSolvingProcStpCmnt AS _ProbSolvingProcStpCmnt ON ProbSolvingProc = _ProbSolvingProcStpCmnt.ProbSolvingProc AND ProbSolvingProcStp = _ProbSolvingProcStpCmnt.ProbSolvingProcStp  -- association [0..*]
LEFT OUTER JOIN I_ProbSolvingProcStpDesc AS _StpDescInCurrentLanguage ON ProbSolvingProcType = _StpDescInCurrentLanguage.ProbSolvingProcType AND ProbSolvingProcStp = _StpDescInCurrentLanguage.ProbSolvingProcStp AND _StpDescInCurrentLanguage.Language = $session.system_language  -- association [0..1]
;

Depth:

C_ProbSolvingProcStepExect view

I_ProbSolvingProcStpTP view