I_DefectLongTextTP

DDL: I_DEFECTLONGTEXTTP SQL: IDEFLONGTXTTP Type: view TRANSACTIONAL

Defect Long Text

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

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_DefectLongText _DefectLongText from

Associations (1)

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

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IDEFLONGTXTTP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
EndUserText.label Defect Long Text view
ObjectModel.dataCategory #TEXT view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence QDEFECTLTXT_D view
ObjectModel.writeActivePersistence V_DEFTXT_BO2ACT view
ObjectModel.representativeKey DefectInternalID view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID I_DefectLongText DefectInternalID
KEY ItemCounter I_DefectLongText LongTextInternalNumber
KEY Language I_DefectLongText Language
LongTextID I_DefectLongText LongTextID
DefectLongText I_DefectLongText DefectLongText
LongTextCreatedByUser I_DefectLongText LongTextCreatedByUser
LongTextCreatedAt I_DefectLongText LongTextCreatedAt
LongTextLastChangedByUser I_DefectLongText LongTextLastChangedByUser
LongTextLastChangedAt I_DefectLongText LongTextLastChangedAt
MimeType I_DefectLongText MimeType
_Defect_TP _Defect_TP
_Language I_DefectLongText _Language 
@AbapCatalog.sqlViewName: 'IDEFLONGTXTTP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true 
@AccessControl.authorizationCheck: #MANDATORY
@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #A
}
@EndUserText.label: 'Defect Long Text'

/* Draft 2.0*/
@ObjectModel:{
    dataCategory: #TEXT,
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    writeDraftPersistence: 'QDEFECTLTXT_D',
    writeActivePersistence: 'V_DEFTXT_BO2ACT',
    representativeKey: 'DefectInternalID'
} 

define view I_DefectLongTextTP  as select from I_DefectLongText as _DefectLongText

    association [1..1] to I_Defect_TP as _Defect_TP on $projection.DefectInternalID = _Defect_TP.DefectInternalID

{

    @ObjectModel.foreignKey.association: '_Defect_TP'
    @ObjectModel.readOnly: true
    key _DefectLongText.DefectInternalID,
   
    @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
    key _DefectLongText.LongTextInternalNumber as ItemCounter,

    @Semantics.language: true
    @ObjectModel.readOnly: true
    key _DefectLongText.Language,
        
    @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
    _DefectLongText.LongTextID,
    
    @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
    _DefectLongText.DefectLongText,
    
    @ObjectModel.readOnly: true
    _DefectLongText.LongTextCreatedByUser,
    @ObjectModel.readOnly: true
    _DefectLongText.LongTextCreatedAt,
    @ObjectModel.readOnly: true
    _DefectLongText.LongTextLastChangedByUser,
    @ObjectModel.readOnly: true
    _DefectLongText.LongTextLastChangedAt,
    @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
    _DefectLongText.MimeType,
    
    /* Associations */
    @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
    _Defect_TP,
    _DefectLongText._Language
  
}

Learn More