I_InspResultRecordingViewText

DDL: I_INSPRESULTRECORDINGVIEWTEXT SQL: IINSPRSLTRECGVWT Type: view BASIC

Inspection Results Recording View Text

I_InspResultRecordingViewText is a Basic CDS View that provides data about "Inspection Results Recording View Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields InspResultRecordingView, Language.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IINSPRSLTRECGVWT view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Inspection Results Recording View Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.dataCategory #TEXT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey InspResultRecordingView view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY InspResultRecordingView
KEY Language ddlanguage
InspResultRecordingViewText
_InspResultRecordingView _InspResultRecordingView
_Language _Language 
@AbapCatalog.sqlViewName: 'IINSPRSLTRECGVWT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Inspection Results Recording View Text'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
    dataClass: #META,
    sizeCategory: #S,
    serviceQuality: #A
}
@ObjectModel.dataCategory: #TEXT
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.representativeKey: 'InspResultRecordingView'

define view I_InspResultRecordingViewText as select from dd07t 

    association[0..1] to I_Language                  as _Language on $projection.Language = _Language.Language
    association[1..1] to I_InspResultRecordingView   as _InspResultRecordingView  on $projection.InspResultRecordingView = _InspResultRecordingView.InspResultRecordingView

{
    key cast ( substring( dd07t.domvalue_l, 1, 2 ) as vdm_qerfsicht ) as InspResultRecordingView,
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key ddlanguage as Language,
    @Semantics.text: true
    cast( ddtext as vdm_qerfsicht_text ) as  InspResultRecordingViewText,    
    
    /* Associations */
    _InspResultRecordingView,
    _Language       
}
where domname = 'QERFSICHT' and as4local = 'A'

Learn More