C_InspLotMatlDocValHelp

DDL: C_INSPLOTMATLDOCVALHELP SQL: CILMATLDOCVH Type: view CONSUMPTION Package: ODATA_QM_INSPLOT

Inspection Lot Material Document ValueHelp

C_InspLotMatlDocValHelp is a Consumption CDS View that provides data about "Inspection Lot Material Document ValueHelp" in SAP S/4HANA. It reads from 2 data sources (I_InspLotMatlDocItem, I_InspectionLot) and exposes 11 fields with key fields InspectionLot, InspLotMatlDocItem. Part of development package ODATA_QM_INSPLOT.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_InspLotMatlDocItem I_InspLotMatlDocItem from
I_InspectionLot InspLot inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CILMATLDOCVH view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
Search.searchable true view
EndUserText.label Inspection Lot Material Document ValueHelp view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspLotMatlDocItem InspectionLot
KEY InspLotMatlDocItem InspLotMatlDocItem
InspLotMatlDocItemType InspLotMatlDocItemType
Plant I_InspectionLot Plant
InspectionLotType I_InspectionLot InspectionLotType
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup
IsBusinessPurposeCompleted I_InspectionLot IsBusinessPurposeCompleted
MaterialDocument I_InspLotMatlDocItem MaterialDocument
MaterialDocumentYear I_InspLotMatlDocItem MaterialDocumentYear
MaterialDocumentItem I_InspLotMatlDocItem MaterialDocumentItem
CreationDate CreationDate 
@AbapCatalog.sqlViewName: 'CILMATLDOCVH'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #B
}
@Search.searchable: true
@EndUserText.label: 'Inspection Lot Material Document ValueHelp'
define view C_InspLotMatlDocValHelp
  as select from I_InspLotMatlDocItem
    inner join   I_InspectionLot as InspLot on InspLot.InspectionLot = I_InspLotMatlDocItem.InspectionLot

{
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.8
  key  I_InspLotMatlDocItem.InspectionLot,
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.8
  key  InspLotMatlDocItem,
       InspLotMatlDocItemType,    
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.8
       InspLot.Plant,
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.8
       InspLot.InspectionLotType,
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.8
       InspLot.MatlQualityAuthorizationGroup,
       @UI.hidden: true
       InspLot.IsBusinessPurposeCompleted,
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.8
       I_InspLotMatlDocItem.MaterialDocument,
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.8
       I_InspLotMatlDocItem.MaterialDocumentYear,
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.8
       I_InspLotMatlDocItem.MaterialDocumentItem,

       @UI.hidden: true
       CreationDate
}

Learn More