C_ProbSolvingProcAssmt

DDL: C_PROBSOLVINGPROCASSMT SQL: CPRSOLPRASMT Type: view CONSUMPTION

Problem-Solving Process Assessment

C_ProbSolvingProcAssmt is a Consumption CDS View that provides data about "Problem-Solving Process Assessment" in SAP S/4HANA. It reads from 1 data source (I_ProbSolvingProcAssmtTP) and exposes 5 fields with key field ProbSolvingProc. It has 3 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_ProbSolvingProcAssmtTP _ProbSolvingProcAssmt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_ProbSolvingProcExect _ProbSolvingProc $projection.ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc
[0..*] C_ProbSolvingProcAssmtDetDesc _ProbSolvingProcAssmtLongT $projection.ProbSolvingProc = _ProbSolvingProcAssmtLongT.ProbSolvingProc
[0..1] C_ProbSolvingProcAssmtDetDesc _ProbSolvingProcAssmtDetDesc $projection.ProbSolvingProc = _ProbSolvingProcAssmtDetDesc.ProbSolvingProc and $projection.masterlanguage = _ProbSolvingProcAssmtDetDesc.Language and _ProbSolvingProcAssmtDetDesc.ItemCounter = 1

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CPRSOLPRASMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Problem-Solving Process Assessment view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey ProbSolvingProc 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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProbSolvingProc I_ProbSolvingProcAssmtTP ProbSolvingProc
MasterLanguage _ProbSolvingProc MasterLanguage
_ProbSolvingProc _ProbSolvingProc
_ProbSolvingProcAssmtLongT _ProbSolvingProcAssmtLongT
_ProbSolvingProcAssmtDetDesc _ProbSolvingProcAssmtDetDesc 
@AbapCatalog.sqlViewName: 'CPRSOLPRASMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Problem-Solving Process Assessment'
@VDM: {
    viewType: #CONSUMPTION
}
@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #M, 
        serviceQuality: #C },
    representativeKey: 'ProbSolvingProc',
    semanticKey:  [ 'ProbSolvingProc' ],
// Begin Draft 2.0

    compositionRoot: false,
    transactionalProcessingDelegated:true,
    createEnabled: false,
    updateEnabled: true,
    deleteEnabled: false
// End Draft

}
@Metadata.allowExtensions: true

define view C_ProbSolvingProcAssmt as select from I_ProbSolvingProcAssmtTP as _ProbSolvingProcAssmt 

//=== associations to own consumption views

  association [1..1] to C_ProbSolvingProcExect        as _ProbSolvingProc             on  $projection.ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc  
  association [0..*] to C_ProbSolvingProcAssmtDetDesc as _ProbSolvingProcAssmtLongT   on  $projection.ProbSolvingProc = _ProbSolvingProcAssmtLongT.ProbSolvingProc
  association [0..1] to C_ProbSolvingProcAssmtDetDesc as _ProbSolvingProcAssmtDetDesc on  $projection.ProbSolvingProc = _ProbSolvingProcAssmtDetDesc.ProbSolvingProc
                                                                                      and $projection.masterlanguage  = _ProbSolvingProcAssmtDetDesc.Language
                                                                                      and _ProbSolvingProcAssmtDetDesc.ItemCounter = 1 
{
  @ObjectModel.foreignKey.association: '_ProbSolvingProc'
  key _ProbSolvingProcAssmt.ProbSolvingProc,

  @ObjectModel.readOnly: true
  @Consumption.hidden: true
  _ProbSolvingProc.MasterLanguage,
  
//=== exposed associations

  @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
  @Consumption.filter.hidden: true
  _ProbSolvingProc,
  @ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD ]  
  @Consumption.filter.hidden: true
  _ProbSolvingProcAssmtLongT,
  @Consumption.filter.hidden: true
  _ProbSolvingProcAssmtDetDesc
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_PROBSOLVINGPROCEXECT",
"I_PROBSOLVINGPROCASSMTTP"
],
"ASSOCIATED":
[
"C_PROBSOLVINGPROCASSMTDETDESC",
"C_PROBSOLVINGPROCEXECT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More