C_CommodityCodeForKeyDate

DDL: C_COMMODITYCODEFORKEYDATE SQL: CCMDTYCDFORKDATE Type: view CONSUMPTION Package: VDM_SLL_CLS
21 Fields 1 Data Sources 1 Associations 3 OData Services

Commodity Code for Key Date

C_CommodityCodeForKeyDate is a Consumption CDS View that provides data about "Commodity Code for Key Date" in SAP S/4HANA. It reads from 1 data source (I_CommodityCodeForKeyDate) and exposes 21 fields with key fields TrdClassfctnNmbrSchm, CommodityCode. It has 1 association to related views. It is exposed through 3 OData services (ASQL_F2151, ASQL_F2152, ASQL_F2826). Part of development package VDM_SLL_CLS.

SAP Help Documentation

CategoryTrade Classification Numbers
StatusC1 Released
Purpose
This CDS view is used to get the commodity code for a given date. This CDS view provides the data to answer the following business questions: Which commodity code exists on the specified date? Which customs unit of measure does a commodity code have? What is the official description and the concatenated text? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Parameters The parameters of the CDS view are as follows: P_KeyDate : This parameter is used to specify the key date for the commodity codes. Important Fields Important fields in this view include the following: Field Name Description TrdClassfctnNmbrSchm Numbering scheme TrdClassfctnNmbrSchmCntnt Numbering scheme content CommodityCode Commodity code ValidityStartDate Validity from date of the commodity code ValidityEndDate Validity to date of the commodity code CustomsUnitOfMeasure Customs unit of measure TrdClassfctnNmbrForOfclDesc Official description TrdClassfctnNmbrForCnctntdDesc Concatenated text

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_CommodityCodeForKeyDate I_CommodityCodeForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sll_validon

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _Date $projection.ValidityStartDate = _Date.CalendarDate

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CCMDTYCDFORKDATE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #NONE view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F2151 ASQL_F2151 C2 NOT_RELEASED
ASQL_F2152 ASQL_F2152 C2 NOT_RELEASED
ASQL_F2826 ASQL_F2826 C2 NOT_RELEASED

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrSchm TrdClassfctnNmbrSchm
KEY CommodityCode CommodityCode Commodity Code
TrdClassfctnNmbrSchmCntnt TrdClassfctnNmbrSchmCntnt
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbrForOfclDesc
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbrForCnctntdDesc
UnitOfMeasureSystem UnitOfMeasureSystem
CustomsUnitOfMeasure CustomsUnitOfMeasure
SecondCustomsUnitOfMeasure SecondCustomsUnitOfMeasure
SupplementaryUnit SupplementaryUnit
SecondSupplementaryUnit SecondSupplementaryUnit
_Date _Date
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc
_TrdClassfctnNmbrSchmCntnt _TrdClassfctnNmbrSchmCntnt
_TrdClassfctnNmbrSchm _TrdClassfctnNmbrSchm
_SupplementaryUnit _SupplementaryUnit
_SecondSupplementaryUnit _SecondSupplementaryUnit
_CustomsUnitOfMeasure _CustomsUnitOfMeasure
_SecondCustomsUnitOfMeasure _SecondCustomsUnitOfMeasure

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CommodityCodeForKeyDate.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCMDTYCDFORKDATE
-- Parameters: P_KeyDate : sll_validon

CREATE VIEW C_CommodityCodeForKeyDate AS
SELECT
  TrdClassfctnNmbrSchm,
  CommodityCode,
  TrdClassfctnNmbrSchmCntnt,
  ValidityStartDate,
  ValidityEndDate,
  TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbrForCnctntdDesc,
  UnitOfMeasureSystem,
  CustomsUnitOfMeasure,
  SecondCustomsUnitOfMeasure,
  SupplementaryUnit,
  SecondSupplementaryUnit
FROM I_CommodityCodeForKeyDate
LEFT OUTER JOIN I_CalendarDate AS _Date ON ValidityStartDate = _Date.CalendarDate  -- association [0..1]
;

Learn More