CRMS4_IU_I_PRDA

DDL: CRMS4_IU_I_PRDA SQL: CRMS4IUVIPRDA Type: view
30 Fields 2 Data Sources 1 Associations

Utilities Product Attribute

CRMS4_IU_I_PRDA is a CDS View that provides data about "Utilities Product Attribute" in SAP S/4HANA. It reads from 2 data sources (I_ClfnCharcDescForKeyDate, I_UtilsProdAttributes) and exposes 30 fields with key fields UtilitiesProduct, Characteristic. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_ClfnCharcDescForKeyDate I_ClfnCharcDescForKeyDate left_outer
I_UtilsProdAttributes I_UtilsProdAttributes from

Associations (1)

CardinalityTargetAliasCondition
[0..1] CRMS4_IU_I_PRD _Product _Product.UtilitiesProduct = $projection.UtilitiesProduct

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CRMS4IUVIPRDA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Utilities Product Attribute view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesProduct I_UtilsProdAttributes UtilitiesProduct
KEY Characteristic I_UtilsProdAttributes Characteristic Field Name
UtilitiesReferenceProduct I_UtilsProdAttributes UtilitiesReferenceProduct
CharcValuePositionNumber I_UtilsProdAttributes CharcValuePositionNumber
UtilsBillingOperand I_UtilsProdAttributes UtilsBillingOperand
UtilsTimeSliceCharacteristicID I_UtilsProdAttributes UtilsTimeSliceCharacteristicID
char1asIsTimeSliceAttribute
CharcValue I_UtilsProdAttributes CharcValue Char. Value
CharcValueUnit I_UtilsProdAttributes CharcValueUnit Internal UoM
ValidityEndDate I_UtilsProdAttributes ValidityEndDate ValidTo
ValidityStartDate I_UtilsProdAttributes ValidityStartDate Validity Start Date
CharcInternalID I_UtilsProdAttributes CharcInternalID Characteristic Internal ID
ProductAuthorizationGroup I_UtilsProdAttributes ProductAuthorizationGroup
CharcDataType I_UtilsProdAttributes CharcDataType Format
CharcToAmount I_UtilsProdAttributes CharcToAmount UprBndry Crcy
CharcFromAmount I_UtilsProdAttributes CharcFromAmount LowrBndry Crcy
UtilsTimeSliceDurationFrom I_UtilsProdAttributes UtilsTimeSliceDurationFrom LowrBndry Nmrc
UtilsTimeSliceDurationTo I_UtilsProdAttributes UtilsTimeSliceDurationTo UprBndry Nmrc
UtilsTimeSliceDurationUoM I_UtilsProdAttributes UtilsTimeSliceDurationUoM Internal UoM
Currency I_UtilsProdAttributes Currency Valuation Crcy
CharcToDate I_UtilsProdAttributes CharcToDate UprBndry Date
CharcFromDate I_UtilsProdAttributes CharcFromDate LowrBndry Date
CharcToDecimalValue I_UtilsProdAttributes CharcToDecimalValue UprBndry Nmrc
CharcFromDecimalValue I_UtilsProdAttributes CharcFromDecimalValue LowrBndry Nmrc
CharcDecimals I_UtilsProdAttributes CharcDecimals Decimal Places
CharcLength I_UtilsProdAttributes CharcLength Number of Chars
CharcConversionRoutine I_UtilsProdAttributes CharcConversionRoutine
CharcDescription _ProductAttributeText CharcDescription
_UtilsOperand I_UtilsProdAttributes _UtilsOperand
_Product _Product

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 CRMS4_IU_I_PRDA.
-- 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: CRMS4IUVIPRDA

CREATE VIEW CRMS4_IU_I_PRDA AS
SELECT
  I_UtilsProdAttributes.UtilitiesProduct AS UtilitiesProduct,
  I_UtilsProdAttributes.Characteristic AS Characteristic,
  I_UtilsProdAttributes.UtilitiesReferenceProduct AS UtilitiesReferenceProduct,
  I_UtilsProdAttributes.CharcValuePositionNumber AS CharcValuePositionNumber,
  I_UtilsProdAttributes.UtilsBillingOperand AS UtilsBillingOperand,
  I_UtilsProdAttributes.UtilsTimeSliceCharacteristicID AS UtilsTimeSliceCharacteristicID,
  cast( case when I_UtilsProdAttributes.UtilsTimeSliceCharacteristicID is not initial then 'X' else ' ' end as abap.char( 1 ) ) as IsTimeSliceAttribute AS char1asIsTimeSliceAttribute,
  I_UtilsProdAttributes.CharcValue AS CharcValue,
  I_UtilsProdAttributes.CharcValueUnit AS CharcValueUnit,
  I_UtilsProdAttributes.ValidityEndDate AS ValidityEndDate,
  I_UtilsProdAttributes.ValidityStartDate AS ValidityStartDate,
  I_UtilsProdAttributes.CharcInternalID AS CharcInternalID,
  I_UtilsProdAttributes.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  I_UtilsProdAttributes.CharcDataType AS CharcDataType,
  I_UtilsProdAttributes.CharcToAmount AS CharcToAmount,
  I_UtilsProdAttributes.CharcFromAmount AS CharcFromAmount,
  I_UtilsProdAttributes.UtilsTimeSliceDurationFrom AS UtilsTimeSliceDurationFrom,
  I_UtilsProdAttributes.UtilsTimeSliceDurationTo AS UtilsTimeSliceDurationTo,
  I_UtilsProdAttributes.UtilsTimeSliceDurationUoM AS UtilsTimeSliceDurationUoM,
  I_UtilsProdAttributes.Currency AS Currency,
  I_UtilsProdAttributes.CharcToDate AS CharcToDate,
  I_UtilsProdAttributes.CharcFromDate AS CharcFromDate,
  I_UtilsProdAttributes.CharcToDecimalValue AS CharcToDecimalValue,
  I_UtilsProdAttributes.CharcFromDecimalValue AS CharcFromDecimalValue,
  I_UtilsProdAttributes.CharcDecimals AS CharcDecimals,
  I_UtilsProdAttributes.CharcLength AS CharcLength,
  I_UtilsProdAttributes.CharcConversionRoutine AS CharcConversionRoutine,
  _ProductAttributeText.CharcDescription AS CharcDescription,
  I_UtilsProdAttributes._UtilsOperand AS _UtilsOperand
FROM I_UtilsProdAttributes
LEFT OUTER JOIN I_ClfnCharcDescForKeyDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CRMS4_IU_I_PRD AS _Product ON _Product.UtilitiesProduct = UtilitiesProduct  -- association [0..1]
;

Learn More