I_ProductTypeCodeText

DDL: I_PRODUCTTYPECODETEXT Type: view BASIC Package: VDM_MD_PRODUCT_DDIC

Product Type Code - Text

I_ProductTypeCodeText is a Basic CDS View that provides data about "Product Type Code - Text" in SAP S/4HANA. It reads from 1 data source (cmd_prdtype_t) and exposes 5 fields with key fields ProductTypeCode, Language. It has 2 associations to related views. Part of development package VDM_MD_PRODUCT_DDIC.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
cmd_prdtype_t cmd_prdtype_t from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProductTypeCode _ProductTypeCode $projection.ProductTypeCode = _ProductTypeCode.ProductTypeCode
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IPRODTYPCODETXT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey ProductTypeCode view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.sapObjectNodeType.name ProductTypeGroupCodeText view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Product Type Code - Text view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Search.searchable true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProductTypeCode prod_type_code
KEY Language spras
Name description
_ProductTypeCode _ProductTypeCode
_Language _Language 
@AbapCatalog:{
  sqlViewName: 'IPRODTYPCODETXT',
  preserveKey: true,
  compiler.compareFilter: true
 }

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel:{
  representativeKey: 'ProductTypeCode',
  dataCategory: #TEXT,
  usageType: {
    serviceQuality: #A,
    sizeCategory : #L,
    dataClass: #CUSTOMIZING
  },
  sapObjectNodeType.name:'ProductTypeGroupCodeText'
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Product Type Code - Text'
@Metadata.ignorePropagatedAnnotations: true
@Analytics:{
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture.automatic: true
    }
}
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #LANGUAGE_DEPENDENT_TEXT,
                                      #EXTRACTION_DATA_SOURCE
]
@Search.searchable: true

define view I_ProductTypeCodeText
  as select from cmd_prdtype_t

  association [1..1] to I_ProductTypeCode as _ProductTypeCode on $projection.ProductTypeCode = _ProductTypeCode.ProductTypeCode
  association [1..1] to I_Language        as _Language        on $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_ProductTypeCode'
  key prod_type_code as ProductTypeCode,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key spras          as Language,
      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      description    as Name,

      _ProductTypeCode,
      _Language
}

Learn More