A_RecProcParamValCharcValue

DDL: A_RECPROCPARAMVALCHARCVALUE SQL: ANGCRPPCLFN4 Type: view CONSUMPTION
23 Fields 1 Data Sources 1 Associations

Recipe Process Parameter Value Characteristic Values

A_RecProcParamValCharcValue is a Consumption CDS View that provides data about "Recipe Process Parameter Value Characteristic Values" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValForKeyDate) and exposes 23 fields with key fields RecipeProcessParamValUUID, ClassType, CharcInternalID, CharcValuePositionNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_RecipeProcessParamValue _RecipeProcessParamValue $projection.RecipeProcessParamValUUID = _RecipeProcessParamValue.RecipeProcessParamValUUID

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ANGCRPPCLFN4 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Consumption.filter.businessDate.at true view
EndUserText.label Recipe Process Parameter Value Characteristic Values view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY RecipeProcessParamValUUID RecipeProcessParamValue RecipeProcessParamValUUID
KEY ClassType Valuation ClassType X Flag
KEY CharcInternalID Valuation CharcInternalID Characteristic Internal ID
KEY CharcValuePositionNumber Valuation CharcValuePositionNumber
KeyDate
CharcValueDependency Valuation CharcValueDependency Code
CharcValue Valuation CharcValue Char. Value
CharcFromNumericValue Valuation CharcFromNumericValue Value from
CharcFromNumericValueUnit Valuation CharcFromNumericValueUnit Internal UoM
CharcToNumericValue Valuation CharcToNumericValue Value to
CharcToNumericValueUnit Valuation CharcToNumericValueUnit Internal UoM
CharcFromDecimalValue Valuation CharcFromDecimalValue LowrBndry Nmrc
CharcToDecimalValue Valuation CharcToDecimalValue UprBndry Nmrc
CharcFromAmount Valuation CharcFromAmount LowrBndry Crcy
CharcToAmount Valuation CharcToAmount UprBndry Crcy
Currency Valuation Currency Valuation Crcy
CharcFromDate Valuation CharcFromDate LowrBndry Date
CharcToDate Valuation CharcToDate UprBndry Date
CharcFromTime Valuation CharcFromTime LowrBndry Time
CharcToTime Valuation CharcToTime UprBndry Time
CharacteristicAuthor Valuation CharacteristicAuthor
CharcMaintAuthGrp
_RecipeProcessParamValue _RecipeProcessParamValue

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 A_RecProcParamValCharcValue.
-- 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: ANGCRPPCLFN4
-- Parameters: P_KeyDate : sydate

CREATE VIEW A_RecProcParamValCharcValue AS
SELECT
  RecipeProcessParamValue.RecipeProcessParamValUUID AS RecipeProcessParamValUUID,
  Valuation.ClassType AS ClassType,
  Valuation.CharcInternalID AS CharcInternalID,
  Valuation.CharcValuePositionNumber AS CharcValuePositionNumber,
  $parameters.P_KeyDate AS KeyDate,
  Valuation.CharcValueDependency AS CharcValueDependency,
  Valuation.CharcValue AS CharcValue,
  Valuation.CharcFromNumericValue AS CharcFromNumericValue,
  Valuation.CharcFromNumericValueUnit AS CharcFromNumericValueUnit,
  Valuation.CharcToNumericValue AS CharcToNumericValue,
  Valuation.CharcToNumericValueUnit AS CharcToNumericValueUnit,
  Valuation.CharcFromDecimalValue AS CharcFromDecimalValue,
  Valuation.CharcToDecimalValue AS CharcToDecimalValue,
  Valuation.CharcFromAmount AS CharcFromAmount,
  Valuation.CharcToAmount AS CharcToAmount,
  Valuation.Currency AS Currency,
  Valuation.CharcFromDate AS CharcFromDate,
  Valuation.CharcToDate AS CharcToDate,
  Valuation.CharcFromTime AS CharcFromTime,
  Valuation.CharcToTime AS CharcToTime,
  Valuation.CharacteristicAuthor AS CharacteristicAuthor,
  Valuation._Characteristic(P_KeyDate: $parameters.P_KeyDate).CharcMaintAuthGrp AS CharcMaintAuthGrp
FROM I_ClfnObjectCharcValForKeyDate
LEFT OUTER JOIN A_RecipeProcessParamValue AS _RecipeProcessParamValue ON RecipeProcessParamValUUID = _RecipeProcessParamValue.RecipeProcessParamValUUID  -- association [1..1]
;

Learn More