R_ComplaintPricingProcedure

DDL: R_COMPLAINTPRICINGPROCEDURE Type: view_entity TRANSACTIONAL Package: VDM_CMH_SD
3 Fields 1 Data Sources 1 Associations

Pricing procedure for Complaint

R_ComplaintPricingProcedure is a Transactional CDS View that provides data about "Pricing procedure for Complaint" in SAP S/4HANA. It reads from 1 data source (I_ComplaintPricingProcedure) and exposes 3 fields with key fields ConditionUsage, ConditionApplication, PricingProcedure. It has 1 association to related views. Part of development package VDM_CMH_SD.

Data Sources (1)

SourceAliasJoin Type
I_ComplaintPricingProcedure I_ComplaintPricingProcedure from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_CmplPricingProcedureItem _PricingProcedureItem $projection.ConditionUsage = _PricingProcedureItem.ConditionUsage and $projection.ConditionApplication = _PricingProcedureItem.ConditionApplication and $projection.PricingProcedure = _PricingProcedureItem.PricingProcedure

Annotations (9)

NameValueLevelField
EndUserText.label Pricing procedure for Complaint view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ConditionUsage ConditionUsage Usage
KEY ConditionApplication ConditionApplication Application
KEY PricingProcedure PricingProcedure Procedure

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 R_ComplaintPricingProcedure.
-- 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 R_ComplaintPricingProcedure AS
SELECT
  ConditionUsage,
  ConditionApplication,
  PricingProcedure
FROM I_ComplaintPricingProcedure
LEFT OUTER JOIN R_CmplPricingProcedureItem AS _PricingProcedureItem ON ConditionUsage = _PricingProcedureItem.ConditionUsage AND ConditionApplication = _PricingProcedureItem.ConditionApplication AND PricingProcedure = _PricingProcedureItem.PricingProcedure  -- association [0..*]
;

Learn More