I_INSPECTIONMETHODVERSIONTEXT

CDS View

Inspection Method Version Text

I_INSPECTIONMETHODVERSIONTEXT is a CDS View in S/4HANA. Inspection Method Version Text. It contains 6 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_InspectionMethodText view from COMPOSITE Inspection Method Texts

Fields (6)

KeyField CDS FieldsUsed in Views
KEY InspectionMethod InspectionMethod 1
KEY InspectionMethodPlant InspectionMethodPlant 1
KEY InspectionMethodVersion InspectionMethodVersion 1
KEY Language Language 1
InspectionMethodText InspectionMethodText 1
InspMethodHasLongText InspMethodHasLongText 1 
@AbapCatalog.sqlViewName: 'IINSPMETHODVERST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Inspection Method Version Text'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.dataCategory: #TEXT
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities:
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #LANGUAGE_DEPENDENT_TEXT ]
@ObjectModel.representativeKey: 'InspectionMethodVersion'
@ObjectModel.usageType: {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #A 
}
define view I_InspectionMethodVersionText as select from qmtt 
      
   association [1..1] to I_Plant as _InspectionMethodPlant
      on     $projection.InspectionMethodPlant = _InspectionMethodPlant.Plant
      
   association [1..1] to I_InspectionMethod    as _InspectionMethod
      on     $projection.InspectionMethodPlant = _InspectionMethod.InspectionMethodPlant
         and $projection.InspectionMethod      = _InspectionMethod.InspectionMethod

   association [1..1] to I_InspectionMethodVersion as _InspectionMethodVersion
      on     $projection.InspectionMethodPlant     = _InspectionMethodVersion.InspectionMethodPlant
         and $projection.InspectionMethod          = _InspectionMethodVersion.InspectionMethod
         and $projection.InspectionMethodVersion   = _InspectionMethodVersion.InspectionMethodVersion

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

{
    @ObjectModel.foreignKey.association: '_InspectionMethodPlant'
    key qmtt.werks as InspectionMethodPlant, 
    @ObjectModel.foreignKey.association: '_InspectionMethod'
    key qmtt.pmtnr as InspectionMethod, 
    @ObjectModel.foreignKey.association: '_InspectionMethodVersion'
    key qmtt.version as InspectionMethodVersion,
    @Semantics.language: true
    key qmtt.sprache as Language, 
    
    @Semantics.text: true 
    cast( qmtt.kurztext as vdm_qkurztext_qmtt preserving type ) as InspectionMethodText,
    
    @Semantics.booleanIndicator: true
    cast( qmtt.ltextkz as vdm_qltextmt preserving type )  as InspMethodHasLongText,
//    qmtt.geloescht,   // is deleted 

//    qmtt.gueltigab,   // valid from date


   /* Associations */
   _InspectionMethodVersion,
   _InspectionMethod,
   _InspectionMethodPlant,
   _Language
}
// Exclude content with technical language codes 1Q and 2Q

where sprache <> '늑'
  and sprache <> '닱'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QMTT"
],
"ASSOCIATED":
[
"I_INSPECTIONMETHOD",
"I_INSPECTIONMETHODVERSION",
"I_LANGUAGE",
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More