I_DEFECTLONGTEXT

CDS View

Defect Long Text

I_DEFECTLONGTEXT is a CDS View in S/4HANA. Defect Long Text. It contains 11 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 11 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_QltyTaskProcDefectInfoLongT view_entity from CONSUMPTION Defect Long Text for Quality Task
I_DefectLongTextTP view from TRANSACTIONAL Defect Long Text
R_DefectLongTextTP view_entity from TRANSACTIONAL Defect Long Text

Fields (11)

KeyField CDS FieldsUsed in Views
KEY DefectInternalID DefectInternalID 2
KEY Language Language 2
KEY LongTextInternalNumber ItemCounter,LongTextInternalNumber 2
_Language _Language 2
DefectLongText DefectLongText 2
LongTextCreatedAt LongTextCreatedAt 2
LongTextCreatedByUser LongTextCreatedByUser 2
LongTextID LongTextID 2
LongTextLastChangedAt LongTextLastChangedAt 2
LongTextLastChangedByUser LongTextLastChangedByUser 2
MimeType MimeType 2 
@AccessControl.authorizationCheck: #MANDATORY
@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities:
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern: #NONE
@ObjectModel:
    { usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L,
        serviceQuality: #A
    },
    representativeKey: 'LongTextInternalNumber',
    dataCategory: #TEXT
}
@Analytics.technicalName: 'IDEFLONGTXT'
@EndUserText.label: 'Defect Long Text'
@Metadata.ignorePropagatedAnnotations: true // Projection from generic NotificationItemLT to DefectLT => Start new with annotations


define view entity I_DefectLongText as select from I_NotificationItemLongText

    association [1..1] to I_Defect as _Defect    on $projection.DefectInternalID = _Defect.DefectInternalID

{

    @ObjectModel.foreignKey.association: '_Defect'
    key cast( I_NotificationItemLongText.Notification as qdefectinternalid preserving type ) as DefectInternalID,
    
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    key Language,
    
    key LongTextInternalNumber,
    
    
    LongTextID,
    
    @EndUserText:{  label: 'Defect Detailed Description',
                    quickInfo: 'Detailed Description of Defect'
    }/* normally you should build a vdm_q* data element and cast the field to it to get the label, but cast to STRING is not allowed */
    @Semantics.text: true
    NotificationItemLongText as DefectLongText,
    
    LongTextCreatedByUser,
    LongTextCreatedAt,
    LongTextLastChangedByUser,
    LongTextLastChangedAt,
    MimeType,
    
    /* Associations */
    _Defect,
    _Language
  
} where I_NotificationItemLongText.Notification like '$%'
    and I_NotificationItemLongText.NotificationItem = '0000'

Learn More