P_PricingProcedure

DDL: P_PRICINGPROCEDURE SQL: PPRCGPROCED Type: view BASIC Package: VDM_SD_BF_PR
6 Fields 1 Data Sources 2 Associations

Procedure for Pricing

P_PricingProcedure is a Basic CDS View that provides data about "Procedure for Pricing" in SAP S/4HANA. It reads from 1 data source (t683) and exposes 6 fields with key fields ConditionUsage, ConditionApplication, PricingProcedure. It has 2 associations to related views. Part of development package VDM_SD_BF_PR.

Data Sources (1)

SourceAliasJoin Type
t683 _Procedure from

Associations (2)

CardinalityTargetAliasCondition
[0..*] P_PricingProcedureItem _PricingProcedureItem $projection.ConditionUsage = _PricingProcedureItem.ConditionUsage and $projection.ConditionApplication = _PricingProcedureItem.ConditionApplication and $projection.PricingProcedure = _PricingProcedureItem.PricingProcedure
[0..*] P_PricingProcedureText _Text $projection.ConditionUsage = _Text.ConditionUsage and $projection.ConditionApplication = _Text.ConditionApplication and $projection.PricingProcedure = _Text.PricingProcedure

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPRCGPROCED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ConditionUsage t683 kvewe Usage
KEY ConditionApplication t683 kappl Application
KEY PricingProcedure t683 kalsm Search Proced.
InclusionPoint t683 inclusionpoint Inclusion Point
_Text _Text
_PricingProcedureItem _PricingProcedureItem

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 P_PricingProcedure.
-- 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: PPRCGPROCED

CREATE VIEW P_PricingProcedure AS
SELECT
  _Procedure.kvewe AS ConditionUsage,
  _Procedure.kappl AS ConditionApplication,
  _Procedure.kalsm AS PricingProcedure,
  _Procedure.inclusionpoint AS InclusionPoint
FROM t683 AS _Procedure
LEFT OUTER JOIN P_PricingProcedureItem AS _PricingProcedureItem ON ConditionUsage = _PricingProcedureItem.ConditionUsage AND ConditionApplication = _PricingProcedureItem.ConditionApplication AND PricingProcedure = _PricingProcedureItem.PricingProcedure  -- association [0..*]
LEFT OUTER JOIN P_PricingProcedureText AS _Text ON ConditionUsage = _Text.ConditionUsage AND ConditionApplication = _Text.ConditionApplication AND PricingProcedure = _Text.PricingProcedure  -- association [0..*]
;

Learn More