A_InspectionMethod

DDL: A_INSPECTIONMETHOD SQL: AINSPMETHOD Type: view COMPOSITE

Inspection Methods

A_InspectionMethod is a Composite CDS View that provides data about "Inspection Methods" in SAP S/4HANA. It reads from 1 data source (I_InspectionMethodVersion) and exposes 16 fields with key fields InspectionMethod, InspectionMethodVersion, InspectionMethodPlant. It has 2 associations to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_InspectionMethodVersion I_InspectionMethodVersion from

Associations (2)

CardinalityTargetAliasCondition
[0..*] A_InspectionMethodText _Text $projection.InspectionMethod = _Text.InspectionMethod and $projection.InspectionMethodVersion = _Text.InspectionMethodVersion and $projection.InspectionMethodPlant = _Text.InspectionMethodPlant
[0..1] E_InspectionMethodVersion _Extension $projection.InspectionMethod = _Extension.InspectionMethod and $projection.InspectionMethodVersion = _Extension.InspectionMethodVersion and $projection.InspectionMethodPlant = _Extension.InspectionMethodPlant

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName AINSPMETHOD 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 Methods 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 (16)

KeyFieldSource TableSource FieldDescription
KEY InspectionMethod I_InspectionMethodVersion InspectionMethod
KEY InspectionMethodVersion I_InspectionMethodVersion InspectionMethodVersion
KEY InspectionMethodPlant I_InspectionMethodVersion InspectionMethodPlant
InspectionMethodValidFromDate I_InspectionMethodVersion InspectionMethodValidFromDate
InspectionMethodSearchField I_InspectionMethodVersion InspectionMethodSearchField
InspectionMethodStatus I_InspectionMethodVersion InspectionMethodStatus
InspMethInformationField1 I_InspectionMethodVersion InspMethInformationField1
InspMethInformationField2 I_InspectionMethodVersion InspMethInformationField2
InspMethInformationField3 I_InspectionMethodVersion InspMethInformationField3
QltyMstrDataAuthorizationGroup I_InspectionMethodVersion QltyMstrDataAuthorizationGroup
InspectorQualification I_InspectionMethodVersion InspectorQualification
CreatedByUser I_InspectionMethodVersion CreatedByUser
CreationDate I_InspectionMethodVersion CreationDate
LastChangedByUser I_InspectionMethodVersion LastChangedByUser
LastChangeDate I_InspectionMethodVersion LastChangeDate
_Text _Text 
@AbapCatalog.sqlViewName: 'AINSPMETHOD'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@EndUserText.label: 'Inspection Methods'
@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_InspectionMethod as select from I_InspectionMethodVersion 
  association [0..*] to A_InspectionMethodText as _Text 
    on $projection.InspectionMethod = _Text.InspectionMethod
          and $projection.InspectionMethodVersion = _Text.InspectionMethodVersion                                                           
          and $projection.InspectionMethodPlant = _Text.InspectionMethodPlant
          
       //Extensibility

  association [0..1] to E_InspectionMethodVersion as _Extension
    on    $projection.InspectionMethod = _Extension.InspectionMethod
          and $projection.InspectionMethodVersion = _Extension.InspectionMethodVersion                                                           
          and $projection.InspectionMethodPlant = _Extension.InspectionMethodPlant
            
{

   key I_InspectionMethodVersion.InspectionMethod,
   key I_InspectionMethodVersion.InspectionMethodVersion, 
   key I_InspectionMethodVersion.InspectionMethodPlant, 
   I_InspectionMethodVersion.InspectionMethodValidFromDate, 
   I_InspectionMethodVersion.InspectionMethodSearchField, 
   I_InspectionMethodVersion.InspectionMethodStatus, 
   I_InspectionMethodVersion.InspMethInformationField1, 
   I_InspectionMethodVersion.InspMethInformationField2, 
   I_InspectionMethodVersion.InspMethInformationField3, 
   I_InspectionMethodVersion.QltyMstrDataAuthorizationGroup,
   I_InspectionMethodVersion.InspectorQualification,  // Inspector Qualification 

   I_InspectionMethodVersion.CreatedByUser,
   I_InspectionMethodVersion.CreationDate,
   I_InspectionMethodVersion.LastChangedByUser,
   I_InspectionMethodVersion.LastChangeDate,
   concat(concat(I_InspectionMethodVersion.InspectionMethodPlant, I_InspectionMethodVersion.InspectionMethod),
   I_InspectionMethodVersion.InspectionMethodVersion) as LinkedSAPObjectKey,
   
   /*Assocations*/
   _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONMETHODVERSION"
],
"ASSOCIATED":
[
"A_INSPECTIONMETHODTEXT",
"E_INSPECTIONMETHODVERSION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More