C_DefectLongText

DDL: C_DEFECTLONGTEXT SQL: CDEFECTLT Type: view CONSUMPTION

Defect Long Text

C_DefectLongText is a Consumption CDS View that provides data about "Defect Long Text" in SAP S/4HANA. It reads from 1 data source (I_DefectLongTextTP) and exposes 8 fields with key fields DefectInternalID, Language, ItemCounter. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_DefectLongTextTP I_DefectLongTextTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_DefectRecord _Defect_TP $projection.DefectInternalID = _Defect_TP.DefectInternalID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CDEFECTLT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.representativeKey DefectInternalID view
EndUserText.label Defect Long Text view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID DefectInternalID
KEY Language Language
KEY ItemCounter ItemCounter
LongTextID LongTextID
DefectLongText DefectLongText
MasterLanguage
_Defect_TP _Defect_TP
_Language _Language 
@AbapCatalog.sqlViewName: 'CDEFECTLT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

/* Draft 2.0*/
@ObjectModel:{
    dataCategory: #TEXT,
    transactionalProcessingDelegated: true,
    createEnabled: false,
    updateEnabled: true,
    deleteEnabled: false,
    
    representativeKey: 'DefectInternalID'
} 
@EndUserText.label: 'Defect Long Text'
define view C_DefectLongText as select from I_DefectLongTextTP 

    association [1..1] to C_DefectRecord as _Defect_TP on $projection.DefectInternalID = _Defect_TP.DefectInternalID
{
    @ObjectModel.foreignKey.association: '_Defect_TP'
    @UI.hidden: true
    key DefectInternalID,
    
    @Semantics.language: true
    @UI.hidden: true
    key Language,
    
    @UI.hidden: true
    key ItemCounter,
    
    @UI.hidden: true
    LongTextID,
    
    @UI:    { multiLineText: true }
    DefectLongText,
    
    @Consumption.hidden: true
    cast( _Defect_TP.MasterLanguage as vdm_j_masterlanguage ) as MasterLanguage,
           
    /* Associations */
    @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
    _Defect_TP,
    _Language

} where ItemCounter = 1 and Language = _Defect_TP.MasterLanguage

Learn More