P_PurgInfoRecdVarcCalc

DDL: P_PURGINFORECDVARCCALC SQL: PPIRVARCCALC Type: view CONSUMPTION
6 Fields 2 Data Sources

Private View for PIR Variance

P_PurgInfoRecdVarcCalc is a Consumption CDS View that provides data about "Private View for PIR Variance" in SAP S/4HANA. It reads from 2 data sources (I_PurInfCndPeriod, I_PurInfCndPeriod) and exposes 6 fields with key fields PurchasingInfoRecord, PurchasingOrganization, PurchasingInfoRecordCategory, Plant, ConditionValidityEndDate.

Data Sources (2)

SourceAliasJoin Type
I_PurInfCndPeriod infoRecord1 from
I_PurInfCndPeriod infoRecord2 left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPIRVARCCALC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Private View for PIR Variance view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord I_PurInfCndPeriod PurchasingInfoRecord Info Record
KEY PurchasingOrganization I_PurInfCndPeriod PurchasingOrganization Purchasing Organization
KEY PurchasingInfoRecordCategory I_PurInfCndPeriod PurchasingInfoRecordCategory Infotype
KEY Plant I_PurInfCndPeriod Plant Valuation Area
KEY ConditionValidityEndDate I_PurInfCndPeriod ConditionValidityEndDate Valid To
FuturePriceValidityStartDate

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_PurgInfoRecdVarcCalc.
-- 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: PPIRVARCCALC

CREATE VIEW P_PurgInfoRecdVarcCalc AS
SELECT
  infoRecord1.PurchasingInfoRecord AS PurchasingInfoRecord,
  infoRecord1.PurchasingOrganization AS PurchasingOrganization,
  infoRecord1.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  infoRecord1.Plant AS Plant,
  infoRecord1.ConditionValidityEndDate AS ConditionValidityEndDate,
  max(infoRecord2.ConditionValidityEndDate) AS FuturePriceValidityStartDate
FROM I_PurInfCndPeriod AS infoRecord1
LEFT OUTER JOIN I_PurInfCndPeriod AS infoRecord2 ON /* join condition not captured in parsed metadata */
;

Learn More