R_CndnContrPlainLongText

DDL: R_CNDNCONTRPLAINLONGTEXT Type: view BASIC

Plain Long Texts of a Condition Contract

R_CndnContrPlainLongText is a Basic CDS View that provides data about "Plain Long Texts of a Condition Contract" in SAP S/4HANA. It reads from 2 data sources (I_ConditionContract, I_TextObjectPlainLongText) and exposes 6 fields with key fields ConditionContract, TextObjectType, Language.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_ConditionContract CndnContr inner
I_TextObjectPlainLongText PlainLongText from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName RWCBCCTXT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Plain Long Texts of a Condition Contract view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
Analytics.internalName #LOCAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey TextObjectType view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract I_ConditionContract ConditionContract
KEY TextObjectType
KEY Language I_TextObjectPlainLongText Language
PlainLongText I_TextObjectPlainLongText PlainLongText
_ConditionContract _ConditionContract
_Language I_TextObjectPlainLongText _Language 
@AbapCatalog: {
  sqlViewName: 'RWCBCCTXT',
  preserveKey: true,
  compiler.compareFilter: true
}
@EndUserText: {
   label: 'Plain Long Texts of a Condition Contract'
}
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ClientHandling: {
  type: #INHERITED,
  algorithm: #SESSION_VARIABLE
}
@AccessControl: { 
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@Analytics: {
    internalName: #LOCAL
}   
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #L
   },
   dataCategory: #TEXT,
   representativeKey: 'TextObjectType'
}
@Metadata: {
  ignorePropagatedAnnotations: true
}

define view R_CndnContrPlainLongText 
  as select from I_TextObjectPlainLongText    as PlainLongText
    inner join   I_ConditionContract          as CndnContr  on  PlainLongText.TextObjectCategory  = 'WCOCOH'
                                                            and PlainLongText.TextObjectKey = bintohex( CndnContr.CndnContrUUID )
      
    association[1..1] to I_ConditionContract  as _ConditionContract  on  $projection.ConditionContract     = _ConditionContract.ConditionContract
  
{
    @ObjectModel.foreignKey.association: '_ConditionContract'                                                                                                   
    @Consumption: {
      valueHelpDefinition: [{ entity: { name: 'I_ConditionContractStdVH', element: 'ConditionContract' } }]
    }
    key CndnContr.ConditionContract                                               as ConditionContract,  
    
    key cast( PlainLongText.TextObjectType as textobjecttype preserving type )    as TextObjectType,
    
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    key PlainLongText.Language                                                    as Language,
        
        @Semantics.text:true
        PlainLongText.PlainLongText                                               as PlainLongText,
  
        //Associations

        @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
        _ConditionContract,
        PlainLongText._Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONDITIONCONTRACT",
"I_TEXTOBJECTPLAINLONGTEXT"
],
"ASSOCIATED":
[
"I_CONDITIONCONTRACT",
"I_LANGUAGE"
],
"BASE":
[
"I_TEXTOBJECTPLAINLONGTEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More