I_UtilsProdValidToCharName

DDL: I_UTILSPRODVALIDTOCHARNAME SQL: IUILPRODVALIDTOD Type: view COMPOSITE
5 Fields 3 Data Sources

Valid To Date for Utilities Product

I_UtilsProdValidToCharName is a Composite CDS View that provides data about "Valid To 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 IUILPRODVALIDTOD 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 To 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
UtilsProdValidToDate 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_UtilsProdValidToCharName.
-- 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: IUILPRODVALIDTOD

CREATE VIEW I_UtilsProdValidToCharName AS
SELECT
  CharacteristicsValue.CharcInternalID AS CharcInternalID,
  CharacteristicsValue.ClfnObjectID AS UtilitiesProduct,
  _C.Characteristic AS Characteristic,
  CharacteristicsValue.CharcFromDate AS UtilsProdValidToDate,
  _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