I_ProbSolvingProcCauseLongTTP

DDL: I_PROBSOLVINGPROCCAUSELONGTTP SQL: IPRSOLPROCCLTTP Type: view TRANSACTIONAL

Problem-Solving Process Cause Long Text

I_ProbSolvingProcCauseLongTTP is a Transactional CDS View that provides data about "Problem-Solving Process Cause Long Text" in SAP S/4HANA. It reads from 1 data source (I_ProbSolvingProcCauseLongT) and exposes 14 fields with key fields ProbSolvingProc, ProbSolvingProcCause, ItemCounter, Language. It has 2 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_ProbSolvingProcCauseLongT _ProbSolvingProcCauseLongT from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProbSolvingProcTP _ProbSolvingProc $projection.ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc
[1..1] I_ProbSolvingProcCauseTP _ProbSolvingProcCause $projection.ProbSolvingProc = _ProbSolvingProcCause.ProbSolvingProc and $projection.ProbSolvingProcCause = _ProbSolvingProcCause.ProbSolvingProcCause

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IPRSOLPROCCLTTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Problem-Solving Process Cause Long Text view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey ItemCounter view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.writeDraftPersistence QPRBSLVPRCCLT_D view
ObjectModel.writeActivePersistence V_PRSLPRCLT_B2A view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProbSolvingProc I_ProbSolvingProcCauseLongT ProbSolvingProc
KEY ProbSolvingProcCause I_ProbSolvingProcCauseLongT ProbSolvingProcCause
KEY ItemCounter I_ProbSolvingProcCauseLongT ItemCounter
KEY Language I_ProbSolvingProcCauseLongT Language
LongTextID I_ProbSolvingProcCauseLongT LongTextID
ProbSolvingProcCauseLongText I_ProbSolvingProcCauseLongT ProbSolvingProcCauseLongText
MimeType I_ProbSolvingProcCauseLongT MimeType
LongTextCreatedByUser I_ProbSolvingProcCauseLongT LongTextCreatedByUser
LongTextCreatedAt I_ProbSolvingProcCauseLongT LongTextCreatedAt
LongTextLastChangedByUser I_ProbSolvingProcCauseLongT LongTextLastChangedByUser
LongTextLastChangedAt I_ProbSolvingProcCauseLongT LongTextLastChangedAt
_ProbSolvingProc _ProbSolvingProc
_ProbSolvingProcCause _ProbSolvingProcCause
_Language I_ProbSolvingProcCauseLongT _Language 
@AbapCatalog.sqlViewName: 'IPRSOLPROCCLTTP'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Problem-Solving Process Cause Long Text'

@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API
}

@AccessControl.authorizationCheck: #CHECK

@ObjectModel: {
    dataCategory: #TEXT,
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #M, 
        serviceQuality: #A },
    representativeKey: 'ItemCounter',
    semanticKey:  [ 'ProbSolvingProc', 'ProbSolvingProcCause', 'Language', 'ItemCounter' ],
// Begin Draft

    createEnabled: false,
    updateEnabled: true,
    deleteEnabled: false,
    writeDraftPersistence: 'QPRBSLVPRCCLT_D',
    writeActivePersistence: 'V_PRSLPRCLT_B2A'
// End Draft  

}

define view I_ProbSolvingProcCauseLongTTP as select from I_ProbSolvingProcCauseLongT as _ProbSolvingProcCauseLongT 

  association [1..1] to I_ProbSolvingProcTP      as _ProbSolvingProc      on  $projection.ProbSolvingProc      = _ProbSolvingProc.ProbSolvingProc
  association [1..1] to I_ProbSolvingProcCauseTP as _ProbSolvingProcCause on  $projection.ProbSolvingProc      = _ProbSolvingProcCause.ProbSolvingProc
                                                                          and $projection.ProbSolvingProcCause = _ProbSolvingProcCause.ProbSolvingProcCause


{
  @ObjectModel:{  readOnly: true,
                  foreignKey.association: '_ProbSolvingProc' }
  key _ProbSolvingProcCauseLongT.ProbSolvingProc,
  @ObjectModel:{  readOnly: true,
                  foreignKey.association: '_ProbSolvingProcCause' }  
  key _ProbSolvingProcCauseLongT.ProbSolvingProcCause,
  @ObjectModel.readOnly: true
  key _ProbSolvingProcCauseLongT.ItemCounter,
  @ObjectModel.readOnly: true
  @Semantics.language: true
  key _ProbSolvingProcCauseLongT.Language,

      @ObjectModel.readOnly: true
      _ProbSolvingProcCauseLongT.LongTextID,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      _ProbSolvingProcCauseLongT.ProbSolvingProcCauseLongText,
      @ObjectModel.readOnly: true
      _ProbSolvingProcCauseLongT.MimeType,

//    Admin Data

      @ObjectModel.readOnly: true
      _ProbSolvingProcCauseLongT.LongTextCreatedByUser,
      @ObjectModel.readOnly: true
      _ProbSolvingProcCauseLongT.LongTextCreatedAt,
      @ObjectModel.readOnly: true
      _ProbSolvingProcCauseLongT.LongTextLastChangedByUser,
      @ObjectModel.readOnly: true
      _ProbSolvingProcCauseLongT.LongTextLastChangedAt,

//    Associations

      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT ]
      _ProbSolvingProc,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT ]
      _ProbSolvingProcCause,
      
      _ProbSolvingProcCauseLongT._Language
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROBSOLVINGPROCCAUSELONGT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_PROBSOLVINGPROCCAUSETP",
"I_PROBSOLVINGPROCTP"
],
"BASE":
[
"I_PROBSOLVINGPROCCAUSELONGT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More