A_RecProcEquipRqmtCharcValue

DDL: A_RECPROCEQUIPRQMTCHARCVALUE SQL: ANGCRERCLFN4 Type: view CONSUMPTION Package: VDM_PLMB_RECIPE_API
23 Fields 1 Data Sources 1 Associations

Recipe Equipment Requirement Characteristic Values

A_RecProcEquipRqmtCharcValue is a Consumption CDS View that provides data about "Recipe Equipment Requirement Characteristic Values" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValForKeyDate) and exposes 23 fields with key fields RecipeProcessEquipRqmtUUID, ClassType, CharcInternalID, CharcValuePositionNumber. It has 1 association to related views. Part of development package VDM_PLMB_RECIPE_API.

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_RecipeProcessEquipRqmt _RecipeProcessEquipRqmt $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessEquipRqmt.RecipeProcessEquipRqmtUUID

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ANGCRERCLFN4 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 Equipment Requirement Characteristic Values view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY RecipeProcessEquipRqmtUUID RecipeProcessEquipRqmt RecipeProcessEquipRqmtUUID
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
_RecipeProcessEquipRqmt _RecipeProcessEquipRqmt

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_RecProcEquipRqmtCharcValue.
-- 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: ANGCRERCLFN4
-- Parameters: P_KeyDate : sydate

CREATE VIEW A_RecProcEquipRqmtCharcValue AS
SELECT
  RecipeProcessEquipRqmt.RecipeProcessEquipRqmtUUID AS RecipeProcessEquipRqmtUUID,
  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_RecipeProcessEquipRqmt AS _RecipeProcessEquipRqmt ON RecipeProcessEquipRqmtUUID = _RecipeProcessEquipRqmt.RecipeProcessEquipRqmtUUID  -- association [1..1]
;

Learn More