I_PurgInfoRecdOrdPrcHist

DDL: I_PURGINFORECDORDPRCHIST SQL: IINFRECORDPRCHIS Type: view BASIC Package: VDM_MM_PUR_SOS
18 Fields 1 Data Sources 1 Associations

Purg Inf Rec Ordr Price History

I_PurgInfoRecdOrdPrcHist is a Basic CDS View that provides data about "Purg Inf Rec Ordr Price History" in SAP S/4HANA. It reads from 1 data source (eipa) and exposes 18 fields with key fields PurchasingInfoRecord, PurchasingDocument, PurchasingDocumentItem. It has 1 association to related views. Part of development package VDM_MM_PUR_SOS.

Data Sources (1)

SourceAliasJoin Type
eipa eipa from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PurchasingInfoRecord _PurchasingInfoRecord $projection.PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IINFRECORDPRCHIS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purg Inf Rec Ordr Price History view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord eipa infnr Info Record
KEY PurchasingDocument eipa ebeln Source PurchDoc
KEY PurchasingDocumentItem eipa ebelp Item pur. doc.
PurchasingInfoRecordCategory eipa esokz Infotype
Plant eipa werks Receiving Plant
PurchasingOrganization eipa ekorg Purchasing Org.
PurchasingDocumentOrderDate eipa bedat Start date
OrderQuantity eipa menge WarrCountValue
PurgDocNetPriceAmount eipa preis Valuation Price
Currency eipa bwaer Ref.currency
PurchaseOrderPriceUnit eipa peinh Unit of measure
OrderPriceUnitQty
OrderPriceUnit eipa bprme PO Price Unit
PurOrdPriceInRefDocCrcy eipa lprei Price
ReferenceDocumentCrcy eipa lwaer Reporting Crcy
ReferenceDocumentQuantity eipa lpein Price Unit
ReferenceDocumentUnit eipa lmein Base Unit
_PurchasingInfoRecord _PurchasingInfoRecord

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_PurgInfoRecdOrdPrcHist.
-- 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: IINFRECORDPRCHIS

CREATE VIEW I_PurgInfoRecdOrdPrcHist AS
SELECT
  eipa.infnr AS PurchasingInfoRecord,
  eipa.ebeln AS PurchasingDocument,
  eipa.ebelp AS PurchasingDocumentItem,
  eipa.esokz AS PurchasingInfoRecordCategory,
  eipa.werks AS Plant,
  eipa.ekorg AS PurchasingOrganization,
  eipa.bedat AS PurchasingDocumentOrderDate,
  eipa.menge AS OrderQuantity,
  eipa.preis AS PurgDocNetPriceAmount,
  eipa.bwaer AS Currency,
  eipa.peinh AS PurchaseOrderPriceUnit,
  cast(eipa.peinh as mmpur_ord_price_unit_qty) AS OrderPriceUnitQty,
  eipa.bprme AS OrderPriceUnit,
  eipa.lprei AS PurOrdPriceInRefDocCrcy,
  eipa.lwaer AS ReferenceDocumentCrcy,
  eipa.lpein AS ReferenceDocumentQuantity,
  eipa.lmein AS ReferenceDocumentUnit
FROM eipa
LEFT OUTER JOIN I_PurchasingInfoRecord AS _PurchasingInfoRecord ON PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord  -- association [0..1]
;

Learn More