I_InspectionLotAllLongText

DDL: I_INSPECTIONLOTALLLONGTEXT SQL: IINSPLOTALLLTXT Type: view BASIC

All Text of Inspection Lot

I_InspectionLotAllLongText is a Basic CDS View that provides data about "All Text of Inspection Lot" in SAP S/4HANA. It reads from 1 data source (qalsltext) and exposes 11 fields with key fields InspectionLot, ItemCounter, Language. It has 2 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
qalsltext qalsltext from

Associations (2)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IINSPLOTALLLTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label All Text of Inspection Lot 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 (11)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot prueflos
KEY ItemCounter counter
KEY Language langu
LongTextID textid
InspectionLotLongText content
LongTextCreatedByUser created_by
LongTextCreatedAt created_at
LongTextLastChangedByUser changed_by
LongTextLastChangedAt changed_at
_InspectionLot _InspectionLot
_Language _Language 
@AbapCatalog.sqlViewName: 'IINSPLOTALLLTXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'All Text of Inspection Lot'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel: {
    dataCategory: #TEXT,
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L,
        serviceQuality: #C
    },
    representativeKey: 'InspectionLot'
}
define view I_InspectionLotAllLongText as select from qalsltext
    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 counter as ItemCounter,
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key langu as Language,
    textid as LongTextID,
  
    content     as InspectionLotLongText, 
    created_by  as LongTextCreatedByUser,
    created_at  as LongTextCreatedAt,
    changed_by  as LongTextLastChangedByUser,
    changed_at  as LongTextLastChangedAt,

    /* Association */ 
    _InspectionLot,
    _Language        
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QALSLTEXT"
],
"ASSOCIATED":
[
"I_INSPECTIONLOT",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More