A_AssgmtInspMethInspSpec

DDL: A_ASSGMTINSPMETHINSPSPEC SQL: AASSGMTIMETHSPEC Type: view BASIC

Assignmt Inspection Specification-Method

A_AssgmtInspMethInspSpec is a Basic CDS View that provides data about "Assignmt Inspection Specification-Method" in SAP S/4HANA. It reads from 2 data sources (I_AssgmtInspMethInspSpec, I_InspSpecificationVersion) and exposes 12 fields with key fields InspectionSpecificationPlant, InspectionSpecification, InspectionSpecificationVersion, InspectionMethodPlant, InspectionMethod.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_AssgmtInspMethInspSpec I_AssgmtInspMethInspSpec from
I_InspSpecificationVersion I_InspSpecificationVersion inner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName AASSGMTIMETHSPEC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Assignmt Inspection Specification-Method view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InspectionSpecificationPlant I_AssgmtInspMethInspSpec InspectionSpecificationPlant
KEY InspectionSpecification I_AssgmtInspMethInspSpec InspectionSpecification
KEY InspectionSpecificationVersion I_AssgmtInspMethInspSpec InspectionSpecificationVersion
KEY InspectionMethodPlant I_AssgmtInspMethInspSpec InspectionMethodPlant
KEY InspectionMethod I_AssgmtInspMethInspSpec InspectionMethod
KEY InspectionMethodVersion I_AssgmtInspMethInspSpec InspectionMethodVersion
Plant I_AssgmtInspMethInspSpec Plant
ValidityStartDate I_AssgmtInspMethInspSpec ValidityStartDate
SelectedCodeSet I_AssgmtInspMethInspSpec SelectedCodeSet
SelectedCodeSetPlant I_AssgmtInspMethInspSpec SelectedCodeSetPlant
QltyMstrDataAuthorizationGroup
InspectionSpecificationStatus 
@AbapCatalog.sqlViewName: 'AASSGMTIMETHSPEC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Assignmt Inspection Specification-Method'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ObjectModel.compositionRoot: true
@ObjectModel.usageType: {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #A
}
@ObjectModel.createEnabled: false
@ObjectModel.updateEnabled: false
@ObjectModel.deleteEnabled: false
@Metadata.ignorePropagatedAnnotations: true

define view A_AssgmtInspMethInspSpec as select from I_AssgmtInspMethInspSpec 
  inner join I_InspSpecificationVersion on I_InspSpecificationVersion.InspectionSpecification = I_AssgmtInspMethInspSpec.InspectionSpecification
                                        and I_InspSpecificationVersion.InspectionSpecificationVersion = I_AssgmtInspMethInspSpec.InspectionSpecificationVersion
                                        and I_InspSpecificationVersion.InspectionSpecificationPlant = I_AssgmtInspMethInspSpec.InspectionSpecificationPlant
                     
{
   key I_AssgmtInspMethInspSpec.InspectionSpecificationPlant, 
   key I_AssgmtInspMethInspSpec.InspectionSpecification, 
   key I_AssgmtInspMethInspSpec.InspectionSpecificationVersion, 
   key I_AssgmtInspMethInspSpec.InspectionMethodPlant, 
   key I_AssgmtInspMethInspSpec.InspectionMethod, 
   key I_AssgmtInspMethInspSpec.InspectionMethodVersion, 
   I_AssgmtInspMethInspSpec.Plant, 
   I_AssgmtInspMethInspSpec.ValidityStartDate, 
   I_AssgmtInspMethInspSpec.SelectedCodeSet,
   I_AssgmtInspMethInspSpec.SelectedCodeSetPlant,

   I_AssgmtInspMethInspSpec._InspSpecificationVersion.QltyMstrDataAuthorizationGroup,
   @Consumption.hidden: true
   I_AssgmtInspMethInspSpec._InspSpecificationVersion.InspectionSpecificationStatus
}

Learn More