I_ProbSolvingProcStpCmntTP

DDL: I_PROBSOLVINGPROCSTPCMNTTP SQL: IPRSLPRSTCMNTTP Type: view TRANSACTIONAL

Problem-Solving Process Step Comment

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

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_ProbSolvingProcStpCmnt _ProbSolvingProcStpCmnt from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProbSolvingProcTP _ProbSolvingProc $projection.ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc
[1..1] I_ProbSolvingProcStpTP _ProbSolvingProcStp $projection.ProbSolvingProc = _ProbSolvingProcStp.ProbSolvingProc and $projection.ProbSolvingProcStp = _ProbSolvingProcStp.ProbSolvingProcStp

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IPRSLPRSTCMNTTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Problem-Solving Process Step Comment 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 ProbSolvingProcCommentID view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.writeDraftPersistence QPRSLPRSTCMNT_D view
ObjectModel.writeActivePersistence V_PRSLPRSTCM_B2A view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProbSolvingProc I_ProbSolvingProcStpCmnt ProbSolvingProc
KEY ProbSolvingProcStp I_ProbSolvingProcStpCmnt ProbSolvingProcStp
KEY ProbSolvingProcCommentID I_ProbSolvingProcStpCmnt ProbSolvingProcCommentID
Language I_ProbSolvingProcStpCmnt Language
ProbSolvingProcCommentText I_ProbSolvingProcStpCmnt ProbSolvingProcCommentText
CreatedByUser I_ProbSolvingProcStpCmnt CreatedByUser
ProbSolvingCmntCrtedDteTme I_ProbSolvingProcStpCmnt ProbSolvingCmntCrtedDteTme
LastChangedByUser I_ProbSolvingProcStpCmnt LastChangedByUser
ProbSolvingCmntLastChgdDteTme I_ProbSolvingProcStpCmnt ProbSolvingCmntLastChgdDteTme
_ProbSolvingProc _ProbSolvingProc
_ProbSolvingProcStp _ProbSolvingProcStp
_Language I_ProbSolvingProcStpCmnt _Language
_CreatedByUserContactCard I_ProbSolvingProcStpCmnt _CreatedByUserContactCard
_LastChangedByUserContactCard I_ProbSolvingProcStpCmnt _LastChangedByUserContactCard 
@AbapCatalog.sqlViewName: 'IPRSLPRSTCMNTTP'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Problem-Solving Process Step Comment'
@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #M, 
        serviceQuality: #A },
    representativeKey: 'ProbSolvingProcCommentID',
    semanticKey:  [ 'ProbSolvingProc', 'ProbSolvingProcStp', 'ProbSolvingProcCommentID' ],
    
// Begin Draft

    createEnabled: true,
    updateEnabled: false,
    deleteEnabled: false,
    writeDraftPersistence: 'QPRSLPRSTCMNT_D',
    writeActivePersistence: 'V_PRSLPRSTCM_B2A'
// End Draft 

}

define view I_ProbSolvingProcStpCmntTP as select from I_ProbSolvingProcStpCmnt as _ProbSolvingProcStpCmnt

  association [1..1] to I_ProbSolvingProcTP    as _ProbSolvingProc    on $projection.ProbSolvingProc    = _ProbSolvingProc.ProbSolvingProc
  association [1..1] to I_ProbSolvingProcStpTP as _ProbSolvingProcStp on $projection.ProbSolvingProc    = _ProbSolvingProcStp.ProbSolvingProc
                                                                     and $projection.ProbSolvingProcStp = _ProbSolvingProcStp.ProbSolvingProcStp
{
      @ObjectModel.readOnly: true 
  key _ProbSolvingProcStpCmnt.ProbSolvingProc,
  
      @ObjectModel.readOnly: true 
  key _ProbSolvingProcStpCmnt.ProbSolvingProcStp,
  
      @ObjectModel.readOnly: true 
  key _ProbSolvingProcStpCmnt.ProbSolvingProcCommentID,
  
      @ObjectModel.readOnly: true
      _ProbSolvingProcStpCmnt.Language,
  
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      _ProbSolvingProcStpCmnt.ProbSolvingProcCommentText,
      
      @ObjectModel.readOnly: true
      _ProbSolvingProcStpCmnt.CreatedByUser,
      
      @ObjectModel.readOnly: true
      _ProbSolvingProcStpCmnt.ProbSolvingCmntCrtedDteTme,
      
      @ObjectModel.readOnly: true
      _ProbSolvingProcStpCmnt.LastChangedByUser,
      
      @ObjectModel.readOnly: true
      _ProbSolvingProcStpCmnt.ProbSolvingCmntLastChgdDteTme,
      
//=== exposed associations

      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT ]
      _ProbSolvingProc,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT ]
      _ProbSolvingProcStp,
      _ProbSolvingProcStpCmnt._Language,
      _ProbSolvingProcStpCmnt._CreatedByUserContactCard,
      _ProbSolvingProcStpCmnt._LastChangedByUserContactCard
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROBSOLVINGPROCSTPCMNT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_PROBSOLVINGPROCSTPTP",
"I_PROBSOLVINGPROCTP",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_PROBSOLVINGPROCSTPCMNT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More