I_RecipeClassCharcTP

DDL: I_RECIPECLASSCHARCTP SQL: IRECCLSCHRTP Type: view TRANSACTIONAL
11 Fields 1 Data Sources 3 Associations

TP for Recipe Class Charcs

I_RecipeClassCharcTP is a Transactional CDS View that provides data about "TP for Recipe Class Charcs" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcForKeyDate) and exposes 11 fields with key fields RecipeUUID, ClassInternalID, CharcInternalID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcForKeyDate I_ClfnObjectCharcForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_RecipeCharcValueTP _Valuation $projection.RecipeUUID = _Valuation.RecipeUUID and $projection.CharcInternalID = _Valuation.CharcInternalID and $projection.ClassType = _Valuation.ClassType
[1..1] I_RecipeClassTP _RecipeClass $projection.RecipeUUID = _RecipeClass.RecipeUUID and $projection.ClassInternalID = _RecipeClass.ClassInternalID
[1..1] I_RecipeForKeyDateTP _Recipe $projection.RecipeUUID = _Recipe.RecipeUUID

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IRECCLSCHRTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP for Recipe Class Charcs view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY RecipeUUID Recipe RecipeUUID Recipe GUID
KEY ClassInternalID Characteristics ClassInternalID Int class no.
KEY CharcInternalID Characteristics CharcInternalID Characteristic Internal ID
KeyDate
ClassType Characteristics ClassType X Flag
ValidityStartDate Characteristics ValidityStartDate Validity Start Date
ValidityEndDate Characteristics ValidityEndDate ValidTo
_Valuation _Valuation
_RecipeClass _RecipeClass
_Recipe _Recipe
_Characteristic Characteristics _Characteristic

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_RecipeClassCharcTP.
-- 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: IRECCLSCHRTP
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_RecipeClassCharcTP AS
SELECT
  Recipe.RecipeUUID AS RecipeUUID,
  Characteristics.ClassInternalID AS ClassInternalID,
  Characteristics.CharcInternalID AS CharcInternalID,
  $parameters.P_KeyDate AS KeyDate,
  Characteristics.ClassType AS ClassType,
  Characteristics.ValidityStartDate AS ValidityStartDate,
  Characteristics.ValidityEndDate AS ValidityEndDate,
  Characteristics._Characteristic AS _Characteristic
FROM I_ClfnObjectCharcForKeyDate
LEFT OUTER JOIN I_RecipeCharcValueTP AS _Valuation ON RecipeUUID = _Valuation.RecipeUUID AND CharcInternalID = _Valuation.CharcInternalID AND ClassType = _Valuation.ClassType  -- association [0..*]
LEFT OUTER JOIN I_RecipeClassTP AS _RecipeClass ON RecipeUUID = _RecipeClass.RecipeUUID AND ClassInternalID = _RecipeClass.ClassInternalID  -- association [1..1]
LEFT OUTER JOIN I_RecipeForKeyDateTP AS _Recipe ON RecipeUUID = _Recipe.RecipeUUID  -- association [1..1]
;

Learn More