I_CommodityCodeForKeyDate

DDL: I_COMMODITYCODEFORKEYDATE SQL: ICMDTYCDFORKDATE Type: view COMPOSITE

Commodity Code for Key Date

I_CommodityCodeForKeyDate is a Composite CDS View that provides data about "Commodity Code for Key Date" in SAP S/4HANA. It reads from 2 data sources (I_TrdClassfctnNmbrSchmCntntAct, I_CommodityCode) and exposes 20 fields with key fields TrdClassfctnNmbrSchm, CommodityCode.

2 data source(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchmCntntAct inner
I_CommodityCode CommodityCode from

Parameters (1)

NameTypeDefault
P_KeyDate sll_validon

Annotations (8)

NameValueLevelField
EndUserText.label Commodity Code for Key Date view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICMDTYCDFORKDATE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct TrdClassfctnNmbrSchm
KEY CommodityCode CommodityCode
TrdClassfctnNmbrSchmCntnt I_CommodityCode TrdClassfctnNmbrSchmCntnt
ValidityStartDate I_CommodityCode ValidityStartDate
ValidityEndDate I_CommodityCode ValidityEndDate
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbrForOfclDesc
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbrForCnctntdDesc
UnitOfMeasureSystem UnitOfMeasureSystem
CustomsUnitOfMeasure CustomsUnitOfMeasure
SecondCustomsUnitOfMeasure SecondCustomsUnitOfMeasure
SupplementaryUnit SupplementaryUnit
SecondSupplementaryUnit SecondSupplementaryUnit
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc
_TrdClassfctnNmbrSchmCntnt _TrdClassfctnNmbrSchmCntnt
_TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchm
_SupplementaryUnit _SupplementaryUnit
_SecondSupplementaryUnit _SecondSupplementaryUnit
_CustomsUnitOfMeasure _CustomsUnitOfMeasure
_SecondCustomsUnitOfMeasure _SecondCustomsUnitOfMeasure 
@EndUserText.label: 'Commodity Code for Key Date'
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'ICMDTYCDFORKDATE'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
define view I_CommodityCodeForKeyDate
  with parameters
    P_KeyDate : sll_validon
  as select from I_CommodityCode                as CommodityCode
    inner join   I_TrdClassfctnNmbrSchmCntntAct as _TrdClassfctnNmbrSchmCntntAct on  _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchmCntnt = CommodityCode.TrdClassfctnNmbrSchmCntnt
                                                                                 and _TrdClassfctnNmbrSchmCntntAct.ValidityStartDate         <= $parameters.P_KeyDate
                                                                                 and _TrdClassfctnNmbrSchmCntntAct.ValidityEndDate           >= $parameters.P_KeyDate
{
  key _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchm,
  key CommodityCode,
      CommodityCode.TrdClassfctnNmbrSchmCntnt,
      CommodityCode.ValidityStartDate,
      CommodityCode.ValidityEndDate,
      TrdClassfctnNmbrForOfclDesc,
      TrdClassfctnNmbrForCnctntdDesc,
      UnitOfMeasureSystem,
      CustomsUnitOfMeasure,
      SecondCustomsUnitOfMeasure,
      SupplementaryUnit,
      SecondSupplementaryUnit,

      _OfficialDesc,
      _CnctntdDesc,
      _TrdClassfctnNmbrSchmCntnt,
      _TrdClassfctnNmbrSchmCntntAct._TrdClassfctnNmbrSchm,
      _SupplementaryUnit,
      _SecondSupplementaryUnit,
      _CustomsUnitOfMeasure,
      _SecondCustomsUnitOfMeasure
}
where
      CommodityCode.ValidityStartDate <= $parameters.P_KeyDate
  and CommodityCode.ValidityEndDate   >= $parameters.P_KeyDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMODITYCODE",
"I_TRDCLASSFCTNNMBRSCHMCNTNTACT"
],
"ASSOCIATED":
[
"I_CUSTOMSUNITOFMEASURE",
"I_TRDCLASSFCTNNMBRCNCTNTDDESC",
"I_TRDCLASSFCTNNMBROFFICIALDESC",
"I_TRDCLASSFCTNNMBRSCHM",
"I_TRDCLASSFCTNNMBRSCHMCNTNT",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_COMMODITYCODE",
"I_TRDCLASSFCTNNMBRSCHMCNTNTACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More