I_PrcgDocPricingProcedureText

DDL: I_PRCGDOCPRICINGPROCEDURETEXT Type: view_entity BASIC Package: VF_PRC_RAP_ROOT

Pricing Procedure - Text

I_PrcgDocPricingProcedureText is a Basic CDS View that provides data about "Pricing Procedure - Text" in SAP S/4HANA. It reads from 1 data source (P_PricingProcedureText) and exposes 8 fields with key fields Language, PricingProcedure, ConditionApplication. It has 3 associations to related views. Part of development package VF_PRC_RAP_ROOT.

Data Sources (1)

SourceAliasJoin Type
P_PricingProcedureText P_PricingProcedureText from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ConditionUsage _ConditionUsage $projection.ConditionUsage = _ConditionUsage.ConditionUsage
[1..1] I_ConditionApplication _ConditionApplication $projection.ConditionApplication = _ConditionApplication.ConditionApplication
[1..*] I_PrcgDocumentPricingProcedure _PrcgDocPricingProcedure $projection.PricingProcedure = _PrcgDocPricingProcedure.PricingProcedure

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey PricingProcedure view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Pricing Procedure - Text view
Analytics.technicalName IPrcDocPrcgPrT view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Language Language Report Text Language
KEY PricingProcedure PricingProcedure Procedure
KEY ConditionApplication ConditionApplication Application
ConditionUsage ConditionUsage Usage
PricingProcedureName PricingProcedureName Wgh.Dat.Ty.Txt.
_ConditionUsage _ConditionUsage
_ConditionApplication _ConditionApplication
_PrcgDocPricingProcedure _PrcgDocPricingProcedure

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_PrcgDocPricingProcedureText.
-- 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_PrcgDocPricingProcedureText AS
SELECT
  Language,
  PricingProcedure,
  ConditionApplication,
  ConditionUsage,
  PricingProcedureName
FROM P_PricingProcedureText
LEFT OUTER JOIN I_ConditionUsage AS _ConditionUsage ON ConditionUsage = _ConditionUsage.ConditionUsage  -- association [1..1]
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- association [1..1]
LEFT OUTER JOIN I_PrcgDocumentPricingProcedure AS _PrcgDocPricingProcedure ON PricingProcedure = _PrcgDocPricingProcedure.PricingProcedure  -- association [1..*]
;