I_InspectionLotType

DDL: I_INSPECTIONLOTTYPE SQL: IINSPLOTTYPE Type: view BASIC

Inspection Type

I_InspectionLotType is a Basic CDS View that provides data about "Inspection Type" in SAP S/4HANA. It reads from 1 data source (tq30) and exposes 6 fields with key field InspectionLotType. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
tq30 tq30 from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_InspectionLotTypeText _Text $projection.InspectionLotType = _Text.InspectionLotType
[0..1] I_Indicator _SelectedCodeSetHasSamePlant $projection.SelectedCodeSetHasSamePlant = _SelectedCodeSetHasSamePlant.IndicatorValue

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IINSPLOTTYPE view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Inspection Type view
ObjectModel.compositionRoot true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey InspectionLotType view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
ObjectModel.sapObjectNodeType.name InspectionLotType view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InspectionLotType tq30 art
BillOfOperationsUsage tq30 pplverw
SelectedCodeSet tq30 vemenge
SelectedCodeSetHasSamePlant tq30 kzvewerks
_Text _Text
_SelectedCodeSetHasSamePlant _SelectedCodeSetHasSamePlant 
@AbapCatalog.sqlViewName: 'IINSPLOTTYPE'
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inspection Type'
@ObjectModel.compositionRoot: true
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities:
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #SEARCHABLE_ENTITY ]
@ObjectModel.usageType: { dataClass: #CUSTOMIZING, sizeCategory: #S, serviceQuality: #A }
@ObjectModel.representativeKey: 'InspectionLotType'
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
@ObjectModel.sapObjectNodeType.name: 'InspectionLotType'
define view I_InspectionLotType as select from tq30 

   association [0..*] to I_InspectionLotTypeText as _Text 
     on $projection.InspectionLotType = _Text.InspectionLotType
     
   association [0..1] to I_Indicator as _SelectedCodeSetHasSamePlant
     on $projection.SelectedCodeSetHasSamePlant = _SelectedCodeSetHasSamePlant.IndicatorValue
     
{ 
  @ObjectModel.text.association: '_Text'
  @Search : {
    defaultSearchElement: true,
    fuzzinessThreshold: 0.8,
    ranking: #HIGH
  }
  key tq30.art as InspectionLotType,
    @Search : {
    defaultSearchElement: true,
    fuzzinessThreshold: 0.8,
    ranking: #HIGH
  }
      tq30.pplverw as BillOfOperationsUsage, 
//  tq30.bilds, 

      tq30.vemenge     as SelectedCodeSet, 
//  tq30.veversion, 

//  tq30.vedatum, 

      @ObjectModel.foreignKey.association: '_SelectedCodeSetHasSamePlant'
      tq30.kzvewerks   as SelectedCodeSetHasSamePlant, 
//  tq30.kzpzdr, 

//  tq30.kzpadr, 

//  tq30.kzmessage, 

//  tq30.stsma, 

//  tq30.erfsicht, 

//  tq30.steus, 

//  tq30.qmart, 

//  tq30.vornr, 

//  tq30.prart, 

//  tq30.einemeld, 

//  tq30.auart,


   // Associations

   _Text,
   _SelectedCodeSetHasSamePlant
    
}   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TQ30"
],
"ASSOCIATED":
[
"I_INDICATOR",
"I_INSPECTIONLOTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More