I_CmmdtyHdgSpecPerdCatText

DDL: I_CMMDTYHDGSPECPERDCATTEXT SQL: ICMMHSPRDCAT Type: view_entity COMPOSITE

Commodity Hedge Specification Period Category - Text

I_CmmdtyHdgSpecPerdCatText is a Composite CDS View that provides data about "Commodity Hedge Specification Period Category - Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 4 fields with key fields CmmdtyHdgSpecQtaPeriodCategory, Language.

Data Sources (1)

SourceAliasJoin Type
dd07t Domain from

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #TEXT view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Commodity Hedge Specification Period Category - Text view
VDM.viewType #COMPOSITE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHdgSpecQtaPeriodCategory dd07t domvalue_l
KEY Language dd07t ddlanguage
CmmdtyHdgSpecPerdCategoryText dd07t ddtext
_HdgSpecPeriodCat _HdgSpecPeriodCat
//@AbapCatalog.sqlViewName: 'ICMMHSPRDCAT'

//@AbapCatalog.compiler.compareFilter: true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@AbapCatalog.preserveKey: true

@ObjectModel.dataCategory:#TEXT
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Commodity Hedge Specification Period Category - Text'
@VDM.viewType: #COMPOSITE
define view entity I_CmmdtyHdgSpecPerdCatText
  as select from dd07t as Domain
  association to parent I_CmmdtyHdgSpecPeriodCategory as _HdgSpecPeriodCat on $projection.CmmdtyHdgSpecQtaPeriodCategory = _HdgSpecPeriodCat.CmmdtyHdgSpecQtaPeriodCategory

{

  key Domain.domvalue_l as CmmdtyHdgSpecQtaPeriodCategory,
  key Domain.ddlanguage as Language,
      Domain.ddtext     as CmmdtyHdgSpecPerdCategoryText,
      _HdgSpecPeriodCat

}
where
      domname           = 'CMM_PERIOD_CATEGORY'
  and as4local          = 'A'
  and as4vers           = '0000'
  and Domain.ddlanguage = $session.system_language
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_CMMDTYHDGSPECPERIODCATEGORY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/