I_EvaldRcptSettlmtProfileText

DDL: I_EVALDRCPTSETTLMTPROFILETEXT Type: view_entity BASIC
5 Fields 1 Data Sources 1 Associations

Evaluated Receipt Settlmt Profile - Text

I_EvaldRcptSettlmtProfileText is a Basic CDS View that provides data about "Evaluated Receipt Settlmt Profile - Text" in SAP S/4HANA. It reads from 1 data source (cvalid_t) and exposes 5 fields with key fields PurchasingOrganization, EvaldRcptSettlementProfile, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
cvalid_t cvalid_t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EvaldRcptSettlmtProfile _EvaldRcptSettlmtProfile $projection.PurchasingOrganization = _EvaldRcptSettlmtProfile.PurchasingOrganization and $projection.EvaldRcptSettlementProfile = _EvaldRcptSettlmtProfile.EvaldRcptSettlementProfile

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Evaluated Receipt Settlmt Profile - Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchasingOrganization ekorg Purchasing Org.
KEY EvaldRcptSettlementProfile valid_pro Settlement profile
KEY Language spras Off. Language
EvaldRcptSettlementProfileText valid_text Profile description
_EvaldRcptSettlmtProfile _EvaldRcptSettlmtProfile

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_EvaldRcptSettlmtProfileText.
-- 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.

CREATE VIEW I_EvaldRcptSettlmtProfileText AS
SELECT
  ekorg AS PurchasingOrganization,
  valid_pro AS EvaldRcptSettlementProfile,
  spras AS Language,
  valid_text AS EvaldRcptSettlementProfileText
FROM cvalid_t
LEFT OUTER JOIN I_EvaldRcptSettlmtProfile AS _EvaldRcptSettlmtProfile ON PurchasingOrganization = _EvaldRcptSettlmtProfile.PurchasingOrganization AND EvaldRcptSettlementProfile = _EvaldRcptSettlmtProfile.EvaldRcptSettlementProfile  -- association [0..1]
;

Learn More