I_InspectionMethodVersionText

DDL: I_INSPECTIONMETHODVERSIONTEXT SQL: IINSPMETHODVERST Type: view BASIC

Inspection Method Version Text

I_InspectionMethodVersionText is a Basic CDS View that provides data about "Inspection Method Version Text" in SAP S/4HANA. It reads from 1 data source (qmtt) and exposes 10 fields with key fields InspectionMethodPlant, InspectionMethod, InspectionMethodVersion, Language. It has 4 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
qmtt qmtt from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_Plant _InspectionMethodPlant $projection.InspectionMethodPlant = _InspectionMethodPlant.Plant
[1..1] I_InspectionMethod _InspectionMethod $projection.InspectionMethodPlant = _InspectionMethod.InspectionMethodPlant and $projection.InspectionMethod = _InspectionMethod.InspectionMethod
[1..1] I_InspectionMethodVersion _InspectionMethodVersion $projection.InspectionMethodPlant = _InspectionMethodVersion.InspectionMethodPlant and $projection.InspectionMethod = _InspectionMethodVersion.InspectionMethod and $projection.InspectionMethodVersion = _InspectionMethodVersion.InspectionMethodVersion
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IINSPMETHODVERST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Inspection Method Version Text view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey InspectionMethodVersion view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY InspectionMethodPlant qmtt werks
KEY InspectionMethod qmtt pmtnr
KEY InspectionMethodVersion qmtt version
KEY Language qmtt sprache
InspectionMethodText
InspMethodHasLongText
_InspectionMethodVersion _InspectionMethodVersion
_InspectionMethod _InspectionMethod
_InspectionMethodPlant _InspectionMethodPlant
_Language _Language 
@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