I_InspSpecAddlCodeGroupText

DDL: I_INSPSPECADDLCODEGROUPTEXT Type: view_entity BASIC Package: VDM_QM_PLANNING

Addl Code Group of Master Charc - Text

I_InspSpecAddlCodeGroupText is a Basic CDS View that provides data about "Addl Code Group of Master Charc - Text" in SAP S/4HANA. It reads from 1 data source (qpgt) and exposes 7 fields with key fields InspSpecAdditionalCatalog, InspSpecAdditionalCodeGroup, Language. It has 3 associations to related views. Part of development package VDM_QM_PLANNING.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
qpgt qpgt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_InspSpecAdditionalCatalog _InspSpecAdditionalCatalog $projection.InspSpecAdditionalCatalog = _InspSpecAdditionalCatalog.InspSpecAdditionalCatalog
[1..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_InspSpecAddlCodeGroup _InspSpecAddlCodeGroup $projection.InspSpecAdditionalCatalog = _InspSpecAddlCodeGroup.InspSpecAdditionalCatalog and $projection.InspSpecAdditionalCodeGroup = _InspSpecAddlCodeGroup.InspSpecAdditionalCodeGroup

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Addl Code Group of Master Charc - Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey InspSpecAdditionalCodeGroup view
Analytics.technicalName IINSPADDCODEGRPT view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY InspSpecAdditionalCatalog qpgt katalogart
KEY InspSpecAdditionalCodeGroup qpgt codegruppe
KEY Language qpgt sprache
InspSpecAddlCodeGroupText qpgt kurztext
_InspSpecAdditionalCatalog _InspSpecAdditionalCatalog
_Language _Language
_InspSpecAddlCodeGroup _InspSpecAddlCodeGroup 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Addl Code Group of Master Charc - 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: {
        dataClass: #CUSTOMIZING,
        sizeCategory: #M,
        serviceQuality: #A
    },
    dataCategory: #TEXT,
    representativeKey: 'InspSpecAdditionalCodeGroup'
}
@Analytics.technicalName: 'IINSPADDCODEGRPT'
@Metadata.ignorePropagatedAnnotations: true
define view entity I_InspSpecAddlCodeGroupText
  as select from qpgt

  association [1..1] to I_InspSpecAdditionalCatalog as _InspSpecAdditionalCatalog on $projection.InspSpecAdditionalCatalog = _InspSpecAdditionalCatalog.InspSpecAdditionalCatalog
  association [1..1] to I_Language                  as _Language                  on $projection.Language = _Language.Language
  association [1..1] to I_InspSpecAddlCodeGroup     as _InspSpecAddlCodeGroup     on $projection.InspSpecAdditionalCatalog = _InspSpecAddlCodeGroup.InspSpecAdditionalCatalog
                                                                                 and $projection.InspSpecAdditionalCodeGroup = _InspSpecAddlCodeGroup.InspSpecAdditionalCodeGroup

{
      @ObjectModel.foreignKey.association: '_InspSpecAdditionalCatalog'
  key qpgt.katalogart       as InspSpecAdditionalCatalog,
  key qpgt.codegruppe       as InspSpecAdditionalCodeGroup,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key qpgt.sprache          as Language,

      @Semantics.text: true
      @EndUserText: { label: 'Additional Code Group Text', quickInfo: 'Additional Code Group Text' }
      qpgt.kurztext         as InspSpecAddlCodeGroupText

      //  qpgt.ltextv,

      //  qpgt.inaktiv


      /* Associations */
      ,_InspSpecAdditionalCatalog
      ,_Language
      ,_InspSpecAddlCodeGroup

}
where not(
       qpgt.katalogart = '1'
    or qpgt.katalogart = '3'
  )

Learn More