P_PurgInfoRecdPrcCalc

DDL: P_PURGINFORECDPRCCALC SQL: PPIRPRCCALC Type: view CONSUMPTION
9 Fields 1 Data Sources

Info Record Price Conversion

P_PurgInfoRecdPrcCalc is a Consumption CDS View that provides data about "Info Record Price Conversion" in SAP S/4HANA. It reads from 1 data source (I_PurInfCndPeriod) and exposes 9 fields with key fields PurchasingInfoRecord, PurchasingOrganization, PurchasingInfoRecordCategory, Plant, ConditionValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_PurInfCndPeriod I_PurInfCndPeriod from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPIRPRCCALC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Info Record Price Conversion view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord PurchasingInfoRecord Info Record
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory Infotype
KEY Plant Plant Valuation Area
KEY ConditionValidityEndDate Valid To
KEY ConditionRecord ConditionRecord Cond.Record No.
ConditionValidityStartDate ConditionValidityStartDate Valid From
ConditionType ConditionType Condition type
Currency _InfoRecord Currency Valuation Crcy

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_PurgInfoRecdPrcCalc.
-- 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: PPIRPRCCALC

CREATE VIEW P_PurgInfoRecdPrcCalc AS
SELECT
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchasingInfoRecordCategory,
  Plant,
  cast(ConditionValidityEndDate as abap.char(8)) AS ConditionValidityEndDate,
  ConditionRecord,
  ConditionValidityStartDate,
  ConditionType,
  _InfoRecord.Currency AS Currency
FROM I_PurInfCndPeriod
;

Learn More