I_ProbSolvingProcStpTP

DDL: I_PROBSOLVINGPROCSTPTP SQL: IPRSOLPROCSTPTP Type: view TRANSACTIONAL
26 Fields 1 Data Sources 2 Associations

Problem-Solving Process Step

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

Data Sources (1)

SourceAliasJoin Type
I_ProbSolvingProcStp _ProbSolvingProcStp from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProbSolvingProcTP _ProbSolvingProc $projection.ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc
[0..*] I_ProbSolvingProcStpCmntTP _ProbSolvingProcStpCmnt $projection.ProbSolvingProc = _ProbSolvingProcStpCmnt.ProbSolvingProc and $projection.ProbSolvingProcStp = _ProbSolvingProcStpCmnt.ProbSolvingProcStp

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IPRSOLPROCSTPTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Problem-Solving Process Step view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey ProbSolvingProcStp view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.writeDraftPersistence QPRBSLVPRCSTEP_D view
ObjectModel.writeActivePersistence V_PRSLPRST_B2A view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ProbSolvingProc I_ProbSolvingProcStp ProbSolvingProc Problem-Solving Process
KEY ProbSolvingProcStp I_ProbSolvingProcStp ProbSolvingProcStp Problem-Solving Step
ProbSolvingProcType ProbSolvingProcType
ProbSolvingProcStpSortNumber I_ProbSolvingProcStp ProbSolvingProcStpSortNumber Sort Number
MasterLanguage I_ProbSolvingProcStp MasterLanguage Primary lang.
ProbSolvingProcStpLfcycSts I_ProbSolvingProcStp ProbSolvingProcStpLfcycSts Task Status
CreatedByUser I_ProbSolvingProcStp CreatedByUser User Name
ProbSolvingStpCreatedDateTime I_ProbSolvingProcStp ProbSolvingStpCreatedDateTime Variant created on
LastChangedByUser I_ProbSolvingProcStp LastChangedByUser User Name
ProbSolvingStpLastChgdDteTime I_ProbSolvingProcStp ProbSolvingStpLastChgdDteTime Variant Changed on
ProbSolvingProcStpHasTeam I_ProbSolvingProcStp ProbSolvingProcStpHasTeam Step Has Team
ProbSolvingProcStpHasProbDesc I_ProbSolvingProcStp ProbSolvingProcStpHasProbDesc Step Has Description
ProbSolvingProcStpHasFreeTasks I_ProbSolvingProcStp ProbSolvingProcStpHasFreeTasks Step Has Free Tasks
ProbSolvingProcStpHasCauses I_ProbSolvingProcStp ProbSolvingProcStpHasCauses Step Has Causes
ProbSolvingProcStpHasPlndTsks I_ProbSolvingProcStp ProbSolvingProcStpHasPlndTsks Step Has Planned Tasks
ProbSolvingProcStpHasFnshdTsks I_ProbSolvingProcStp ProbSolvingProcStpHasFnshdTsks Step Has Finished Tasks
ProbSolvingProcStpHasComments I_ProbSolvingProcStp ProbSolvingProcStpHasComments Step Has Comments
ProbSolvingProcStpHasAssmt I_ProbSolvingProcStp ProbSolvingProcStpHasAssmt Step Has Assessment
ProbSolvingProcStpHasTimeLine I_ProbSolvingProcStp ProbSolvingProcStpHasTimeLine Step Has Timeline
_ProbSolvingProc _ProbSolvingProc
_ProbSolvingProcStpCmnt _ProbSolvingProcStpCmnt
_Language I_ProbSolvingProcStp _Language
_ProbSolvingProcStpConfign I_ProbSolvingProcStp _ProbSolvingProcStpConfign
_CreatedByUserContactCard I_ProbSolvingProcStp _CreatedByUserContactCard
_LastChangedByUserContactCard I_ProbSolvingProcStp _LastChangedByUserContactCard
_ProbSolvingProcStpLfcycSts I_ProbSolvingProcStp _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 I_ProbSolvingProcStpTP.
-- 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: IPRSOLPROCSTPTP

CREATE VIEW I_ProbSolvingProcStpTP AS
SELECT
  _ProbSolvingProcStp.ProbSolvingProc AS ProbSolvingProc,
  _ProbSolvingProcStp.ProbSolvingProcStp AS ProbSolvingProcStp,
  ProbSolvingProcType,
  _ProbSolvingProcStp.ProbSolvingProcStpSortNumber AS ProbSolvingProcStpSortNumber,
  _ProbSolvingProcStp.MasterLanguage AS MasterLanguage,
  _ProbSolvingProcStp.ProbSolvingProcStpLfcycSts AS ProbSolvingProcStpLfcycSts,
  _ProbSolvingProcStp.CreatedByUser AS CreatedByUser,
  _ProbSolvingProcStp.ProbSolvingStpCreatedDateTime AS ProbSolvingStpCreatedDateTime,
  _ProbSolvingProcStp.LastChangedByUser AS LastChangedByUser,
  _ProbSolvingProcStp.ProbSolvingStpLastChgdDteTime AS ProbSolvingStpLastChgdDteTime,
  _ProbSolvingProcStp.ProbSolvingProcStpHasTeam AS ProbSolvingProcStpHasTeam,
  _ProbSolvingProcStp.ProbSolvingProcStpHasProbDesc AS ProbSolvingProcStpHasProbDesc,
  _ProbSolvingProcStp.ProbSolvingProcStpHasFreeTasks AS ProbSolvingProcStpHasFreeTasks,
  _ProbSolvingProcStp.ProbSolvingProcStpHasCauses AS ProbSolvingProcStpHasCauses,
  _ProbSolvingProcStp.ProbSolvingProcStpHasPlndTsks AS ProbSolvingProcStpHasPlndTsks,
  _ProbSolvingProcStp.ProbSolvingProcStpHasFnshdTsks AS ProbSolvingProcStpHasFnshdTsks,
  _ProbSolvingProcStp.ProbSolvingProcStpHasComments AS ProbSolvingProcStpHasComments,
  _ProbSolvingProcStp.ProbSolvingProcStpHasAssmt AS ProbSolvingProcStpHasAssmt,
  _ProbSolvingProcStp.ProbSolvingProcStpHasTimeLine AS ProbSolvingProcStpHasTimeLine,
  _ProbSolvingProcStp._Language AS _Language,
  _ProbSolvingProcStp._ProbSolvingProcStpConfign AS _ProbSolvingProcStpConfign,
  _ProbSolvingProcStp._CreatedByUserContactCard AS _CreatedByUserContactCard,
  _ProbSolvingProcStp._LastChangedByUserContactCard AS _LastChangedByUserContactCard,
  _ProbSolvingProcStp._ProbSolvingProcStpLfcycSts AS _ProbSolvingProcStpLfcycSts
FROM I_ProbSolvingProcStp AS _ProbSolvingProcStp
LEFT OUTER JOIN I_ProbSolvingProcTP AS _ProbSolvingProc ON ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc  -- association [1..1]
LEFT OUTER JOIN I_ProbSolvingProcStpCmntTP AS _ProbSolvingProcStpCmnt ON ProbSolvingProc = _ProbSolvingProcStpCmnt.ProbSolvingProc AND ProbSolvingProcStp = _ProbSolvingProcStpCmnt.ProbSolvingProcStp  -- association [0..*]
;

Learn More