I_CmmdtyHdgDrvtvContrSpecUoM

DDL: I_CMMDTYHDGDRVTVCONTRSPECUOM Type: view BASIC
3 Fields 1 Data Sources

DCS Commmodity Unit of Measure

I_CmmdtyHdgDrvtvContrSpecUoM is a Basic CDS View that provides data about "DCS Commmodity Unit of Measure" in SAP S/4HANA. It reads from 1 data source (tbac_dcs_cty) and exposes 3 fields with key fields DerivativeContrSpecification, DrvtvContrSpecValidFromDate.

Data Sources (1)

SourceAliasJoin Type
tbac_dcs_cty tbac_dcs_cty from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICMMHDGDCSUOM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label DCS Commmodity Unit of Measure view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY DerivativeContrSpecification dcsid DCSID
KEY DrvtvContrSpecValidFromDate Vers.Valid From
UnitOfMeasure dcs_uom DCS Unit of Measure

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 I_CmmdtyHdgDrvtvContrSpecUoM.
-- 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 I_CmmdtyHdgDrvtvContrSpecUoM AS
SELECT
  dcsid AS DerivativeContrSpecification,
  cast( validfrom as dats ) AS DrvtvContrSpecValidFromDate,
  dcs_uom AS UnitOfMeasure
FROM tbac_dcs_cty
;

Learn More