I_PRODUCTDESCRIPTION

CDS View

Product Descriptions

I_PRODUCTDESCRIPTION is a CDS View in S/4HANA. Product Descriptions. It contains 4 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 4 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
/SCMTMS/CV_ProductDescription view from BOPF: Product Desc. Representation Node
A_ClfnProductDescription view from BASIC Product Description
A_ProductDescription view from BASIC Product Description
CIC_PRODUCT_TEXT view_entity from Projection on Product Description (Industry Cloud Solutions)
I_ProductDescriptionWD view from TRANSACTIONAL Product BO - Description Node (draft)
P_Prchinforecords_FS view left_outer BASIC
P_ProductDescriptionWD view from COMPOSITE
R_ProductDescriptionTP view_entity from TRANSACTIONAL Product Description

Fields (4)

KeyField CDS FieldsUsed in Views
KEY Language ActiveProductLanguage,Language,LanguageForEdit 3
KEY Product ActiveProduct,Product,ProductForEdit 3
LanguageISOCode LanguageISOCode 1
ProductDescription ProductDescription 4 
// Product description active table

@AbapCatalog:{
  sqlViewName: 'IPRDDESCR',
  preserveKey: true,
  compiler.compareFilter: true
}
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Product Descriptions'
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'Product'
@ObjectModel: {
    usageType.serviceQuality: #C,
    usageType.sizeCategory : #L,
    usageType.dataClass: #MASTER
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
@Analytics:{
    dataCategory: #DIMENSION,
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture:{
          mapping: [{
            viewElement: ['PRODUCT', 'LANGUAGE'],
            role: #MAIN,
            table: 'MAKT',
            tableElement: ['MATNR', 'SPRAS']
          },
          {
            viewElement: ['LANGUAGE'],
            role: #LEFT_OUTER_TO_ONE_JOIN,
            table: 'T002',
            tableElement: ['SPRAS']
          }]
        }
    }
}
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #EXTRACTION_DATA_SOURCE,
                                      #SEARCHABLE_ENTITY
]
define view I_ProductDescription
  as select from makt
  association [1..1] to I_Product  as _Product  on $projection.Product = _Product.Product

  association [1..1] to I_Language as _Language on $projection.Language = _Language.Language
{

  key cast(makt.matnr as productnumber preserving type )                  as Product,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key makt.spras                                                          as Language,
      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      cast(makt.maktx as productdescription preserving type )             as ProductDescription,

      cast(_Language.LanguageISOCode as languageisocode preserving type ) as LanguageISOCode,
      _Product,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LANGUAGE",
"MAKT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_PRODUCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More