I_InspSubsetResultLongText

DDL: I_INSPSUBSETRESULTLONGTEXT SQL: IINSPSBSTRESLT Type: view BASIC

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.

1 data source(s) 14 fields

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 (12)

NameValueLevelField
AbapCatalog.sqlViewName IINSPSBSTRESLT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Long Text of Insp Point Result view
ClientHandling.algorithm #SESSION_VARIABLE 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

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 
@AbapCatalog.sqlViewName: 'IINSPSBSTRESLT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Long Text of Insp Point Result'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel: {
    dataCategory: #TEXT,
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L,
        serviceQuality: #C
    },
    representativeKey: 'InspectionLot'
}
define view 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    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QASRLTEXT"
],
"ASSOCIATED":
[
"I_INSPECTIONLOT",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More