C_ProductTCCValidityClfnTP

DDL: C_PRODUCTTCCVALIDITYCLFNTP Type: view_entity CONSUMPTION Package: CVIEW_CMDTYCODE
10 Fields 1 Data Sources 1 OData Services

Classify Product Commodity Code Validity

C_ProductTCCValidityClfnTP is a Consumption CDS View that provides data about "Classify Product Commodity Code Validity" in SAP S/4HANA. It reads from 1 data source (I_ProductTrdClassfctn) and exposes 10 fields with key fields TrdClassfctnNmbrSchm, Product, ValidityStartDate. It is exposed through 1 OData service (UI_PRDTRCMDTYCLASSIFY). Part of development package CVIEW_CMDTYCODE.

Data Sources (1)

SourceAliasJoin Type
I_ProductTrdClassfctn Classified from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Classify Product Commodity Code Validity view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PRDTRCMDTYCLASSIFY UI_PRDTRCMDTYCLASSIFY V4 C1 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrSchm I_ProductTrdClassfctn TrdClassfctnNmbrSchm Numbering Scheme
KEY Product I_ProductTrdClassfctn Product Product Sold
KEY ValidityStartDate I_ProductTrdClassfctn ValidityStartDate Validity Start Date
ValidityEndDate I_ProductTrdClassfctn ValidityEndDate ValidTo
CommodityCode
CmmdtyCodeNmbrSchm _ProductClsfctn TrdClassfctnNmbrSchm Numbering Scheme
_Product I_ProductTrdClassfctn _Product
_TrdClassfctnNmbrSchm I_ProductTrdClassfctn _TrdClassfctnNmbrSchm
_ProductClsfctn _ProductClsfctn
_TrdClassfctnNmbrSchmText _ProductClsfctn _TrdClassfctnNmbrSchmText

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_ProductTCCValidityClfnTP.
-- 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.

CREATE VIEW C_ProductTCCValidityClfnTP AS
SELECT
  Classified.TrdClassfctnNmbrSchm AS TrdClassfctnNmbrSchm,
  Classified.Product AS Product,
  Classified.ValidityStartDate AS ValidityStartDate,
  Classified.ValidityEndDate AS ValidityEndDate,
  cast (Classified.TrdClassfctnNmbr as /scmtms/comco preserving type) AS CommodityCode,
  _ProductClsfctn.TrdClassfctnNmbrSchm AS CmmdtyCodeNmbrSchm,
  Classified._Product AS _Product,
  Classified._TrdClassfctnNmbrSchm AS _TrdClassfctnNmbrSchm,
  _ProductClsfctn._TrdClassfctnNmbrSchmText AS _TrdClassfctnNmbrSchmText
FROM I_ProductTrdClassfctn AS Classified
;

Learn More