A_InspectionMethodText

DDL: A_INSPECTIONMETHODTEXT SQL: AINSPMETHODT Type: view COMPOSITE

Inspection Method Texts

A_InspectionMethodText is a Composite CDS View that provides data about "Inspection Method Texts" in SAP S/4HANA. It reads from 1 data source (I_InspectionMethodVersionText) and exposes 9 fields with key fields InspectionMethodPlant, InspectionMethod, InspectionMethodVersion, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InspectionMethodVersionText I_InspectionMethodVersionText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_InspectionMethod _InspectionMethod $projection.InspectionMethod = _InspectionMethod.InspectionMethod and $projection.InspectionMethodVersion = _InspectionMethod.InspectionMethodVersion and $projection.InspectionMethodPlant = _InspectionMethod.InspectionMethodPlant

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName AINSPMETHODT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Inspection Method Texts view
AccessControl.authorizationCheck #CHECK view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InspectionMethodPlant I_InspectionMethodVersionText InspectionMethodPlant
KEY InspectionMethod I_InspectionMethodVersionText InspectionMethod
KEY InspectionMethodVersion I_InspectionMethodVersionText InspectionMethodVersion
KEY Language I_InspectionMethodVersionText Language
InspectionMethodText I_InspectionMethodVersionText InspectionMethodText
InspMethodHasLongText I_InspectionMethodVersionText InspMethodHasLongText
QltyMstrDataAuthorizationGroup _InspectionMethod QltyMstrDataAuthorizationGroup
InspectionMethodStatus _InspectionMethod InspectionMethodStatus
_InspectionMethod _InspectionMethod
@AbapCatalog.sqlViewName: 'AINSPMETHODT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@EndUserText.label: 'Inspection Method Texts'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.compositionRoot: true
@ObjectModel.usageType: {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #B
}
@ObjectModel.createEnabled: false
@ObjectModel.updateEnabled: false
@ObjectModel.deleteEnabled: false
@Metadata.ignorePropagatedAnnotations: true

define view A_InspectionMethodText as select from I_InspectionMethodVersionText 
  association [1..1] to A_InspectionMethod as _InspectionMethod
    on $projection.InspectionMethod = _InspectionMethod.InspectionMethod
          and $projection.InspectionMethodVersion = _InspectionMethod.InspectionMethodVersion                                                           
          and $projection.InspectionMethodPlant = _InspectionMethod.InspectionMethodPlant
            
{
   key I_InspectionMethodVersionText.InspectionMethodPlant, 
   key I_InspectionMethodVersionText.InspectionMethod, 
   key I_InspectionMethodVersionText.InspectionMethodVersion, 
   key I_InspectionMethodVersionText.Language, 
   I_InspectionMethodVersionText.InspectionMethodText, 
   I_InspectionMethodVersionText.InspMethodHasLongText,

   // for Auth Check only

   @Consumption.hidden: true
   _InspectionMethod.QltyMstrDataAuthorizationGroup, 
   @Consumption.hidden: true
   _InspectionMethod.InspectionMethodStatus,
   
   /* Associations */
   _InspectionMethod
}