I_UtilsProdValidFromCharName

DDL: I_UTILSPRODVALIDFROMCHARNAME SQL: IUILPRODVALIDFRD Type: view COMPOSITE
5 Fields 3 Data Sources

Valid From Date for Utilities Product

I_UtilsProdValidFromCharName is a Composite CDS View that provides data about "Valid From Date for Utilities Product" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharacteristic, I_UtilsCommonFields, I_Product) and exposes 5 fields with key fields CharcInternalID, UtilitiesProduct.

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharacteristic _C inner
I_UtilsCommonFields _Comm inner
I_Product _P inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IUILPRODVALIDFRD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Valid From Date for Utilities Product view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID CharacteristicsValue CharcInternalID Characteristic Internal ID
KEY UtilitiesProduct CharacteristicsValue ClfnObjectID
Characteristic I_ClfnCharacteristic Characteristic Field Name
UtilsProdValidFromDate CharacteristicsValue CharcFromDate LowrBndry Date
ProductGroup I_Product ProductGroup Product Sold Group

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_UtilsProdValidFromCharName.
-- 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: IUILPRODVALIDFRD

CREATE VIEW I_UtilsProdValidFromCharName AS
SELECT
  CharacteristicsValue.CharcInternalID AS CharcInternalID,
  CharacteristicsValue.ClfnObjectID AS UtilitiesProduct,
  _C.Characteristic AS Characteristic,
  CharacteristicsValue.CharcFromDate AS UtilsProdValidFromDate,
  _P.ProductGroup AS ProductGroup
INNER JOIN I_ClfnCharacteristic AS _C ON /* join condition not captured in parsed metadata */
INNER JOIN I_Product AS _P ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilsCommonFields AS _Comm ON /* join condition not captured in parsed metadata */
;

Learn More