P_PurInfoRecdPrHistCalc

DDL: P_PURINFORECDPRHISTCALC SQL: PPIRHISTCALC Type: view CONSUMPTION
11 Fields 1 Data Sources 1 Associations

Private View for PIR Calculation

P_PurInfoRecdPrHistCalc is a Consumption CDS View that provides data about "Private View for PIR Calculation" in SAP S/4HANA. It reads from 1 data source (P_PurgInfoRecdOrdPrcCalc) and exposes 11 fields with key fields PurchasingInfoRecord, PurchasingOrganization, PurchasingInfoRecordCategory, Plant, PurchasingDocumentOrderDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_PurgInfoRecdOrdPrcCalc P_PurgInfoRecdOrdPrcCalc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_PurgInfoRecdOrdVarcCalc _PurgInfoRecdOrdVarcCalc _PurgInfoRecdOrdVarcCalc.PurchasingInfoRecord = $projection.PurchasingInfoRecord and _PurgInfoRecdOrdVarcCalc.PurchasingOrganization = $projection.PurchasingOrganization and _PurgInfoRecdOrdVarcCalc.PurchasingInfoRecordCategory = $projection.PurchasingInfoRecordCategory and _PurgInfoRecdOrdVarcCalc.Plant = $projection.Plant and _PurgInfoRecdOrdVarcCalc.PurchasingDocumentOrderDate = $projection.PurchasingDocumentOrderDate and _PurgInfoRecdOrdVarcCalc.PurchasingDocument = $projection.PurchasingDocument and _PurgInfoRecdOrdVarcCalc.PurchasingDocumentItem = $projection.PurchasingDocumentItem

Annotations (11)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord PurchasingInfoRecord Info Record
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory Infotype
KEY Plant Plant Valuation Area
KEY PurchasingDocumentOrderDate PurchasingDocumentOrderDate PO Date
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
FormattedPurDoc FormattedPurchaseOrderItem
ReferenceDocumentCrcy ReferenceDocumentCrcy
NetPriceAmount NetPriceAmount Net Price
FormattedInfoRec _PurgInfoRecdOrdVarcCalc FormattedInfoRec

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_PurInfoRecdPrHistCalc.
-- 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: PPIRHISTCALC

CREATE VIEW P_PurInfoRecdPrHistCalc AS
SELECT
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchasingInfoRecordCategory,
  Plant,
  PurchasingDocumentOrderDate,
  PurchasingDocument,
  PurchasingDocumentItem,
  FormattedPurchaseOrderItem AS FormattedPurDoc,
  ReferenceDocumentCrcy,
  NetPriceAmount,
  _PurgInfoRecdOrdVarcCalc.FormattedInfoRec AS FormattedInfoRec
FROM P_PurgInfoRecdOrdPrcCalc
LEFT OUTER JOIN P_PurgInfoRecdOrdVarcCalc AS _PurgInfoRecdOrdVarcCalc ON _PurgInfoRecdOrdVarcCalc.PurchasingInfoRecord = PurchasingInfoRecord AND _PurgInfoRecdOrdVarcCalc.PurchasingOrganization = PurchasingOrganization AND _PurgInfoRecdOrdVarcCalc.PurchasingInfoRecordCategory = PurchasingInfoRecordCategory AND _PurgInfoRecdOrdVarcCalc.Plant = Plant AND _PurgInfoRecdOrdVarcCalc.PurchasingDocumentOrderDate = PurchasingDocumentOrderDate AND _PurgInfoRecdOrdVarcCalc.PurchasingDocument = PurchasingDocument AND _PurgInfoRecdOrdVarcCalc.PurchasingDocumentItem = PurchasingDocumentItem  -- association [0..1]
;

Learn More