I_MerchandiseCategoryText

DDL: I_MERCHANDISECATEGORYTEXT Type: view_entity BASIC

Merchandise Category - Text

I_MerchandiseCategoryText is a Basic CDS View that provides data about "Merchandise Category - Text" in SAP S/4HANA. It reads from 2 data sources (t023t, klah) and exposes 6 fields with key fields MerchandiseCategory, Language. It has 2 associations to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
t023t MerchandiseCategoryText from
klah MrchdsCategory inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MerchandiseCategory _MerchandiseCategory $projection.MerchandiseCategory = _MerchandiseCategory.MerchandiseCategory
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey MerchandiseCategory view
ObjectModel.dataCategory #TEXT view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Merchandise Category - Text view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MerchandiseCategory t023t matkl
KEY Language t023t spras
MerchandiseCategoryName t023t wgbez
MerchandiseCategoryText t023t wgbez60
_MerchandiseCategory _MerchandiseCategory
_Language _Language 
@VDM: {
  viewType                          : #BASIC,
  lifecycle.contract.type           : #PUBLIC_LOCAL_API
}

@Analytics:{
  internalName                      : #LOCAL,
  dataExtraction                    : {
  enabled                           : true
} }

@AccessControl.authorizationCheck   : #CHECK
@ObjectModel: {
   representativeKey                : 'MerchandiseCategory',
   dataCategory                     : #TEXT,
   supportedCapabilities            : [ #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #EXTRACTION_DATA_SOURCE,
                                        #LANGUAGE_DEPENDENT_TEXT
                                       ], 
   modelingPattern                  :  #LANGUAGE_DEPENDENT_TEXT,                                                            
   usageType                        : {serviceQuality: #A,sizeCategory: #M,dataClass: #MASTER }
 }
@Metadata :{
   ignorePropagatedAnnotations      : true
}
@EndUserText.label                  : 'Merchandise Category - Text'

define view entity I_MerchandiseCategoryText
  as select from t023t as MerchandiseCategoryText
    inner join   klah  as MrchdsCategory on  MerchandiseCategoryText.matkl = MrchdsCategory.class
                                         and MrchdsCategory.wwskz          = '1'
                                         
  association [1..1] to I_MerchandiseCategory as _MerchandiseCategory on $projection.MerchandiseCategory = _MerchandiseCategory.MerchandiseCategory
  association [0..1] to I_Language            as _Language            on $projection.Language            = _Language.Language

{
      @ObjectModel.foreignKey.association: '_MerchandiseCategory'
  key MerchandiseCategoryText.matkl   as MerchandiseCategory,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key MerchandiseCategoryText.spras   as Language,
      @Semantics.text: true
      MerchandiseCategoryText.wgbez   as MerchandiseCategoryName,
      @Semantics.text: true
      MerchandiseCategoryText.wgbez60 as MerchandiseCategoryText,
      /* Associations */
      _MerchandiseCategory,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KLAH",
"T023T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_MERCHANDISECATEGORY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More