I_InspSubsetResultLongText

DDL: I_INSPSUBSETRESULTLONGTEXT Type: view_entity BASIC Package: VDM_QM_INSPECTION

Long Text of Insp Point Result

I_InspSubsetResultLongText is a Basic CDS View that provides data about "Long Text of Insp Point Result" in SAP S/4HANA. It reads from 1 data source (qasrltext) and exposes 14 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID, ItemCounter. It has 2 associations to related views. Part of development package VDM_QM_INSPECTION.

Data Sources (1)

SourceAliasJoin Type
qasrltext qasrltext from

Associations (2)

CardinalityTargetAliasCondition
[1] I_InspectionLot _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Long Text of Insp Point Result view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey InspectionLot view
Analytics.technicalName IINSPSBSTRESLT view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot prueflos
KEY InspPlanOperationInternalID vorglfnr
KEY InspectionCharacteristic merknr
KEY InspectionSubsetInternalID probenr
KEY ItemCounter counter
KEY Language langu
LongTextID textid
InspSubsetResultLongText content
LongTextCreatedByUser created_by
LongTextCreatedAt created_at
LongTextLastChangedByUser changed_by
LongTextLastChangedAt changed_at
_InspectionLot _InspectionLot
_Language _Language
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Long Text of Insp Point Result'
@VDM.viewType: #BASIC
@ObjectModel: {
    dataCategory: #TEXT,
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L,
        serviceQuality: #C
    },
    representativeKey: 'InspectionLot'
}
@Analytics.technicalName: 'IINSPSBSTRESLT'
define view entity I_InspSubsetResultLongText as select from qasrltext 
    association [1] to I_InspectionLot as _InspectionLot
      on $projection.InspectionLot = _InspectionLot.InspectionLot
    association [1..1] to I_Language as _Language
      on $projection.Language = _Language.Language
{
    @ObjectModel.foreignKey.association: '_InspectionLot'
    key prueflos as InspectionLot,
    key vorglfnr as InspPlanOperationInternalID,
    key merknr   as InspectionCharacteristic,
    key probenr  as InspectionSubsetInternalID,
    key counter  as ItemCounter,
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key langu as Language,
    textid as LongTextID,

    content     as InspSubsetResultLongText,
    created_by  as LongTextCreatedByUser,
    created_at  as LongTextCreatedAt,
    changed_by  as LongTextLastChangedByUser,
    changed_at  as LongTextLastChangedAt,

    /* Association */
    _InspectionLot,
    _Language    
}