I_InspectionSelectedSetText

DDL: I_INSPECTIONSELECTEDSETTEXT Type: view_entity BASIC Package: VDM_QM_PLANNING

Inspection Selected Set - Text

I_InspectionSelectedSetText is a Basic CDS View that provides data about "Inspection Selected Set - Text" in SAP S/4HANA. It reads from 1 data source (qpamtxt) and exposes 8 fields with key fields SelectedCodeSetPlant, InspectionCatalog, SelectedCodeSet, Language. It has 3 associations to related views. Part of development package VDM_QM_PLANNING.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
qpamtxt qpamtxt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Plant _SelectedSetPlant $projection.SelectedCodeSetPlant = _SelectedSetPlant.Plant
[1..1] I_Inspectioncatalog _InspectionCatalog $projection.InspectionCatalog = _InspectionCatalog.InspectionCatalog
[1..1] I_InspectionSelectedSet _InspectionSelectedSet $projection.SelectedCodeSetPlant = _InspectionSelectedSet.SelectedCodeSetPlant and $projection.InspectionCatalog = _InspectionSelectedSet.InspectionCatalog and $projection.SelectedCodeSet = _InspectionSelectedSet.SelectedCodeSet

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inspection Selected Set - Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view
Analytics.technicalName IINSPSELDSETTEXT view
ObjectModel.representativeKey SelectedCodeSet view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SelectedCodeSetPlant qpamtxt werks
KEY InspectionCatalog qpamtxt katalogart
KEY SelectedCodeSet qpamtxt auswahlmge
KEY Language qpamtxt language
SelectedCodeSetText
_SelectedSetPlant _SelectedSetPlant
_InspectionCatalog _InspectionCatalog
_InspectionSelectedSet _InspectionSelectedSet 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Inspection Selected Set - Text'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities:
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #LANGUAGE_DEPENDENT_TEXT ]
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel.dataCategory: #TEXT
@Analytics.technicalName: 'IINSPSELDSETTEXT'
@ObjectModel.representativeKey: 'SelectedCodeSet'
@Metadata.ignorePropagatedAnnotations: true

define view entity I_InspectionSelectedSetText
  as select from qpamtxt

  association [1..1] to I_Plant                 as _SelectedSetPlant      on $projection.SelectedCodeSetPlant = _SelectedSetPlant.Plant

  association [1..1] to I_Inspectioncatalog     as _InspectionCatalog     on $projection.InspectionCatalog = _InspectionCatalog.InspectionCatalog

  association [1..1] to I_InspectionSelectedSet as _InspectionSelectedSet on $projection.SelectedCodeSetPlant = _InspectionSelectedSet.SelectedCodeSetPlant and
                                                                             $projection.InspectionCatalog = _InspectionSelectedSet.InspectionCatalog and
                                                                             $projection.SelectedCodeSet = _InspectionSelectedSet.SelectedCodeSet                                                                            

{
      @ObjectModel.foreignKey.association: '_SelectedSetPlant'
  key qpamtxt.werks      as SelectedCodeSetPlant,
      @ObjectModel.foreignKey.association: '_Inspectioncatalog'
  key qpamtxt.katalogart as InspectionCatalog,
      @ObjectModel.foreignKey.association: '_InspectionSelectedSet'
  key qpamtxt.auswahlmge as SelectedCodeSet,
      @Semantics.language: true
  key qpamtxt.language as Language,
      @Semantics.text: true
  cast( qpamtxt.ktx01 as vdm_qktextam preserving type ) as SelectedCodeSetText,

      /* Associations */
      _SelectedSetPlant,
      _InspectionCatalog,
      _InspectionSelectedSet
}

Learn More